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, ...
Database
Insights and Experiences from Doyensys’ Database Administrators.
How 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 ...
R12.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 ...
After 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 ...
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 port is ...
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 be done on ...
How 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 ...
R12.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 ...
After 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 ...
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 port is kept open for those products that need to ...
Find 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# , ...
ORA-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( ...
RMAN-06091: no channel allocated for maintenance
RMAN> delete obsolete; the following error occurs: RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ...
Check 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# ...
Check 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, ...