Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Problem in creating a database connection

 
indu yeturu
Ranch Hand
Posts: 123
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Adeel Ansari
Ranch Hand
Posts: 2874
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Look into tnsnames.ora and listener.ora file, under your oracle XE installation directory, in order to debug this.
 
indu yeturu
Ranch Hand
Posts: 123
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks Ansari,

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

Thanks a lot for your prompt reply...
indu
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic