Detail: Customizing Managed Server Configuration via WebLogic Server Administration Console The managed server configuration can be customized via native WebLogic tools such as the WebLogic Server Administration Console and WLST…
Read MoreIssue: 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 More