Container Database (CDB)

How to Resolve ORA-32001: write to SPFILE requested but no SPFILE is in use

by Ed Chen
December 23, 2022November 17, 2022

ORA-32001 ORA-32001 means that it cannot write the server parameter file at this moment, you should make sure SPFILE is being used by the instance.… Read More »

How to Resolve ORA-31541: Supplemental logging is not enabled in CDB$ROOT.

by Ed Chen
December 8, 2022November 7, 2022

ORA-31541 Tried to enable flashback transaction query starting from adding minimal supplemental logs, but it failed with ORA-31541. SQL> alter database add supplemental log data;… Read More »

How to Resolve ORA-65175: cannot grant SYSDBA privilege locally in the root

by Ed Chen
December 7, 2022November 4, 2022

ORA-65175 Tried to grant SYSDBA privilege to SYSTEM, but it failed with ORA-65175. SQL> show user USER is "SYS" SQL> grant sysdba to system; grant… Read More »

How to Resolve ORA-16000: database or pluggable database open for read-only access

by Ed Chen
December 6, 2022December 24, 2022

ORA-16000 Tried to update some rows, but it failed with ORA-16000. SQL> update employees set first_name = 'Ed' where last_name = 'Chen'; update employees set… Read More »

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-30012: undo tablespace does not exist or of wrong type

by Ed Chen
November 11, 2022December 24, 2022

ORA-30012 Tried to restart a normal, typical database after changing the default undo tablespace, but it failed with ORA-30012. SQL> startup ORACLE instance started. ...… Read More »

How to Check DataFile Creation Date

by Ed Chen
July 15, 2022June 17, 2022

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 Resolve ORA-65094: invalid local user or role name

by Ed Chen
June 15, 2022July 7, 2022

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-65049: Creation of local user or role is not allowed in this container

by Ed Chen
June 13, 2022June 15, 2022

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-65096: invalid common user or role name

by Ed Chen
June 10, 2022November 22, 2022
8 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 »