Home » SQL & PL/SQL » Client Tools » How to do remote debugging using SQL Dveloper (version: 1.2.0)
How to do remote debugging using SQL Dveloper [message #425765] Mon, 12 October 2009 02:42 Go to next message
suman.g
Messages: 88
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 Go to previous messageGo to next message
suman.g
Messages: 88
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
Re: How to do remote debugging using SQL Dveloper [message #426529 is a reply to message #425765] Fri, 16 October 2009 06:18 Go to previous messageGo to next message
msmallya77
Messages: 28
Registered: June 2009
Location: Ahmedabad
Junior Member
Hi,

Listener Service is not running. Activate Listener. I do not know what exactly the problem is, but, by looking at No Listener error, start the listener, this may help you.

Thanks and regards,

MSMallya

Re: How to do remote debugging using SQL Dveloper [message #426548 is a reply to message #426529] Fri, 16 October 2009 08:00 Go to previous messageGo to next message
suman.g
Messages: 88
Registered: June 2009
Member
Hi MSMallya,

Thanks for your reply... Smile
Can you please tell me how to activate listener. Do I need to ask DBA's for this?

Regards,
Suman
Re: How to do remote debugging using SQL Dveloper [message #426562 is a reply to message #425765] Fri, 16 October 2009 10:37 Go to previous messageGo to next message
msmallya77
Messages: 28
Registered: June 2009
Location: Ahmedabad
Junior Member
Hi,

Yes, you can ask your DBA to start listener service.

Thanks and regards,

MSMallya
Re: How to do remote debugging using SQL Dveloper [message #426845 is a reply to message #426562] Tue, 20 October 2009 01:41 Go to previous message
suman.g
Messages: 88
Registered: June 2009
Member
Hi MSMallya,

Thanks for your reply..

I will try with this also.

Regards,
Suman
Previous Topic: SQL Developer Templates
Next Topic: Worksheet (Oracle 8/9i database tool)
Goto Forum:
  


Current Time: Sat Dec 10 20:35:57 CST 2016

Total time taken to generate the page: 0.08702 seconds