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 

 

 

 

 

About The Author

Leave a Reply