Shulou(Shulou.com)06/02 Report--

How to set Oracle installation TNS_ADMIN environment variables, many novices are not very clear about this, in order to help you solve this problem, the following editor will explain in detail for you, people with this need can come to learn, I hope you can gain something.

Many oracle products have their own TNS files. If you have multiple Oracle products installed in your system, which tnsnames.ora will the client use when connecting to instance? At this point, you need to look at the parameter TNS_ADMIN.

What is the tns_admin parameter?

How do I use tns_admin to define a public location for my tns file?

The tns_admin parameter determines the location of tns management files, such as tnsnames.ora, listener.ora, etc.

The tns_admin parameter is useful on servers with many databases at different version levels (so the $ORACLE_ home directory is different) because the tns_ admin value for all databases can be set to a single location, allowing all databases on the server to use a set of SQL*Net files.

Without the tns_admin variable, each instance will have its own set of tns files in the $ORACLE_HOME/network/admin directory.

View method: command line C:\ Documents and Settings\ ptian > set TNS_ADMIN TNS_ADMIN=D:\ oracle\ product\ 10.1.0\ Db_1\ NETWORK\ ADMIN, which means that the client will read TNS settings from D:\ oracle\ product\ 10.1.0\ Db_1\ NETWORK\ ADMIN

Modification method: there are two places can be modified, one is the registry, the other is the system environment variable. Location of the registry: HKEY_LOCAL_MACHINE\ SOFTWARE\ ORACLE\ HOME0\ TNS_ADMIN the system environment variable takes precedence over the registry, and if the environment variable is set, the registry value is ignored.

Is it helpful for you to read the above content? If you want to know more about the relevant knowledge or read more related articles, please follow the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.