SRVCTL :

Display the Current Policy  :

Example :

grid@cluster04>srvctl config database -d test
Database unique name: test
Database name: test
Oracle home: /u01/app/oracle/product/11.2.3/laeb
Oracle user: oracle
Spfile: +TEST/test/spfiletest.ora
Domain: maximus.com
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: MANUAL
Server pools: test
Database instances: test1,test2
Disk Groups: TEST
Mount point paths:
Services:
Type: RAC
Database is administrator managed

Modify policy on existing database

grid@cluster04>srvctl modify database -d test -y AUTOMATIC
PH: .    DB: DB: test1
/home/grid
grid@cluster04>srvctl config database -d test
Database unique name: test
Database name: test
Oracle home: /u01/app/oracle/product/11.2.3/laeb
Oracle user: oracle
Spfile: +TEST/test/spfiletest.ora
Domain: maximus.com
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: test
Database instances: test1,test2
Disk Groups: TEST
Mount point paths:
Services:
Type: RAC
Database is administrator managed

Example :

Specify a Policy for a New Database

srvctl add database -d test -y AUTOMATIC -o $ORACLE_HOME -d DATA

=========================================================================

Cluster verification utility .

Verify Integrity of ASM instance.
cluvfy comp asm -n cluster04,cluster05 -verbose

grid@cluster04>cluvfy comp asm -n cluster04,cluster05 -verbose
Verifying ASM Integrity
Task ASM Integrity check started…
Starting check to see if ASM is running on all cluster nodes…
ASM Running check passed. ASM is running on all specified nodes
Starting Disk Groups check to see if at least one Disk Group configured…
Disk Group Check passed. At least one Disk Group configured
Task ASM Integrity check passed…
Verification of ASM Integrity was successful.

==========================================================================

PATCHING  :

Patch the system where  Grid infrastructure and database  is not in shared filesystem .No ACFS filesystem used. Below is the example of patching and patching output .

OPATCH AUTO – Shutdown the database and applies the patch to the grid environment.

Example : Both Grid and Database environment .It has to be invoked per node basis.

Node 1 :
/u01/software/patches/16495688_112034
grid@cluster04>sudo opatch auto /u01/software/patches/16495688_112034 -ocmrf /u01/app/grid/product/11.2.0.3/isg/OPatch/ocm/bin/ocm.rsp
Password:
Executing /u01/app/grid/product/11.2.0.3/isg/perl/bin/perl /u01/app/grid/product/11.2.0.3/isg/OPatch/crs/patch11203.pl -patchdir /u01/software/patches -patchn 16495688_112034 -ocmrf /u01/app/grid/product/11.2.0.3/isg/OPatch/ocm/bin/ocm.rsp -paramfile /u01/app/grid/product/11.2.0.3/isg/crs/install/crsconfig_params
/u01/app/grid/product/11.2.0.3/isg/crs/install/crsconfig_params
/u01/app/grid/product/11.2.0.3/isg/crs/install/s_crsconfig_defs

This is the main log file: /u01/app/grid/product/11.2.0.3/isg/cfgtoollogs/opatchauto2013-05-16_12-27-36.log
This file will show your detected configuration and all the steps that opatchauto attempted to do on your system: /u01/app/grid/product/11.2.0.3/isg/cfgtoollogs/opatchauto2013-05-16_12-27-36.report.log

