CDB$ROOT

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-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 »

SYS_AUTO_SQL_TUNING_TASK Report

by Ed Chen
September 14, 2022March 24, 2023

SYS_AUTO_SQL_TUNING_TASK Sometimes, you don't have to run SQL tuning report for a specific statement, because the automatic SQL tuning job (SYS_AUTO_SQL_TUNING_TASK) could have identified long-running… 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
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 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 »

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