Oracle | DBMS_ISCHED_REMOTE

Oracle DBMS_ISCHED_REMOTE_ACCESS Version 21c

General Information

Library Note

Morgan's Library Page Header

Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.

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 the REMOTE_SCHEDULER_AGENT role.

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