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-12505-TNS:listener does not currently know of SID

683218Mar 22 2010 — edited Mar 22 2010

Hi,

I am getting below error while trying to connect via Toad even it is not connecting using string as below without string is connecting on which node where the database is located.I have already checked listener there is no issue with it as per my knowlege.tnsping is working properly.

1: Toad
ora-12505-TNS:listener does not currently know of SID given in connect descriptor

2:
SQL> conn rms12/rms12@rms;
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor

Warning: You are no longer connected to ORACLE.
SQL> conn rms12/rms12
Connected.
SQL>

Regards,

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 19 2010

Added on Mar 22 2010

#general-database-discussions

11 comments

4,003 views