Problem in creating a database connection

[indu yeturu]

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]

Look into tnsnames.ora and listener.ora file, under your oracle XE installation directory, in order to debug this.

[indu yeturu]

Thanks Ansari,

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

Thanks a lot for your prompt reply...
indu