Active Oldest Votes. Improve this answer. The Overflow Blog. Podcast Explaining the semiconductor shortage, and how it might end. Does ES6 make JavaScript frameworks obsolete? Featured on Meta. Now live: A fully responsive profile. Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise.
All legitimate Oracle experts publish their Oracle qualifications. Oracle technology is changing and we strive to update our BC Oracle support information. If you find an error or have a suggestion for improving our content, we would appreciate your feedback.
Just e-mail: and include the URL for the page. This chapter provides a complete listing of the tnsnames. This chapter contains the following topics:. The tnsnames. A net service name is an alias mapped to a database network address contained in a connect descriptor. A connect descriptor contains the location of the listener through a protocol address and the service name of the database to which to connect. Clients and database servers that are clients of other database servers use the net service name when making a connection with an application.
By default, the tnsnames. Oracle Net will check the other directories for the configuration file. For example, the order checking the tnsnames. If the file is not found in the directory specified, then it is assumed that the file does not exist. The basic syntax for a tnsnames. Example Basic Format of tnsnames. A tnsnames. Each connect descriptor can contain one or more protocol addresses. Example shows two connect descriptors with multiple addresses.
In Example , two address lists are presented. The client first tries the first or second protocol address at random, then tries protocol addresses three and four sequentially. Example Multiple Address Lists in tnsnames. Oracle Net Manager supports only the creation of one protocol address list for a connect descriptor. The parameter is added manually to the file.
The following is an example of the syntax:. Refer to Oracle Database Reference for additional information. When a connect descriptor in a tnsnames. Example illustrates failover of multiple Oracle Connection Manager protocol addresses. These are out of the scope of this article. The OS hostname command must return the correct hostname of your database server.
If not, fix it so it does. For example in this case the values are as follows. If these are provided by DNS, that is fine also. The HOST entry in the "listener. If not, the listener will fail to start. If the HOST entry in the "listener.
0コメント