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

RemoteOperationalException: ERROR: Invalid username and/or password

Problem:

When you try to log on to OEM in windows following error may occur.

Error Message

RemoteOperationalException: ERROR: Invalid username and/or password

Solution:

Set the 'Log on batch job' and 'Log on service'.

Step1: Goto control panel -> Administrative Tool -> Local Security Settings.

       Local Policies -> User Rights Assignment -> double click on 'Log on as a batch job'

Step 2: Add the user here which you are trying accessing the OEM and click apply and OK.

Step3 : Follow the step 2 for adding user to 'Log on as a service'.

Step4: Now try to log on to OEM.

          You will get the following screen if db is down.

Hope it will help to resolve your issue.



By
Manjunath