Re: Problems starting new TNS Listener
Date: Thu, 7 May 2009 09:46:53 -0700 (PDT)
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