Skip to Main Content

Oracle Database Express Edition (XE)

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 known of SID given in connect descriptor

user10977928May 21 2015 — edited May 22 2015

Hello All,

I am facing a strange issue today.

I installed 11g xe db in windows(64) environment 2 yrs ago. It's working correctly. Suddenly I am facing to connect the database through SQL Developer.

Below error id given when I tried to connect the database.

Listener refused the connection with following error.ORA-12505 TNS:listener does not currently known of SID given in connect descriptor.

Strange thing is:

I am able to connect the database by default SQL Plus coming with XE DB.

Can anyone plz help me to resolve the issue. What's wrong when try to connect through sql developer.?

pastedImage_0.png pastedImage_1.png

Thanks,

Tanmoy

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 19 2015
Added on May 21 2015
1 comment
1,295 views