In this article we are going to learn about the privileges  . The ORA-01031: “insufficient privileges” error occurs when you attempt to execute a program or function for which you have not been granted the appropriate privileges. For the DBA, the ORA-01031 can happen if the target OS executable do not have read and execute permissions (e.g. (770) in UNIX/Linux), and ensure that the oracle user is a member of the dba group (e.g. /etc/group).  There are similar permission in the Windows registry.Inside Oracle, the “ORA-01031: insufficient privileges” error can be avoided by signing on “as sysdba” with unlimited database privileges.

ORA-01031: insufficient privileges

Cause: An attempt was made to change the current username or password without the appropriate privilege. This error also occurs if attempting to install a database without the necessary operating system privileges. When Trusted Oracle is configure in DBMS MAC, this error may occur if the user was granted the necessary privilege at a higher label than the current login.

Action: Ask the database administrator to perform the operation or grant the required privileges. For Trusted Oracle users getting this error although granted the appropriate privilege at a higher label, ask the database administrator to re-grant the privilege at the appropriate label.

 

Steps to solve this issue:-

While we connect to data by SYSDBA we will get “ORA-01031”.

 

Verified user to be part of ORA_DBA group, which is missing below

c:\Windows\System32>echo %username%

 

 

c:\Windows\System32>NET LOCALGROUP ORA_DBA

 

Using MMMC ( microsoft management console) Add the user “DBA Anuradha Mudgal to be part of ORA_DBA OS group

oracle – oraDB11g_home1

 

 Administration Assistant for Windows

 

Expand Oracle Managed Objects

Computers

 <UR Hostname> =>

 

Os Database Administrator

Right click  And Add/Remove

Choose Domain 

Add User_name (In my case it is DBA Anuradha Mudgal) then add and Ok

Here we can see new user

Click Ok after add 

 

 

 

Click Ok

 

Now connect 

 

 

 

 

Leave a Reply