Container Database (CDB)

How to Resolve ORA-39087: directory name is invalid

by Ed Chen
May 11, 2023May 12, 2023

ORA-39087 Saw errors ORA-39087 and ORA-39070, when tried to export data AS SYSDBA through data pump expdp. [oracle@test ~]$ expdp \"/ as sysdba\" full=y directory=BACKUP_DUMPS… Read More »

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

by Ed Chen
December 23, 2022May 12, 2023

ORA-32001 ORA-32001 means that the database cannot write SPFILE at this moment, you should make sure that it has been using by the instance. Let's… 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, 2022May 9, 2023

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, 2022March 20, 2023

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, 2022April 15, 2023

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 »

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