Having a PDB PDB3 and an associated service,
created with
"srvctl add service -db testcdb -service pdb3_svc -serverpool testcdb_pool -policy automatic -failovertype SELECT -failovermethod BASIC -cardinality UNIFORM -pdb pdb3"
If service runs and you hit a
"alter pluggable database pdb3 close normal" the PDB will never close.
To resolve this hanging situation you can only enter "srvctl stop service -db testcdb -service pdb3_svc", this seemly failed with ORA-01090,
but then you can hit successfully "alter pluggable database pdb3 close" again.
Same situation, but if entering a
"alter pluggable database pdb3 close immediate" will close the PDB and does stop the service pdb3_svc.
Is it expected, that normal closing of a PDB with associated running service is causing a wait as long this service is forcebly canceled?
Peter