You have a scheduler job that generated an error. When the error occurred, you attempted to disable the job to investigate the error, but received an ORA-27468 error message.

27468, 00000, "\"%s.%s\" is locked by another process"
// *Cause: An attempt was made to read or modify the state of the named
//         scheduler object when another process was also updating the same
//         object and held the lock.
// *Action: Retry the operation. Scheduler locks are held for a very
//          short duration. If the error persists, contact Oracle Support.

Since the documentation for this message said to try again later, you waited, but have continued to receive the same error message.

 

SRE实战 互联网时代守护先锋，助力企业售后服务体系运筹帷幄！一键直达领取阿里云限量特价优惠。

 

To implement the solution, please execute the following steps:

1.  Check the value for the job_queue_processes:

SQL> show parameter job

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
job_queue_processes                  integer     1000
SQL>



2. Stop the cjq0 process.

SQL> show parameter job

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
job_queue_processes                  integer     1000
SQL> alter system set job_queue_processes=0;

System altered.

SQL> show parameter job

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
job_queue_processes                  integer     0
SQL>

    This may require a kill -9 if on Unix or Linux.

3. Drop the problematic job.

4. Restart the cjq0 process.

    Reset the job_queue_processes back to the original setting (from show parameter command) using

         SQL> alter system set job_queue_processes=<old value>;

摘自：文档 ID 330725.1

扫码关注我们
微信号：SRE实战
拒绝背锅 运筹帷幄