Oracle version: Oracle versions earlier than 11.2.0.3.9 have been installed with the patch set 11.2.0.3.9, and Rac has not yet been officially used. Therefore, we can simply hit the latest 11.2.0.3.11 patch set.
Oracle version: Before Oracle Rac 11.2.0.3, the patch set 11.2.0.3.9 has been installed and is not yet officially used. Therefore, you can simply hit the latest 11.2.0.3.11 patch set.
First explain the environment:
Operating System: AIX 7.1
Oracle version: Oracle Rac 11.2.0.3
I used the 11.2.0.3.9 patch set before and it was not officially used for Rac installation, So I simply hit the latest 11.2.0.3.11 patch set.
Today, two sets of Rac were newly installed some time ago to create the latest psu, And the opatch auto method is also used to create psu. However, one of the Rac sets is patch together with Rac and Grid ,, the other is the patch Set of patch Grid only. Very depressing. The crsconfig_params of the two rac sets are basically the same. I installed the configurations of the two Rac sets in one hand. Why are there so many deviations?
The following is the Rac set that Rac and Grid patch together:
Root @ HDB01:/oraapp/oracle/backup>/oraapp/grid/gridhome/OPatch/opatch auto/install/psu-ocmrf/home/grid. rsp
Executing/oraapp/grid/gridhome/perl/bin/perl/oraapp/grid/gridhome/OPatch/crs/patch11203.pl-patchdir/install-patchn psu-ocmrf/home/grid. rsp-paramfile/oraapp/grid/gridhome/crs/install/crsconfig_params
This is the main log file:/oraapp/grid/gridhome/export toollogs/opatchauto2014-09-28_15-07-56.log
This file will show your detected configuration and all the steps that opatchauto attempted to do on your system:
/Oraapp/grid/gridhome/export toollogs/opatchauto2014-09-28_15-07-56.report.log
2014-09-28 15: 07: 56: Starting Clusterware Patch Setup
Using configuration parameter file:/oraapp/grid/gridhome/crs/install/crsconfig_params
Stopping RAC/oraapp/oracle/product/11.2.0/dbhome_1...
Stopped RAC/oraapp/oracle/product/11.2.0/dbhome_1 successfully
Patch/install/psu/17592127/custom/server/17592127 apply successful for home/oraapp/oracle/product/11.2.0/dbhome_1
Patch/install/psu/18522512 apply successful for home/oraapp/oracle/product/11.2.0/dbhome_1
Stopping CRS...
Stopped CRS successfully
Patch/install/psu/17592127 apply successful for home/oraapp/grid/gridhome
Patch/install/psu/18522512 apply successful for home/oraapp/grid/gridhome
Starting CRS...
CRS-4123: Oracle High Availability Services has been started.
Starting RAC/oraapp/oracle/product/11.2.0/dbhome_1...
Started RAC/oraapp/oracle/product/11.2.0/dbhome_1 successfully
Opatch auto succeeded.
Root @ DB01:/oraapp/oracle/backup> su-grid
The Rac that only patches the Grid is as follows:
Root @ ODB01:/install/psu>/oraapp/grid/gridhome/OPatch/opatch auto/install/psu-ocmrf/home/grid. rsp
Executing/oraapp/grid/gridhome/perl/bin/perl/oraapp/grid/gridhome/OPatch/crs/patch11203.pl-patchdir/install-patchn psu-ocmrf/home/grid. rsp-paramfile/oraapp/grid/gridhome/crs/install/crsconfig_params
This is the main log file:/oraapp/grid/gridhome/export toollogs/opatchauto2014-09-28_15-08-19.log
This file will show your detected configuration and all the steps that opatchauto attempted to do on your system:
/Oraapp/grid/gridhome/export toollogs/opatchauto2014-09-28_15-08-19.report.log
2014-09-28 15: 08: 19: Starting Clusterware Patch Setup
Using configuration parameter file:/oraapp/grid/gridhome/crs/install/crsconfig_params
Stopping CRS...
Stopped CRS successfully
Patch/install/psu/17592127 apply successful for home/oraapp/grid/gridhome
Patch/install/psu/18522512 apply successful for home/oraapp/grid/gridhome
Starting CRS...
CRS-4123: Oracle High Availability Services has been started.
Opatch auto succeeded.
Root @ ODB01:/install/psu>
View the Mos document: (Doc ID 1479651.1) It is found that there is a database in HDB (that is, the database is created in the form of dbca), and there is no database DB in ODB.
Ps: Now I suddenly remembered that I did set up a database on HDB some time ago and did some data migration for testing... (Dull)
During opatch, oracle found that no database was registered to OCR, so it only patched the Grid.
The commands provided by Mos show that there is indeed ora. HDB. db in CRS on hdb:
Grid @ HDB01:/home/grid> crsctl stat res-p-w "TYPE = ora. database. type" | egrep '^ NAME | ^ ORACLE_HOME'
NAME = ora. hdb. db
ORACLE_HOME =/oraapp/oracle/product/11.2.0/dbhome_1
ORACLE_HOME_OLD =
NAME = ora. hdb. db
ORACLE_HOME =/oraapp/oracle/product/11.2.0/dbhome_1
ORACLE_HOME_OLD =
Grid @ HDB01:/home/grid>
On the ODB, there is no output for the next command. Check the/etc/oratab file and no other databases except ASM are found:
Grid @ ODB01:/home/grid> crsctl stat res-p-w "TYPE = ora. database. type" | egrep '^ NAME | ^ ORACLE_HOME'
Grid @ SRMBODB01:/home/grid>
You can use the following command to install another Rac patch:
As root user, execute the following command:
Opatch auto -Oh -Ocmrf
Migration from 32-bit to 64-bit for a single Oracle instance
Install Oracle 11gR2 (x64) in CentOS 6.4)
Steps for installing Oracle 11gR2 in vmwarevm
Install Oracle 11g XE R2 In Debian