| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Listener Problem
Dear Oracle gurus,
I am having a problem to connect to my database server, which is Oracle 8.0.4 under Windows NT.
Whenever I am trying to connect from my PC, I am getting error message as
ORA-12505: TNS: listener could not resolve SID given in connect descriptor
Cause: The SID in the CONNECT_DATA was not found in the listener's tables. This error will be returned if the database instance has not registered with the listener; the instance may need to be started.
Action: Check to make sure that the SID specified is correct. The SIDs that
are currently registered with the listener can be obtained
by typing "LSNRCTL SERVICES <listener name>". These SIDs correspond to
SID_NAMEs in TNSNAMES.ORA, or
DB_NAMES in the initialization file.
But I am giving the oracle_sid correctly only, as I checked with my init.ora file.
Just yesterday only I installed Oracle in a new development server, Listener is running very much, as I checked in Services under control panel. Am I missing anymore steps after installation?
Please update me to get connected with oracle server from my pc.
Thanks in advance
Balu Srinivasan.
 |
 |