Skip to content
September 12, 2012 / doganay

Connect As Sysdba On Windows Fails With ORA-12560: TNS:protocol adapter error


Problem:

C:\> sqlplus /nolog
SQL> connect / as sysdba
ERROR:
ORA-12560: TNS:protocol adapter error


Solution:

Check ORACLE_HOME and ORACLE_SID:

c:\> echo %ORACLE_HOME%
c:\> echo %SID%

If these are ok, set the PATH environment variable to specify the database ORACLE_HOME as the first directory in the path.

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

%d bloggers like this: