The tnsnames. When it finds a match it reads the name of the server where it should connect to ,the protocol it should use TCP and the port on which a listener is listening default When it finds a match it goes to the relevant server and knocks on the port where the listener is waiting to hear incoming calls.
If it matches, you are given an entry for the database to connect and a session is created for you. So, tnsnames. The sqlnet. It resides on the client machines and the database server. Profiles are stored and implemented using this file. The database server can be configured with access control parameters in the sqlnet. These parameters specify whether clients are allowed or denied access based on the protocol. Go to Solution. Beginning Nov 15, , the Networking Forum discussion board will move to the Aruba Airheads community.
Click here to learn more. Resources Announcements Email us Feedback. Log In. New Discussion. 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.
The client is instructed to connect to the protocol address of the first Oracle Connection Manager, as indicated by:. The first Oracle Connection Manager is instructed to connect to the first protocol address of another Oracle Connection Manager.
The listener. The listener process uses this file for configuration. The tnsnames. Cheers, R. Thanks for the response. Any other better explanation? Yes, sure. Try Oracle manuals Join Date Apr Posts As far as my knowledge in oracle, 1.
0コメント