Getting this error: ORA-12012: error on auto execute of job 9

Document ID : KB000004243
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

You start to get this error:

ORA-12012: error on auto execute of job 9 

ORA-02289: sequence does not exist 

ORA-06512: at "OBLICORE.PART_MNG_PKG", line 16 

ORA-06512: at "OBLICORE.PART_MNG_PKG", line 440 

ORA-02289: sequence does not exist 

ORA-01403: no data found 

 

Cause:

It’s trying to run one of the scheduled jobs and the job is not created properly. Normally this gets created during the install as long as the Oracle job scheduling service is installed. It may be that they only added the service after the fact or something went wrong during the job creation.

Resolution:

You should be able to recreate it from the installation media (it’s a simple job that then reads a table for what to clear, but the job is always there).

 

Run: Select * from user_jobs;

To see the job.

Please make sure:

1. The database package Part_Mng_Pkg is compiled.

2. The raw data job exists, scheduled and unbroken

 

The job can be recognized by What= Part_Mng_Pkg.G_TABLE_NAME :='T_RAW_DATA';Part_Mng_Pkg.raw_data_purge;

Additional Information:

The Part_Mng_Pkg.sql can be found under the DVD:

DVD:\SetupDB\InstallDB\Build_Schema\Packages