My Oracle Support Banner

PDB in Restricted Mode: ERROR Sync PDB failed with ORA-959 during 'create PENDING user c##abcd identified by * default tablespace xyz quota 1m on xyz container = all (Doc ID 3011941.1)

Last updated on JULY 20, 2024

Applies to:

Oracle Database - Enterprise Edition - Version 19.10.0.0.0 and later
Information in this document applies to any platform.

Symptoms

While checking PDB_PLUG_IN_VIOLATIONS with the following query:

SQL> SELECT name, cause, type, message, status, action FROM PDB_PLUG_IN_VIOLATIONS WHERE type LIKE 'ERROR%' AND status LIKE 'PENDING';

encountered the following error:

 

SQL> select name, cause, type, message, status, action from PDB_PLUG_IN_VIOLATIONS where type like 'ERROR%' and status like 'PENDING'

SQL> set lines 1000

SQL> /

NAME CAUSE TYPE MESSAGE STATUS ACTION

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

PDB199 Sync Failure ERROR Sync PDB failed with ORA-959 during 'cre PENDING

ate user c##abc identified by * default tablespace xyz quota 1m on xyz container = all'

 

Additionally, the PDB is in restricted mode 

SQL> show pdbs

CON_ID CON_NAME OPEN MODE RESTRICTED

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

2 PDB$SEED READ ONLY NO

3 PDB199 READ WRITE YES

While executing this query:

 

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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

In this Document
Symptoms
Changes
Cause
Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.