CONTAINER=ALL

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-17629: Cannot connect to the remote database server

by Ed Chen
September 1, 2021April 12, 2022

ORA-17629 ORA-17629 means that it cannot connect to the remote database because of some underlying errors occurred, most likely, there're some error returned. In the… Read More »

How to Resolve ORA-01045: user lacks CREATE SESSION privilege; logon denied

by Ed Chen
January 11, 2020December 24, 2022
8 Comments

ORA-01045 ORA-01045 means that the user who tried to connect to the database has no privilege to connect to. Therefore, the database refused the user… Read More »

Alter System Scope, SID and Container

by Ed Chen
April 6, 2016October 23, 2022

ALTER SYSTEM SET When we issue ALTER SYSTEM SET to modify parameter, some scope clauses can be used to specify how new value is applied… Read More »