Sometimes You can get “ORA-12606: TNS: Application timeout occurred ” error.
Details of error are as follows.
ORA-12606: TNS: Application timeout occurred
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.
417 views last month, 1 views today