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

[hdes3658]

How to connect with sys oracle data base user

[v-yuaj-msft · Accepted solution]

Hi @hdes3658 ,

The ORA-28009 error occurs when you are connecting as the SYS user, without using the SYSDBA or SYSOPER  clause:

SQL> connect sys/myopass as sysdba;

SQL> connect sys/mypass as sysoper;

The docs note this on the ORA-28009 error:

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

Please check these links as follows.

ORA-28009: connection as SYS should be as SYSDBA or SYSOPER (itsiti.com)

ORA-28009: connection to sys should be as sysdba or sysoper | Ora Code (ora-code.info)

Hope that's what you were looking for.

Best Regards,

Yuna

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mwegener]

Hi @hdes3658 ,

this is an error message from the Oracle database.

https://community.oracle.com/tech/apps-infra/discussion/1135635/ora-28009-connection-as-sys-should-b...

Here in the Oracle Community Forum there seems to be a workaround for this error message.