Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: connect / as sysdba on 9i

RE: connect / as sysdba on 9i

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Thu, 5 Feb 2004 15:20:20 -0800
Message-ID: <B5C5F99D765BB744B54FFDF35F60262119FBC8@irvmbxw02>


Does the ORACLE_HOME really make a difference on Windows, and if so why? As long as the bin directory for the right version of Oracle is in the = path, why would it matter? And SQL*Plus would be using the DLLs in the = bin directory anyway.

> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of
> Jared.Still_at_radisys.com
> Sent: jeudi, 5. f=E9vrier 2004 14:01
> To: oracle-l_at_freelists.org
> Subject: Re: connect / as sysdba on 9i

>=20
>=20

> In that case, it couns like you need to change your=20
> ORACLE_HOME via the=20
> "Home Selector",
> open a new CMD window, set the ORACLE_SID, and try again.
>=20
>=20
>=20
>=20
>=20

> Mohammad Rafiq <rafiq9857_at_yahoo.com>
> Sent by: oracle-l-bounce_at_freelists.org
> 02/05/2004 01:07 PM
> Please respond to oracle-l
>=20

> =20
> To: oracle-l_at_freelists.org
> cc:=20
> Subject: Re: connect / as sysdba on 9i
>=20 >=20

> Does not work with 9i. No problem with 8i.
>=20

> Regards
> Rafiq
>=20
>=20

> =20
> --- Jared.Still_at_radisys.com wrote:
> > Often on Win2k it is as simple as setting your ORACLE_SID=20
> env variable
> >=20
> >=20
> >=20
> >=20
> > Mohammad Rafiq <rafiq9857_at_yahoo.com>
> > Sent by: oracle-l-bounce_at_freelists.org
> > 02/05/2004 06:44 AM
> > Please respond to oracle-l
> >=20
> >=20
> > To: oracle-l_at_freelists.org
> > cc:=20
> > Subject: Re: connect / as sysdba on 9i
> >=20
> >=20
> > Kirti,
> >=20
> > What about Windows 2000 when same behaviour while logging=20
> as sys(not=20
> > system)as=20
> > 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).
> >=20
> >=20
> > Regards
> > Rafiq
> >=20
> >=20
> >=20
> >=20
> > --- 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=20
> sys/pwd_at_database as sysdba"=20
>=20

> > 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
> > >=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
> > > -----------------------------------------------------------------
> >=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
> > -----------------------------------------------------------------
> >=20
> >=20
> >=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
> -----------------------------------------------------------------
>=20
>=20
>=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

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 - 17:20:20 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US