Issue: While applying a patch or Maintenance Pack the adpatch worker does not seem to finish when running one of the following jobs : adobjcmp.sql appostimportaad.sql fapostimportaad.sql This typically happens…
Read MoreLogin Page Loops Back to Login Page Immediately After Entering Username/Password – Password Field Blanks Problem: In 12.2, find the login page “loops” and never allows the user into Self…
Read MoreEBS Homepage Help Link Shows A Blank Page In R12.2 After SSL Is Enabled Problem : In Oracle E-Business Suite Release 12.2, a non-SSL…
Read MoreSELECT e.owner, e.segment_type, e.segment_name, e.partition_name, c.file# , greatest(e.block_id, c.block#) corr_start_block# , least(e.block_id+e.blocks-1, c.block#+c.blocks-1) corr_end_block# , least(e.block_id+e.blocks-1, c.block#+c.blocks-1) – greatest(e.block_id, c.block#) + 1 blocks_corrupted , null description FROM dba_extents e, v$database_block_corruption…
Read MoreIf this error is coming in Oracle database, then take downtime and do the following: Drop the queue table – exec dbms_aqadm.drop_queue_table( queue_table=>’SYS.SYS$SERVICE_METRICS_TAB’, force => TRUE) select object_name, object_type from…
Read MoreRMAN> delete obsolete; the following error occurs: RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of delete command at 18/01/2021 22:04:21 RMAN-06091: no channel allocated…
Read Morecolumn sid_serial format A12 heading “Sid-Serial” column tablespace format a15 heading ‘TBS Name’ column spid format 9,999 heading ‘Unix ID’ column segblk# format 999,999,999 heading ‘Block ID’ column size_mb format…
Read Morecol NAME format a15 col TABLESPACE_NAME format a10 col Programme format a20 col machine format a30 SELECT a.usn, e.sid, e.serial#, e.username, e.program, e.machine, e.osuser, a.name, b.status, c.tablespace_name, d.addr FROM v$rollname…
Read MoreSELECT owner_name ,job_name ,operation ,job_mode ,state ,degree ,attached_sessions FROM dba_datapump_jobs; To get the constraints list: #set linesize 1000 #set verify off #set pagesize 40 #break on owner on table_name on…
Read Morecolumn object_name format a20 column owner format a20 column object_type format a20 column sample_time format a27 column sql_text format a50 set ver off prompt Histogram of Buffer Busy Wait select…
Read More