Wednesday 1 May 2013

ORA- 12535: TNS: operation timed out


ORA- 12535: TNS: operation timed out

A remote Oracle client making a connection to an Oracle database can fails if there is a firewall installed between the client and the server and if port redirection is taking place. The firewall will block the connection to the new port when the Oracle client connects to the database - the client typically fails with Oracle errors ORA-12203 or ORA-12535.

enacle the tracing in sqlnet.ora
trace_level_client = 16
trace_file_client = client
trace_directory_client = c:\apps\oracle\product\trace
It will help you find the root reason
Check the firewall  and open the required port

No comments: