Tuesday, January 31, 2012

application PSU january 2012 on 11.2.0.3


My first encourter with the auto functionality was positive, but still rather scary got the same feeling with it than opening a database with resetlogs ;)
It was the
grid infrastructure  11.2.0.3 on a single node that i patched. 





opatch auto ./gi -oh $GRID_HOME -ocmrf ./gi/ocm.rsp 
Executing /usr/bin/perl /u01/app/grid/product/11.2.0/grid/OPatch/crs/patch112.pl -patchdir . -patchn gi -oh /u01/app/grid/product/11.2.0/grid -ocmrf ./gi/ocm.rsp -paramfile /u01/app/grid/product/11.2.0/grid/crs/install/crsconfig_params
opatch auto log file location is /u01/app/grid/product/11.2.0/grid/OPatch/crs/../../cfgtoollogs/opatchauto2012-01-31_16-34-04.log
Detected Oracle Restart install
Using configuration parameter file: /u01/app/grid/product/11.2.0/grid/crs/install/crsconfig_params
Can't change permissions of ./gi: Not owner




Successfully unlock /u01/app/grid/product/11.2.0/grid
patch ./gi/13348650  apply successful for home  /u01/app/grid/product/11.2.0/grid
patch ./gi/13343438  apply successful for home  /u01/app/grid/product/11.2.0/grid
ACFS-9300: ADVM/ACFS distribution files found.
ACFS-9312: Existing ADVM/ACFS installation detected.
ACFS-9314: Removing previous ADVM/ACFS installation.
ACFS-9315: Previous ADVM/ACFS components successfully removed.
ACFS-9307: Installing requested ADVM/ACFS software.
ACFS-9308: Loading installed ADVM/ACFS drivers.
ACFS-9154: Loading 'oracleoks' driver.
ACFS-9154: Loading 'oracleadvm' driver.
ACFS-9154: Loading 'oracleacfs' driver.
ACFS-9327: Verifying ADVM/ACFS devices.
ACFS-9156: Detecting control device '/dev/asm/.asm_ctl_spec'.
ACFS-9156: Detecting control device '/dev/ofsctl'.
ACFS-9309: ADVM/ACFS installation correctness verified.
CRS-4123: Oracle High Availability Services has been started.





opatch lsinventory ...




Oracle Home       : /u01/app/grid/product/11.2.0/grid
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/grid/product/11.2.0/grid/oraInst.loc
OPatch version    : 11.2.0.1.9
OUI version       : 11.2.0.3.0
Log file location : /u01/app/grid/product/11.2.0/grid/cfgtoollogs/opatch/opatch2012-01-31_16-40-50PM.log


Lsinventory Output file location : /u01/app/grid/product/11.2.0/grid/cfgtoollogs/opatch/lsinv/lsinventory2012-01-31_16-40-50PM.txt


--------------------------------------------------------------------------------
Installed Top-level Products (1): 


Oracle Grid Infrastructure                                           11.2.0.3.0
There are 1 products installed in this Oracle Home.




Interim patches (2) :


Patch  13343438     : applied on Tue Jan 31 16:38:07 CET 2012
Unique Patch ID:  14279366
Patch Description:  "Database Patch Set Update : 11.2.0.3.1 (13343438)"
   Created on 30 Dec 2011, 03:13:30 hrs PST8PDT
   Bugs fixed:
     12847466, 13499128, 12718090, 12917230, 13035804, 12938841, 13528551
     12861463, 12620823, 12950644, 13466801, 13041324, 12998795, 13343438
     13492735, 13362079, 9873405, 12797765, 12834027, 9703627, 12905058


Patch  13348650     : applied on Tue Jan 31 16:37:05 CET 2012
Unique Patch ID:  14279366
Patch Description:  "Grid Infrastructure Patch Set Update : 11.2.0.3.1 (13348650)"
   Created on 12 Jan 2012, 22:24:00 hrs PST8PDT
   Bugs fixed:
     13348650, 13039908, 12794268, 13011520, 12784559, 12758736, 13077654
     13001901, 13074261, 12971251, 12538907, 13066371, 12857064, 12897651
     12897902, 12896850, 12726222, 12829429, 12728585, 13396284, 12899169
     13079948, 13111013, 12876314, 12867511, 13090686, 12925041, 12995950
     13085732, 12848480, 12829917, 12990582, 12849377, 12934171, 12975811
     12917897, 12914824, 13082238, 13334158, 12947871, 12950823, 13355963
     12878750, 13001955, 13002015, 11836951, 12965049, 13024624, 12765467
     12791719, 12885323, 13345868, 13019958, 13255295, 12810890, 12782756
     12823042, 12825835, 12932852, 12695029, 12873909, 13263435, 13038806
     12820045, 12842804, 12827493, 13396356, 13045518, 12765868, 12834777
     13068077, 12772345, 12823838






--------------------------------------------------------------------------------

auto update of the ./runInstaller

one of the nice new features in 11.2.0.x is the fact that the installer can look for appropriate patches.

i thought it would install the PSU  however this seems not to be true :

  opatch lsinventory -bugs_fixed -oh $ORACLE_HOME





List of Bugs fixed by Installed Patches:


Bug        Fixed by  Installed at                   Description
            Patch                                              
---        --------  ------------                   -----------


13499128   13499128  Thu Jan 19 17:03:36 CET 2012   DB-11.2.0.3-MOLECULE-001-CPUJAN2012
13528551   13528551  Thu Jan 19 17:03:30 CET 2012   DB-11.2.0.3-MOLECULE-002-CPUJAN2012
13466801   13466801  Thu Jan 19 17:03:25 CET 2012   CPUJAN2012 DATABASE 11.2.0.3








It installs the CPU ...

Friday, January 6, 2012

adding 10gR2 to 11gR2 clusterware on single node

wanted to add our original 10.2.0.3 database to  srvctl apparently this is not possible nor supported in 11.2.0.3

after executing
"
           srvctl add database -d V10 -o /u01/app/oracle/product/10.2.0/db_1   -n P10
         "
got following fine error ...

"
PRCD-1245 : Addition of database version 11.2.0.3.0 is not allowed using srvctl version 10.2.0.0.0
"
the error is a bit misleading since the db i was trying to add is certainly a 10.2.0.3 ...
anyway further reading showed that this is not supported ....