Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-12560: TNS:protocol adapter error (10.2.0.1)

user640001Jul 13 2009 — edited Jul 13 2009

Hi,

database :- 10.2.0.1 (upgraded from 8.1.7.4 through DBUA)
OS :- Windows2000 Server

In Sql editor (10.2.0.1) when i give command "conn / as sysdba" i get the below error :

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

I can connect with SYS user using TOAD but can't through sql editor

and when i open sql editor (8.1.7.0), SYS user gets connected.

any solution ?

With regards

This post has been answered by 668822 on Jul 13 2009

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 10 2009

Added on Jul 13 2009

#general-database-discussions

3 comments

570 views