SQL> shutdown abort .com

About DBA Queries DBA Scripts Quick Guides Other Stuff Contact
Andy only 
 
ORA-0131: insufficient privileges

If you are seeing this error on a windows machine when doing 'sqlplus / as sysdba', you might want to try the following:
  • Make sure the oracle user is a member of the dba group (or ora_dba group)
  • Make sure that the sqlnet.ora has the following line in it:
       SQLNET.AUTHENTICATION_SERVICES= (NTS)

For more useful DBA queries click here.
Copyright© 2007-2012 Andrew Barry