ORA-12560: TNS:protocol adapter error in Oracle

ORA-12560: TNS: protocol adapter error

Error:

SQL> connect scott/tiger as sysdba
ERROR:
ORA-12560: TNS:protocol adapter error

On Checking on Oracle Sites:

Cause:
A generic protocol adapter error occurred.

Action:
Check addresses used for proper protocol specification. Before reporting this error, look at the error stack and
check for lower level transport errors. For further details, turn on tracing and re-execute the operation.
Turn off tracing when the operation is complete.

Solutions:

1. This error will come if Listener is not up or problem in tnsnames or database is not up.

2. Check the listener status by executing.

lsnrctl status

3. Check the tnsnames entry in tnsnames.ora

tnsping INSTANCENAME

4. Check the database status is up running by checking the service in windows or process in Unix.

On Windows:
Start --> Run--> type "services.msc"
Select the OracleService name, Right Click, Start.

On Unix or Linux:
ps -ef pmon*

5. Check the environment variable of ORACLE_HOME, PATH, TNS_ADMIN and ORACLE_SID.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.