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

Hi,

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.

 

 

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.

https://ittutorial.org/oracle-database-19c-tutorials-for-beginners/

 675 views last month,  12 views today

About Mehmet Salih Deveci

I am Founder of SysDBASoft IT and IT Tutorial and Certified Expert about Oracle & SQL Server database, Goldengate, Exadata Machine, Oracle Database Appliance administrator with 10+years experience. I have OCA, OCP, OCE RAC Expert Certificates I have worked 100+ Banking, Insurance, Finance, Telco and etc. clients as a Consultant, Insource or Outsource. I have done 200+ Operations in this clients such as Exadata Installation & PoC & Migration & Upgrade, Oracle & SQL Server Database Upgrade, Oracle RAC Installation, SQL Server AlwaysOn Installation, Database Migration, Disaster Recovery, Backup Restore, Performance Tuning, Periodic Healthchecks. I have done 2000+ Table replication with Goldengate or SQL Server Replication tool for DWH Databases in many clients. If you need Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS Consultancy and Training you can send my email adress mehmetsalih.deveci@outlook.com. -                                                                                                                                                                                                                                                 - Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS ve linux Danışmanlık ve Eğitim için  mehmetsalih.deveci@outlook.com a mail atabilirsiniz.

Check Also

ORA-01438: value larger than specified precision allowed for this column

Hi, I got ” ORA-01438: value larger than specified precision allowed for this column” error …

Leave a Reply