Oracle | DBMS_DEBUG_JDWP

Oracle DBMS_DEBUG_JDWP_CUSTOM Version 21c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

Purpose Default implementation of the custom package procedure that will be invoked to process a debug connection request that arrives in the form of an ORA_DEBUG_JDWP

AUTHID CURRENT_USER

Dependencies

DBMS_DEBUG_JDWP

Documented Yes: Packages and Types Reference

Exceptions

Error Code	Reason
ORA-20000	debug connection to this host not permitted

First Available 9.0

Security Model Owned by SYS with EXECUTE granted to PUBLIC

Source {ORACLE_HOME}/rdbms/admin/dbmsjdcu.sql

CONNECT_DEBUGGER

Connect the specified session to the debugger waiting at host:port

This demo performs added security checks to decide if the debug connection request is granted (for example, by verifying that the debugger is running on a trusted host)

Note: In 11gR1, and thereafter, an ACL must be created for this call to succeed (see links below) dbms_debug_jdwp.connect_debugger( host IN VARCHAR2, port IN VARCHAR2, debug_role IN VARCHAR2 := NULL, debug_role_pwd IN VARCHAR2 := NULL, option_flags IN PLS_INTEGER := 0, extensions_cmd_set IN PLS_INTEGER := 128);

DECLARE

       vhost VARCHAR2(40) := 'bigdog.mlib.org';

       vport VARCHAR2(10) := '1521';

      BEGIN

        IF (utl_inaddr.get_host_address(vhost) != '192.168.1.42') THEN

          RAISE_APPLICATION_ERROR(-20000, 'debug connection to this host not permitted');

        ELSE

          dbms_debug_jdwp_custom.connect_debugger(vhost, vport);

        END IF;

        dbms_debug_jdwp.disconnect;

      END;

      /