Pluggable Database (PDB)

How to Resolve ORA-65096: invalid common user or role name

by Ed Chen
June 10, 2022November 22, 2022
15 Comments

ORA-65096 Tried to add a user to the database, but it failed with ORA-65096. SQL> create user hr; create user hr … Read More »

How to Resolve ORA-00959: tablespace does not exist

by Ed Chen
May 25, 2022March 20, 2023

ORA-00959 ORA-00959 means that the tablespace you specified in the statement cannot be found in the database, you should check the name you provide or… 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 »

PDB Scheduled Jobs Running at Wrong Time

by Ed Chen
March 21, 2022April 6, 2023

Why are PDB scheduled jobs not running? or running at the wrong times? If you found this problem in a Pluggable Database (PDB), then we… Read More »

How to Set Scheduler Time Zone

by Ed Chen
March 18, 2022March 18, 2022

Scheduler Time Zone Before doing that, we have make sure the time zone region you want to set is valid for Oracle. Then we change… Read More »

How to Resolve ORA-28365: wallet is not open

by Ed Chen
January 3, 2022March 28, 2022

ORA-28365 There're several possibilities about Transparent Data Encryption (TDE) that throw ORA-28365. Wallet is not configured. You should configure a wallet for your database. Wallet… Read More »

How to Resolve ORA-46627: keystore password mismatch

by Ed Chen
December 21, 2021May 18, 2022

ORA-46627 Tried to clone a pluggable database (PDB) with TDE from another PDB, but it failed with ORA-46627. SQL> create pluggable database ORCLPDB2 from ORCLPDB… Read More »

How to Resolve ORA-46697: Keystore password required

by Ed Chen
December 20, 2021May 18, 2022

ORA-46697 Create Pluggable Database Cloning Local PDB Tried to clone a Pluggable Database (PDB) in the same Container Database (CDB), but it failed with ORA-46697.… 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 Switch Service Name to Another PDB

by Ed Chen
November 3, 2021March 25, 2022

In this case, we have two PDBs in a container and a general service name needs to be be switched between them back and forth.… Read More »

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