Before making any changes to Oracle it is highly recommended that Oracle support be consulted first.
During the setup of Oracle, there are three settings mentioned in an Oracle Support bulletin located in the SQLNET.ORA file. Oracle suggests setting the 3 settings to some reasonable number of seconds that could be expected in a normal network. These are listed below: Example:
When these settings are not set correctly, errors similar to the AwE-5001 errors shown above may be encountered. An Oracle DBA should be consulted to look into these settings. The last 2 SEND and RECEIVE timeouts may be interfering or overwriting the SQLNET.INBOUND_CONNECT_TIMEOUT if they are set less than that of the SQLNET.INBOUND_CONNECT_TIMEOUT. See the example below. Example:
The above example can result in sockets being closed prematurely which can cause the Applications Manager Client to lock over time.
Fix Status: No Fix