2013-05-16 12:27:36: Starting Clusterware Patch Setup
Using configuration parameter file: /u01/app/grid/product/11.2.0.3/isg/crs/install/crsconfig_params
patch /u01/software/patches/16495688_112034/16495688/custom/server/16495688  apply successful for home  /u01/app/oracle/product/11.2.3/test
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on ‘cluster04’
CRS-2673: Attempting to stop ‘ora.crsd’ on ‘cluster04’
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on ‘cluster04’
CRS-2673: Attempting to stop ‘ora.LISTENER_SCAN3.lsnr’ on ‘cluster04’
CRS-2673: Attempting to stop ‘ora.LISTENER_SCAN2.lsnr’ on ‘cluster04’
CRS-2673: Attempting to stop ‘ora.CRSDG.dg’ on ‘cluster04’
CRS-2673: Attempting to stop ‘ora.REDO.dg’ on ‘cluster04’
CRS-2673: Attempting to stop ‘ora.TEST.dg’ on ‘cluster04’
CRS-2673: Attempting to stop ‘ora.LISTENER.lsnr’ on ‘cluster04’
CRS-2673: Attempting to stop ‘ora.LISTENER_1535_testUAT_testTRN_LADMSUAT_LADMUAT_testDR.lsnr’ on ‘cluster04’
CRS-2677: Stop of ‘ora.LISTENER_SCAN3.lsnr’ on ‘cluster04’ succeeded
CRS-2673: Attempting to stop ‘ora.scan3.vip’ on ‘cluster04’
CRS-2677: Stop of ‘ora.LISTENER_SCAN2.lsnr’ on ‘cluster04’ succeeded
CRS-2673: Attempting to stop ‘ora.scan2.vip’ on ‘cluster04’
CRS-2677: Stop of ‘ora.LISTENER.lsnr’ on ‘cluster04’ succeeded
CRS-2677: Stop of ‘ora.scan3.vip’ on ‘cluster04’ succeeded
CRS-2672: Attempting to start ‘ora.scan3.vip’ on ‘cluster05’
CRS-2677: Stop of ‘ora.LISTENER_1535_testUAT_testTRN_LADMSUAT_LADMUAT_testDR.lsnr’ on ‘cluster04’ succeeded
CRS-2673: Attempting to stop ‘ora.cluster04.vip’ on ‘cluster04’
CRS-2677: Stop of ‘ora.scan2.vip’ on ‘cluster04’ succeeded
CRS-2672: Attempting to start ‘ora.scan2.vip’ on ‘cluster05’
CRS-2677: Stop of ‘ora.cluster04.vip’ on ‘cluster04’ succeeded
CRS-2672: Attempting to start ‘ora.cluster04.vip’ on ‘cluster05’
CRS-2677: Stop of ‘ora.TEST.dg’ on ‘cluster04’ succeeded
CRS-2677: Stop of ‘ora.REDO.dg’ on ‘cluster04’ succeeded
CRS-2676: Start of ‘ora.scan3.vip’ on ‘cluster05’ succeeded
CRS-2672: Attempting to start ‘ora.LISTENER_SCAN3.lsnr’ on ‘cluster05’
CRS-2676: Start of ‘ora.cluster04.vip’ on ‘cluster05’ succeeded
CRS-2676: Start of ‘ora.LISTENER_SCAN3.lsnr’ on ‘cluster05’ succeeded
CRS-2676: Start of ‘ora.scan2.vip’ on ‘cluster05’ succeeded
CRS-2672: Attempting to start ‘ora.LISTENER_SCAN2.lsnr’ on ‘cluster05’
CRS-2676: Start of ‘ora.LISTENER_SCAN2.lsnr’ on ‘cluster05’ succeeded
CRS-2677: Stop of ‘ora.CRSDG.dg’ on ‘cluster04’ succeeded
CRS-2673: Attempting to stop ‘ora.asm’ on ‘cluster04’
CRS-2677: Stop of ‘ora.asm’ on ‘cluster04’ succeeded
CRS-2673: Attempting to stop ‘ora.ons’ on ‘cluster04’
CRS-2677: Stop of ‘ora.ons’ on ‘cluster04’ succeeded
CRS-2673: Attempting to stop ‘ora.net1.network’ on ‘cluster04’
CRS-2677: Stop of ‘ora.net1.network’ on ‘cluster04’ succeeded
CRS-2792: Shutdown of Cluster Ready Services-managed resources on ‘cluster04’ has completed
CRS-2677: Stop of ‘ora.crsd’ on ‘cluster04’ succeeded
CRS-2673: Attempting to stop ‘ora.crf’ on ‘cluster04’
CRS-2673: Attempting to stop ‘ora.ctssd’ on ‘cluster04’
CRS-2673: Attempting to stop ‘ora.evmd’ on ‘cluster04’
CRS-2673: Attempting to stop ‘ora.asm’ on ‘cluster04’
CRS-2673: Attempting to stop ‘ora.mdnsd’ on ‘cluster04’
CRS-2677: Stop of ‘ora.evmd’ on ‘cluster04’ succeeded
CRS-2677: Stop of ‘ora.mdnsd’ on ‘cluster04’ succeeded
CRS-2677: Stop of ‘ora.crf’ on ‘cluster04’ succeeded
CRS-2677: Stop of ‘ora.asm’ on ‘cluster04’ succeeded
CRS-2673: Attempting to stop ‘ora.cluster_interconnect.haip’ on ‘cluster04’
CRS-2677: Stop of ‘ora.cluster_interconnect.haip’ on ‘cluster04’ succeeded
CRS-2677: Stop of ‘ora.ctssd’ on ‘cluster04’ succeeded
CRS-2673: Attempting to stop ‘ora.cssd’ on ‘cluster04’
CRS-2677: Stop of ‘ora.cssd’ on ‘cluster04’ succeeded
CRS-2673: Attempting to stop ‘ora.gipcd’ on ‘cluster04’
CRS-2677: Stop of ‘ora.gipcd’ on ‘cluster04’ succeeded
CRS-2673: Attempting to stop ‘ora.gpnpd’ on ‘cluster04’
CRS-2677: Stop of ‘ora.gpnpd’ on ‘cluster04’ succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on ‘cluster04’ has completed
CRS-4133: Oracle High Availability Services has been stopped.
Successfully unlock /u01/app/grid/product/11.2.0.3/isg
patch /u01/software/patches/16495688_112034/16495688  apply successful for home  /u01/app/grid/product/11.2.0.3/isg
CRS-4123: Oracle High Availability Services has been started.

