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!

How to add "orcl" SID in listener.ora , so I could use orcl in SQL developer local server.

61bdbdc7-9062-402a-8973-07febab3fa33Nov 26 2015 — edited Nov 26 2015

Hello guys, for the past 6hours I've been trying to create new local host connection in SQL developer, so I could study and do homework...
So as of now I am able to create a connection if I choose SID to be "xe", but if I change it to "orcl" i get this error:ORA-12505, TNS:listener does not currently know of SID given in the connect descriptor

I've been trying to find a solution for a long time, but there is just 0 info on the web.. SO how do I add "orcl" in listener.ora or whatever place i should add it? Please help me, thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 24 2015

Added on Nov 26 2015

#general-database-discussions

11 comments

4,153 views