Failure establishing connection to debugger
Hi, all.
I've tried everything I can think of and still cannot get SQL Developer's PL/SQL debugger to work. Here is my environment:
Server: Oracle VirtualBox VM running OEL5 and Oracle Database 11gR2. VirtualBox Host-only network IP=192.168.56.200. Listener port 1521. Instance name SAMP.
Client: SQL Developer 3.1.07 on Windows 7 32-bit. VirtualBox Host-only network IP=192.168.56.1.
SQL Developer Debugger preferences are set for port range 4000-4999, and prompt for hostname on debug.
The database username is TRAIN01 and it has DEBUG CONNECT SESSION and DEBUG ANY PROCEDURE privileges.
I have a Windows Firewall Inbound rule allowing port 4000 from all programs in all domains (Domain, Work, Home).
What works:
1. SQL Developer can connect to the SAMP instance and run the procedure normally.
2. I can ping each machine from the other successfully.
What doesn't work:
1. Starting a debugging session fails with the following:
Connecting to the database LOCAL-SAMP-TRAIN01.
Executing PL/SQL: ALTER SESSION SET PLSQL_DEBUG=TRUE
Executing PL/SQL: CALL DBMS_DEBUG_JDWP.CONNECT_TCP( '192.168.56.1', '4000' )
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.
Disconnecting from the database LOCAL-SAMP-TRAIN01.
I have tried various recipes for Remote Debugging per the SQL Developer Help and blog posts, but haven't hit the magic incantation yet.
Does anyone have suggestions on what I am missing here?
Regards,
BobW