This article gives an example of each file as a starting point for simple network configuration. The example files below are relevant for an Oracle installation and instance with the following values.
The "listerner. Here is an example of a basic "listener. Notice the reference to the hostname "myserver. If this is incorrect, the listener will not function correctly.
After the "listener. The listener defined above doesn't have any services defined. These are created when database instances auto-register with it. In some cases you may want to manually configure services, so they are still visible even when the database instance is down. If this is the case, you may use a "listener. By signing in, you agree to our Terms of Use and Privacy Policy.
Already have an account? Sign in. By signing up, you agree to our Terms of Use and Privacy Policy. Enter the email address associated with your account. We'll send a magic link to your inbox. Email Address. All Sign in options. Enter a Email Address. Choose your interests Get the latest news, expert insights and market research, sent straight to your inbox.
Newsletter Topics Select minimum 1 topic. Data Management. Tags: Informatica. Anonymous September 13, 0 Comments. Anonymous Posted September 13, 0 Comments.
The Oracle Connection Manager then connects to the database service using the following protocol address:.
Example Client Load Balancing in tnsnames. This section lists and describes the tnsnames. Configuration parameters fall into the following categories:. These parameters are described next. The protocol address section of the tnsnames. When you set the parameter to on , yes , or true , Oracle Net, at connect time, fails over to a different address if the first protocol address fails. When you set the parameter to off , no , or false , Oracle Net tries one protocol address.
When you set the parameter to on , yes , or true , Oracle Net progresses through the list of addresses in a random sequence, balancing the load on the various listener or Oracle Connection Manager protocol addresses.
When you set the parameter to off , no , or false , Oracle Net tries the protocol addresses sequentially until one succeeds. The default value for this parameter is operating-system specific. The default for the Solaris 2. Use the parameter SDU to instruct Oracle Net to optimize the transfer rate of data packets being sent across the network with the session data unit SDU size you specify.
When you set to on or yes , Oracle Net uses each address in order until the destination is reached. To use Oracle Connection Manager, an initial connection from the client to Oracle Connection Manager is required, and a second connection from Oracle Connection Manager to the listener is required.
This parameter should only be used if the application supports both an Oracle Rdb and Oracle database service, and you want the application to load balance between the two. The connection data section of the tnsnames. Depending upon the configuration, session or any SELECT statements which were in progress are automatically failed over. A separate net service name must be created for the failover node. TYPE : Specify the type of failover.
This type of failover does not attempt to recover selects. However, this mode involves overhead on the client side in normal select operations.
0コメント