Re: Upgrade Question

There isn't a separate orainventory for each ORACLE_HOME. A single orainst.loc file defines where orainventory is located, and the orainventory contains info about what is installed for all versions of Oracle on the system (8i and above).

A single oratab file is used by all versions of Oracle to set ORACLE_HOME and ORACLE_SID in the dbshut/dbstart scripts.

In most cases both the oratab and orainventory files are found under /var/opt/oracle.

Hamid Alavi wrote:
>
> List,
>
> Can some body tell me what's the usage of oratab & orainst.loc files (sun
> solaris OS), I am getteing confused because I have two diffrent Oracle_home
> but just one one Orainventory Directory, It shouldn,'t be for each
> oracle_home own Orainventory directory???
> Appreciate your HELP.
> Thanks,
>
> -----Original Message-----
> Sent: Monday, June 03, 2002 12:58 PM
> To: Multiple recipients of list ORACLE-L
>
> >> 1. Use a separate tech stack (oracle home) for each instance.
> In general I like the idea, but it gets a bit pricey on disk space if you
> are running say 20-30 instances on a given box doesn't it??
>
> >> 1a. Use a separate unix account for each oracle home for total isolation.
> The DBA here is
> >> real anal. (BTW, that's me).
> I tend to be a bit anal too, but this is perhaps overkill.... :-)
>
> >> 3. Back up the OraInventory directory before and after an
> install/upgrade. If this
> >> directory get hammered, there is no way to recreate it except to
> re-install (Thank
> >> You Oracle! <all the sarcasm in the world implied here>).
> 100% agree with this one.
>
> >> I've also found that it is easier to use one listener for each instance
> instead of one
> >> listener for all instances.
> While I like different listeners for different versions, one per instance
> seems like a bit
> of overkill. Again, 20 different listeners is expensive from a memory POV
> and I've got to find
> 20 unused ports.
>
> >> For those on the list that disagree, flame away.
> No flames here, just seems like overkill to me.... The number of failures I
> have gotten
> that would have been saved by this amount of overkill would fit on maybe 2
> or 3 fingers
> in about 12 years of DBA'ing, and I can't remember a production problem in
> any event that
> would have been saved.... cost benefit isn't there based on that.
>
> But hey, I'm all for high availability!!
>
> RF
>
> Robert G. Freeman - Oracle8i OCP
> Oracle DBA Technical Lead
> CSX Midtier Database Administration
> Author: Oracle9i New Features
> Mastering Oracle8i
>
> -----Original Message-----
> Sent: Monday, June 03, 2002 2:14 PM
> To: Multiple recipients of list ORACLE-L
>
> This is why we:
> 1. Use a separate tech stack (oracle home) for each instance.
> 1a. Use a separate unix account for each oracle home for total isolation.
> The DBA here is real
> anal. (BTW, that's me).
> 1b. I've also found that it is easier to use one listener for each instance
> instead of one listener
> for all instances.
> 1c. We go so far as to give Oracle Names its own tech stack.
> 2. For each tech stack install, use a separate OraInventory directory. See
> metastink for details on
> this.
> 3. Back up the OraInventory directory before and after an install/upgrade.
> If this directory get
> hammered, there is no way to recreate it except to re-install (Thank You
> Oracle! <all the sarcasm in
> the world implied here>).
>
> For those on the list that dissagree, flame away. This is what I've found
> works the best in this
> environment.
>
> In any case, if the 8.1.6.2 is in a separate home, then the 8.1.7 instance
> upgrade will not effect
> it. Since the patch says that there is nothing to upgrade, the
> /var/opt/oracle/oraInst.loc file
> probably points to the 8.1.6 OraInventory instead of the 8.1.7 OraInventory.
>
> Ron Thomas
> Hypercom, Inc
> rthomas_at_hypercom.com
> "The problem with some people is that when they aren't drunk, they're
> sober." --William Butler
> Yeats.
>
>
>
> hamid.alavi_at_quova
>
> dx.com To:
> ORACLE-L_at_fatcity.com
>
> Sent by: cc:
>
> root_at_fatcity.com Subject: RE: Upgrade
> Question
>
>
>
>
> 06/03/02 10:23 AM
>
> Please respond to
>
> ORACLE-L
>
>
>
>
>
> I have also two other instances running on 8.1.6.2, This upgrade may be
> effected from these version of Oracle or not, or this upgrade can be totaly
> independent from 8.1.6.2
> I am a bit confused, Need your advise guy
> Thanks allot
>
> -----Original Message-----
> Sent: Monday, June 03, 2002 9:59 AM
> To: Multiple recipients of list ORACLE-L
>
> You generally get this error if the conents of the file
> /var/opt/oracle/oraInst.loc points to the
> wrong OraInventory directory.
>
> We just went to 8.1.7.4 to resolve some issues with .2. So far, so good.
>
> Ron Thomas
> Hypercom, Inc
> rthomas_at_hypercom.com
> "The problem with some people is that when they aren't drunk, they're
> sober." --William Butler
> Yeats.
>
> hamid.alavi_at_quova
>
> dx.com To:
> ORACLE-L_at_fatcity.com
>
> Sent by: cc:
>
> root_at_fatcity.com Subject: Upgrade Question
>
> 06/03/02 09:18 AM
>
> Please respond to
>
> ORACLE-L
>
> Hi List,
>
> Friday afternoon I try to upgrade database(8.1.7.0 on sun solaris) to
> 8.1.7.4 but after few minutes I got the following message:
> "There are no Patches need to be applied from the patch set oracle 8i patch
> set 8.1.7.4.0" and doesn't go thru at all, My question is for installing
> any patch do I have to install the previous patch first or what?
> Is there any Prepatch to Install for any patching or NOT?
> We have two option for upgrading 8.1.7.2 OR 8.1.7.4, Which one is better &
> safer??
> If I want to go for Patch 4,is there any comments or recommendation
> Really appreciate
>
> Hamid Alavi
> Office 818 737-0526
> Cell 818 402-1987
>
> ======================= Confidentiality Statement =======================
> The information contained in this message and any attachments is
> intended only for the use of the individual or entity to which it is
> addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL
> and exempt from disclosure under applicable law. If you have received
> this message in error, you are prohibited from copying, distributing, or
> using the information. Please contact the sender immediately by return
> e-mail and delete the original message from your system.
> ===================== End Confidentiality Statement =====================
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Hamid Alavi
> INET: hamid.alavi_at_quovadx.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> 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).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Ron Thomas
> INET: rthomas_at_hypercom.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> 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).
>
> ======================= Confidentiality Statement =======================
> The information contained in this message and any attachments is
> intended only for the use of the individual or entity to which it is
> addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL
> and exempt from disclosure under applicable law. If you have received
> this message in error, you are prohibited from copying, distributing, or
> using the information. Please contact the sender immediately by return
> e-mail and delete the original message from your system.
> ===================== End Confidentiality Statement =====================
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Hamid Alavi
> INET: hamid.alavi_at_quovadx.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> 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).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Ron Thomas
> INET: rthomas_at_hypercom.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> 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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Freeman, Robert
> INET: Robert_Freeman_at_csx.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> 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).
>
> ======================= Confidentiality Statement =======================
> The information contained in this message and any attachments is
> intended only for the use of the individual or entity to which it is
> addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL
> and exempt from disclosure under applicable law. If you have received
> this message in error, you are prohibited from copying, distributing, or
> using the information. Please contact the sender immediately by return
> e-mail and delete the original message from your system.
> ===================== End Confidentiality Statement =====================
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Hamid Alavi
> INET: hamid.alavi_at_quovadx.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> 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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Suzy Vordos
  INET: lvordos_at_qwest.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).