To restart a PDB (Pluggable Database) in an Oracle RAC (Real Application Clusters) environment, you can use the following commands:

1. Connect to the CDB (Container Database) as a privileged user:
   
   
   
   
   sqlplus / as sysdba
2. Determine the name of the PDB that you want to restart:
   
   
   
   
   SELECT name FROM v$pdbs;
3. Switch to the PDB that you want to restart:
   
   
   
   
   ALTER SESSION SET CONTAINER=<PDB_NAME>;
4. Check the current status of the PDB:
   
   
   
   
   SELECT name, open_mode FROM v$pdbs WHERE name='<PDB_NAME>';
5. If the PDB is currently open, close it:
   
   
   
   
   ALTER PLUGGABLE DATABASE <PDB_NAME> CLOSE;
6. Wait for the PDB to close:
   
   
   
   
   SELECT name, open_mode FROM v$pdbs WHERE name='<PDB_NAME>';
7. Once the PDB is closed, restart it:
   
   
   
   
   ALTER PLUGGABLE DATABASE <PDB_NAME> OPEN;
8. Check the status of the PDB to confirm that it has been restarted:
   
   
   
   
   SELECT name, open_mode FROM v$pdbs WHERE name='<PDB_NAME>';

That's it! You have successfully restarted a PDB in an Oracle RAC environment using commands.

 

Looking forward for your suggestions.. please feel free to write to me.. Your help would definitely help to improve our blog. Chetan Yadav