How to Check DataFile Creation Date
Data File Creation Date To check the creation date time of data files, we should query V$DATAFILE, not DBA_DATA_FILES. First of all, we format the… Read More »How to Check DataFile Creation Date
Container Database (CDB)
How to Resolve ORA-65094: invalid local user or role name
ORA-65094 Tried to create a common user in the root container (CDB), but it failed with ORA-65094. SQL> show con_name CON_NAME ------------------------------ CDB$ROOT SQL> create… Read More »How to Resolve ORA-65094: invalid local user or role name
How to Resolve ORA-65049: Creation of local user or role is not allowed in this container
ORA-65049 Tried to create a user in the current container, but it failed with ORA-65049. SQL> create user hr container=current; create user hr container=current *… Read More »How to Resolve ORA-65049: Creation of local user or role is not allowed in this container
How to Resolve ORA-65096: invalid common user or role name
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-65096: invalid common user or role name
How to Resolve ORA-00959: tablespace does not exist
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-00959: tablespace does not exist
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
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