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

From: Jared Still <jkstill_at_gmail.com>
Date: Tue, 22 Sep 2009 10:35:23 -0700
Message-ID: <bf46380909221035t206a94f6v499dfed5fba3921f_at_mail.gmail.com>



Perhaps you could explain why you need SQLNET.AUTHENTICATION_SERVICES = (NONE) ?
Maybe you are trying to solve the wrong problem.

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist Oracle Blog: http://jkstill.blogspot.com Home Page: http://jaredstill.com

On Tue, Sep 22, 2009 at 10:04 AM, sundar mahadevan < sundarmahadevan82_at_gmail.com> wrote:

> I should have been little more informative. I want to retain
> SQLNET.AUTHENTICATION_SERVICES = (NONE) in my sqlnet.ora and would
> want oracle database to authenticate the users. Since
> SQLNET.AUTHENTICATION_SERVICES = (NONE) is specified, OS
> authentication is disabled and hence / as sysdba fails with
> insufficient privileges. But dbstart/dbshut use / as sysdba to start
> database from /etc/oratab with values 'Y' against the instance names.
> sys/password_at_orams works fine while connecting normally but I
> cannot/donot want to hard code sys password in dbstart/dbshut
> scripts(No one would do that). TWO_TASK does not work. When set
> TWO_TASK basically is a replacement for _at_orams where orams is the tns
> connection name. It is not set in my environment. I hope I made myself
> clear here. Please let me know if you need more info. Thanks for your
> help.
>
> version of oracle: 10.1.0.3.0
> platorm: OEL 5.3
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Sep 22 2009 - 12:35:23 CDT

Original text of this message