Removing a managed server in EBS R12.2
Information: The following steps should be executed in order to delete a managed server from the domain. As in the case of managed server addition, deletion of managed servers should…
Read MoreHow to change the Port Numbers of the Managed Servers
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 MoreR12.2 : Patch seems to hang in adobjcmp.sql or appostimportaad.sql or fapostimportaad.sql
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 MoreAfter Entering Username/Password in R12.2 Login window- Password Field become Blanks
Login 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
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 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 More