CODEWITHSUNDEEP
oracle-databaseoracle11goracle-sqldeveloperoracle-xe
Harshit Bohra
Harshit Bohra

Reputation: 11

I am able to connect to the Oracle Database thru sql plus but not thru sql developer

I installed Oracle11g XE for windows32. First time when I try to connect via SQL developer it gets connected effortlessly. But once I close the SQL Developer and restart it, then again I am unable to connect to the DB. Then I tried to connect with SQL plus and guess what it gets connected! But through SQL devloper I receive an error message as follows:

ORA-12505, TNS:listener does not currently know of SID given in connect descriptor.

I have checked all the credentials thoroughly. Still am unable to find the error. Please Help.

Upvotes: 0

Views: 873

Answers (1)

nightfox79
nightfox79

Reputation: 2119

When you are using sql plus you use the tnsnames.ora file to find your connection. You can do the same in sql developer. Just click the listbox connection type and choose TNS instead of basic then for network alias you should be able to choose a connection from your tnsnames.ora

Upvotes: 1

Related Questions