I am connected to a remote Dev database through SQL Developer.
SQL Developer specifications are as follows:
Java(TM) Platform 1.7.0
Oracle IDE 3.2.20.09.87
Versioning Support 3.2.20.09.87
When I try to debug the stored PL/SQL procedure, I get the following exceptions:
Connecting to the database XXXX.
Executing PL/SQL: ALTER SESSION SET PLSQL_DEBUG=TRUE
Executing PL/SQL: CALL DBMS_DEBUG_JDWP.CONNECT_TCP( 'XX.XX.X.XXX', '49152' )
ORA-30683: failure establishing connection to debugger
ORA-12541: TNS:no listener
ORA-06512: at "SYS.DBMS_DEBUG_JDWP", line 68
ORA-06512: at line 1 Process exited.
Disconnecting from the database XXXX.
I checked using netstat command and found that the PORT 49152 is listening. So it is not blocked. I tried using both the IPs: The IP of my machine and also the IP of the remote database server which is used to establish the connection.
What are the other things I should try?