RE: SQLNET.AUTHENTICATION_SERVICES = (NONE) results in ERROR: ORA-01031: insufficient privileges
Date: Tue, 22 Sep 2009 11:12:03 -0400
Message-ID: <D1DC33E67722D54A93F05F702C99E2A9045EE5FD_at_usahm208.amer.corp.eds.com>
What version of Oracle?
What platform?
The insufficient privileges error can also be produced when attempting to connect as sysdba and the $TWO_TASK environment variable is set on UNIX platforms.
$ sqlplus /nolog
SQL*Plus: Release 9.2.0.6.0 - Production on Tue Sep 22 11:10:34 2009
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
> connect / as sysdba
ERROR:
ORA-01031: insufficient privileges
> exit
$ unset TWO_TASK
$ sqlplus /nolog
SQL*Plus: Release 9.2.0.6.0 - Production on Tue Sep 22 11:10:57 2009
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
> connect / as sysdba
Connected.
- Mark D Powell -- Phone (313) 592-5148
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of sundar mahadevan
Sent: Monday, September 21, 2009 6:06 PM
To: Oracle-L_at_freelists.org
Subject: SQLNET.AUTHENTICATION_SERVICES = (NONE) results in ERROR:
ORA-01031: insufficient privileges
Hi All,
SQLNET.AUTHENTICATION_SERVICES = (NONE) results in ERROR: ORA-01031: insufficient privileges when I connect with "/ as sysdba". This the expected behavior. The problem is that database startup and shutdown scripts execute as "/ as sysdba". What other options do I have to get dbstart and dbshut working? Any ideas are greatly appreciated. Thanks in advance.
-- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-lReceived on Tue Sep 22 2009 - 10:12:03 CDT