My Oracle Support Banner

Shutdown Immediate Hangs When Job With Dbms_lock.sleep Is Running (Doc ID 2692108.1)

Last updated on JULY 20, 2024

Applies to:

Oracle Database - Enterprise Edition - Version 12.2.0.1 and later
Information in this document applies to any platform.

Symptoms

Shutdown immediate on a PDB does not kill Jxxx secondary for dbms_jobs

ALTER PLUGGABLE DATABASE OPEN
Fri Sep 13 07:46:30 2019
Database Characterset for PDB1 is WE8MSWIN1252
Opening pdb PDB1 (3) with no Resource Manager plan active
Pluggable database PDB1 opened read write
Completed: ALTER PLUGGABLE DATABASE OPEN
ALTER PLUGGABLE DATABASE CLOSE IMMEDIATE
Fri Sep 13 07:51:04 2019
Immediate Kill Session#: 1, Serial#: 44079
Immediate Kill Session: sess: 4080fd2d8 OS pid: 24388
Fri Sep 13 07:56:05 2019
Active process 24542 user 'oracle' program 'oracle@solaris (J000)' ------------>>>>>>>>>>>> shutdown will not proceed here
SHUTDOWN: waiting for logins to complete.
Fri Sep 13 08:06:03 2019

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.