Hello All
I have a couple of questions.
VPN :
I have a DB residing on a server. I connect to this using SQL Developer via VPN.
I need to debug a Stored Procedure on this DB. I compiled the procedure for debug, set a breakpoint, but when I try to debug, the DEBUG LISTENER uses the PORT = 4000 and LOCAL ADDRESS = ETHERNET IP address.
QUESTION 01: How can I change the setting to make the LOCAL ADDRESS to be the VPN IP Address assigned to the laptop running SQL Developer ?
QUESTION 02 : I understand that the LOCAL ADDRESS should be the VPN IP ADDRESS assigned to me. On occassion, I was refused connection using the local IP and I entered the VPN IP. Yet the connection is refused. Do I need to open the port 4000 on the remote machine hosting the DB ?
SSH TUNNEL :
The PRODUCTION DB resides on a server [B] to which we connect using SSH TUNNEL. The Client [A] that uses SQL Developer will need to have the tunnel turned on manually, before connecting via SQL Developer.
QUESTION 03 : What configuration is needed for A to debug a stored procedure on B ? Does a port, say 4000, need to be opened on B, configured in the SSH TUNNEL software to connect to A ?
QUESTION 04 : We may have no choice but to COMPILE FOR DEBUG a PACKAGE on the PRODUCTION DB. Any risks or impacts ? I will of course COMPILE it back when the debug is done.
Many thanks for your answers
Best