DiigIT | IT Community
No Profile Image
Welcome Guest
New User? Register | Login
IT Tags
DiigIT » Oracle »

ORA-12560: TNS:protocol adapter error on windows machine while starting oracle

By: | 06 Sep 2008 4:15 pm

 ORA-12560: TNS:protocol adapter error on windows machine while starting oracle Error Description

On my windows server machine whenever I try to logon to database as a sysdba user it fails with the message ORA-12560.
C:\Documents and Settings\Oracle> sqlplus / as sysdba
 
SQL*Plus: Release 10.2.0.1.0 - Production on Sat Aug 16 11:01:58 2008
 
Copyright (c) 1982, 2005, Oracle. All rights reserved.
 
ERROR:
ORA-12560: TNS:protocol adapter error

Comments

First off check the listener is running or not
IF you are directly connected to database server then
Try to logon with sys
i.e. sql>conn sys/password as sysdba
IF it works then check the sqlnet.ora file. and use appropriate authentication method.

-- Suresh Borse
By: Suresh Borse | 02 Dec 2008

Leave a comment

Enter the text in the image
img
Can't read?
Type the characters you see in the picture below.


Close Move