This blog aims to support DBAs in converting a Non-CDB database to a PDB using remote cloning method.

Note: Non-CDB and target CDB are on different hosts (both on-premises)

Create a user in Source Non-CDB and grant required privileges.

SQL> create user CDB_CLONE_USER identified by !@#$%^&*;

User created.

SQL> GRANT CREATE SESSION, CREATE PLUGGABLE DATABASE TO CDB_CLONE_USER;

Grant succeeded.

Put the Source Non-CDB in read only mode.

SQL> startup mount;

ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance

ORACLE instance started.

Total System Global Area 1.2885E+10 bytes

Fixed Size 8939584 bytes

Variable Size 1778384896 bytes

Database Buffers 1.1073E+10 bytes

Redo Buffers 24612864 bytes

Database mounted.

SQL> ALTER DATABASE OPEN READ ONLY;

Database altered.

SQL> create database link CLONE_LINK connect to CDB_CLONE_USER identified by !@#$%^&* using ‘remote_non_cdb’;

SQL> CREATE PLUGGABLE DATABASE TEST FROM TEST@clone_link keystore identified by “PTM_sal#1511#” parallel 8;

Pluggable database created.

./datapatch -verbose