Database Blog

How to configure two OC4j containers for two different applications running on same server

How to configure two OC4j containers for two different applications running on same server. Introduction: The default port for the OC4j container is 8888. You may not be able to…

Read More

OC4j: How to Resolve the sharing violation by ending the process currently holding the file lock or by using a different persistence directory for one or both processes

Introduction: Requirement to configure additional OC4J instance for PDF printing for two different application. Error: ERROR ServerFile[PersistentMap,/u02/oc4j/j2ee/home/persistence/jms.state]: persistence file could not be locked. Resolve the sharing violation by ending the…

Read More

Oracle Apex : Failed to load resource: the server responded with a status of 404 ()

Environment: In our case, Apex: 19.2.0.00.18 Tomcat: apache-tomcat-9.0.36 ORDS: 19.1 Error: Developer reported Dashboard images and themes are not loading for one of the Application developed using Oracle Apex. When…

Read More

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 More

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 Server Administration Console and WLST…

Read More

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 typically happens…

Read More

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 into Self…

Read More

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 More

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# , 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 More

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( queue_table=>’SYS.SYS$SERVICE_METRICS_TAB’, force => TRUE) select object_name, object_type from…

Read More