Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Listener with mixed releases
GovindanK,
Well TNS_ADMIN is for config files like *ora files
Sun Solaris running Oracle 8i or 9i
First: The oracle user's home directory is searched for a hidden '.tnsnames.ora'
Second: The value of the TNS_ADMIN environment variable.
Third: /var/opt/oracle
Fourth: $ORACLE_HOME/network/admin
I prefer using /var/opt/oracle or /etc on HP because I can't guarantee my clients have the TNS_ADMIN variable set in their environment and don't want them to change something they may not know how to do.
One server had 8 different tnsnames.ora files, some we installed and some we didn't.
I don't see how this has any effect on lsnrctl which is executed from
your $PATH.
That may change when you do a
". oraenv"
Thanks Larry
-----Original Message-----
From: GovindanK [mailto:gkatteri_at_fastmail.fm]
Sent: Wednesday, May 24, 2006 1:31 PM
To: Wolfson Larry - lwolfs; oracle-l
Subject: Re: Listener with mixed releases
Correction. Should be TNS_ADMIN variable and the exact link is http://download-west.oracle.com/docs/cd/B19306_01/gateways.102/b16209/ch 4.htm#sthref288
HTH
GovindanK
On Wed, 24 May 2006 11:28:01 -0700, "GovindanK" <gkatteri_at_fastmail.fm>
said:
> Did you try setting TNSADMIN variable?
> http://download-west.oracle.com/docs/cd/B19306_01/gateways.102/b16209/
> ch4.htm
>
> HTH
> GovindanK
>
> On Wed, 24 May 2006 11:26:55 -0500, "Wolfson Larry - lwolfs"
> <lawrence.wolfson_at_acxiom.com> said:
> > Got a couple of clients who had us install 10G on some servers where
> > some have DBs and some don't.
> >
> > The installers activated the 10G listener (because we always use
> > highest
> > version) and we got 1000s of
> > oerr tns 12618
> > 12618, 00000, "TNS:versions are incompatible"
> > // *Cause: The two machines are running incompatible versions of
TNS.
> > // *Action: Check the version numbers, and upgrade the machine with
> > the // smaller one.
> >
> > What's really happening is anytime someone/thing, like monitor
> > programs, executes lsnrctl from lower release we're getting error.
> >
> > I thought we could just rename lsnrctl in lower releases and put in
> > soft link to 10G lsnrctl program.
> >
> > Someone suggested we could have problems with NLS settings and
> > should replace lsnrctl with a script instead?
> >
> > Anyone know if link is enough or do we have to watch out for
> > something else?
> >
> >
> > Thanks
> > Larry
If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited.
If you have received this communication in error, please resend this communication to the sender and delete the original message or any copy of it from your computer system.
Thank you.
-- http://www.freelists.org/webpage/oracle-lReceived on Wed May 24 2006 - 14:22:53 CDT
![]() |
![]() |