ORA-01031: insufficient privileges with SYSDBA Priviliges

Hi,

Although sys user is most priviliged user in Oracle database but also you can get ORA-01031: insufficient privileges SYSDBA.

If this error is not related with the Oracle database vault, then read the following post to grant priviliges to related user.

How to Grant and Revoke Privileges | Create and Drop any User in Oracle Database

You can get ORA-01031: insufficient privileges error event though you use sys user if Oracle Database Vault is open like following.

SQL> create user dd identified by dew;

ORA-01031: insufficient privileges 




SQL> SELECT * FROM V$OPTION WHERE PARAMETER = 'Oracle Database Vault';

PARAMETER
----------------------------------------------------------------
VALUE
----------------------------------------------------------------
Oracle Database Vault
TRUE

To solve this problem you should close database and disable Oracle Database Vault option like following.

SQL> shutdown immediate

$ cd $ORACLE_HOME/rdbms/lib
$ make -f ins_rdbms.mk dv_off ioracle

SQL> startup
ORACLE instance started.

Total System Global Area 2087780352 bytes
Fixed Size 2221208 bytes
Variable Size 1577061224 bytes
Database Buffers 503316480 bytes
Redo Buffers 5181440 bytes
Database mounted.
Database opened.

After database opened, we can create user like following.

SQL> create user mehmet identified by salih;

User created.

SQL> SELECT * FROM V$OPTION WHERE PARAMETER = 'Oracle Database Vault';

PARAMETER
----------------------------------------------------------------
VALUE
----------------------------------------------------------------
Oracle Database Vault
FALSE

If this error is not related with the Oracle database vault, then read the following post to grant priviliges to related user.

How to Grant and Revoke Privileges | Create and Drop any User in Oracle Database

Do you want to learn Oracle Database for Beginners, then read the following articles.

https://ittutorial.org/oracle-database-19c-tutorials-for-beginners/