Status RESTRICTED

How to Resolve "Warning: PDB altered with errors."

by Ed Chen
April 11, 2022February 12, 2023
6 Comments

Warning: PDB altered with errors Tried to open a newly cloned or created PDB, but it failed with "Warning: PDB altered with errors". SQL> alter… Read More »

How to Resolve ORA-65144: ALTER SYSTEM DISABLE RESTRICTED SESSION is not permitted

by Ed Chen
April 11, 2022May 18, 2022

ORA-65144 Tried to remove restricted mode from a newly cloned PDB, but it failed with ORA-65144. SQL> show pdbs CON_ID CON_NAME … Read More »

How Oracle Enable PDB Restricted Mode

by Ed Chen
September 20, 2021December 24, 2022

We can enable the restricted mode of a PDB either in CDB or PDB. In CDB Enabling the restricted mode of a PDB in the… Read More »

How to Remove PDB from Restricted Mode

by Ed Chen
September 20, 2021December 24, 2022

To remove the restricted mode from PDB, we can do it either in CDB or PDB. In fact, disabling the restricted mode is just a… Read More »

How to Connect Idle, Nomount or Restricted Database Remotely

by Ed Chen
October 10, 2012December 11, 2022

Connect an Idle, Nomount or Restricted Database Locally Users who belong to OSDBA or OSOPER can access a database in any states including idle, NOMOUNT… Read More »