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

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.
DBA Tips Data Pump Reference

0 comments:

Post a Comment

 

dba topics. Copyright 2011-16 All Rights Reserved | Site Map | Contact | Disclaimer | Google