Forums Register Login

Problem in creating a database connection

+Pie Number of slices to send: Send
Hi,

am trying to create one database Connection in Oracle SQL developer and when I try the connection for "Test" it is showing the status as -->>

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

am using "Basic" as connection type and "default" as Role.
HostName: local host
port : 1521
SID : xe

please help me in resolving this,
thanks
indu
+Pie Number of slices to send: Send
Look into tnsnames.ora and listener.ora file, under your oracle XE installation directory, in order to debug this.
+Pie Number of slices to send: Send
Thanks Ansari,

The problem get resolved by checking the SID_name of the Listener.ora file.

Thanks a lot for your prompt reply...
indu
Would anybody like some fudge? I made it an hour ago. And it goes well with a tiny ad ...
a bit of art, as a gift, the permaculture playing cards
https://gardener-gift.com


reply
reply
This thread has been viewed 1570 times.
Similar Threads
Oracle driver expeption
Oracle 10g Connection Settings Required
connecting with oracle
sid in jdbc oracle connection string
Starting database instance
More...

All times above are in ranch (not your local) time.
The current ranch time is
Mar 28, 2024 08:49:44.