Reasons for ORA-28009: connection as SYS should be as SYSDBA or SYSOPER

advertisements

_____________________________________________________________________________________________________________________

Error Description:

SQL*Plus Connection fails with following error.

SQL> connect sys/welcome

ERROR: connection as SYS should be as SYSDBA or SYSOPER

Solution Description:

The error description itself is clear.

If you try to connect as sys using SQL*plus it should be either SYSDBA or SYSOPER. From Oracle 9i onwards, this has been implemented in Oracle. All other users will work as normal with username and password.

Different Usages:

SQL> connect sys as sysoper

Enter password:

Connected.

SQL> connect sys as sysdba

Enter password:

Connected.

_____________________________________________________________________________________________________________________

Website Stats