Troubleshooting and Maintenance

This chapter covers the topic that can help you maintain, use best practice, and troubleshoot the Oracle Applications Adapter.

Note: If you have updated the passwords and are experiencing issues with running jobs or events, we recommend disabling and re-enabling the connection to ensure everything works properly.

Non-responsive Oracle Applications Connection

For a non-responsive Oracle Applications connection during the upgrade of Oracle 11g to Oracle 12c version, execute the following concurrent manager list query and check whether the response time is good:

SELECT manager,APPLICATION_ID,CONCURRENT_QUEUE_ID,
CONCURRENT_QUEUE_NAME,node,actual,target,running,pending ,status FROM sabdg_manager_v where manager = 'Internal Manager' or manager = 'Conflict Resolution Manager' or manager = 'Standard Manager'

If it is not responsive or consumes more time, involve DBA to optimize the query plan for this query.