topic Re: After fresh Linux install, getting ORA-12560 protocal adaptor error in Operating System - Linux

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

Randy Hagedorn — Thu, 08 Jul 2010 13:02:19 GMT

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

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

Ivan Ferreira — Thu, 08 Jul 2010 13:39:25 GMT

>>> 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."

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

TwoProc — Thu, 08 Jul 2010 20:37:00 GMT

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.

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

Randy Hagedorn — Fri, 09 Jul 2010 11:22:53 GMT

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

Randy