OraVR: Relocate PDBs using DBCA in Silent Mode

Relocate PDBs using DBCA in Silent Mode

-- Connect to ORCL as SYS.
CREATE USER c##RMT_VB IDENTIFIED BY password CONTAINER=ALL;
GRANT create session, create pluggable database, sysoper TO c##RMT_VB CONTAINER=ALL;

SQL> select name from v$database;
NAME
---------
EAST
SQL> show pdbs;
    CON_ID CON_NAME           OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
     2 PDB$SEED                READ ONLY NO
     3 PDB1                   READ WRITE NO

[oracle@vishalbh db]$ dbca -silent -relocatePDB -remotePDBName PDB1 -remoteDBConnString ORCL -sysDBAUserName SYSTEM -sysDBAPassword password -remoteDBSYSDBAUserName SYS -remoteDBSYSDBAUserPassword password -dbLinkUsername c##RMT_VB -dbLinkUserPassword password -sourceDB ORCL2 -pdbName PDB1_RMT_VB
Prepare for db operation
50% complete
Create pluggable database using relocate PDB operation
100% complete
Pluggable database "PDB1_RMT_VB" plugged successfully.
Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/orcl2/PDB1_RMT_VB/orcl2.log" for further details.

SQL> -- login East
SQL> select name from v$database;
NAME
---------
EAST
SQL> show pdbs;
    CON_ID CON_NAME           OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
     2 PDB$SEED                 READ ONLY NO
     3 PDB1_RMT_VB             READ WRITE NO
SQL> conn vishalbh/*****@vishalbh:1521/PDB1_RMT_VB
Connected.
SQL> select count(*) from vb.temp;
COUNT(*)
----------
       201