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

Last updated on JUNE 07, 2023

Applies to:

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

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