Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Upgrade Question

RE: Upgrade Question

From: Ron Thomas <rthomas_at_hypercom.com>
Date: Mon, 03 Jun 2002 10:13:46 -0800
Message-ID: <F001.00472856.20020603101346@fatcity.com>

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

--

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: 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). Received on Mon Jun 03 2002 - 13:13:46 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US