天天看點

change pdb name in rac

node1:

1.close pdb on each node

SQL> alter pluggable database crmpdb close immediate;

Pluggable database altered.

2.open pdb on one node in restricted mode

SQL> alter pluggable database crmpdb open restricted;

Pluggable database altered.

SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED

---------- ------------------------------ ---------- ----------

         2 PDB$SEED                       READ ONLY  NO

         3 PDB                            READ WRITE NO

         4 PDB2                           READ WRITE NO

         5 CRMPDB                         READ WRITE YES

SQL> alter session set container=crmpdb;

Session altered.

3.change pdb name

SQL> alter pluggable database rename global_name to hcpdbc;

Pluggable database altered.

4.close  and   open

SQL> alter pluggable database close immediate;

Pluggable database altered.

SQL> alter pluggable database open;

Pluggable database altered.

SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED

---------- ------------------------------ ---------- ----------

         5 HCPDBC                         READ WRITE NO

SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED

---------- ------------------------------ ---------- ----------

         2 PDB$SEED                       READ ONLY  NO

         3 PDB                            READ WRITE NO

         4 PDB2                           READ WRITE NO

         5 HCPDBC                         READ WRITE NO

SQL> 

SQL> 

node2:

SQL> alter pluggable  database crmpdb close immediate;

Pluggable database altered.

SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED

---------- ------------------------------ ---------- ----------

         2 PDB$SEED                       READ ONLY  NO

         3 PDB                            READ WRITE NO

         4 PDB2                           READ WRITE NO

         5 CRMPDB                         MOUNTED

SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED

---------- ------------------------------ ---------- ----------

         2 PDB$SEED                       READ ONLY  NO

         3 PDB                            READ WRITE NO

         4 PDB2                           READ WRITE NO

         5 HCPDBC                         MOUNTED

after change ok on node1,open on node2

SQL> alter pluggable database hcpdbc open;

Pluggable database altered.

SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED

---------- ------------------------------ ---------- ----------

         2 PDB$SEED                       READ ONLY  NO

         3 PDB                            READ WRITE NO

         4 PDB2                           READ WRITE NO

         5 HCPDBC                         READ WRITE NO

SQL>