Jump to Navigation

123 - ORA-01031: insufficient privileges

ORA-01031: insufficient privileges is that there is something wrong configuration.

1. Check sqlnet.ora

Comment out this line.

SQLNET.AUTHENTICATION_SERVICES=(NTS)

2. Check the OS user in terms of DBA group.

# id
uid=501(oracle) gid=501(grp01) groups=501(grp01)
# groupadd dba
# gpasswd -a oracle dba

Nothing happens after 1 and 2,
But you could connect to the database with sys user.

# sqlplus /NOLOG
SQL> CONNECT sys as sysdba
Enter password: SYS_PASSWORD

SQL>startup

SQL>shutdown immediate

 

Oracle:


Main menu 2

Story | by Dr. Radut