Oracle19C配置MAX_STRING_SIZE

问题

在oracle19C数据库恢复完成后，进行PDB得启动未成功，报错了。

SQL> show pdbs; 

    CON_ID CON_NAME			  OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
	 2 PDB$SEED			  READ ONLY  NO
	 4 TEST			  MOUNTED
SQL> alter pluggable database TEST open;
alter pluggable database TEST open
*
ERROR at line 1:
ORA-14694: database must in UPGRADE mode to begin MAX_STRING_SIZE migration

处理

网上有很多大神发布了12C得处理过程，但是在19C上却不能运行。我按照如下操作解决得。
需要将MAX_STRING_SIZE修改为extended

SQL> alter session set container=TEST;

Session altered.

SQL> alter system set MAX_STRING_SIZE=extended scope=spfile;

System altered.




SQL> alter pluggable database TEST open read write;

Pluggable database altered.

SQL> show pdbs;

    CON_ID CON_NAME			  OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
	 2 PDB$SEED			  READ ONLY  NO
	 4 TEST			  READ WRITE NO

另外我也没跑utl32k.sql脚本，因为执行报错报错了

SQL> @?/rdbms/admin/utl32k.sql

Session altered.


Session altered.

DOC>#######################################################################
DOC>#######################################################################
DOC>   The following statement will cause an "ORA-01722: invalid number"
DOC>   error if the database has not been opened for UPGRADE.
DOC>
DOC>   Perform a "SHUTDOWN ABORT"  and
DOC>   restart using UPGRADE.
DOC>#######################################################################
DOC>#######################################################################
DOC>#
SELECT TO_NUMBER('MUST_BE_OPEN_UPGRADE') FROM v$instance
                 *
ERROR at line 1:
ORA-01722: invalid number