Think I found solution:
Not only do you have to use fully qualified path in the sid_list - but also in the program statement of the listener.ora
geez. What complicates it is under the same error: TNS-01201 - there are multiple notes, problems solutions.
Sorry guys.
-----Original Message-----
From: Jared Still [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 10, 2003 12:20 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: making me crazy
The curious among us would like to know what kind of situation
prevents you from correcting the listener.ora in the ORACLE_HOME
that is running the listener.
On Wed, 2003-09-10 at 07:44, [EMAIL PROTECTED] wrote:
> Dealing with 2 Oracle Homes - one if which I need to run the listener from
> and one in which I need to use the tnsnames.ora definitions from and no I
> can't just copy the tnsnames.ora to the 1st Oracle Home. Even when I set
> the oracle home from which to run lsnrctl it tries to use the listener.ora
> from the TNS_ADMIN home. How can I make sure to explicitly start the
> correct listener.ora?
>
> Thanks,
> Paula
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jared Still
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).
