Sometimes You can get “ORA-28009: connection as SYS should be as SYSDBA or SYSOPER ” error.
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>
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.
1,595 views last month, 1 views today