My Oracle Support Banner

OCI: Cloning a PDB from 12.2 CDB to migrate to 18.2 CDB failed (Doc ID 2455363.1)

Last updated on APRIL 09, 2020

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

The source 12.2 database was hosted in the Oracle Cloud OCI-Classic and the target was an 18c OCI database.
The upgrade process crashes while running the SQL "alter system flush shared_pool;". This issue was seen only for a particular PDB while for other PDBs in the same setup and cloned in the same way, the issue was not seen.

Details of the steps used:

- db-20 was 12.2 database in OCI Classic.
- db-100 was18.2 database in OCI.
- A VPN connection between both datacenters and a databaselink between both databases was used.
- Open source restricted

 

Changes

PDB Cloning from 12.2 to 18.2 CDB was attempted.

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.