ALTER PLUGGABLE DATABASE

How to Resolve ORA-65040: operation not allowed from within a pluggable database

by Ed Chen
November 18, 2022October 25, 2022

ORA-65040 Tried to do something on all PDB, but it failed with ORA-65040. Alter Pluggable Database All SQL> alter pluggable database all open instances=all; alter… Read More »

How to Resolve ORA-65054: Cannot open a pluggable database in the desired mode

by Ed Chen
November 14, 2022November 21, 2022

ORA-65054 Tried to open a pluggable database (PDB), but it failed with ORA-65054. Let's see how it happened. SQL> alter session set container=ORCLPDB; Session altered.… Read More »

How to Build 19c RAC on Windows - 4 of 4 - Creating a RAC Database

by Ed Chen
July 9, 2022February 15, 2023

We click on Database Configuration Assistant (DBCA) in the menu to initiate the database creation process. We had better to restart both nodes to verify… 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 to Resolve ORA-44773: Cannot perform requested service operation

by Ed Chen
November 10, 2021November 10, 2021
2 Comments

ORA-44773 Tried to start a service of a cloned PDB, but it failed with ORA-44773. SQL> exec dbms_service.start_service('ERPGEN', DBMS_SERVICE.ALL_INSTANCES); BEGIN dbms_service.start_service('ERPGEN', DBMS_SERVICE.ALL_INSTANCES); END; * ERROR… Read More »

How to Resolve ORA-65000: missing or invalid pluggable database name

by Ed Chen
October 15, 2021October 11, 2021

ORA-65000 Tried to close a pluggable database (PDB) and got error ORA-65000. SQL> show con_name CON_NAME ------------------------------ CDB$ROOT SQL> alter pluggable database close immediate; alter… Read More »

How to Resolve ORA-65011: Pluggable database does not exist

by Ed Chen
August 23, 2021February 20, 2023
2 Comments

ORA-65011 There're several use cases that may throw ORA-65011. Switch Session Container Tried to set a PDB as the current session container, but it failed… Read More »

How to Resolve ORA-01109: database not open

by Ed Chen
June 5, 2021December 24, 2022
2 Comments

ORA-01109 ORA-01109 is pretty normal when the database you want to connect or operate with is at MOUNT or NOMOUNT state. In this post, we… Read More »

How to Create Pluggable Database (PDB)

by Ed Chen
May 29, 2021March 14, 2023

There're several ways that can create a PDB. Create a PDB by using SQL*Plus Create a PDB by using DBCA Create a PDB by cloning… Read More »

How to Resolve ORA-65025: Pluggable database is not closed on all instances.

by Ed Chen
May 22, 2021May 17, 2022

ORA-65025 ORA-65025 means that the pluggable database should be closed completely for further operations like dropping. Let's see some cases about this error. Drop PDB… Read More »