up vote 0 down vote favorite
share [g+] share [fb]

I got this error while starting new connection in oracle 11g

" Listern refused the connection with the follwoing error: ORA-12505,TNS: Listner does not currently know of SID given in connect descriptor the connection descriptor used by the client was: localhost:1521:xe"

what is the sid and how can i fix the error?? please help!

link|improve this question
Do you have access to the Oracle server or are you doing this from a client? – REW Apr 15 '11 at 21:14
feedback

1 Answer

up vote 0 down vote

The SID in this case is XE (think of the SID being the database name). The Error means that the listener is not configured to listen for a database called XE on port 1521 on server localhost. Unless you are running the client and server on the same box localhost isn't likely to be correct - change this to the server name. This looks like a connection to Oracle XE which isn't available for 11g (yet) so it isn't clear what your set-up is exactly and so it is difficult to provide a definitive answer - but most likely wither the database is down or you are connecting to the wrong server.

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.