How to Set Scheduler Time Zone
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 Set Scheduler Time Zone
Container Database (CDB)
How to Resolve PRCC-1016 : ORCLCDB was already stopped
PRCC-1016 Found an error PRCC-1016 when I tried to stop a RAC database. By the way, it's a Container Database (CDB). [oracle@primary01 ~]$ srvctl stop… Read More »How to Resolve PRCC-1016 : ORCLCDB was already stopped
How to Resolve ORA-28365: wallet is not open
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-28365: wallet is not open
How to Resolve ORA-46627: keystore password mismatch
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-46627: keystore password mismatch
How to Resolve ORA-46697: Keystore password required
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-46697: Keystore password required
How to Switch Service Name to Another PDB
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 »How to Switch Service Name to Another PDB
How Oracle Enable PDB Restricted Mode
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 Oracle Enable PDB Restricted Mode
How to Resolve ORA-65011: Pluggable database does not exist
ORA-65011 There're several use cases that may throw ORA-65011. 1. Set PDB as Session Container Tried to set a PDB as the current session container,… Read More »How to Resolve ORA-65011: Pluggable database does not exist
How to Resolve ORA-65118: operation affecting a pluggable database cannot be performed from another pluggable database
ORA-65118 When we tried to close a pluggable database (PDB), we got ORA-65118. SQL> alter pluggable database FINPDB close; alter pluggable database FINPDB close *… Read More »How to Resolve ORA-65118: operation affecting a pluggable database cannot be performed from another pluggable database
How to Resolve ORA-01109: database not open
ORA-01109 ORA-01109 is pretty normal when your database is idle, stop or close. Mostly it's previously shutdown manually by someone, or the database shutdown itself… Read More »How to Resolve ORA-01109: database not open