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 > [EMAIL PROTECTED] > "The problem with some people is that when they aren't drunk, they're > sober." --William Butler > Yeats. > > > > hamid.alavi@quova > > dx.com To: > [EMAIL PROTECTED] > > Sent by: cc: > > [EMAIL PROTECTED] 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 > [EMAIL PROTECTED] > "The problem with some people is that when they aren't drunk, they're > sober." --William Butler > Yeats. > > hamid.alavi@quova > > dx.com To: > [EMAIL PROTECTED] > > Sent by: cc: > > [EMAIL PROTECTED] 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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).