User on Windows 2008
ORA-01031: insufficient privileges while connecting as "sys / as sysdba"
Things are different in windows environment, as a DBA you will encounter it sooner than later
One of them is trying to login to database on a Windows server I wasn't able to connect as sysdba.
On Windows 2008 R2
start--> run--> cmd
opens up command prompt
C:\Users\youruser>sqlplus / as sysdba
You are greeted with ORA-01031: insufficient privileges
Error suggests insufficient privileges, solution--->
Check if the user who is executing this command "sqlplus / as sysdba" is part of ORA_DBA groups.
There are few groups in windows Administrators, ORA_DBA & ORA_OPER, just like we have dba, oper, orainstall.. .etc on unix.
On a side note for installing Oracle you need to be a part of Administartors group.
Groups creation is the responsibility of Administrator
Ok back to the note to avoid this error you have to make sure "youruser" is a part of ORA_DBA group
we will see how this is done
start--> programs---> administrative tools--> computer management
This will open a console/window
Under computer management-->
select "local users and groups" ---> "groups"---> open "ora_dba "
click the "Add" button
Enter the object name ---> "youruser" ---> check names & then ok
this will add your user to ORA_DBA group
Now you can connect to database as sys / as sysdba
Connect to RMAN without error message ORA-01031