Common User

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

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