debugger stubbornly refuses to use correct IP address
662886Jul 16 2009 — edited Jul 20 2009I'm trying to use SQL Developer 1.5.4 to debug a stored procedure.
Sql Developer is running on my laptop: 192.168.8.148.
My database server is running on 192.168.8.197. Another machine on my LAN.
I'm trying to start a debugging session, I see
Executing PL/SQL: CALL DBMS_DEBUG_JDWP.CONNECT_TCP( '172.x.y.x', '64179' )
ORA-30683: failure establishing connection to debugger
ORA-12535: TNS:operation timed out
172.x.y.z is the address from my VPN. That's not right. My database server isn't on VPN. So I turn OFF the VPN, and now I see
Executing PL/SQL: CALL DBMS_DEBUG_JDWP.CONNECT_TCP( '192.168.80.1', '64195' )
ORA-30683: failure establishing connection to debugger
ORA-12535: TNS:operation timed out
192.168.80.1 is assigned to 'VMware Virtual Ethernet Adapter for VMnet1' The virtual adapter created for HOST ONLY connections. My server isn't running in a VM (ok, it is, but not on this host)
So I disable that adapter. and now:
Executing PL/SQL: CALL DBMS_DEBUG_JDWP.CONNECT_TCP( '192.168.153.1', '64234' )
ORA-30683: failure establishing connection to debugger
ORA-12535: TNS:operation timed out
192.168.153.1 is assigned to 'VMware Virtual Ethernet Adapter for VMnet8' The virtual adapter created for NAT connections. My server still isn't running on this host
So I disable that adapter, and now, FINALLY I can debug the stored procedure. But now I can't get email, nor can I have any VM's running.
So how do I make the debugger use the same network adapter that made the connection to the server