ORACLE_HOME doesn't need to be set in the environment.
But if you want to connect via '/ as sysdba' you will need to run
the Oracle Home Selector and open a new CMD window.
The Home Selector changes the search order of the PATH variable.
If you try to login as '/ as sysdba' on a 9i database while the search
path is set to find 8i first, you will get an error.
Jared
"Jacques Kilchoer" <Jacques.Kilchoer_at_quest.com>
Sent by: oracle-l-bounce_at_freelists.org
02/05/2004 03:20 PM
Please respond to oracle-l
To: <oracle-l_at_freelists.org>
cc:
Subject: RE: connect / as sysdba on 9i
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
-----------------------------------------------------------------
----------------------------------------------------------------
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 - 18:33:15 CST