Etrack Incidents: 1049285, 1044590 * * * Storage Foundation For Oracle RAC (SFRAC) 5.0 MP1 (AIX) PATCH 5.0MP1+e1049285+e1044590 * * * Patch Date: May 2006 This README provides information on: * BEFORE GETTING STARTED * FIXES AND ENHANCEMENTS INCLUDED IN THIS SFRAC PATCH * FILE AFFECTED BY THIS SFRAC PATCH * VERIFYING CRC AND BYTE COUNT * COPYING FILES TO THEIR LOCATION * RELINKING ORACLE WITH THE NEWLY COPIED LIBRARY BEFORE GETTING STARTED ---------------------- This patch is only for SFRAC 5.0 MP1 on AIX 5.2 or AIX 5.3. Ensure that you are running one of these supported configurations before applying this patch. FIXES AND ENHANCEMENTS INCLUDED IN THIS SFRAC PATCH --------------------------------------------------- e997770 In one of the senario IPC was leaving request handler in the queue even after Oracle calls skgxpdis() for the connection. This cause ORA-0600 since after skgxp24.h Oracle expects us to remove all request handler associated with a connection from the done queue when skgxpdis() is called. e1044590 Oracle crash on one node leads to Oracle crash on another. The fix is to suppress connection failure by not propogating it to Oracle. The membership module will do the needful. This patch supplies the required SKGXP libraries Oracle 9i, 10gR1 and 10gR2 in a SFRAC environment on AIX. FILE AFFECTED BY THIS SFRAC PATCH --------------------------------- This patch will replace the following files in your environment: $VCS_HOME/ops/lib/libskgxp9_ver22_32.so $VCS_HOME/ops/lib/libskgxp9_ver22_32.a $VCS_HOME/ops/lib/libskgxp9_ver22_64.so $VCS_HOME/ops/lib/libskgxp9_ver22_64.a $VCS_HOME/ops/lib/libskgxp9_ver24_32.so $VCS_HOME/ops/lib/libskgxp9_ver24_32.a $VCS_HOME/ops/lib/libskgxp9_ver24_64.so $VCS_HOME/ops/lib/libskgxp9_ver24_64.a $VCS_HOME/ops/lib/libskgxp9_ver25_32.so $VCS_HOME/ops/lib/libskgxp9_ver25_32.a $VCS_HOME/ops/lib/libskgxp9_ver25_64.so $VCS_HOME/ops/lib/libskgxp9_ver25_64.a $VCS_HOME/ops/lib/libskgxp10_ver23_32.so $VCS_HOME/ops/lib/libskgxp10_ver23_32.a $VCS_HOME/ops/lib/libskgxp10_ver23_64.so $VCS_HOME/ops/lib/libskgxp10_ver23_64.a $VCS_HOME/ops/lib/libskgxp10_ver24_32.so $VCS_HOME/ops/lib/libskgxp10_ver24_32.a $VCS_HOME/ops/lib/libskgxp10_ver24_64.so $VCS_HOME/ops/lib/libskgxp10_ver24_64.a $VCS_HOME/ops/lib/libskgxp10_ver25_32.so $VCS_HOME/ops/lib/libskgxp10_ver25_32.a $VCS_HOME/ops/lib/libskgxp10_ver25_64.so $VCS_HOME/ops/lib/libskgxp10_ver25_64.a VERIFYING CRC AND BYTE COUNT ---------------------------- For each library in the patch, ensure that the CRC and byte count match the output shown below: # cd /lib # cksum * 1530928435 191760 libskgxp10_ver23_32.a 3932127263 204383 libskgxp10_ver23_32.so 556795876 215360 libskgxp10_ver23_64.a 138098352 228997 libskgxp10_ver23_64.so 45227464 192332 libskgxp10_ver24_32.a 1481612525 204872 libskgxp10_ver24_32.so 4216850240 216114 libskgxp10_ver24_64.a 891061662 229746 libskgxp10_ver24_64.so 4240721659 192332 libskgxp10_ver25_32.a 1213748225 204872 libskgxp10_ver25_32.so 4048337667 216114 libskgxp10_ver25_64.a 343655171 229746 libskgxp10_ver25_64.so 274756326 191760 libskgxp9_ver22_32.a 3995245357 204383 libskgxp9_ver22_32.so 455984249 215360 libskgxp9_ver22_64.a 3880273882 228997 libskgxp9_ver22_64.so 3107566956 192332 libskgxp9_ver24_32.a 2524423673 204872 libskgxp9_ver24_32.so 1719616185 216114 libskgxp9_ver24_64.a 3201009833 229746 libskgxp9_ver24_64.so 1956789261 192332 libskgxp9_ver25_32.a 1071190728 204872 libskgxp9_ver25_32.so 1487336172 216114 libskgxp9_ver25_64.a 1638072371 229746 libskgxp9_ver25_64.so COPYING FILES TO THEIR LOCATION ------------------------------- On each node of your cluster (as "root" user), 1. Backup the SKGXP libraries under /opt/VRTSvcs/ops/lib # cd /opt/VRTSvcs/ops/lib # for file in libskgxp* > do > cp $file $file.bak > done 2. Change directory to the patch location. # cd /lib 3. Copy all the libraries to /opt/VRTSvcs/ops/lib # cp * /opt/VRTSvcs/ops/lib RELINKING ORACLE WITH THE NEWLY COPIED LIBRARY ---------------------------------------------- 1. If you"ve already installed Oracle, you must relink Oracle with the newly installed SKGXP library (from the installsfrac menu). 2. If Oracle has not been installed yet, follow the instructions in the SFRAC ICG to install and relink Oracle.