Why not hit the RAC database home when Oracle RAC Opatch Auto

Source: Internet
Author: User
Tags egrep

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

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.