Skip to Main Content
Forums

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

ORA-30683 when trying to debug "remote" DB package

Dezsoe KadosOct 5 2019 — edited Oct 28 2019

DB-Version 12.1.0.2.0

Sqldeveloper information;

Java(TM) Platform13
Oracle IDE19.2.1.247.2212
Versioning Support19.2.1.247.2212

Executing PL/SQL: CALL DBMS_DEBUG_JDWP.CONNECT_TCP( '192.168.134.1', '4000' )

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

The user setup includes

grant debug connect session to xxxxx;

grant debug any PROCEDURE to xxxxx;

grant EXECUTE on sys.DBMS_DEBUG_JDWP to xxxxx;

BEGIN

DBMS_NETWORK_ACL_ADMIN.APPEND_HOST_ACE

(

host => '192.168.134.1',

lower_port => 4000,

upper_port => 4000,

ace => xs$ace_type(privilege_list => xs$name_list('jdwp'),

principal_name => 'XXXXX',

principal_type => xs_acl.ptype_db)

);

END;

/

Windows firewall is off,

firewall on DB system is also off.

Connect happens via TNS.

After some Google search I also tried to use "DatabaseDebuggerDisableJDWP=true" in the config file, but this does not seem to honored.

Any hints?

Comments

Post Details

Added on Oct 5 2019
#sql-developer
5 comments
479 views