ALTER SYSTEM DISABLE RESTRICTED SESSION

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 to Resolve ORA-12526: TNS:listener: all appropriate instances are in restricted mode

by Ed Chen
November 17, 2021June 11, 2022

ORA-12526 When we tried to connect to the database, it failed with ORA-12526 like the following. SQL> conn hr/hr@orcl ERROR: ORA-12526: TNS:listener: all appropriate instances… Read More »

How Oracle Rename PDB

by Ed Chen
May 24, 2021February 17, 2023

Rename Pluggable Database After creating a new PDB or cloning a remote PDB, you might want to change its name for your own purpose. In… Read More »

How Oracle Disable Restricted Mode

by Ed Chen
October 11, 2018December 20, 2022

Disable Restricted Mode After you have done your jobs in restricted mode, you may consider to leave the mode. Disabling restricted mode means that we… Read More »

JavaScript is not enabled. Please enable it and reload the page.