Re: Upgrade Question

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
> > 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).
>
> ======================= 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).