In 12.2 environment the below parameter change throws error saying not allowed from within a pluggable database

SQL> alter system set "undo_retention"= 900;
alter system set "undo_retention"= 900
*
ERROR at line 1:
ORA-65040: operation not allowed from within a pluggable database

Undo related parameters are not PDB-modifiable in “shared” undo mode. But in local undo mode, they are PDB-modifiable, since the undo tablespace is available in each PDB.http://www.cndba.cn/hbhe0316/article/116521

Convert CDB from Shared to Local Undo Mode as below, Login to CDB


SQL> startup upgrade
SQL> alter database local undo on;
SQL> startup force;

SQL> ALTER PLUGGABLE DATABASE PDB1  OPEN READ WRITE;
SQL> ALTER SESSION SET CONTAINER=PDB1;
SQL> alter system set "undo_retention"=900;

 If you check v$parameter view again in local undo mode, then ISPDB_MODIFIABLE will show TRUE. This is the reason that ALTER SYSTEM SET is also succeeding.

SQL> select property_value from database_properties where property_name='LOCAL_UNDO_ENABLED';

PROPERTY_VALUE
-----------------------------------------------------------------------------
TRUE

SQL> select ispdb_modifiable from v$parameter where name='undo_retention';

ISPDB
-----
TRUE

版权声明：本文为博主原创文章，未经博主允许不得转载。

oracle