Why didn't Oracle RAC Opatch go to Rac database home during auto?
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 form the latest psu, And the opatch auto method is also used to create psu, but one of the Rac 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 <UNZIPPED_PATCH_LOCATION>-oh <DATABASE_HOME>-ocmrf <ocm response file>
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