Thursday, September 23, 2010

Autoconfig on FE node fails with TNS error or was failing with the below error even though the listener is running in the db server

ORA-12541: TNS: no listener

You may further notice that it is trying to connecto to DB via a different port# whereas the DB listener is running on a different port#.

Well, the reason for your problem is the database context file was not updated with the new port# and hence the Autoconfig on FE node was erroring out.
Please do the following steps to rectify the error:

•    Update the context file on db node with the original port#  and run Autoconfig.
•    Then run the Autoconfig on FE node which will complete successfully.

No comments:

Post a Comment