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 given in connect des

929103Jun 12 2012 — edited Mar 12 2013

Hi All,

I would like to ask you about this error.
ORA-12505: TNS:listener does not currently know of SID given in connect descriptor (DBD ERROR: OCIServerAttach)

I have searched forum here and there. I checked the tnsnames.ora and listener.ora file. It looks correct.

The strange thing is that we have 4 database instances on the server. All other instances are working except only one.

tnsnames or listener.ora file never been changed. But suddenly one database got this problem.

Could anyone help this issue, please?

Thanks,
Jun

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 9 2013

Added on Jun 12 2012

#general-database-discussions

18 comments

17,142 views