EBS Homepage Help Link Shows A Blank Page In R12.2 After SSL Is Enabled
EBS 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 MoreFind All the Corrupted Objects in Your Database
SELECT 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 MorePurging of Old pending Notification and workflow data
SQL> select count(*),status from wf_notifications group by status; COUNT(*) STATUS ———- ——– 1530 CANCELED 1627 CLOSED 15266 OPEN SQL> select count(*),status, MAIL_STATUS from wf_notifications group by 2 status, MAIL_STATUS order by status; COUNT(*) STATUS…
Read MoreHow to find log files locations in 11i and R12
Alert Log File location: $ORACLE_HOME/admin/$CONTEXT_NAME/bdump/alert_$SID.log Trace file location: $ORACLE_HOME/admin/SID_Hostname/udump Application Tier Logs Start/Stop script log files location: $COMMON_TOP/admin/log/CONTEXT_NAME/ OPMN log file location $ORACLE_HOME/opmn/logs/ipm.log Apache, Jserv, JVM log files locations: $IAS_ORACLE_HOME/Apache/Apache/logs/ssl_engine_log…
Read MoreORA-00600: error in Queue Table SYS.SYS$SERVICE_METRICS_TAB
If 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-06091: no channel allocated for maintenance
RMAN> 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 MoreCheck the temporary tablespace usage
column 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 MoreCheck the undo tablespace usage
col 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 MoreCheck datapump job is being executed
SELECT 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 MoreTo check the waits stats
column 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