ORA-01031: insufficient privileges in oracle on windows

Problem:

When you try to log on to SQLPLUS as sysdba following error may occur.

Error Message

ORA-01031: insufficient privileges

Reason:Your user is not a member of ORA_DBA group  (dba group in unix).

Solution:

For Windows.

Add your user to ORA_DBA group.

Here are the below steps to add your user to ORA_DBA group.

1.       Goto start  -> run -> compmgmt.msc  -> Local Users and Groups -> users -> goto properties of your user -> Member of -> add ORA_DBA group.

Now try to connect via sysdba.

Here is the solved screen.

Hope it will help to resolve your issue.



By
Manjunath