Oracle-L: RE: Multiple Oracle Homes for Oracle

From: April Wells <awells_at_csedge.com>
Date: Fri, 04 Oct 2002 06:33:28 -0800
Message-ID: <F001.004E0ADD.20021004063328@fatcity.com>

If you try to run sqlplus or any other sql utility on the database without those environment variables set, it won't know where to look for the utilities or where to look for a database whose name it doesn't know. Your best bet to see exactly what it does is do what you are describing and try to run sqlplus to access the database and see what happens.

But this isn't really the multiple homes concept.

April Wells
Oracle DBA
Keep yourself well oiled with life, laughter, new ideas and action. Otherwise you will rust out. _Anonymous

-----Original Message-----
Sent: Friday, October 04, 2002 8:08 AM
To: Multiple recipients of list ORACLE-L

Hi All,

I am not very clear on how the Multiple Oracle Homes' concept works. Does
one need an ORALE_HOME and ORACLE_SID environment veriable with appropriate values ONLY when starting the DB instance, or launching an application that uses these variables? Are these environment variables not accessed after that?

To make my question clear, say, I need to start a database having SID = 'db1'.

I do a $ export ORACLE_SID=db1 and export ORACLE_HOME=/opt/oracle/product/9201 and then connect to sqlplus and start the database. (FYI: Oracle on Linux)

after this, if I unset the 2 environment variables or set them to some other garbage value, will anything go wrong?

Cheers,
Shantanu.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Shantanu Datta
INET: shantanu.datta_at_hurix.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).

begin 666 InterScan_Disclaimer.txt
M0U-502 R,# R.B @26UA9VEN92!T:&4_at_4&]S<VEB:6QI=&EE<R$-"D-O<G!O M<F%T92!3>7-T96US($%N;G5A;"!5<V5R<R!!<W-O8VEA=&EO;B!#;VYF97)E

M;F-E#0I7:&5N.B!/8W1O8F5R(#(M-"P@,C P,@T*5VAE<F4Z($-A<FEB92!2
M;WEA;&4_at_4F5S;W)T(" @3W)L86YD;RP_at_1DP@(%5300T*1F]R(&UO<F4@:6YF
M;W)M871I;VX_at_9V\@=&\@=W=W+F-S961G92YC;VT-"@T*#0H-"E1H92!I;F9O

M<FUA=&EO;B!C;VYT86EN960@:6X@=&AI<R!E+6UA:6P@:7,@<W1R:6-T;'D@ M8V]N9FED96YT:6%L(&%N9"!F;W(@=&AE(&EN=&5N9&5D('5S92!O9B!T:&4@ M861D<F5S<V5E(&]N;'D[(&ET(&UA>2!A;'-O(&)E(&QE9V%L;'D@<')I=FEL M96=E9"!A;F0O;W(@<')I8V4@<V5N<VET:79E+B @3F]T:6-E(&ES(&AE<F5B M>2!G:79E;B!T:&%T(&%N>2!D:7-C;&]S=7)E+"!U<V4@;W(@8V]P>6EN9R!O M9B!T:&4@:6YF;W)M871I;VX_at_8GD@86YY;VYE(&]T:&5R('1H86X@=&AE(&EN M=&5N9&5D(')E8VEP:65N="!I<R!P<F]H:6)I=&5D(&%N9"!M87D_at_8F4@:6QL M96=A;"X@($EF('EO=2!H879E(')E8V5I=F5D('1H:7,@;65S<V%G92!I;B!E M<G)O<BP@<&QE87-E(&YO=&EF>2!T:&4@<V5N9&5R(&EM;65D:6%T96QY(&)Y M(')E='5R;B!E+6UA:6PN"@I#;W)P;W)A=&4_at_4WES=&5M<RP_at_26YC+B!H87,@ M=&%K96X_at_979E<GD@<F5A<V]N86)L92!P<F5C875T:6]N('1O(&5N<W5R92!T

M:&%T(&%N>2!A='1A8VAM96YT('1O('1H:7,@92UM86EL(&AA<R!B965N('-W
M97!T(&9O<B!V:7)U<V5S+B @5V4_at_86-C97!T(&YO(&QI86)I;&ET>2!F;W(@
M86YY(&1A;6%G92!S=7-T86EN960_at_87,@82!R97-U;'0@;V8@<V]F='=A<F4@

M=FER=7-E<R!A;F0_at_861V:7-E('EO=2!C87)R>2!O=70@>6]U<B!O=VX@=FER M=7,@8VAE8VMS(&)E9F]R92!O<&5N:6YG(&%N>2!A='1A8VAM96YT+@T*#0H- #"@T*
end

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: April Wells
INET: awells_at_csedge.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------