RE: ORA-12560: TNS protocol adapter error ora error

Admin — Tue, 23 Jun 2009 17:07:40 GMT

Here is the solution :

You need to do either of the two things. I prefer to do both.

1. Login to your oracle account.

2. set ORACLE_SID=SID

3. set LOCAL=SID

4. check your $ORACLE_HOME/network/admin/sqlnet.ora file for any reference to EZCONNECT; if you have it remove it.

This should fix your problem. Remember the "set" command is depending on what shell you are using. If you are using korn shell replace the set with "export" (i.e export ORACLE_SID=SID )

I updated my sqlnet.ora file by taking out the EZCONNECT part out. Here is a diff between my original sqlnet.ora file and the new one:

/u01/oracle/product/10.2.0.4/network/admin >diff sqlnet.ora.original.062309 sqlnet.ora
4c4
< NAMES.DIRECTORY_PATH= (LDAP, TNSNAMES, EZCONNECT)
---
> NAMES.DIRECTORY_PATH= (LDAP, TNSNAMES)

Hope this helps.

Thanks,

ORA-12560: TNS protocol adapter error ora error

Admin — Tue, 23 Jun 2009 17:02:16 GMT

Hi,

When i'm trying to sqlplus '/ as sysdba' , i'm getting the following ora error message:

# sqlplus '/ as sysdba'

Anyone know what to do? I tried all over the internet to search for the solution but couldn't find a solid one.

Thanks,

FranklinFaces.com - Oracle & SQL Server Database Forums for all IT Professionals / Oracle Forum / ORA - Oracle Database Error Codes - Search via specific error codes. / ORA-10560 Through ORA-19999 / ORA-12560: TNS protocol adapter error ora error / Latest Posts

RE: ORA-12560: TNS protocol adapter error ora error

ORA-12560: TNS protocol adapter error ora error