Debug Upgrade Problems

Important Notes

  • How to Apply a Grid Infrastructure Patch Before root script (root.sh or rootupgrade.sh) is Executed? (Doc ID 1410202.1)
  • How to Configure or Re-configure Grid Infrastructure With config.sh/config.bat (Doc ID 1354258.1)
  • Things to Consider Before Upgrading to 11.2.0.2 Grid Infrastructure/ASM (Doc ID 1312225.1)
  •  rootupgrade.sh (and root.sh for that matter) are restartable since 11.2.0.2 at least
  •   A great deal of logging is available in $GRID_HOME/cfgtoollogs/crsconfig/rootcrs_hostname.logLogfiles :
    • Checkpoint file  : /u01/app/grid/Clusterware/ckptGridHA_grac31.xml
    • Log File         :  $GRID_HOME/cfgtoollogs/crsconfig/rootcrs_grac31.log
  • How to Proceed When Upgrade to 11.2 Grid Infrastructure Cluster Fails (Doc ID 1364947.1)
  • Be careful before you remove the OLD binaires – if you need to drop old resouces  you may need these binairies

PRCD-1229 error if you want  to delete a  12.1.0.1  created resource  with 12.1.0.2 srvctl

[oracle@gract1 ~]$  srvctl  remove service -db cdb -s hr -force
PRCD-1229 : An attempt to access configuration of database cdb was rejected because its version 
12.1.0.1.0 differs from the  program version 12.1.0.2.0. 
Instead run the program from /u01/app/oracle/product/121/racdb.

Check that ASM and database is running

[oracle@grac41 ~/DBSupportBundle134]$ srvctl status  database -d grac4
Instance grac41 is running on node grac41
Instance grac42 is running on node grac42
Instance grac43 is running on node grac43

[oracle@grac41 ~/DBSupportBundle134]$ srvctl status  asm
ASM is running on grac42,grac43,grac41

Run orack as oracle user and cluvfy as user grid

[oracle@grac41 ~/DBSupportBundle134]$ cd /home/oracle/DBSupportBundle134
[oracle@grac41 ~/DBSupportBundle134]$ ./orachk -u -o pre 

grid@grac41 /]$  cluvfy stage -pre crsinst -upgrade -n grac41,grac42,grac43 -rolling -src_crshome $GRID_HOME 
                 -dest_crshome /u01/app/grid_new -dest_version 12.1.0.1.0  -fixup -fixupdir /tmp -verbose

 

Install software

  • To upgrade to this release, you must install the Oracle Grid Infrastructure and Oracle Database software into a new Oracle home instead of applying a patch set to the existing Oracle home.
  • This is referred to as an out-of-place upgrade and is different from patch set releases for earlier releases of Oracle Database, where the patch set was always installed in place.

Problems before running rootupgrade.sh

  • Troubleshoot 11gR2 Grid Infrastructure/RAC Database runInstaller Issues (Doc ID 1056322.1)
  • Top 11gR2 Grid Infrastructure Upgrade Issues (Doc ID 1366558.1)

 

Problems after running rootupgrade.sh

  • How to Proceed When Upgrade to 11.2 Grid Infrastructure Cluster Fails (Doc ID 1364947.1)
  • Step 1: Identify cause of rootupgrade.sh failure
Identify the cause of the rootupgrade.sh failure by reviewing logs in $NEW_HOME/cfgtoollog/crsconfig,
$NEW_HOME/log, $CIL/logs and $ORACLE_BASE/cfgtoollogs/asmca. Once root cause is identified and the issue is resolved,
proceed with the steps below.
  • Step 2 : Rerun rootupgrade.sh
rootupgrade.sh is restartable when upgrading to 11.2.0.2 or above. After the issue identified in Step 1 has been 
resolved, as root execute "$NEW_HOME/rootupgrade.sh" (even if the cause is unclear, it's still recommended to 
re-run rootupgrade.sh 10 minutes after the failure at least once ). It will continue from the last failed step. 
If it succeeds, continue with your planned upgrade procedure. Continue with the rest of steps in this document 
only when this Step fails

For complete deconfiguration steps read  Note  1364947.1
  • How To Proceed After The Failed Upgrade or Deconfiguration Of The Grid Infrastructure Software In Standalone Environments (Doc ID 1121573.1)

Reference

  • Troubleshoot 11gR2 Grid Infrastructure/RAC Database runInstaller Issues (Doc ID 1056322.1)
  • Top 11gR2 Grid Infrastructure Upgrade Issues (Doc ID 1366558.1)
  • How to Proceed When Upgrade to 11.2 Grid Infrastructure Cluster Fails (Doc ID 1364947.1)
  • How To Proceed After The Failed Upgrade or Deconfiguration Of The Grid Infrastructure Software In Standalone Environments (Doc ID 1121573.1)
  • Things to Consider Before Upgrading to 11.2.0.3/11.2.0.4 Grid Infrastructure/ASM (Doc ID 1363369.1)
  • How to Apply a Grid Infrastructure Patch Before root script (root.sh or rootupgrade.sh) is Executed? (Doc ID 1410202.1)
  • How to Configure or Re-configure Grid Infrastructure With config.sh/config.bat (Doc ID 1354258.1)
  • Oracle® Grid Infrastructure Installation Guide 11g Release 2 (11.2) for Linux
      F How to Upgrade to Oracle Grid Infrastructure 11g Release
  • http://gavinsoorma.com/2012/07/upgrading-11gr2-rac-grid-infrastructure-to-11-2-0-3/       (Grid Upgrade 11.2.0.1 -> 11. 2.0.4 ) 
  • http://appsdbaworkshop.blogspot.co.uk/2014/03/upgrade-oracle-grid-infrastructure-from.html    (Grid Upgrade 11.2.0.1 -> 11. 2.0.4 )

Leave a Reply

Your email address will not be published. Required fields are marked *


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>