DBA

ora-01031- insufficent privilege

Suppose these error occur means..your ora_dba group not configured in OS authentication.

Solve...

• Control Panel -----------> Adminstrative tools -------> Computer management
• Click Local groups and then users or groups
• on right side administrative is appear.right click on this and click properties.

In this case You should find Ora_dba ..its not appear in this. so you go to add the Ora_dba privilege to OS.

• run -------> cmd enter
• > net localgroup ora_dba /add enter

And then you find the Ora_dba is there and then add ora_dba to your administrator groups.

• >set oracle_sid=oracle
• sqlplus
• sys/sys@localdb as sysdba

database connected.........and then you can easily access it.