Oracle | DBMS_ISCHED_REMOTE

Oracle DBMS_ISCHED_REMOTE_ACCESS 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 Undocumented DBMS_SCHEDULER utilities

AUTHID DEFINER

Dependencies

ADD_AGENT_CERTIFICATE	DBMS_TRANSACTION	SCHEDULER_FILEWATCHER_RES_LIST
AQ$_AGENT	DBMS_UTILITY	SUBMIT_FILEWATCH_RESULTS
DBMS_AQ	DUAL	SUBMIT_JOB_RESULTS
DBMS_ASSERT	FILEWATCH_REQUEST_RESEND	SUBMIT_JOB_RESULTS2
DBMS_CRYPTO	OBJ$	UNREGISTER_AGENT
DBMS_ISCHED	PLITBLM	UTL_ENCODE
DBMS_ISCHED_REMDB_JOB	REGISTER_AGENT3	UTL_FILE
DBMS_LOB	REG_START	UTL_I18N
DBMS_LOCK	SCHEDULER$_DESTINATIONS	UTL_INADDR
DBMS_SCHEDULER	SCHEDULER$_GLOBAL_ATTRIBUTE	UTL_RAW
DBMS_SCHEDULER_LIB	SCHEDULER_FILEWATCHER_REQUEST	UTL_TCP
DBMS_STANDARD	SCHEDULER_FILEWATCHER_REQ_LIST	UTL_URL
DBMS_SYSTEM	SCHEDULER_FILEWATCHER_RESULT

Documented No

First Available 12.1

Security Model Owned by SYS with EXECUTE granted to REMOTE_SCHEDULER_AGENT.

Source {ORACLE_HOME}/rdbms/admin/dbmsrsa.plb

Subprograms

ADD_AGENT_CERTIFICATE	FILEWATCH_REQUEST_RESEND	SUBMIT_JOB_RESULTS
AGENT_REGISTRATION_LOCKED	GETREGPWDKEYSPEC	SUBMIT_JOB_RESULTS2
ATTEMPT_LIMIT_REACHED	SUBMIT_FILEWATCH_RESULTS	UNREGISTER_AGENT

ADD_AGENT_CERTIFICATE

Undocumented dbms_isched_remote_access.add_agent_certificate( hostname IN VARCHAR2, certificate IN VARCHAR2, current_date IN VARCHAR2, password_hash IN VARCHAR2, port IN VARCHAR2, nonce IN VARCHAR2, enc_key IN VARCHAR2, key_hash IN VARCHAR2, agent_name IN VARCHAR2, hashed_password IN VARCHAR2, db_name OUT VARCHAR2, my_nonce OUT VARCHAR2, my_mac OUT VARCHAR2);

TBD

AGENT_REGISTRATION_LOCKED

Undocumented

This likely must be run after ADD_AGENT_CERTIFICATE dbms_isched_remote_access.agent_registration_locked;

exec dbms_isched_remote_access.agent_registration_locked;

      *

      ERROR at line 1:

      ORA-00988: missing or invalid password(s)

      ORA-06512: at "SYS.DBMS_ISCHED", line 3742

      ORA-06512: at "SYS.DBMS_ISCHED_REMOTE_ACCESS", line 137

      ORA-01403: no data found

      ORA-06512: at "SYS.DBMS_ISCHED_REMOTE_ACCESS", line 123

      ORA-06512: at line 1

ATTEMP_LIMIT_REACHED

Undocumented

This likely must be run after ADD_AGENT_CERTIFICATE dbms_isched_remote_access.attempt_limit_reached RETURN BOOLEAN;

BEGIN

        IF dbms_isched_remote_access.attempt_limit_reached THEN

          dbms_output.put_line('Attempt Limit Reached');

        ELSE

          dbms_output.put_line('Attempt Limit Not Yet Reached');

        END IF;

      END;

      /

      *

      ERROR at line 1:

      ORA-00988: missing or invalid password(s)

      ORA-06512: at "SYS.DBMS_ISCHED", line 3742

      ORA-06512: at "SYS.DBMS_ISCHED_REMOTE_ACCESS", line 44

      ORA-01403: no data found

      ORA-06512: at "SYS.DBMS_ISCHED_REMOTE_ACCESS", line 25

      ORA-06512: at line 2

FILEWATCH_REQUEST_RESEND

Undocumented dbms_isched_remote_access.filewatch_request_resend(hostname IN VARCHAR2) RETURN BOOLEAN;

BEGIN

        IF dbms_isched_remote_access.filewatch_request_resend('PERRITO5') THEN

          dbms_output.put_line('T');

        ELSE

          dbms_output.put_line('F');

        END IF;

      END;

      /

      F

      

      PL/SQL procedure successfully completed.

GETREGPWDKEYSPEC

Undocumented dbms_isched_remote_access.getRegPwdKeySpec( salt OUT VARCHAR2, iterations OUT VARCHAR2, keylen OUT VARCHAR2);

TBD

SUBMIT_FILEWATCH_RESULTS

Undocumented dbms_isched_remote_access.submit_filewatch_results( name_array IN dbms_utility.lname_array, value_array IN dbms_utility.lname_array);

TBD

SUBMIT_JOB_RESULTS

Undocumented dbms_isched_remote_access.dbms_isched_remote_access.submit_job_results( job_name IN VARCHAR2, job_subname IN VARCHAR2, job_owner IN VARCHAR2, start_date IN TIMESTAMP WITH TIME ZONE, run_duration IN INTERVAL DAY TO SECOND, cpu_used IN INTERVAL DAY TO SECOND, error_number IN NUMBER, error_text IN VARCHAR2, output_text IN VARCHAR2, request_id IN NUMBER, add_info IN VARCHAR2, logging_level IN NUMBER, store_output IN NUMBER, std_err_length IN NUMBER, std_out_length IN NUMBER);

TBD

SUBMIT_JOB_RESULTS2

Undocumented dbms_isched_remote_access.submit_job_results2( agent_host IN VARCHAR2, job_results IN VARCHAR2, nonce IN VARCHAR2, current_date IN VARCHAR2, agent_name IN VARCHAR2);

TBD

UNREGISTER_AGENT

Undocumented dbms_isched_remote_access.unregister_agent( agent_host IN VARCHAR2, agent_name IN VARCHAR2, current_date IN VARCHAR2, nonce IN VARCHAR2, hash IN VARCHAR2);

TBD