What does Error "ora-28009 connection as sys should be as sysdba or sysoper" means?

Have you come across the Error "Error ora-28009 connection as sys should be as sysdba or sysoper" while connecting to Oracle as sysdba? Here we will see what does this error means and how to resolve it.

When I was trying to connect to Oracle database from my .NET application. I was getting the following error: "error ora-28009 connection as sys should be as sysdba or sysoper".

In this article we will see how to resolve this error if you are connecting to oracle database as sys.

In the database connection string add an additional attribute "DBA Privilege" and assign it a value "SYSDBA" as follows:

Adding an additional attribute "DBA Privilege" will connect to the oracle database and while trying to connect it will make the connection as a SYSDBA.This allows you to connect to oracle database as SYSDBA without giving any errors.