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
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