RC-40201: Unable to connect to Database is a common error that occurs when running adclonectx in Oracle EBS R12.2.
This error occurs when the connection to the target database is not successful.
Checking the port pool 40 done: Port Pool 40 is free Report file located at /apps/applmgr/r12/fs2/inst/apps/dbname_server/admin/out/portpool.lst RC-40201: Unable to connect to Database dbname. Enter the Database listener port [1521] : RC-00200: Error: Exception occurred while taking input from user
The reason for this error can be:
- Incorrect database credentials
- Network connectivity issues
- Problems with the database listener (not UP or services not registered properly).
To resolve this error, you should check the database credentials, ensure that the network connectivity is stable, and check the status of the database listener.
In our case, we had to do the below at the database end to correct this issue:
1. Change tcp.validnode_checking = NO instead of tcp.validnode_checking = YES in sqlnet.ora file
2. Bounce DB Listener
After that adclonectx worked fine.
Latest posts by Brijesh Gogia (see all)
- Building a Scalable and Secure AI Infrastructure in the Cloud - May 12, 2024
- Harnessing the Power of AI in the Cloud for Business Transformation - March 2, 2024
- Building a Resilient Cybersecurity Framework in the Oracle Cloud - January 16, 2024