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@xxxxxxxxxxxxxxxxxxxxxxx> 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@xxxxxxxxx=20 > Sent: 05 February 2004 14:44 > To: oracle-l@xxxxxxxxxxxxx; rafiq9857@xxxxxxxxx > 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@xxxxxxxxx> wrote: > > Your UNIX id is not in the 'dba' group.=20 > >=20 > > - Kirti=20 > >=20 > >=20 > >=20 > > --- "Daiminger, Helmut" <HELMUT.DAIMINGER@xxxxxx> 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@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@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 > > > ----------------------------------------------------------------- > >=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@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 > ----------------------------------------------------------------- > > > > > ********************************************************************** > 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@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 -----------------------------------------------------------------