12.2:DB Upgrade step:"alter pluggable database all open upgrade" Fails with Error : "ORA-00604 & ORA-01465: invalid hex number" (Doc ID 2249786.1)

Last updated on JUNE 16, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 12.2.0.1 to 12.2.0.1 [Release 12.2]
Information in this document applies to any platform.

Symptoms

Before running upgrade script on 12.2.0.1 Oracle_Home need to open all PDB's in upgrade mode, which fails:

SQL> startup upgrade
ORACLE instance started.

Total System Global Area 3254779904 bytes
Fixed Size 8798024 bytes
Variable Size 1946157240 bytes
Database Buffers 1291845632 bytes
Redo Buffers 7979008 bytes
Database mounted.
Database opened.

SQL> alter pluggable database all open upgrade;
alter pluggable database all open upgrade
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-01465: invalid hex number

SQL> select CON_ID, NAME, OPEN_MODE from V$PDBS;

CON_ID NAME OPEN_MODE
---------- -------------- ----------
2 PDB$SEED MIGRATE
3 XYZ_PDB MOUNTED >>>>Status no changed to Migrate

 

 

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms