The oratab doesn't look right to me. The second token should have the full path to ORACLE_HOME for each version. Unless of course Oracle is *really* installed under /u01/app/oracle instead of /u01/app/oracle/8.1.6, in which case that doesn't follow OFA standards.
STAR:/u01/app/oracle/8.1.6:Y The Y or N says whether to start/shutdown the database when dbstart/dbshut are executed. Installing software of patches is driven by oraInst.loc and proper setting of dependent env variables ORACLE_BASE, ORACLE_ADMIN and ORACLE_HOME. Is it possible one or more env variables isn't set? Here's an example of what is needed (the actual values would differ for your environment). ORACLE_BASE=/opt/app/oracle ORACLE_ADMIN=/opt/app/oracle/admin ORACLE_HOME=/opt/app/oracle/product/8.1.7 Note that ORACLE_BASE is generally where the orainventory resides (which should also match the value of inventory_loc in the /var/opt/oracle/oraInst.loc file). Under ORACLE_BASE you should see the following directories: jre OraInventory oui product. Hamid Alavi wrote: > > Thanks, > So why when I try to Upgrade from 8.1.7.0 to 8.1.7.4 installer get confused > and looking for a installed patch? > What the content of oratab should be? > I have the following values in my oratab: > > STAR:/u01/app/oracle:Y 8.1.6 > CQST:/u01/app/oracle:Y 8.1.6 > HMS:/u01/app/oracle:N 8.1.6 > DEVL:/u04/app/oracle:N 8.1.7.0 > REPO:/u04/app/oracle:N 8.1.7.0 > PROD:/u04/app/oracle:N 8.1.7.0 > > Actualy I don't know those "Y" or "N" infront of each instance name, Do I > have to change it to "Y" for 8.1.7 instances or NOT? > Appreciate. > > -----Original Message----- > Sent: Monday, June 03, 2002 3:23 PM > To: Multiple recipients of list ORACLE-L > > 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). > > ======================= 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).
