Home » RDBMS Server » Server Administration » TNS protocol adapter error (Oracle 10gR2, Solaris 5.10)
TNS protocol adapter error [message #484103] Sat, 27 November 2010 05:11 Go to next message
karthickbab
Messages: 16
Registered: November 2009
Location: India
Junior Member
Hi,
When connecting to Oracle Db as sysdba the following error message occurs.

-bash-3.00$ sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Sat Nov 27 00:34:55 2010

Copyright (c) 1982, 2005, Oracle. All rights reserved.

SQL> conn sys/sys as sysdba
ERROR:
ORA-12560: TNS:protocol adapter error


Can anybody the reason?
Re: TNS protocol adapter error [message #484106 is a reply to message #484103] Sat, 27 November 2010 05:28 Go to previous messageGo to next message
Michel Cadot
Messages: 68650
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORACLE_HOME or ORACLE_SID is not set.

Regards
Michel
Re: TNS protocol adapter error [message #484108 is a reply to message #484106] Sat, 27 November 2010 05:33 Go to previous messageGo to next message
karthickbab
Messages: 16
Registered: November 2009
Location: India
Junior Member
-bash-3.00$ export ORACLE_SID=orcl
-bash-3.00$ export ORACLE_HOME=/export/home/oracle/product/10.2/db_1
-bash-3.00$ export ORACLE_BASE=/export/home/oracle/product/10.2/db_1/
-bash-3.00$ sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Sat Nov 27 01:02:15 2010

Copyright (c) 1982, 2005, Oracle. All rights reserved.

SQL> conn sys/sys as sysdba
ERROR:
ORA-12560: TNS:protocol adapter error
Re: TNS protocol adapter error [message #484109 is a reply to message #484108] Sat, 27 November 2010 05:50 Go to previous messageGo to next message
Michel Cadot
Messages: 68650
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
env | sort

Regards
Michel
Re: TNS protocol adapter error [message #484110 is a reply to message #484109] Sat, 27 November 2010 05:58 Go to previous messageGo to next message
karthickbab
Messages: 16
Registered: November 2009
Location: India
Junior Member
env
Re: TNS protocol adapter error [message #484113 is a reply to message #484110] Sat, 27 November 2010 07:37 Go to previous message
cookiemonster
Messages: 13922
Registered: September 2008
Location: Rainy Manchester
Senior Member
Post the results of
env | sort
Previous Topic: how many times has been executes a job?
Next Topic: oracle &timesten
Goto Forum:
  


Current Time: Sun May 12 03:48:25 CDT 2024