Re: connect / as sysdba on 9i
- From: Jared.Still@xxxxxxxxxxx
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 5 Feb 2004 09:33:26 -0800
I've posted a Word doc that may help with this.
It's a cheat sheet I use when setting up Windoze DB's and run into
authentication problems.
http://www.cybcon.com/~jkstill/util/zips/Connect_Internal_Gymnastics_8i_public.doc
I find it useful, YMMV.
Jared
Mohammad Rafiq <rafiq9857@xxxxxxxxx>
Sent by: oracle-l-bounce@xxxxxxxxxxxxx
02/05/2004 07:43 AM
Please respond to oracle-l
To: oracle-l@xxxxxxxxxxxxx
cc:
Subject: Re: connect / as sysdba on 9i
Thanks. The setting is NTS for both 8i and 9i sqlnet on same machine but I
can
connect with 8i as sys without password but with 9i it requires
password....
Now I become used to it.
Regards
Rafiq
--- Kirtikumar Deshpande <kirtikumar_deshpande@xxxxxxxxx> wrote:
> Rafiq,
>
> I believe it is the SQLNET.AUTHENTICATED_SERVICES = (NTS), and not
> REMOTE_LOGIN_PASSWORDFILE.
>
> I have no access to W2K at the moment to test it, though.
>
>
> Regards,
> - Kirti
>
>
> --- Mohammad Rafiq <rafiq9857@xxxxxxxxx> wrote:
> > Kirti,
> >
> > What about Windows 2000 when same behaviour while logging as sys(not
> system)as
> > and user is a part of dba group. I think it depends on setting of
> > remote_login_passwordfile=EXCLUSIVE( if setting is NONE no problem).
> >
> >
> > Regards
> > Rafiq
> >
> >
> >
> >
> > --- Kirtikumar Deshpande <kirtikumar_deshpande@xxxxxxxxx> wrote:
> > > Your UNIX id is not in the 'dba' group.
> > >
> > > - Kirti
> > >
> > >
> > >
> > > --- "Daiminger, Helmut" <HELMUT.DAIMINGER@xxxxxx> wrote:
> > > > Hi!
> > > >
> > > > What parameters need to be set to allow
> > > >
> > > > connect / as sysdba on 9i?
> > > >
> > > > On my db this is disabled. Only "connect sys/pwd@database as
sysdba"
> works.
> > > >
> > > > Any ideas?
> > > >
> > > > This is 9.2 on HP-UX.
> > > >
> > > > Thanks,
> > > > Helmut
> > > >
> > > >
> > > > ----------------------------------------------------------------
> > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > > ----------------------------------------------------------------
> > > > To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
> > > > put 'unsubscribe' in the subject line.
> > > > --
> > > > Archives are at //www.freelists.org/archives/oracle-l/
> > > > FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
> > > > -----------------------------------------------------------------
> > >
> > >
> > > __________________________________
> > > Do you Yahoo!?
> > > Yahoo! Finance: Get your refund fast by filing online.
> > > http://taxes.yahoo.com/filing.html
> > > ----------------------------------------------------------------
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > ----------------------------------------------------------------
> > > To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
> > > put 'unsubscribe' in the subject line.
> > > --
> > > Archives are at //www.freelists.org/archives/oracle-l/
> > > FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
> > > -----------------------------------------------------------------
> >
> >
> > __________________________________
> > Do you Yahoo!?
> > Yahoo! Finance: Get your refund fast by filing online.
> > http://taxes.yahoo.com/filing.html
> > ----------------------------------------------------------------
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > ----------------------------------------------------------------
> > To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
> > put 'unsubscribe' in the subject line.
> > --
> > Archives are at //www.freelists.org/archives/oracle-l/
> > FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
> > -----------------------------------------------------------------
>
>
> __________________________________
> Do you Yahoo!?
> Yahoo! Finance: Get your refund fast by filing online.
> http://taxes.yahoo.com/filing.html
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
__________________________________
Do you Yahoo!?
Yahoo! Finance: Get your refund fast by filing online.
http://taxes.yahoo.com/filing.html
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
