ORA-01031: insufficient privileges while connecting to database as sysdba

ORA-01031: insufficient privileges while connecting to database as sysdba

Applies to:

            Oracle Database 11.2.0.4

            Oracle Linux 5 and above

Description:

After hardware failure of our Test server, we restore the backup of Test server on new machine. We are unable to connect/start the database. We are facing the error “ORA-01031: insufficient privileges while connecting to database as sysdba” on our Test database server.

Solution:

            This is a very common or generic error that can occur after the new oracle database software installation. There are multiple reasons of this error. I describe the only one which belongs to me.

After some research I found that my user did not belong to dba group. Issue the following command to add the user “oratest” to dba group:

[root@oradb ~]# usermod -a -G dba oratest

Now connect the oracle database from oratest user:

[oratest@oradb ~]# sqlplus / as sysdba

Its working fine now.

           

Your comments, especially which will help us improve the functionality, will be greatly appreciatedJ

You are requested to follow my Blog.

👉 Check our complete guide: Oracle Error Codes Guide

---

Your comments, especially which will help us improve the functionality, will be greatly appreciated. Do not forget to follow my Blog.

---

About the Author

Rana Abdul Wahid is an Oracle Database Administrator (DBA) with expertise in Oracle RMAN recovery, Oracle EBS administration, backup and recovery, performance tuning, database cloning, and troubleshooting critical Oracle database issues.