![multispec lan file description multispec lan file description](https://i0.wp.com/tech-story.net/wp-content/uploads/2022/08/Golden-Software-Grapher.jpg)
This sequence is specified with the following configuration: If the first protocol address fails, then it tries the second protocol address. The first Oracle Connection Manager is instructed to connect to the first protocol address of another Oracle Connection Manager. The client is instructed to connect to an protocol address of the first Oracle Connection Manager, as indicated by: In Example 6-4, the syntax does the following: If the TNS_ADMIN environment variable is not set, then Oracle Net will check the ORACLE_HOME/network/admin directory.Įxample 6-4 Multiple Oracle Connection Manager Addresses in tnsnames.ora If the file is not found in the directory specified, then it is assumed that the file does not exist. The directory specified by the TNS_ADMIN environment variable. For example, the order checking the tnsnames.ora file is as follows: Oracle Net will check the other directories for the configuration files. Clients and database servers (that are clients of other database servers) use the net service name when making a connection with an application.īy default, the tnsnames.ora file is located in the ORACLE_HOME/network/admin directory. A connect descriptor contains the location of the listener through a protocol address and the service name of the database to which to connect.
![multispec lan file description multispec lan file description](http://driverslab.ru/images/post/mediatek_wifi_chip.jpg)
This tnsnames.ora file is a configuration file that contains net service names mapped to connect descriptors for the local naming method, or net service names mapped to listener protocol addresses.Ī net service name is an alias mapped to a database network address contained in a connect descriptor.