RE: ORA 2019 - Listener/TNS

From: <Kimberly.smith_at_gmd.fujitsu.com>
Date: Sun, 6 Aug 2000 12:22:14 -0700
Message-Id: <10581.113928@fatcity.com>

You did not mention that you had a dblink in your database.

-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of swamy rs Sent: Sunday, August 06, 2000 12:04 PM
To: Multiple recipients of list ORACLE-L Subject: ORA 2019 - Listener/TNS

Hi all.

I have 3 listeners running on the server, which hosts many databases. (Many on 8.0.5.2 on HpUX 11.0) I started all the listeners. I checked that status of listener A and found that, it is up. I gave the following command at os prompt.

connect system_at_hostname. I got connected. I tried to access a remote table(table on another instance) through the public link, on the same server, which is serviced by the same listener. I got OERR 2019 : "connection description for remote database not found".

I cross checked listener.ora. It is in right place. The remote database sid is in the sid-list of listener.ora. I cross checked in tnsnames.ora. The alias is fine. what could be the problem? Could any body please help me?

Also my understanding of listner/tns is to be improved. Any white papers/pointers will be highly appreciated. I am bit confused between SID and ALIAS. Which is used when. Especially if db-link name is same as alias.

TIA,
Swamy.

Do You Yahoo!?
Kick off your party with Yahoo! Invites. http://invites.yahoo.com/

-- 
Author: swamy rs
  INET: swamy55555_at_yahoo.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 Sun Aug 06 2000 - 14:22:14 CDT