Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
JavaRanch.com/granny.jsp
The moose likes JDBC and the fly likes Problem in creating a database connection Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Problem in creating a database connection" Watch "Problem in creating a database connection" New topic
Author

Problem in creating a database connection

indu yeturu
Ranch Hand

Joined: Aug 27, 2008
Posts: 123
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


thanks,
indu
Adeel Ansari
Ranch Hand

Joined: Aug 15, 2004
Posts: 2874
Look into tnsnames.ora and listener.ora file, under your oracle XE installation directory, in order to debug this.
indu yeturu
Ranch Hand

Joined: Aug 27, 2008
Posts: 123
Thanks Ansari,

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

Thanks a lot for your prompt reply...
indu
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: Problem in creating a database connection