ORA-12560: TNS:protocol adapter error in Oracle

 ORA-12560: TNS:protocol adapter error

SQL> CONN /AS SYSDBA
ERROR:
ORA-12560: TNS:protocol adapter error

SQL>

Solution:

conn /@SID as sysdba

Example: My sid is orcl

conn /@orcl as sysdba

It will solve the problem

Otherwise

set oracle_home=
set oracle_sid=
set path

conn /@ as sysdba

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s