preupgrade errors:"Preupgrade was executed, but there are some errors in some pluggable databases"
(Doc ID 2889391.1)
Last updated on APRIL 17, 2023
Applies to:
Oracle Database - Enterprise Edition - Version 12.1.0.2 and laterInformation in this document applies to any platform.
Symptoms
19c preupgrade.jar execution on RAC database, errors:
INFORMATION - Preupgrade was executed, but there are some errors in some pluggable databases, please review *.lst and *.log files
INFORMATION - Preupgrade was executed, but there are some errors in some pluggable databases, please review *.lst and *.log files
ERROR - Unable to run the preupgrade due to: Please review the preupgrade logs (*.log and/or *.lst files) for further information.
preupgrade.log is generated but it does not have any prechecks information for PDB$SEED
preupgrade is is unable to open PDB$SEED in read write mode as seen in alert log:
alter pluggable database pdb$seed close immediate instances=all
Tue July 09 11:25:49 2022
ALTER SYSTEM: Flushing buffer cache inst=1 container=2 local
Pluggable database PDB$SEED closed
Completed: alter pluggable database pdb$seed close immediate instances=all
alter pluggable database pdb$seed OPEN READ WRITE
Pdb PDB$SEED hit error 16001 during open read write (1) and will be closed.
Tue July 09 11:25:52 2022
ORA-16001: database already open for read-only access by another instance
ALTER SYSTEM: Flushing buffer cache inst=1 container=2 local
ORA-16001 signalled during: alter pluggable database pdb$seed OPEN READ WRITE...
Tue July 09 11:25:49 2022
ALTER SYSTEM: Flushing buffer cache inst=1 container=2 local
Pluggable database PDB$SEED closed
Completed: alter pluggable database pdb$seed close immediate instances=all
alter pluggable database pdb$seed OPEN READ WRITE
Pdb PDB$SEED hit error 16001 during open read write (1) and will be closed.
Tue July 09 11:25:52 2022
ORA-16001: database already open for read-only access by another instance
ALTER SYSTEM: Flushing buffer cache inst=1 container=2 local
ORA-16001 signalled during: alter pluggable database pdb$seed OPEN READ WRITE...
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 |