SEO

Hello All,

I am creating an Installation Script that installs an application and
makes a few changes to the tnsnames.ora file. Our users have multiple
TNSNAMES.ORA files on their computers. How can I determine which
TNSNAMES.ORA file is the active one (the one which is being used
Oracle OLE to connect)?

Thanks.
Saqib Ali
http://validate.sf.net Online DocBook XML -> HTML/PDF Convertor

Saqib Ali wrote:

> Hello All,
>
> I am creating an Installation Script that installs an application and
> makes a few changes to the tnsnames.ora file. Our users have multiple
> TNSNAMES.ORA files on their computers. How can I determine which
> TNSNAMES.ORA file is the active one (the one which is being used
> Oracle OLE to connect)?
>
> Thanks.
> Saqib Ali
> http://validate.sf.net Online DocBook XML -> HTML/PDF Convertor

From Oracle9i Net Services Administrator's Guide
Release 2 (9.2)
Part Number A96580-02

available free of charge at http://ocs.racle.com ....

-----------------
Configuration files are typically created in $ORACLE_HOME/network/admin on
UNIX operating systems and ORACLE_HOME\network\admin on Windows operating
systems. However, configuration files can be created in a variety of
places, because Oracle Net searches for the configuration files in a
variety of places. The search order for sqlnet.ora and ldap.ora is as
follows:

1. The directory specified by the TNS_ADMIN environment variable

If the TNS_ADMIN environment variable is not defined as a variable on
Windows NT, it may be in the registry.

2. The $ORACLE_HOME/network/admin directory on UNIX operating systems and
the ORACLE_HOME\network\admin directory on Windows operating systems
----------------

Note, under Windows the ORACLE_HOME is identifed by the specific executable
being run. This is somewhat recursive, as the executable is in a specific
ORACLE_HOME/bin, but this rule eliminates ambiguity and appears to be
enforced by all Windows-based Oracle executables.


/Hans

Saqib Ali wrote:

> Hello All,
>
> I am creating an Installation Script that installs an application and
> makes a few changes to the tnsnames.ora file. Our users have multiple
> TNSNAMES.ORA files on their computers. How can I determine which
> TNSNAMES.ORA file is the active one (the one which is being used
> Oracle OLE to connect)?
>
> Thanks.
> Saqib Ali
> http://validate.sf.net Online DocBook XML -> HTML/PDF Convertor

Depends on what you mean by "script". From the standpoint of most
scripts ... you can't.

Daniel Morgan

A non-Oracle script modifying the "primary" tnsnames.ora file. Yikes!

Seems like a mistake to me to "modify" Oracle primary config files with a
script or program.

If you really need to modify the tnsnames.ora file, then I think you can
just create your own tnsnames.ora in the directory where your script or
program runs from.

The tnsnames.ora in the current directory could have just 1 entry for your
"new" database. Entries in a tnsnames.ora in the current directory of a
program will add to the entries of a primary tnsnames.ora (no matter where
it is) or it will override existing entries in the primary copy.

I don't know if I saw this documented or from a trace file. But, it
definitely works on windows.

And on Unix, you can do the same thing, but the file name of tnsnames.ora
must begin with a "." for a "hidden file" ( $HOME/.tnsnames.ora ) . Also, it
must reside in the $HOME of the Unix account.

--

"Saqib Ali" <saqib@stonebeat.org> wrote in message
news:d22b4f0d.0407211243.7717a40c@posting.google.c om...
> Hello All,
>
> I am creating an Installation Script that installs an application and
> makes a few changes to the tnsnames.ora file. Our users have multiple
> TNSNAMES.ORA files on their computers. How can I determine which
> TNSNAMES.ORA file is the active one (the one which is being used
> Oracle OLE to connect)?
>
> Thanks.
> Saqib Ali
> http://validate.sf.net Online DocBook XML -> HTML/PDF Convertor