shutdown normal 挂起 在ora_j00X进程上

shutdown normal 挂起 在ora_j00X进程上

参考原文：Shutdown Normal Hung On ORA_J00# Process (Doc ID 1197314.1)

适用于：
Oracle Server - Enterprise Edition - Version: 10.2.0.4 and later   [Release: 10.2 and later ]
Information in this document applies to any platform.


症状：

在alert log中显示 shutdown normal 挂起 在ora_j00X进程上：

Active process 1432 user 'oraj0' program 'oracle@mydb129 (J000)'
Active process 1432 user 'oraj0' program 'oracle@mydb129 (J000)'
SHUTDOWN: waiting for logins to complete.


原因：

shutdown normal 正在等待job完成。使用下面的语句来检查哪个job正在运行：

 

SQL> select owner, job_name, session_id, slave_os_process_id, running_instance from dba_scheduler_running_jobs;

shutdown normal 挂起 ，原因是它正在等待 the AUTO_SPACE_ADVISOR_JOB job  完成。

解决方案：
首先停止正在执行的job，然后shutdown normal
BEGIN
DBMS_SCHEDULER.stop_job (job_name => 'AUTO_SPACE_ADVISOR_JOB', force => TRUE);
END;
/