SYSOPER

How to Resolve ORA-28009: connection as SYS should be as SYSDBA or SYSOPER

by Ed Chen
March 10, 2023February 15, 2023

ORA-28009 Tried to connect to a database, but it failed with ORA-28009. SQL> conn sys/password@orclpdb ERROR: ORA-28009: connection as SYS should be as SYSDBA or… Read More »

SYSDBA vs SYSOPER Privileges

by Ed Chen
October 13, 2012February 3, 2023

SYSDBA vs SYSOPER According to Oracle documentation about administrative accounts and privileges, I compared their privileges between SYSDBA and SYSOPER as below: Allowed Actions SYSDBA… Read More »

Who has SYSDBA Privilege?

by Ed Chen
October 13, 2012December 11, 2022

SYSDBA Privilege SYSDBA is a system privilege. By default, only SYS has the privilege, but it can be changed by granting to other user. Although… Read More »

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