Is it Possible to Switch OID Database DBA_JOBS / DBMS_JOBS to DBA_SCHEDULER_JOBS / DBMS_SCHEDULER in Order to Comply With STIG Recommendations?

(Doc ID 2388805.1)

Last updated on APRIL 19, 2018

Applies to:

Oracle Internet Directory - Version 11.1.1 and later
Information in this document applies to any platform.

Goal

Database (DB) Security Technical Implementation Guide (STIG) ID V-61449 flags dba_jobs / dbms_jobs usage which is obsolete.

As per this STIG: "The DBMS_JOB PL/SQL package has been replaced by DBMS_SCHEDULER in Oracle versions 10.1 and higher, though it continues to be supported for backward compatibility."

Oracle Internet Directory (OID) database jobs uses various DBA_JOBS jobs, such as oid_stats.gatherstats, or TSPurge.purgeDirObject (PL/SQL package TSPurge - reference OID Garbage Collection Framework, a garbage collector executed by the database job queue system based on a defined interval).

Reference OID documentation:
Fusion Middleware Administering Oracle Internet Directory
Chapter 36 Managing Garbage Collection

And DB documentation:
Database Administrator’s Guide
Appendix A Support for DBMS_JOB

Which shows:
"In Oracle Database 11g Release 2 (11.2), Oracle Scheduler replaces DBMS_JOB. Oracle Scheduler is more powerful and flexible than DBMS_JOB, which is a package used to schedule jobs. Although Oracle recommends that you switch from DBMS_JOB to Oracle Scheduler, DBMS_JOB is still supported for backward compatibility."


How to switch, change or move these OID related DBA_JOBS jobs to DBA_SCHEDULER_JOBS / DBMS_SCHEDULER?
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms