This content has been marked as final. Show 1 reply
The above address is the one chosen by SQL developer initially and is also the one shown in my sys_context('userenv','ip_address').
It might be a firewall issue; especially if you have been working with VM on that machine.
While you wait for one of the sql dev people to respond you may want to review this doc about 'Running and Debugging PL/SQL and Java Stored Procedures'.
This is from the Fusion Middleware doc for JDeveloper but sql developer is based on JDeveloper
29.3.2 How to Specify the Database Debugger Port
When the database debugger is running, for example to debug PL/SQL through a database connection, the ports used are randomly assigned. This can cause problems with firewalls, and to avoid them you can edit the ide.properties file to ensure that a specific port is used.
To specify the port:
If necessary, close JDeveloper.
In a text editor, open jdev_install/jdeveloper/jdev/system/oracle.jdeveloper.release_number/ide.properties.
Type the following:
where port_number is the port number you want the debugger to use.
Save ide.properties. When you restart JDeveloper, the port you specified will be used.
The entire section at the link provides more information about establishing a debugger connection if you haven't done that before on any machine.