My Oracle Support Banner

The Cloning PDB from NON-CDB via Database Link Failed with ORA-01219 (Doc ID 2713578.1)

Last updated on OCTOBER 12, 2020

Applies to:

Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

 
The Cloning PDB from NON-CDB via Database Link Failed with ORA-01219

Environment is OCI DB system. The Pluggable Database was cloned from Standby Database which is opened in Read Only
The steps documented in the Note 1928653.1 is followed to clone the PDB from NON-CDB via Database Link

The PDB open failed as shown in the alert log file and trace file

Pdb XYZ hit error 1219 during open read write (1) and will be closed.
2020-08-10T18:45:04.983220-07:00
Errors in file /u01/app/oracle/diag/rdbms/XYZ/xyz/trace/xyz_ora_44693.trc:
ORA-01219: database or pluggable database not open: queries allowed on fixed tables or views only
XYZ(4):JIT: pid 44693 requesting stop
XYZ(4):Buffer Cache flush started: 4
2020-08-10T18:45:05.754236-07:00
XYZ(4):Buffer Cache flush finished

XYZ_ora_44693.trc
=======================
dbkedDefDump(): Starting a non-incident diagnostic dump (flags=0x0, level=0, mask=0x0)
----- Error Stack Dump -----
<error barrier> at 0x7ffd870bf558 placed kpdba.c@12767
ORA-01219: database or pluggable database not open: queries allowed on fixed tables or views only

 

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
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.