Sometimes You can get “TNS-12606: TNS: Application timeout occurred ” error.
Details of error are as follows.
TNS-12606: TNS: Application timeout occurred Cause: A network session did not reach an application-defined stage within the allowed time interval. Action: This is an error which does not normally appear at the high level. The action to take is application specific, and is detailed in the higher level error description.
Error TNS-12535 when connecting to Oracle database via dispatchers (shared servers). The dispatcher trace shows following error message - NS Primary Error: TNS-12535: TNS:operation timed out NS Secondary Error: TNS-12606: TNS: Application timeout occurred kmduicxd: 0EEE01DC, kmduiflg: 1, circuit: 4D08C930 (circuit) dispatcher process id = (85917028, 1) parent process id = (64, 1) serial # = 44 connection context = 0EEE01DC user session = (00000000), flag = (100c0), queue = (9) current buffer = (0), status = (4, 0) Client Address = (ADDRESS=(PROTOCOL=tcp)(HOST=<IP address>)(PORT=<port>))
The 12535 error in the dispatcher trace indicates that the connection was timed out in the dispatchers queue.
To solve this error, Increase value for following database parameters –
These parameters are modifiable using ALTER SYSTEM.
SQL> alter system set shared_server=30 scope=both sid='*'; SQL> alter system set max_shared_server=300 scope=both sid='*';
Do you want to learn more details about RMAN, then read the following articles.