Node 2 :

grid@cluster05>sudo opatch auto /u01/software/patches/16495688_112034 -oh /u01/app/grid/product/11.2.0.3/isg -ocmrf /u01/app/grid/product/11.2.0.3/isg/OPatch/ocm/bin/ocm.rsp
Password:
Executing /u01/app/grid/product/11.2.0.3/isg/perl/bin/perl /u01/app/grid/product/11.2.0.3/isg/OPatch/crs/patch11203.pl -patchdir /u01/software/patches -patchn 16495688_112034 -oh /u01/app/grid/product/11.2.0.3/isg -ocmrf /u01/app/grid/product/11.2.0.3/isg/OPatch/ocm/bin/ocm.rsp -paramfile /u01/app/grid/product/11.2.0.3/isg/crs/install/crsconfig_params
/u01/app/grid/product/11.2.0.3/isg/crs/install/crsconfig_params
/u01/app/grid/product/11.2.0.3/isg/crs/install/s_crsconfig_defs

This is the main log file: /u01/app/grid/product/11.2.0.3/isg/cfgtoollogs/opatchauto2013-05-16_14-21-22.log
This file will show your detected configuration and all the steps that opatchauto attempted to do on your system: /u01/app/grid/product/11.2.0.3/isg/cfgtoollogs/opatchauto2013-05-16_14-21-22.report.log

