Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Listener Problem

Re: Listener Problem

From: <Winnie_Liu_at_infonet.com>
Date: Thu, 4 May 2000 16:08:01 -0700
Message-Id: <10487.105016@fatcity.com>


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.



Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
--
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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US