Re: Connecting as sysdba without password

From: Guillermo Alan Bort <cicciuxdba_at_gmail.com>
Date: Sun, 10 Jun 2012 16:26:51 -0300
Message-ID: <CAJ2dSGR7=wxBfo9ZA+DYEXkxhu1B1YjxwV5y7gb9BkNhmARpfA_at_mail.gmail.com>

Beware when setting this, it may break some applications. But yeah, windows and oracle are not very friendly and this parameter is required for OS authentication in windows.
You can have this separate from the machine's SQLNET.ORA by using the TNS_ADMIN variable as a local variable (i.e. not system wide).

HTH.
Alan.-

On Sun, Jun 10, 2012 at 2:54 AM, Steve Wales <sjwales_at_comcast.net> wrote:

> Thanks to Harel Safra, I have my answer.
>
> SQLNET.AUTHENTICATION_SERVICES=(NTS) in sqlnet.ora and problem solved.
>
> Thanks again!
>
> Steve
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
> On Behalf Of Steve Wales
> Sent: Saturday, June 09, 2012 9:52 PM
> To: oracle-l_at_freelists.org
> Subject: Connecting as sysdba without password
>
> I've just inherited an Oracle 8.1.7 database on Windows 2000.
>
> No one has the SYS / SYSTEM passwords.
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Sun Jun 10 2012 - 14:26:51 CDT