oracle sql DEVELOPER ORA-12535: TNS:operation timed out

Question

I am using Oracle SQL Developer 4.0.2.15.21 and I want to debug a PROCEDURE. I am unable to do this as I get the following error message...

Executing PL/SQL: ALTER SESSION SET PLSQL_DEBUG=TRUE
Executing PL/SQL: CALL DBMS_DEBUG_JDWP.CONNECT_TCP( '192.168.1.88', '54159' )
ORA-30683: failure establishing connection to debugger
ORA-12535: TNS:operation timed out
ORA-06512: at "SYS.DBMS_DEBUG_JDWP", line 68
ORA-06512: at line 1
Process exited.

Can anyone help me ?

Solution

In SQLDeveloper go to 'Tools' -> 'Preferences' -> 'Debugger'
Click the option for 'Prompt for debugger host for database debugging'

Comments

[Philippe RUAUDEL]

A precision, you have to enter the hostname of the machine which execute the debugger not the hostname of the database server. If you have ACL on your database instance, you need to add the hostname of the debugger machine in.