Re: Migrate EBS on a Single DB Instance to a RAC DB

Posted by ErmanArslansOracleBlog on Feb 18, 2017; 8:15am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Migrate-EBS-on-a-Single-DB-Instance-to-a-RAC-DB-tp2165p2182.html

This may be caused by an autoconfig bug, or by a problematic entry in one of the files/tables that autoconfig uses for building the tnsnames.ora.

check the following 14 things and ensure there is no ip address defined there. (defined where it must not be defined)
Check these things and try to solve the issue, if you can't send me the following;

1)Your apps release
2)Your db version
3)your /etc/hosts file
4)your db context file
5)your remote listener parameter
6)your local listener parameter
7)your current listener.ora (your local listener's listener.ora)
8)your current tnsnames.ora (from TNS_ADMIN)
9)your autoconfig log file
10)output of "ping your virtual ipaddress"  , "ping your virtual hostname"
11)output of "ping your physical paddress" , "ping your physical hostname"
12)lsnrctl status <LISTENER_NAME>  --> listener name that is written in your local_listener parameter
12)lsnrctl status <LISTENER_NAME>  --> listener name that is written in your remote_listener parameter
13)output of select * from fnd_nodes table (formatted)
14)output of FND_DATABASES, applsys.FND_DATABASE_INSTANCES, applsys.FND_TNS_LISTENERS,
and applsys.FND_TNS_LISTENER_PORTS, (formatted)