2013-05-16 14:21:23: Starting Clusterware Patch Setup
Using configuration parameter file: /u01/app/grid/product/11.2.0.3/isg/crs/install/crsconfig_params
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on ‘cluster05’
CRS-2673: Attempting to stop ‘ora.crsd’ on ‘cluster05’
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on ‘cluster05’
CRS-2673: Attempting to stop ‘ora.LISTENER_SCAN3.lsnr’ on ‘cluster05’
CRS-2673: Attempting to stop ‘ora.CRSDG.dg’ on ‘cluster05’
CRS-2673: Attempting to stop ‘ora.REDO.dg’ on ‘cluster05’
CRS-2673: Attempting to stop ‘ora.test.db’ on ‘cluster05’
CRS-2673: Attempting to stop ‘ora.LISTENER_SCAN2.lsnr’ on ‘cluster05’
CRS-2673: Attempting to stop ‘ora.LISTENER.lsnr’ on ‘cluster05’
CRS-2673: Attempting to stop ‘ora.LISTENER_1535_testUAT_testTRN_LADMSUAT_LADMUAT_testDR.lsnr’ on ‘cluster05’
CRS-2677: Stop of ‘ora.LISTENER_SCAN3.lsnr’ on ‘cluster05’ succeeded
CRS-2673: Attempting to stop ‘ora.scan3.vip’ on ‘cluster05’
CRS-2677: Stop of ‘ora.LISTENER_SCAN2.lsnr’ on ‘cluster05’ succeeded
CRS-2673: Attempting to stop ‘ora.scan2.vip’ on ‘cluster05’
CRS-2677: Stop of ‘ora.LISTENER.lsnr’ on ‘cluster05’ succeeded
CRS-2677: Stop of ‘ora.scan3.vip’ on ‘cluster05’ succeeded
CRS-2672: Attempting to start ‘ora.scan3.vip’ on ‘cluster04’
CRS-2677: Stop of ‘ora.LISTENER_1535_testUAT_testTRN_LADMSUAT_LADMUAT_testDR.lsnr’ on ‘cluster05’ succeeded
CRS-2673: Attempting to stop ‘ora.cluster05.vip’ on ‘cluster05’
CRS-2677: Stop of ‘ora.scan2.vip’ on ‘cluster05’ succeeded
CRS-2672: Attempting to start ‘ora.scan2.vip’ on ‘cluster04’
CRS-2677: Stop of ‘ora.cluster05.vip’ on ‘cluster05’ succeeded
CRS-2672: Attempting to start ‘ora.cluster05.vip’ on ‘cluster04’
CRS-2677: Stop of ‘ora.REDO.dg’ on ‘cluster05’ succeeded
CRS-2677: Stop of ‘ora.test.db’ on ‘cluster05’ succeeded
CRS-2673: Attempting to stop ‘ora.TEST.dg’ on ‘cluster05’
CRS-2677: Stop of ‘ora.TEST.dg’ on ‘cluster05’ succeeded
CRS-2676: Start of ‘ora.scan3.vip’ on ‘cluster04’ succeeded
CRS-2672: Attempting to start ‘ora.LISTENER_SCAN3.lsnr’ on ‘cluster04’
CRS-2676: Start of ‘ora.scan2.vip’ on ‘cluster04’ succeeded
CRS-2672: Attempting to start ‘ora.LISTENER_SCAN2.lsnr’ on ‘cluster04’
CRS-2676: Start of ‘ora.LISTENER_SCAN3.lsnr’ on ‘cluster04’ succeeded
CRS-2676: Start of ‘ora.cluster05.vip’ on ‘cluster04’ succeeded
CRS-2676: Start of ‘ora.LISTENER_SCAN2.lsnr’ on ‘cluster04’ succeeded
CRS-2677: Stop of ‘ora.CRSDG.dg’ on ‘cluster05’ succeeded
CRS-2673: Attempting to stop ‘ora.asm’ on ‘cluster05’
CRS-2677: Stop of ‘ora.asm’ on ‘cluster05’ succeeded
CRS-2673: Attempting to stop ‘ora.ons’ on ‘cluster05’
CRS-2677: Stop of ‘ora.ons’ on ‘cluster05’ succeeded
CRS-2673: Attempting to stop ‘ora.net1.network’ on ‘cluster05’
CRS-2677: Stop of ‘ora.net1.network’ on ‘cluster05’ succeeded
CRS-2792: Shutdown of Cluster Ready Services-managed resources on ‘cluster05’ has completed
CRS-2677: Stop of ‘ora.crsd’ on ‘cluster05’ succeeded
CRS-2673: Attempting to stop ‘ora.crf’ on ‘cluster05’
CRS-2673: Attempting to stop ‘ora.ctssd’ on ‘cluster05’
CRS-2673: Attempting to stop ‘ora.evmd’ on ‘cluster05’
CRS-2673: Attempting to stop ‘ora.asm’ on ‘cluster05’
CRS-2673: Attempting to stop ‘ora.mdnsd’ on ‘cluster05’
CRS-2677: Stop of ‘ora.mdnsd’ on ‘cluster05’ succeeded
CRS-2677: Stop of ‘ora.crf’ on ‘cluster05’ succeeded
CRS-2677: Stop of ‘ora.evmd’ on ‘cluster05’ succeeded
CRS-2677: Stop of ‘ora.asm’ on ‘cluster05’ succeeded
CRS-2673: Attempting to stop ‘ora.cluster_interconnect.haip’ on ‘cluster05’
CRS-2677: Stop of ‘ora.ctssd’ on ‘cluster05’ succeeded
CRS-2677: Stop of ‘ora.cluster_interconnect.haip’ on ‘cluster05’ succeeded
CRS-2673: Attempting to stop ‘ora.cssd’ on ‘cluster05’
CRS-2677: Stop of ‘ora.cssd’ on ‘cluster05’ succeeded
CRS-2673: Attempting to stop ‘ora.gipcd’ on ‘cluster05’
CRS-2677: Stop of ‘ora.gipcd’ on ‘cluster05’ succeeded
CRS-2673: Attempting to stop ‘ora.gpnpd’ on ‘cluster05’
CRS-2677: Stop of ‘ora.gpnpd’ on ‘cluster05’ succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on ‘cluster05’ has completed
CRS-4133: Oracle High Availability Services has been stopped.
Successfully unlock /u01/app/grid/product/11.2.0.3/isg
patch /u01/software/patches/16495688_112034/16495688  apply successful for home  /u01/app/grid/product/11.2.0.3/isg
CRS-4123: Oracle High Availability Services has been started.

Advertisement