RE: SQLNET.AUTHENTICATION_SERVICES = (NONE) results in ERROR: ORA-01031: insufficient privileges

From: Powell, Mark D <mark.powell_at_EDS.COM>
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-l
Received on Tue Sep 22 2009 - 10:12:03 CDT

Original text of this message