RC-40201: Unable to connect to Database when running adclonectx in Oracle EBS R12.2

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.

Author
Recent Posts

Brijesh Gogia

I’m an experienced Cloud/Oracle Applications/DBA Architect with more than 15 years of full-time DBA/Architect experience. I have gained wide knowledge on Oracle and Non-Oracle software stack running on-prem and on Cloud and have worked on several big projects for multi-national companies. I enjoy working with leading-edge technology and have a passion for Cloud architecture, automation, database performance, and stability. Thankfully my work allows me time for researching new technologies (and to write about them).

RC-40201: Unable to connect to Database when running adclonectx in Oracle EBS R12.2

Related posts: