Shutdown normal hangs on the ora_j00x process

Shutdown normal hangs on the ora_j00x process

Reference Original: Shutdown Normal Hung on ora_j00# Process (Doc ID 1197314.1)

Suitable for:
Oracle server-enterprise edition-version:10.2.0.4 and later [release:10.2 and later]
Information in this document applies to any platform.


Symptoms:

Shown in alert log shutdown normal hangs on the ora_j00x process:

Active process 1432 User ' oraj0 ' program ' [email protected] (J000) '
Active process 1432 User ' oraj0 ' program ' [email protected] (J000) '
Shutdown:waiting for logins to complete.


Reason:

Shutdown normal is waiting for the job to complete. Use the following statement to check which job is running:

Sql> Select owner, job_name, session_id, slave_os_process_id, running_instance from Dba_scheduler_running_jobs;

Shutdown normal hangs because it is waiting for the auto_space_advisor_job JOB to complete.

Solution:
First stop the job that is being executed, and then shutdown normal
BEGIN
Dbms_scheduler.stop_job (job_name = ' auto_space_advisor_job ', force = TRUE);
END;
/

Shutdown normal hangs on the ora_j00x process