He is trying to close a PDB on all the instances using following command:alter pluggable database PDB1 close instances=ALL;As per the documentation, it should close PDB on all the instances, but it only closing the PDB on local instance and not on remote instance. ...
ALTER PLUGGABLE DATABASE pdb6 CLOSE RELOCATE TO 'ORCLDB_3'; CDB内のすべてのPDBの状態を変更する例:現在のコンテナがルートであることが前提となります。次の文はCDB内のすべてのPDBをREADONLYオープン・モードでオープンします。
You can perform allALTERPLUGGABLEDATABASEtasks by connecting to a PDB and running the correspondingALTERDATABASEstatement. This functionality is provided to maintain backward compatibility for applications that have been migrated to a CDB environment. The exception is modifying PDB storage limits, for wh...
A pluggable database (PDB) name to switch to that PDB. You can view the names of the PDBs in a CDB by querying the DBA_PDBS view. You can determine the container to which the current session is connected by using the SQL*Plus SHOW CON_NAME command or with the following SQL query:...
When you use theALTERSYSTEMstatement in a multitenant container database (CDB), you can specify some clauses to alter the CDB as a whole and other clauses to alter a specific pluggable database (PDB). See Also: Oracle Database Administrator's Guidefor complete information on using theALTER...
alter_pluggable_database::= Description of the illustration alter_pluggable_database.eps (pdb_unplug_clause::=,pdb_settings_clauses::=,pdb_datafile_clause::=,pdb_recovery_clauses,pdb_change_state::=,pdb_change_state_from_root::=,application_clauses::=) ...
When you use theALTERSYSTEMstatement in a multitenant container database (CDB), you can specify some clauses to alter the CDB as a whole and other clauses to alter a specific pluggable database (PDB). See Also: Oracle Database Administrator's Guidefor complete information on using theALTER...