On a production system, this will need approval and an off-hours window to perform the action. You must also look at your hardware resources and other database parameters to ensure this new setting can be increased without causing additional resource limitations.
This blog went over a few common TNS errors and quick ways to troubleshoot them. This is not the all-encompassing list of causes for these errors and TNS errors, in general, but this should head you in the right direction in your troubleshooting. Your email address will not be published.
This site uses Akismet to reduce spam. Learn how your comment data is processed. Virtual-DBA uses cookies to personalize content and ads. UNIX connectivity for Oracle. When the Oracle DBA creates the tnsnames. For example, an entry in the tnsnames. This shows a TNS service name of kc, which defines a connection to a remote server named gates, that contains an Oracle database named bbq.
From the listing below, it shows that the gates server is located at The protocol address section of the tnsnames. Keepalive allows the caller to detect a dead remote server, although typically it will take 2 hours or more to notice.
Operating system TCP configurables, which vary by platform, define the actual keepalive timing details. 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. The client uses this information to obtain the list of DNs it expects for each of the servers, enforcing the database server DN to match its service name.
Use this parameter with the sqlnet. The timeout section of the tnsnames. To specify the timeout duration in seconds for a client to establish an Oracle Net connection to an Oracle database. It includes the time to be connected to the database instance providing the requested service, not just the duration of the TCP connection. To specify the delay in seconds between subsequent retries for a connection.
To specify the transportation timeout duration in seconds for a client to establish an Oracle Net connection to an Oracle database. The default value is 60 seconds. The compression section of the tnsnames. The compression levels are used at the time of negotiation to verify which levels are used at both ends, and select one level.
General Syntax of tnsnames. Multiple Descriptions in tnsnames. Notes: Oracle Net Manager does not support the creation of multiple connect descriptors for a net service name when using Oracle Connection Manager.
Multiple Address Lists in tnsnames. Note: Oracle Net Manager supports only the creation of one protocol address list for a connect descriptor. Protocol Address Section The protocol address section of the tnsnames. Usage Notes When you set the parameter to on , yes , or true , Oracle Net fails over at connect time to a different address if the first protocol address fails. A statically configured global database name disables connect-time failover.
Usage Notes When you set the parameter to on , yes , or true , Oracle Net goes through the list of addresses in a random sequence, balancing the load on the various listener or Oracle Connection Manager protocol addresses. Note: Additional protocols might support this parameter on certain operating systems. Refer to the operating system-specific documentation for additional information about additional protocols. Default bytes 8 KB Values to bytes.
Refer to the operating system-specific documentation for information about additional protocols. Usage Notes When you set this parameter to on or yes , Oracle Net uses each address in order until the destination is reached.
0コメント