Disabling Parallel DML for Oracle Autonomous Database on Oracle 19c

If you choose to use the HIGH or MEDIUM services for Oracle Autonomous Database on Oracle 19c, you must modify the orpm_admuser.sql script to disable Parallel Data Manipulation Language (Parallel DML) before you run dbsetup.bat. If Parallel DML is not disabled, dbsetup.bat will fail with an error code of either ORA-12838 or ORA-12839.

To disable Parallel DML in the orpm_admuser.sql script:

  1. Browse to the database directory where dbsetup resides, then open the lib directory.
  2. Open DBS_PM_<release_level>.jar in an archive extraction utility.
  3. Within the archive extraction utility:
    1. Go to \install\PM_<release_level>.
    2. Copy orpm_admuser.sql to a local drive.
  4. Open the local copy of orpm_admuser.sql in a text editor.
    1. Add following lines to the top of the orpm_admuser.sql script:

      alter session disable parallel dml

      /

    2. Save your changes, then close the text editor.
  5. Copy the modified script back into the DBS_PM_<release_level>.jar file.

Related Topics

Installing a P6 EPPM Database with Oracle Autonomous Database


Last Published Friday, August 8, 2025