After recovery ORA-14693 / ORA-14694 (Doc ID 2011194.1)

Last updated on APRIL 18, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.1 to 12.1.0.2 [Release 12.1]
Information in this document applies to any platform.

Symptoms

SQL>  alter pluggable database all open;

ORA-14693: The MAX_STRING_SIZE parameter must be EXTENDED.

SQL> show pdbs

   CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 PDB11                          MOUNTED     NO             <<<<<<<<<<<<<<<<<<<<<<  This database is not opened
         4 PDB12                          READ WRITE NO
         5 PDB13                          READ WRITE NO
SQL>


SQL> alter pluggable database PDB11 open;
alter pluggable database PDB11 open
*
ERROR at line 1:
ORA-14693: The MAX_STRING_SIZE parameter must be EXTENDED.

 

SQL> sho parameter max_string_size

 

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

max_string_size string STANDARD             <<<<<<<<<< in CDB$ROOT

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