Debugging PL/SQL in SQLDeveloper Fails with ORA-24247 Error (Doc ID 2949123.1)

Last updated on MAY 24, 2023

Applies to:

Symptoms

Not able to use the Debug functionality in SQL Developer 19.2. Getting the below mentioned error.

Executing PL/SQL: CALL DBMS_DEBUG_JDWP.CONNECT_TCP( '<IP_ADDRESS>', '' )
ORA-24247: network access denied by access control list (ACL)
ORA-06512: at "SYS.DBMS_DEBUG_JDWP", line 68
ORA-06512: at line 1

But the below mentioned grants have already been made:

GRANT DEBUG CONNECT SESSION TO ;
GRANT DEBUG ANY PROCEDURE TO ;
GRANT EXECUTE ON SYS.DBMS_DEBUG_JDWP to ;

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. In SQL Developer, connect to the desired schema
2. In the list of procedures, choose the one that needs to be debugged
3. From the context menu, select Debug
4. Enter proper parameter values and select OK
5. The error will be shown

BUSINESS IMPACT
-----------------------
Due to this issue, users cannot perform debugging sessions on the PL/SQL code, which affects the development process

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.