Re: Problems starting new TNS Listener

From: voivod <francesco.pighi_at_gmail.com>
Date: Thu, 7 May 2009 09:46:53 -0700 (PDT)
Message-ID: <211d051f-5a06-4b68-87f2-bacfec2c9877_at_q2g2000vbr.googlegroups.com>



On May 7, 5:37 pm, ddf <orat..._at_msn.com> wrote:
> On May 7, 9:52 am, voivod <francesco.pi..._at_gmail.com> wrote:
>
> > On May 7, 11:25 am, sybrandb <sybra..._at_gmail.com> wrote:
>
> > > Ever heard of TNS_ADMIN?
>
> > > Please set TNS_ADMIN.
>
> > Ok, I have set TNS_ADMIN variable to %ORACLE_HOME%/network/admin, but
> > when I launch "lsnrctl start SE" it still get the wrong listener.ora
> > from the Oracle XE directory.
>
> Where IS this 'correct' listener.ora file?  Setting TNS_ADMIN to the
> default location Oracle will search anyway doesn't fix anything; you
> should set TNS_ADMIN to the location where this alternate listener.ora
> file resides.
>
> David Fitzjarrell

Yes sorry, in my previous reply I wrote %ORACLE_HOME% but actually I have specified the full path of the SE directory I have the following situation:
XE directory = C:\oraclexe\app\oracle\product\10.2.0\server\ SE directory = C:\oracle\product\10.2.0\db_1\ TNS_ADMIN = C:\oracle\product\10.2.0\db_1\NETWORK\ADMIN Received on Thu May 07 2009 - 11:46:53 CDT

Original text of this message