Please Login or Register
Advanced search

123 - ORA-01031: insufficient privileges

Submitted by admin on Tue, 12/01/2009 - 10:42

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