Hi,

Sometimes You can get “ORA-28009: connection as SYS should be as SYSDBA or SYSOPER ” error.

ORA-28009

Details of error are as follows.

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

Cause: connect SYS/<password> is no longer a valid syntax

Action: Try connect SYS/<password> as SYSDBA or connect SYS/<password> as SYSOPER

SQL> conn sys/welcome1
ERROR:
ORA-28009: connection as SYS should be as SYSDBA or SYSOPER
Warning: You are no longer connected to ORACLE.

connection as SYS should be as SYSDBA or SYSOPER

To solve this error, your connection as SYS should be as SYSDBA or SYSOPER as follows.

SQL> conn / as sysdba
Connected.
SQL>

O7_DICTIONARY_ACCESSIBILITY Parameter

Or You should change O7_DICTIONARY_ACCESSIBILITY parameter from False to True as follows.

SQL> SHOW PARAMETER O7_DICTIONARY_ACCESSIBILITY
NAME                            TYPE         VALUE
————————————                   ———–      ——————————
O7_DICTIONARY_ACCESSIBILITY     boolean      FALSE


SQL> ALTER SYSTEM SET O7_DICTIONARY_ACCESSIBILITY=TRUE scope=spfile sid='*';
System altered.

Restart database as follows.

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.

SQL> startup
ORACLE instance started.
Total System Global Area 3676221530 bytes
Fixed Size 5069288 bytes
Variable Size 109051944 bytes
Database Buffers 30361648 bytes
Redo Buffers 3368280 bytes
Database mounted.
Database opened.

Once restart is completed, you can connect as sys with only password as follows.

SQL> conn sys/welcome1
Connected.

Do you want to learn Oracle Database for Beginners, then read the following articles.

Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA )