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 10.2.0.1.0 Production on Wed Jan 22 02:09:17 2014
Copyright (c) 1982, 2010, Oracle.  All rights reserved.

ERROR:

ORA-01031: insufficient privileges

SOLUTION:

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 )

SQLNET.AUTHENTICATION_SERVICES=ALL  —LINUX

Then retest the issue,



No comments: