Niall,
Thanks for your response. What about when I connect to server through
PCAnywhere , my login id is a part of dba_group and when I connect locally as
sys is requires password as mentioned by Hemant.
Regards
Rafiq
- Niall Litchfield <n-litchfield_at_audit-commission.gov.uk> wrote:
> Remote_login_passwordfile applies to 'remote' connections. Note that sqlplu=
> s /@dbname as sysdba is a 'remote' connection even if run from the console.=
> For local connections it works the same way IIRC, but the group is ORA_DBA=
> or ORA_SID_DBA.=20
>
> Niall Litchfield
> Oracle DBA
> Audit Commission
> +44 117 975 7805=20
>
> -----Original Message-----
> From: rafiq9857_at_yahoo.com=20
> Sent: 05 February 2004 14:44
> To: oracle-l_at_freelists.org; rafiq9857_at_yahoo.com
> Subject: Re: connect / as sysdba on 9i
>
>
> 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=20
> remote_login_passwordfile=3DEXCLUSIVE( if setting is NONE no problem).
>
>
> Regards
> Rafiq
>
>
>
>
> --- Kirtikumar Deshpande <kirtikumar_deshpande_at_yahoo.com> wrote:
> > Your UNIX id is not in the 'dba' group.=20
> >=20
> > - Kirti=20
> >=20
> >=20
> >=20
> > --- "Daiminger, Helmut" <HELMUT.DAIMINGER_at_WWK.DE> wrote:
> > > Hi!
> > >=20
> > > What parameters need to be set to allow
> > >=20
> > > connect / as sysdba on 9i?
> > >=20
> > > On my db this is disabled. Only "connect sys/pwd_at_database as sysdba"
> works.
> > >=20
> > > Any ideas?
> > >=20
> > > This is 9.2 on HP-UX.
> > >=20
> > > Thanks,
> > > Helmut
> > >=20
> > >=20
> > > ----------------------------------------------------------------
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > ----------------------------------------------------------------
> > > To unsubscribe send email to: oracle-l-request_at_freelists.org
> > > put 'unsubscribe' in the subject line.
> > > --
> > > Archives are at http://www.freelists.org/archives/oracle-l/
> > > FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> > > -----------------------------------------------------------------
> >=20
> >=20
> > __________________________________
> > 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_at_freelists.org
> > put 'unsubscribe' in the subject line.
> > --
> > Archives are at http://www.freelists.org/archives/oracle-l/
> > FAQ is at http://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_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>
>
>
>
> **********************************************************************
> This email contains information intended for
> the addressee only. It may be confidential
> and may be the subject of legal and/or
> professional privilege. Any dissemination,
> distribution, copyright or use of this
> communication without prior permission of
> the sender is strictly prohibited.
> **********************************************************************
>
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://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_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Thu Feb 05 2004 - 09:38:24 CST
