SQL Developer

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 and ORA-12514: TNS:listener

santhosh TApr 7 2013 — edited Apr 15 2013

Hi All,

Am not able to connect to the database through the SQL Developer. When i am trying to connect the error was as below.

"An error was encountered performing the requested operation:

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

Vendor code 12505"

My Database version : Oracle Database 10g Express Edition
O/S : Windows 7, 32 bit

I have tried to restart the machine and also the OraclceServiceXE service in the services menu, but of no use.

And when i am trying to connect it from the sqlplus prompt...the error was

"C:\>sqlplus santhu/abcd@xe

SQL*Plus: Release 10.2.0.1.0 - Production on Sun Apr 7 14:30:21 2013

Copyright (c) 1982, 2005, Oracle. All rights reserved.

ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor"

Could you please help me where to check for the resolution.

Thanks,

Locked Post

New comments cannot be posted to this locked post.

Locked on May 13 2013

Added on Apr 7 2013

#sql-developer

2 comments

1,325 views