DOYENSYS Knowledge Portal

We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal

Saturday, January 10, 2015

ORA-01031: insufficient privileges when connect as sysdba

     ORA-01031: insufficient privileges when connect as sysdba

[oraprod@oracle-dba ~]$ sqlplus “/ as sysdba”

SQL*Plus: Release Production on Wed Jan 22 02:09:17 2014
Copyright (c) 1982, 2010, Oracle.  All rights reserved.


ORA-01031: insufficient privileges


Go to oracle_home/network/admin 

1. Check sqlnet.ora file for SQLNET.AUTHENTICATION_SERVICES parameter. 

It should be set to NTS for windows and for Linux set it to ALL.

SQLNET.AUTHENTICATION_SERVICES=NTS  —WINDOWS .. ( If the Commented then remove the comment before the statement )


Then retest the issue,

No comments: