Re: Problems starting new TNS Listener
From: Francesco Pighi <francesco.pighi_at_gmail.com>
Date: Fri, 8 May 2009 03:14:08 -0700 (PDT)
Message-ID: <f47c260d-51eb-402d-a2d8-8ff4b2aed550_at_r3g2000vbp.googlegroups.com>
On May 7, 7:21 pm, ddf <orat..._at_msn.com> wrote:
> 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.
Checked. The value in the registry is correct, as I specified earlier I set the environment variable either at session level and at machine level and in the windows registry all the two TNS_ADMIN settings point to the SE dir
Date: Fri, 8 May 2009 03:14:08 -0700 (PDT)
Message-ID: <f47c260d-51eb-402d-a2d8-8ff4b2aed550_at_r3g2000vbp.googlegroups.com>
On May 7, 7:21 pm, ddf <orat..._at_msn.com> wrote:
> 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.
Checked. The value in the registry is correct, as I specified earlier I set the environment variable either at session level and at machine level and in the windows registry all the two TNS_ADMIN settings point to the SE dir
> 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.
If I understood correctly you refer to the possibility (inside the
Oracle Universal Installer) of sorting the ORACLE_HOMEs directories in
the windows PATH, do you?
If this is the case, I only have two ORACLE_HOMEs, one for the Oracle
SE (and it's the first in the PATH) and the other for the ODP.Net.
Thank you very much! Received on Fri May 08 2009 - 05:14:08 CDT