Explain the environment: operating system: AIX 7.1Oracle version: Oracle RAC 11.2.0.3 before the 11.2.0.3.9 patch set, the RAC is not formally used, so you can simply hit the latest 11.2.0.3.11 patch set.
The two sets of RAC that were newly installed today in the new PSU, also use Opatch Auto to hit the PSU, but one set of RAC is a patch with RAC and grid, and the other is patch grid-only patches. Very depressed, two sets of RAC Crsconfig_params is basically the same, two sets of RAC related configuration is I install the configuration, why there are so many deviations?
The following is the set of Rac:[email that the RAC and grid patch together Protected]:/oraapp/oracle/backup>/oraapp/grid/gridhome/opatch/opatch Auto/ install/psu-ocmrf/home/grid/grid.rspexecuting/oraapp/grid/gridhome/perl/bin/perl/oraapp/grid/gridhome/opatch/ Crs/patch11203.pl-patchdir/install-patchn psu-ocmrf/home/grid/grid.rsp-paramfile/oraapp/grid/gridhome/crs/ Install/crsconfig_params
This is the main log file:/oraapp/grid/gridhome/cfgtoollogs/opatchauto2014-09-28_15-07-56.log
This file would show your detected configuration and all the steps, Opatchauto attempted to doing on your system:/oraapp/g Rid/gridhome/cfgtoollogs/opatchauto2014-09-28_15-07-56.report.log
2014-09-28 15:07:56:starting clusterware Patch setupusing 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_1patch/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 Successfu L for Home/oraapp/grid/gridhome
Starting CRS ... Crs-4123:oracle High Availability Services have 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. [Email Protected]:/oraapp/oracle/backup>su-grid
The following is a patch of the grid of the set of Rac:[email Protected]:/install/psu>/oraapp/grid/gridhome/opatch/opatch AUTO/INSTALL/PSU- ocmrf/home/grid/grid.rspexecuting/oraapp/grid/gridhome/perl/bin/perl/oraapp/grid/gridhome/opatch/crs/ Patch11203.pl-patchdir/install-patchn psu-ocmrf/home/grid/grid.rsp-paramfile/oraapp/grid/gridhome/crs/install/ Crsconfig_params
This is the main log file:/oraapp/grid/gridhome/cfgtoollogs/opatchauto2014-09-28_15-08-19.log
This file would show your detected configuration and all the steps, Opatchauto attempted to doing on your system:/oraapp/g Rid/gridhome/cfgtoollogs/opatchauto2014-09-28_15-08-19.report.log
2014-09-28 15:08:19:starting clusterware Patch setupusing 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 Successfu L for Home/oraapp/grid/gridhome
Starting CRS ... Crs-4123:oracle High Availability Services have been started.
Opatch Auto succeeded. [Email protected]:/install/psu>
By looking at the MoS document: (Doc ID 1479651.1), it is known that there is a database in the HDB (that is, the database is created through DBCA, etc.), and there is no database db on the ODB. PS: Then suddenly remembered, the previous period of time indeed in the HDB set up a database, and do some data migration to do test ... (dull) Opatch when Oracle discovers that no database is registered in OCR, it simply patches the grid.
As follows: The command provided by the MoS found that the ora.hdb.db exists in the CRS on the HDB: [email protected]:/home/grid>crsctl stat res-p-W "TYPE = Ora.database.type "|egrep ' ^name|^oracle_home 'name=ora.hdb.dbOracle_home=/oraapp/oracle/product/11.2.0/dbhome_1oracle_home_old=name=ora.hdb.dbOracle_home=/oraapp/oracle/product/11.2.0/dbhome_1oracle_home_old=[Email protected]:/home/grid>
And on ODB, the command goes down without any output, look at the/etc/oratab file, and do not find a database other than ASM: [email protected]:/home/grid>crsctl stat res-p-W "TYPE = Ora.database.type "|egrep ' ^name|^oracle_home ' [email protected]:/home/grid>
You can also give a RAC patch patch by using the following command: As root user, execute the following Command:opatch auto <UNZIPPED_PATCH_LOCATION>-oh <d atabase_home>-OCMRF <ocm Response file>
Why not hit the RAC database home when Oracle RAC Opatch Auto
