How to do remote debugging using SQL Dveloper [message #425765] |
Mon, 12 October 2009 02:42  |
suman.g
Messages: 89 Registered: June 2009
|
Member |
|
|
Hi All,
I want to use remote debugging using SQL Developer but I am getting some errors.
Steps performed:
database(Dev Ins) -> right click -> remote debug -> new window will open -> 10 class IP of my system and port number as 4000.
database(Dev Ins) -> right click -> SQL*Plus -> password.
exec DBMS_DEBUG_JDWP.CONNECT_TCP( 'Local IP',4000);
giving below errors:
ERROR at line 1:
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
Please let me know if I have missed any setup or if I am not giving correct parameters.
Thanks in advance.
Regards,
Suman
|
|
|
Re: How to do remote debugging using SQL Dveloper [message #425806 is a reply to message #425765] |
Mon, 12 October 2009 05:13   |
suman.g
Messages: 89 Registered: June 2009
|
Member |
|
|
Hi All,
I have also done the following setup as suggested in some forums..
1- granted the user with privileges DEBUG CONNECT SESSION and DEBUG ANY PROCEDURE in our Dev Ins.
2- tools -> preferences -> debugger -> checked "Prompt for Debugger host for database Debugging.
3- tools -> preferences -> debugger -> debugging port range between 4000-4999.
In my local machine only one port is open i.e. 4473 and I have tried out with that but it's still giving the same error.
I it require to open all ports between 4000-4999.
Thanks & Regards,
Suman
|
|
|
|
|
|
|