My Oracle Support Banner

ORA-00600 [kpdbGetReplayCount: no pdb_sync$ row] Error While Trying To Open PDB. (Doc ID 2758031.1)

Last updated on MARCH 14, 2021

Applies to:

Oracle Cloud Infrastructure - Database Service - Version N/A to N/A [Release 1.0]
Information in this document applies to any platform.

Symptoms

SQL> show pdbs;

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 <pdb>                            MOUNTED
        
Trying to open pdb:

SQL> alter pluggable database <pd> open;
alter pluggable database <pdb> open
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [kpdbGetReplayCount: no pdb_sync$
row], [3], [], [], [], [], [], [], [], [], [], []

Sync Failure for user in PDB_PLUG_IN_VIOLATIONS not allowing PDB to come up. Violation shows:

NAME                           CAUSE                          TYPE      MESSAGE                                  STATUS
------------------------------ ------------------------------ --------- ---------------------------------------- --------------------
<pdb name>                   Sync Failure                   ERROR     Sync PDB failed with ORA-65177 during 'a PENDING
                                                                        lter user ORDS_PUBLIC_USER identified by
                                                                         * account unlock'

There is no row in the PDB_SYNC$ table in PDB:

SQL> select CTIME,SQLSTMT,NAME,FLAGS,OPCODE,REPLAY# from PDB_SYNC$;

no rows selected

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
References


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