Link to home
Start Free TrialLog in
Avatar of sventhan
sventhanFlag for United States of America

asked on

ORA-12560: TNS:protocol adapter error | connecting as SYS user

Experts -

I'm getting the following error when connecting using windows SQLPLUS command line.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining,
Oracle Database Vault and Real Application Testing options

  2  /

D
-
X

SQL> show user;
USER is "SYSTEM"
SQL> def
DEFINE _DATE           = "15-JUL-15" (CHAR)
DEFINE _CONNECT_IDENTIFIER = "ikbqas2" (CHAR)
DEFINE _USER           = "SYSTEM" (CHAR)
DEFINE _PRIVILEGE      = "" (CHAR)
DEFINE _SQLPLUS_RELEASE = "1002000100" (CHAR)
DEFINE _EDITOR         = "Notepad" (CHAR)
DEFINE _O_VERSION      = "Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Producti
With the Partitioning, Oracle Label Security, OLAP, Data Mining,
Oracle Database Vault and Real Application Testing options" (CHAR)
DEFINE _O_RELEASE      = "1102000400" (CHAR)
SQL> conn sys / as sysdba
Enter password: *********
ERROR:
ORA-12560: TNS:protocol adapter error


Warning: You are no longer connected to ORACLE.

I can be able to connect as system but not as SYS.

Thanks,
Sve
SOLUTION
Avatar of johnsone
johnsone
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of msb1979
msb1979

adding to johnsone  comments

command should be

connect sys/<syspassword>@<your tnsnames> as sysdba
The @tnsnames is not necessary if you are on the database server.
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of sventhan

ASKER

Thanks for the help.