After fresh Linux install, getting ORA-12560 protocal adaptor error

[Randy Hagedorn]

Hi,

I had to re-install RHEL 5 onto a system that was an Oracle DB server. After re-presenting the original LUNS to the system, the database starts, but I can not connect to it from clients. We get an ORA-12560 TNS:Protocol Adaptor Error.

I have tried using the iptables command to open port 1521, but I still can't connect.

What else can I check?

Thanks,
Randy

[Ivan Ferreira · Accepted solution]

>>> I have tried using the iptables command to open port 1521, but I still can't connect.

It's better if your stop iptables at:

service iptables stop

http://www.cryer.co.uk/brian/oracle/ORA12560.htm

"Oracle classify this as a â generic protocol adapter errorâ . In my experience it indicates that Oracle client does not know what instance to connect to or what TNS alias to use."

[TwoProc]

from the client systems:

tnsping ;

So, if your database has a name of "PROD", then,

tnsping PROD;

If you don't get a response, then try pinging the server name.

ping .

From the above steps, you can see if you've got a basic network problem, or a SQLNet problem.

Also, look in the $ORACLE_HOME/network/admin/tnsnames.ora file, and make sure the database you're trying to connect to is in there, and for that listing, make sure that the port number, and the server name (or IP address) is correct.


Get back to us with the error codes from above.

[Randy Hagedorn]

John,
Thanks for the additional ways to test Oracle connectivity.

Randy