Why didn't Oracle RAC Opatch go to Rac database home during auto?

Source: Internet
Author: User
Tags egrep

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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.