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 executables 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>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
<UR Hostname> =>
Os Database Administrator
Right click And Add/Remove
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