问题
在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