Oracle DBMS_ISCHED_REMOTE_ACCESS
Version 20c

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

Note: This page has been posted prior to the GA release of 20c. It will be completed once we have access to the release version.
AUTHID DEFINER
Dependencies
ADD_AGENT_CERTIFICATE DBMS_TRANSACTION SUBMIT_FILEWATCH_RESULTS
AQ$_AGENT DBMS_UTILITY SUBMIT_JOB_RESULTS
DBMS_AQ DUAL SCHEDULER_FILEWATCHER_RES_LIST
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 UTL_URL
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
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

Related Topics
Built-in Functions
Built-in Packages
DBMS_CHAIN_INVOKER
DBMS_ISCHED
DBMS_ISCHEDFW
DBMS_ISCHED_AGENT
DBMS_ISCHED_REMDB_JOB
DBMS_ISCHED_UTL
DBMS_SCHEDULER
DBMS_SCHED_ARGUMENT_IMPORT
DBMS_SCHED_ATTRIBUTE_EXPORT
DBMS_SCHED_EXPORT_CALLOUTS
DBMS_SCHED_FILE_WATCHER_EXPORT
What's New In 19c
What's New In 20c

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx