Today I saw the following error message in the alert log of my database:
2019-02-12T13:27:30.506714+01:00 Errors in file /u01/oracle/diag/rdbms/proddb01/proddb01/trace/proddb01_j000_20661.trc: ORA-12012: error on auto execute of job 98 ORA-30967: operation directly on the Path Table is disallowedThis error was connected to a procedure I had made earlier, in this post.
In short, the procedure creates a job using dbms_jobs, and executes it thereafter. Because an error occured during job execution, the job appeared to be jamming connections to the database. The job needed to be dropped immediately.
To remove the job, use either the dbms_job.remove procedure, like this:
sqlplus username/password begin sys.dbms_job(98); commit; end; /
If you do not have the password for schema owning the job, Use the undocumented procedure sys.dbms_ijob, like this:
sqlplus / as sysdba begin sys.dbms_ijob(98); commit; end; /
No comments:
Post a Comment