Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Listener Problem
Have you configure the tnsnames.ora file?
Winnie
"Balu Sethuram Srinivasan" <balusrinivasan_at_hotmail.com> on 05/04/2000 04:55:29 PM
Please respond to ORACLE-L_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc: (bcc: Winnie Liu/HQ/ISC)
Subject: 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.
-- Author: Balu Sethuram Srinivasan INET: balusrinivasan_at_hotmail.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Thu May 04 2000 - 18:08:01 CDT
![]() |
![]() |