ORA-14400: inserted partition key does not map to any partition in OMS 12c

This is due to job_queue_processes initialization parameter is set to zero and none of the Repository DBMS_SCHEDULER jobs are running.

Please execute the below in repository database.

alter system set JOB_QUEUE_PROCESSES=100 scope=both;

Depending on the work load we may need to increase the value.

  • December 28, 2017 | 15 views
  • Comments