Reinstall ASM or DB HOME on One RAC Node From the Install Media_864614.1

rongshiyuan發表於2014-05-06

How to Reinstall ASM or DB HOME on One RAC Node From the Install Media. (Doc ID 864614.1)


In this Document
  Goal
  Solution
     Scalability RAC Community


Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 10.2.0.5 - Release: 10.2 to 10.2
Information in this document applies to any platform.

Goal

There is a need to reinstall either ASM or RDBMS  HOME on one node or a subset of nodes.   Cloning the ASM and RDBMS HOME sometimes requires that the database instance and/or ASM be brought down on the node where the clone image is being made.  Also, cloning sometimes fails for various reasons and there may be a need for an alternate method to reinstall an ASM or RDBMS HOME.

Solution

1) Get the list of patches that are applied to the ORACLE_HOME that is being reinstalled.

a) Run "opatch lsinventory -detail -oh 
   from node 1 or another node if node 1 is getting reinstalled. 
b) Save the output. 

2) Shutdown all resources on the local node that use the ORACLE_HOME that is being reinstalled.

a) Shutdown instances 
b) Shutdown listeners, if applicable 
c) Shutdown ASM, if applicable 

3) Backup oraInventory and ORACLE_HOME that is getting reinstalled.
    This is strongly suggested, in case anything goes wrong. Having backup, will allow a quick and
    easy restoration.

a) cd  b) cp -rp oraInventory oraInventory.bkup 
c) cd  
d) mv    
     e.g. mv /app/oracle/10.2.0/db /app/oracle/10.2.0/db.bkup 

4) Remove ORACLE_HOME.

a) Start runInstaller from ORA_CRS_HOME/oui/bin 
  (must be started from installed oui and not from product image) 
b) On Welcome screen, click "Deinstall Products" 
c) Select ORACLE_HOME that needs to be removed 
   -- confirm that the location (directory) is correct. 
d) Click "Remove" 
e) Click "Yes" after confirming the location 
f) Click "Close" 
  

5) Install 10.2.0.1 (base release of 10g)

a) Go to the 10.2.0.1 product image home 
b) cd database 
c) ./runInstaller -local 
d) On "Specify Home Details" page, make sure that "Name" is the 
   "HOME NAME" used previously.  Go to another node and 
   check oraInventory/ContentsXML/inventory.xml file for the "HOME NAME". 
   The "Path" should also be same as before, and this is same as "LOC" 
   in the oraInventory/ContentsXML/inventory.xml file. 
e) On "Specify Hardware Cluster Installation Mode" page, 
   select "Cluster Installation and make sure that only the 
   local node is selected. 
   The local node is where the ORACLE_HOME is getting reinstalled. 
f) On "Upgrade an Existing Database" page, make sure to select "no" 
   because the database is not being upgraded. 
g) on "Select Configuration Option", make sure to select 
   "Install database Software only" 
h) Continue the installation until OUI asks to run root.sh. 
i) Run ORACLE_HOME/root.sh only on the local node that ORACLE_HOME is 
   getting reinstalled. 

6) Install 10.2.0.4 or the patchset that was applied to the previous HOME.
    The output from "opatch lsinventory" from step 1 shows the patchset level.

a) Go to the 10.2.0.4 or other patchset home 
b) cd Disk1 
c) Issue ./runInstaller -local 
d) On "Specify Home Details" page, make sure that Name is "HOME NAME" for 
   ORACLE_HOME  that is found in the inventory.xml file. 
   Also, make sure that the path is correct and is same as ORACLE_HOME 
e) Continue the installation until oui asks to run root.sh. 
f) Run ORACLE_HOME/root.sh only on the node that ORACLE_HOME is getting 
   reinstalled 

7) Apply the patches listed in the output from "opatch lsinventory" (from step 1).

8) Copy the following files from the backed up ORACLE_HOME (old home) 
    to the new ORACLE_HOME.

a) create same soft links in dbs and network/admin directories in the 
   new ORACLE_HOME as in the old backed up ORACLE_HOME
b) files in the dbs directory.
c) files in the network/admin directory

9) Copy the oraInventory/ContentsXML/inventory.xml file from another node to the local node

10) Start the resources that were stopped in step 2



Scalability RAC Community

To discuss this topic further with Oracle experts and industry peers, we encourage you to review, join or start a discussion in the My Oracle Support Scalability RAC Community.




來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/17252115/viewspace-1155489/,如需轉載,請註明出處,否則將追究法律責任。

相關文章