If I was going to use any 'client' type tools on the
'server' I might wish to set default characterset and
date format in the ORACLE_HOME. This depends on what
you have in your server, and the default behaviours.
Assuming everyone knows how the defaults work, and how
to control characterset and date format in loader,
sql*plus, etc., then the info in ORACLE_HOME is not
required.
Regards,
Mike Thomas
- Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
wrote:
> Well sure. I was assuming the PATH was correct. I
> should have said "As =
> long as the bin directory for the right version of
> Oracle is FIRST in =
> the path" which is what I meant.
> Even if I have two installations of Oracle, e.g.
> Oracle 8.1 and Oracle =
> 9.2, and the BIN directory for Oracle 8.1 is first
> in the path, I should =
> still be able to "connect / as sysdba" to a 9.2
> local database if I cd =
> %ORACLE_92_HOME%/bin and then run SQL*Plus.
>
> > -----Original Message-----
> > Jared.Still_at_radisys.com
> >=20
> > 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.
> >=20
> > The Home Selector changes the search order of the
> PATH variable.
> >=20
> > 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.
> >
> >=20
> > "Jacques Kilchoer" <Jacques.Kilchoer_at_quest.com>
> >=20
> > Does the ORACLE_HOME really make a difference on
> Windows, and=20
> > if so why?
> > As long as the bin directory for the right version
> of Oracle=20
> > is in the
> > path, why would it matter? And SQL*Plus would be
> using the=20
> > DLLs in the
> > bin directory anyway.
>
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 - 19:02:58 CST
