Re: Problems starting new TNS Listener

From: ddf <oratune_at_msn.com>
Date: Thu, 7 May 2009 10:21:21 -0700 (PDT)
Message-ID: <3f6fa13a-f7a7-4069-baaf-d53d7279d96d_at_z7g2000vbh.googlegroups.com>

On May 7, 11:46 am, voivod <francesco.pi..._at_gmail.com> wrote:
> 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- Hide quoted text -
>
> - Show quoted text -

Check the registry for a TNS_ADMIN setting which overrides the one you're trying to set at the command prompt. Also check Start->Programs->Oracle Installation Products for a Home Selector; use it to select the SE home and you should be able to start your listener.

David Fitzjarrell Received on Thu May 07 2009 - 12:21:21 CDT