Thinking Out Loud

April 30, 2013

OCM Installation Response Generator

Filed under: 11g,oracle — mdinh @ 5:07 am

Do you get annoyed at having to answer the questions all the time for patching?

Provide your email address to be informed of security issues, install and
initiate Oracle Configuration Manager. Easier for you if you use your My
Oracle Support Email address/User Name.
Visit http://www.oracle.com/support/policies.html for details.
Email address/User Name:

You have not provided an email address for notification of security issues.
Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]:  Y

You won’t have to answer those questions anymore if you create OCM response file.

$ /u01/app/oracle/product/11.2.0.3/db_1/OPatch/ocm/bin/emocmrsp

OCM Installation Response Generator 10.3.4.0.0 - Production
Copyright (c) 2005, 2010, Oracle and/or its affiliates.  All rights reserved.

Provide your email address to be informed of security issues, install and
initiate Oracle Configuration Manager. Easier for you if you use your My
Oracle Support Email address/User Name.
Visit http://www.oracle.com/support/policies.html for details.
Email address/User Name:

You have not provided an email address for notification of security issues.
Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]:  Y
The OCM configuration response file (ocm.rsp) was successfully created.

Response file – ocm.rsp is create at the current directory.
$ ll ocm.rsp

-rw-r--r-- 1 oracle oinstall 623 Apr 29 21:37 ocm.rsp

Here comes the patching part and don’t ask me again

$ /u01/app/oracle/product/11.2.0.3/db_1/OPatch/opatch apply -ocmrf /home/oracle/ocm.rsp

Oracle Interim Patch Installer version 11.2.0.3.4
Copyright (c) 2012, Oracle Corporation.  All rights reserved.

Oracle Home       : /u01/app/oracle/product/11.2.0.3/db_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/11.2.0.3/db_1/oraInst.loc
OPatch version    : 11.2.0.3.4
OUI version       : 11.2.0.3.0
Log file location : /u01/app/oracle/product/11.2.0.3/db_1/cfgtoollogs/opatch/opatch2013-04-29_20-38-04PM_1.log

Verifying environment and performing prerequisite checks...
OPatch continues with these patches:   13343438  13696216  13923374  14275605  14727310  16056266

Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u01/app/oracle/product/11.2.0.3/db_1')

Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying sub-patch '13343438' to OH '/u01/app/oracle/product/11.2.0.3/db_1'

Patching component oracle.rdbms.rsf, 11.2.0.3.0...

Patching component oracle.rdbms, 11.2.0.3.0...

Patching component oracle.rdbms.dbscripts, 11.2.0.3.0...

Verifying the update...
Applying sub-patch '13696216' to OH '/u01/app/oracle/product/11.2.0.3/db_1'

Patching component oracle.rdbms.rsf, 11.2.0.3.0...

Patching component oracle.rdbms, 11.2.0.3.0...

Patching component oracle.sdo.locator, 11.2.0.3.0...

Patching component oracle.sysman.console.db, 11.2.0.3.0...

Patching component oracle.sysman.oms.core, 10.2.0.4.4...

Verifying the update...
Applying sub-patch '13923374' to OH '/u01/app/oracle/product/11.2.0.3/db_1'
ApplySession: Optional component(s) [ oracle.network.cman, 11.2.0.3.0 ]  not present in the Oracle Home or a higher version is found.

Patching component oracle.rdbms.rsf, 11.2.0.3.0...

Patching component oracle.rdbms, 11.2.0.3.0...

Patching component oracle.rdbms.dbscripts, 11.2.0.3.0...

Patching component oracle.network.rsf, 11.2.0.3.0...

Patching component oracle.network.listener, 11.2.0.3.0...

Patching component oracle.sysman.console.db, 11.2.0.3.0...

Verifying the update...
Applying sub-patch '14275605' to OH '/u01/app/oracle/product/11.2.0.3/db_1'
ApplySession: Optional component(s) [ oracle.precomp.lang, 11.2.0.3.0 ]  not present in the Oracle Home or a higher version is found.

Patching component oracle.network.client, 11.2.0.3.0...

Patching component oracle.network.rsf, 11.2.0.3.0...

Patching component oracle.precomp.common, 11.2.0.3.0...

Patching component oracle.rdbms, 11.2.0.3.0...

Patching component oracle.rdbms.dbscripts, 11.2.0.3.0...

Patching component oracle.rdbms.rman, 11.2.0.3.0...

Patching component oracle.rdbms.rsf, 11.2.0.3.0...

Patching component oracle.rdbms.util, 11.2.0.3.0...

Verifying the update...
Applying sub-patch '14727310' to OH '/u01/app/oracle/product/11.2.0.3/db_1'

Patching component oracle.rdbms, 11.2.0.3.0...

Patching component oracle.rdbms.dbscripts, 11.2.0.3.0...

Patching component oracle.rdbms.rsf, 11.2.0.3.0...

Patching component oracle.sdo.locator, 11.2.0.3.0...

Patching component oracle.sysman.console.db, 11.2.0.3.0...

Patching component oracle.sysman.oms.core, 10.2.0.4.4...

Verifying the update...
Applying sub-patch '16056266' to OH '/u01/app/oracle/product/11.2.0.3/db_1'
ApplySession: Optional component(s) [ oracle.network.cman, 11.2.0.3.0 ]  not present in the Oracle Home or a higher version is found.

Patching component oracle.network.listener, 11.2.0.3.0...

Patching component oracle.network.rsf, 11.2.0.3.0...

Patching component oracle.ovm, 11.2.0.3.0...

Patching component oracle.rdbms, 11.2.0.3.0...

Patching component oracle.rdbms.rman, 11.2.0.3.0...

Patching component oracle.rdbms.rsf, 11.2.0.3.0...

Patching component oracle.sdo.locator, 11.2.0.3.0...

Patching component oracle.rdbms.deconfig, 11.2.0.3.0...

Verifying the update...

OPatch found the word "warning" in the stderr of the make command.
Please look at this stderr. You can re-run this make command.
Stderr output:
ins_precomp.mk:19: warning: overriding commands for target `pcscfg.cfg'
/u01/app/oracle/product/11.2.0.3/db_1/precomp/lib/env_precomp.mk:2160: warning: ignoring old commands for target `pcscfg.cfg'
/u01/app/oracle/product/11.2.0.3/db_1/precomp/lib/ins_precomp.mk:19: warning: overriding commands for target `pcscfg.cfg'
/u01/app/oracle/product/11.2.0.3/db_1/precomp/lib/env_precomp.mk:2160: warning: ignoring old commands for target `pcscfg.cfg'

Composite patch 16056266 successfully applied.
OPatch Session completed with warnings.
Log file location: /u01/app/oracle/product/11.2.0.3/db_1/cfgtoollogs/opatch/opatch2013-04-29_20-38-04PM_1.log

OPatch completed with warnings.

EXTRA, EXTRA:

Scripts to download patch.
PLEASE NOTE the difference in naming conventions between version patch and OPatch.
$ cat getpatch.sh

#!/bin/sh

DN=`dirname $0`
BN=`basename $0`
FN=${1:?"---> USAGE: $DN/$BN "}
wget --http-user=fakeuser@mail.com --http-password=fakepassword --no-check-certificate --output-document=p${1}_112030_Linux-x86-64.zip "https://updates.oracle.com/Orion/Download/download_patch/p${1}_112030_Linux-x86-64.zip"
exit

$ cat getopatch.sh

#!/bin/sh
wget --http-user=fakeuser@mail.com --http-password=fakepassword --no-check-certificate --output-document=p6880880_112000_Linux-x86-64.zip "https://updates.oracle.com/Orion/Download/download_patch/p6880880_112000_Linux-x86-64.zip"
exit

Download patch
$ ./getpatch.sh

./getpatch.sh: line 5: 1: ---> USAGE: ./getpatch.sh <patch number>

$ ll *16056266*

ls: cannot access *16056266*: No such file or directory

$ ./getpatch.sh 16056266

--2013-04-29 21:00:06--  https://updates.oracle.com/Orion/Download/download_patch/p16056266_112030_Linux-x86-64.zip
Resolving updates.oracle.com... 141.146.44.51
Connecting to updates.oracle.com|141.146.44.51|:443... connected.
HTTP request sent, awaiting response... 301 Moved Permanently
Location: https://login.oracle.com/pls/orasso/orasso.wwsso_app_admin.ls_login?site2pstoretoken=v1.2~E4066BF0~987B78EA259CB31D8BBC6647FDEE2DC7510D66F0A54FD6E7394DC81087F3535168022325FA0D7143E72537529DC60E9E1491A6E7EA2414B38EF6E710353365E803F669AF7F790254A8AFD47D776A218FA4B7F252BC2942C0B1BF65DFBC6296EDB7CBF365277E3646943194E1D6B74105B6A9E9F2EBECC1C0FD25943B4234AA240801C9EB0A2C859B6BB45222645B4092019E17801422ABDF91DECF57F2FBC6D26B0F60842FD49019330A27A629E9C82000BE9AB648FA8B3C70FCA74F1ECB7D29001B87A6622CE81E299C088EFE9AAE87BA92854AA220ED81 [following]
--2013-04-29 21:00:19--  https://login.oracle.com/pls/orasso/orasso.wwsso_app_admin.ls_login?site2pstoretoken=v1.2~E4066BF0~987B78EA259CB31D8BBC6647FDEE2DC7510D66F0A54FD6E7394DC81087F3535168022325FA0D7143E72537529DC60E9E1491A6E7EA2414B38EF6E710353365E803F669AF7F790254A8AFD47D776A218FA4B7F252BC2942C0B1BF65DFBC6296EDB7CBF365277E3646943194E1D6B74105B6A9E9F2EBECC1C0FD25943B4234AA240801C9EB0A2C859B6BB45222645B4092019E17801422ABDF91DECF57F2FBC6D26B0F60842FD49019330A27A629E9C82000BE9AB648FA8B3C70FCA74F1ECB7D29001B87A6622CE81E299C088EFE9AAE87BA92854AA220ED81
Resolving login.oracle.com... 141.146.8.119
Connecting to login.oracle.com|141.146.8.119|:443... connected.
HTTP request sent, awaiting response... 401 Unauthorized
Reusing existing connection to login.oracle.com:443.
HTTP request sent, awaiting response... 302 Moved Temporarily
Location: https://updates.oracle.com/osso_login_success?urlc=v1.2%7EA4976F93813F9B35D4A1906FC5551FCF60299648E704348146F3111CE746E2C649E4BF1726C0D94107745E2307F14284E943B765C55859B993213F7FE963869554CB565F1B265C9D5391ADF4D908CD97BC62C96BA4925D889B40C7B51E52A215B44CC70ECEF5E544FF284736BFE50544D25D557DFDDEBAA0F6888A6EC22D0CC7ACB761FE37A0BD3D2B74629E91E2AAB1BAC09AA65DFCF41C5266242F8F89577DFD62055BCA94ACD87E4637489000C9951E18C55EF90C9E37C8D11E536612A9C30715A3D1302531E9A385DB4407CD9A6903BF55E738BCA312D28ED8ECE2784D67DBDE1F25B787FB1998C5B4E10F7BC463A5DF512BD88B5DD67744C479F88AE2A33DCE6745FB9736FDC396D72A6B93F9A90450CA1AE9BBB3B3DAF2DADA8F1194B4BC1B10E5DE070B79EFBC1EE4321D0D66DC9C59152257DB3EFC0899CC57C4A4E9D84BCB7A6518BA3044C5C86622DEAC2CF9135C635D0CA68A [following]
--2013-04-29 21:00:38--  https://updates.oracle.com/osso_login_success?urlc=v1.2%7EA4976F93813F9B35D4A1906FC5551FCF60299648E704348146F3111CE746E2C649E4BF1726C0D94107745E2307F14284E943B765C55859B993213F7FE963869554CB565F1B265C9D5391ADF4D908CD97BC62C96BA4925D889B40C7B51E52A215B44CC70ECEF5E544FF284736BFE50544D25D557DFDDEBAA0F6888A6EC22D0CC7ACB761FE37A0BD3D2B74629E91E2AAB1BAC09AA65DFCF41C5266242F8F89577DFD62055BCA94ACD87E4637489000C9951E18C55EF90C9E37C8D11E536612A9C30715A3D1302531E9A385DB4407CD9A6903BF55E738BCA312D28ED8ECE2784D67DBDE1F25B787FB1998C5B4E10F7BC463A5DF512BD88B5DD67744C479F88AE2A33DCE6745FB9736FDC396D72A6B93F9A90450CA1AE9BBB3B3DAF2DADA8F1194B4BC1B10E5DE070B79EFBC1EE4321D0D66DC9C59152257DB3EFC0899CC57C4A4E9D84BCB7A6518BA3044C5C86622DEAC2CF9135C635D0CA68A
Connecting to updates.oracle.com|141.146.44.51|:443... connected.
HTTP request sent, awaiting response... 301 Moved Permanently
Location: https://updates.oracle.com/Orion/Download/download_patch/p16056266_112030_Linux-x86-64.zip [following]
--2013-04-29 21:00:39--  https://updates.oracle.com/Orion/Download/download_patch/p16056266_112030_Linux-x86-64.zip
Connecting to updates.oracle.com|141.146.44.51|:443... connected.
HTTP request sent, awaiting response... 302 Found
Location: http://aru-akam.oracle.com/adcarurepos/vol/patch40/PLATFORM/CORE/Linux-x86-64/R80112030/p16056266_112030_Linux-x86-64.zip?AuthParam=1367294568_5a3356da38d8dd77c27d9ef722be6b7a&FilePath=/adcarurepos/vol/patch40/PLATFORM/CORE/Linux-x86-64/R80112030/p16056266_112030_Linux-x86-64.zip&File=p16056266_112030_Linux-x86-64.zip&params=RU5zK21lVUxPZnJZam1vZTMxYjZjQTphcnU9MTU5NjI4MDMmZW1haWw9ZGluaEBweXRoaWFuLmNvbSZmaWxlX2lkPTU4Mzg5MzI4JnBhdGNoX2ZpbGU9cDE2MDU2MjY2XzExMjAzMF9MaW51eC14ODYtNjQuemlwJnVzZXJpZD1vLWRpbmhAcHl0aGlhbi5jb20mc2l6ZT0zMjE1MjY3MiZjb250ZXh0PUFAMTArSEBhYXJ1dm10cDAxLm9yYWNsZS5jb20rUEAmZG93bmxvYWRfaWQ9NzM3MTg5OTI@ [following]
--2013-04-29 21:00:48--  http://aru-akam.oracle.com/adcarurepos/vol/patch40/PLATFORM/CORE/Linux-x86-64/R80112030/p16056266_112030_Linux-x86-64.zip?AuthParam=1367294568_5a3356da38d8dd77c27d9ef722be6b7a&FilePath=/adcarurepos/vol/patch40/PLATFORM/CORE/Linux-x86-64/R80112030/p16056266_112030_Linux-x86-64.zip&File=p16056266_112030_Linux-x86-64.zip&params=RU5zK21lVUxPZnJZam1vZTMxYjZjQTphcnU9MTU5NjI4MDMmZW1haWw9ZGluaEBweXRoaWFuLmNvbSZmaWxlX2lkPTU4Mzg5MzI4JnBhdGNoX2ZpbGU9cDE2MDU2MjY2XzExMjAzMF9MaW51eC14ODYtNjQuemlwJnVzZXJpZD1vLWRpbmhAcHl0aGlhbi5jb20mc2l6ZT0zMjE1MjY3MiZjb250ZXh0PUFAMTArSEBhYXJ1dm10cDAxLm9yYWNsZS5jb20rUEAmZG93bmxvYWRfaWQ9NzM3MTg5OTI@
Resolving aru-akam.oracle.com... 69.31.119.160, 69.31.119.187
Connecting to aru-akam.oracle.com|69.31.119.160|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 32152672 (31M) [application/zip]
Saving to: âp16056266_112030_Linux-x86-64.zipâ

100%[==>] 32,152,672  1.32M/s   in 24s

2013-04-29 21:01:13 (1.29 MB/s) - âp16056266_112030_Linux-x86-64.zipâ

$ ll *16056266*

-rw-r--r-- 1 oracle oinstall 32152672 Apr 14 23:55 p16056266_112030_Linux-x86-64.zip

April 27, 2013

CRS and Cluster

Filed under: 11g,RAC — mdinh @ 5:55 pm

CRS and Cluster, what’s the difference and which one should I use for start and stop?

CRS is Cluster Ready Service and used to manage HAS (High Availability Services)

Cluster is where the application runs on.

Stop CRS is local to the node and will shutdown local HAS – crsctl stop crs
Stop cluster will shutdown across all nodes and will NOT shutdown HAS – crsctl stop cluster -all

Here’s the catch.
Start cluster will NOT start the node without HAS running – crsctl start cluster -all
The node must be started manually – crsctl start crs

 

DEMO:

[root@rac01 ~]# /u01/app/11.2.0.3/grid/bin/crsctl status server

NAME=rac01
STATE=ONLINE

NAME=rac02
STATE=ONLINE

NAME=rac03
STATE=ONLINE

[root@rac01 ~]# /u01/app/11.2.0.3/grid/bin/crsctl stop crs

CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'rac01'
CRS-2673: Attempting to stop 'ora.crsd' on 'rac01'
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'rac01'
CRS-2673: Attempting to stop 'ora.DATA.dg' on 'rac01'
CRS-2673: Attempting to stop 'ora.LISTENER_SCAN2.lsnr' on 'rac01'
CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'rac01'
CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'rac01' succeeded
CRS-2673: Attempting to stop 'ora.rac01.vip' on 'rac01'
CRS-2677: Stop of 'ora.LISTENER_SCAN2.lsnr' on 'rac01' succeeded
CRS-2673: Attempting to stop 'ora.scan2.vip' on 'rac01'
CRS-2677: Stop of 'ora.scan2.vip' on 'rac01' succeeded
CRS-2672: Attempting to start 'ora.scan2.vip' on 'rac02'
CRS-2677: Stop of 'ora.rac01.vip' on 'rac01' succeeded
CRS-2672: Attempting to start 'ora.rac01.vip' on 'rac03'
CRS-2676: Start of 'ora.rac01.vip' on 'rac03' succeeded
CRS-2676: Start of 'ora.scan2.vip' on 'rac02' succeeded
CRS-2672: Attempting to start 'ora.LISTENER_SCAN2.lsnr' on 'rac02'
CRS-2676: Start of 'ora.LISTENER_SCAN2.lsnr' on 'rac02' succeeded
CRS-2677: Stop of 'ora.DATA.dg' on 'rac01' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'rac01'
CRS-2677: Stop of 'ora.asm' on 'rac01' succeeded
CRS-2673: Attempting to stop 'ora.ons' on 'rac01'
CRS-2677: Stop of 'ora.ons' on 'rac01' succeeded
CRS-2673: Attempting to stop 'ora.net1.network' on 'rac01'
CRS-2677: Stop of 'ora.net1.network' on 'rac01' succeeded
CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'rac01' has completed
CRS-2677: Stop of 'ora.crsd' on 'rac01' succeeded
CRS-2673: Attempting to stop 'ora.mdnsd' on 'rac01'
CRS-2673: Attempting to stop 'ora.ctssd' on 'rac01'
CRS-2673: Attempting to stop 'ora.evmd' on 'rac01'
CRS-2673: Attempting to stop 'ora.asm' on 'rac01'
CRS-2677: Stop of 'ora.evmd' on 'rac01' succeeded
CRS-2677: Stop of 'ora.mdnsd' on 'rac01' succeeded
CRS-2677: Stop of 'ora.asm' on 'rac01' succeeded
CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'rac01'
CRS-2677: Stop of 'ora.ctssd' on 'rac01' succeeded
CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'rac01' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'rac01'
CRS-2677: Stop of 'ora.cssd' on 'rac01' succeeded
CRS-2673: Attempting to stop 'ora.crf' on 'rac01'
CRS-2677: Stop of 'ora.crf' on 'rac01' succeeded
CRS-2673: Attempting to stop 'ora.gipcd' on 'rac01'
CRS-2677: Stop of 'ora.gipcd' on 'rac01' succeeded
CRS-2673: Attempting to stop 'ora.gpnpd' on 'rac01'
CRS-2677: Stop of 'ora.gpnpd' on 'rac01' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'rac01' has completed
CRS-4133: Oracle High Availability Services has been stopped.

[root@rac01 ~]# /u01/app/11.2.0.3/grid/bin/crsctl status server

CRS-4535: Cannot communicate with Cluster Ready Services
CRS-4000: Command Status failed, or completed with errors.

[root@rac01 ~]# /u01/app/11.2.0.3/grid/bin/crsctl check cluster -all

CRS-4639: Could not contact Oracle High Availability Services
CRS-4000: Command Check failed, or completed with errors.

[root@rac01 ~]# ssh rac02 /u01/app/11.2.0.3/grid/bin/crsctl status server

NAME=rac02
STATE=ONLINE

NAME=rac03
STATE=ONLINE

[root@rac01 ~]# ssh rac02 /u01/app/11.2.0.3/grid/bin/crsctl check cluster -all

**************************************************************
rac02:
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
**************************************************************
rac03:
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
**************************************************************

[root@rac01 ~]# ps -ef|grep grid

root     10899 10603  0 10:24 pts/1    00:00:00 grep grid

[root@rac02 ~]# /u01/app/11.2.0.3/grid/bin/crsctl stop cluster -all

CRS-2673: Attempting to stop 'ora.crsd' on 'rac02'
CRS-2673: Attempting to stop 'ora.crsd' on 'rac03'
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'rac02'
CRS-2673: Attempting to stop 'ora.oc4j' on 'rac02'
CRS-2673: Attempting to stop 'ora.cvu' on 'rac02'
CRS-2673: Attempting to stop 'ora.LISTENER_SCAN2.lsnr' on 'rac02'
CRS-2673: Attempting to stop 'ora.LISTENER_SCAN3.lsnr' on 'rac02'
CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'rac02'
CRS-2673: Attempting to stop 'ora.DATA.dg' on 'rac02'
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'rac03'
CRS-2673: Attempting to stop 'ora.LISTENER_SCAN1.lsnr' on 'rac03'
CRS-2673: Attempting to stop 'ora.rac03.vip' on 'rac03'
CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'rac03'
CRS-2673: Attempting to stop 'ora.DATA.dg' on 'rac03'
CRS-2677: Stop of 'ora.rac03.vip' on 'rac03' succeeded
CRS-2677: Stop of 'ora.LISTENER_SCAN2.lsnr' on 'rac02' succeeded
CRS-2673: Attempting to stop 'ora.scan2.vip' on 'rac02'
CRS-2677: Stop of 'ora.LISTENER_SCAN3.lsnr' on 'rac02' succeeded
CRS-2673: Attempting to stop 'ora.scan3.vip' on 'rac02'
CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'rac02' succeeded
CRS-2673: Attempting to stop 'ora.rac02.vip' on 'rac02'
CRS-2677: Stop of 'ora.scan2.vip' on 'rac02' succeeded
CRS-2677: Stop of 'ora.rac02.vip' on 'rac02' succeeded
CRS-2677: Stop of 'ora.LISTENER_SCAN1.lsnr' on 'rac03' succeeded
CRS-2673: Attempting to stop 'ora.scan1.vip' on 'rac03'
CRS-2677: Stop of 'ora.scan3.vip' on 'rac02' succeeded
CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'rac03' succeeded
CRS-2673: Attempting to stop 'ora.rac01.vip' on 'rac03'
CRS-2677: Stop of 'ora.scan1.vip' on 'rac03' succeeded
CRS-2677: Stop of 'ora.rac01.vip' on 'rac03' succeeded
CRS-2677: Stop of 'ora.oc4j' on 'rac02' succeeded
CRS-2677: Stop of 'ora.cvu' on 'rac02' succeeded
CRS-2677: Stop of 'ora.DATA.dg' on 'rac02' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'rac02'
CRS-2677: Stop of 'ora.DATA.dg' on 'rac03' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'rac03'
CRS-2677: Stop of 'ora.asm' on 'rac03' succeeded
CRS-2677: Stop of 'ora.asm' on 'rac02' succeeded
CRS-2673: Attempting to stop 'ora.ons' on 'rac03'
CRS-2677: Stop of 'ora.ons' on 'rac03' succeeded
CRS-2673: Attempting to stop 'ora.net1.network' on 'rac03'
CRS-2677: Stop of 'ora.net1.network' on 'rac03' succeeded
CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'rac03' has completed
CRS-2673: Attempting to stop 'ora.ons' on 'rac02'
CRS-2677: Stop of 'ora.ons' on 'rac02' succeeded
CRS-2673: Attempting to stop 'ora.net1.network' on 'rac02'
CRS-2677: Stop of 'ora.net1.network' on 'rac02' succeeded
CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'rac02' has completed
CRS-2677: Stop of 'ora.crsd' on 'rac03' succeeded
CRS-2673: Attempting to stop 'ora.ctssd' on 'rac03'
CRS-2673: Attempting to stop 'ora.evmd' on 'rac03'
CRS-2673: Attempting to stop 'ora.asm' on 'rac03'
CRS-2677: Stop of 'ora.crsd' on 'rac02' succeeded
CRS-2673: Attempting to stop 'ora.ctssd' on 'rac02'
CRS-2673: Attempting to stop 'ora.evmd' on 'rac02'
CRS-2673: Attempting to stop 'ora.asm' on 'rac02'
CRS-2677: Stop of 'ora.evmd' on 'rac03' succeeded
CRS-2677: Stop of 'ora.evmd' on 'rac02' succeeded
CRS-2677: Stop of 'ora.ctssd' on 'rac03' succeeded
CRS-2677: Stop of 'ora.ctssd' on 'rac02' succeeded
CRS-2677: Stop of 'ora.asm' on 'rac03' succeeded
CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'rac03'
CRS-2677: Stop of 'ora.asm' on 'rac02' succeeded
CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'rac02'
CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'rac02' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'rac02'
CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'rac03' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'rac03'
CRS-2677: Stop of 'ora.cssd' on 'rac02' succeeded
CRS-2677: Stop of 'ora.cssd' on 'rac03' succeeded

[root@rac02 ~]# ps -ef|grep grid

root      2253     1  1 09:02 ?        00:01:02 /u01/app/11.2.0.3/grid/bin/ohasd.bin reboot
grid      2491     1  0 09:02 ?        00:00:24 /u01/app/11.2.0.3/grid/bin/oraagent.bin
grid      2503     1  0 09:02 ?        00:00:00 /u01/app/11.2.0.3/grid/bin/mdnsd.bin
grid      2513     1  0 09:02 ?        00:00:03 /u01/app/11.2.0.3/grid/bin/gpnpd.bin
grid      2524     1  0 09:02 ?        00:00:18 /u01/app/11.2.0.3/grid/bin/gipcd.bin
root      2537     1  0 09:02 ?        00:00:28 /u01/app/11.2.0.3/grid/bin/orarootagent.bin
root      2549     1  1 09:02 ?        00:01:19 /u01/app/11.2.0.3/grid/bin/osysmond.bin
root      3367     1  1 09:04 ?        00:00:54 /u01/app/11.2.0.3/grid/bin/ologgerd -M -d /u01/app/11.2.0.3/grid/crf/db/rac02
root      8324  8022  0 10:28 pts/0    00:00:00 grep grid

[root@rac02 ~]# /u01/app/11.2.0.3/grid/bin/crsctl status server

CRS-4535: Cannot communicate with Cluster Ready Services
CRS-4000: Command Status failed, or completed with errors.

[root@rac02 ~]# /u01/app/11.2.0.3/grid/bin/crsctl check crs

CRS-4638: Oracle High Availability Services is online
CRS-4535: Cannot communicate with Cluster Ready Services
CRS-4530: Communications failure contacting Cluster Synchronization Services daemon
CRS-4534: Cannot communicate with Event Manager

[root@rac02 ~]# /u01/app/11.2.0.3/grid/bin/crsctl start cluster -all

CRS-2672: Attempting to start 'ora.cssdmonitor' on 'rac02'
CRS-2672: Attempting to start 'ora.cssdmonitor' on 'rac03'
CRS-2676: Start of 'ora.cssdmonitor' on 'rac02' succeeded
CRS-2672: Attempting to start 'ora.cssd' on 'rac02'
CRS-2672: Attempting to start 'ora.diskmon' on 'rac02'
CRS-2676: Start of 'ora.cssdmonitor' on 'rac03' succeeded
CRS-2672: Attempting to start 'ora.cssd' on 'rac03'
CRS-2672: Attempting to start 'ora.diskmon' on 'rac03'
CRS-2676: Start of 'ora.diskmon' on 'rac02' succeeded
CRS-2676: Start of 'ora.diskmon' on 'rac03' succeeded
CRS-2676: Start of 'ora.cssd' on 'rac02' succeeded
CRS-2672: Attempting to start 'ora.ctssd' on 'rac02'
CRS-2676: Start of 'ora.cssd' on 'rac03' succeeded
CRS-2672: Attempting to start 'ora.ctssd' on 'rac03'
CRS-2676: Start of 'ora.ctssd' on 'rac02' succeeded
CRS-2672: Attempting to start 'ora.evmd' on 'rac02'
CRS-2676: Start of 'ora.ctssd' on 'rac03' succeeded
CRS-2672: Attempting to start 'ora.evmd' on 'rac03'
CRS-2672: Attempting to start 'ora.cluster_interconnect.haip' on 'rac02'
CRS-2672: Attempting to start 'ora.cluster_interconnect.haip' on 'rac03'
CRS-2676: Start of 'ora.evmd' on 'rac02' succeeded
CRS-2676: Start of 'ora.evmd' on 'rac03' succeeded
CRS-2676: Start of 'ora.cluster_interconnect.haip' on 'rac02' succeeded
CRS-2672: Attempting to start 'ora.asm' on 'rac02'
CRS-2676: Start of 'ora.cluster_interconnect.haip' on 'rac03' succeeded
CRS-2672: Attempting to start 'ora.asm' on 'rac03'
CRS-2676: Start of 'ora.asm' on 'rac02' succeeded
CRS-2672: Attempting to start 'ora.crsd' on 'rac02'
CRS-2676: Start of 'ora.asm' on 'rac03' succeeded
CRS-2672: Attempting to start 'ora.crsd' on 'rac03'
CRS-2676: Start of 'ora.crsd' on 'rac02' succeeded
CRS-2676: Start of 'ora.crsd' on 'rac03' succeeded

[root@rac02 ~]# /u01/app/11.2.0.3/grid/bin/crsctl check cluster -all

**************************************************************
rac02:
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
**************************************************************
rac03:
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
**************************************************************

[root@rac02 ~]# /u01/app/11.2.0.3/grid/bin/crsctl status server

NAME=rac02
STATE=ONLINE

NAME=rac03
STATE=ONLINE

[root@rac01 ~]# ps -ef|grep grid

root     11599  2537  0 10:46 pts/0    00:00:00 grep grid
[root@rac01 ~]# ssh rac02 /u01/app/11.2.0.3/grid/bin/crsctl status server
NAME=rac02
STATE=ONLINE

NAME=rac03
STATE=ONLINE

[root@rac01 ~]# /u01/app/11.2.0.3/grid/bin/crsctl start crs

CRS-4123: Oracle High Availability Services has been started.
[root@rac01 ~]# /u01/app/11.2.0.3/grid/bin/crsctl status server
CRS-4535: Cannot communicate with Cluster Ready Services
CRS-4000: Command Status failed, or completed with errors.

[root@rac01 ~]# /u01/app/11.2.0.3/grid/bin/crsctl status server

CRS-4535: Cannot communicate with Cluster Ready Services
CRS-4000: Command Status failed, or completed with errors.

[root@rac01 ~]# /u01/app/11.2.0.3/grid/bin/crsctl start cluster

CRS-4691: Oracle Clusterware is already running
CRS-4000: Command Start failed, or completed with errors.

[root@rac01 ~]# /u01/app/11.2.0.3/grid/bin/crsctl check cluster -all

**************************************************************
rac01:
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
**************************************************************
rac02:
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
**************************************************************
rac03:
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
**************************************************************

[root@rac01 ~]# /u01/app/11.2.0.3/grid/bin/crsctl status server

NAME=rac01
STATE=ONLINE

NAME=rac02
STATE=ONLINE

NAME=rac03
STATE=ONLINE

Now, stop and start is making me tired. Now I get to spend – go shopping.

April 21, 2013

New Features – Pages

Filed under: Uncategorized — mdinh @ 3:07 pm

Please take a look at Menu (all the way to the right) and you will find:

Linux
Patches and Upgrades

Information is good, but how fast can you find it?

Changed from Pages to Menu.

Disk Performance Benchmark

Filed under: 11g — mdinh @ 3:53 am

Where should I put my ASM disks?

-----------------------------------------------------------------------
CrystalDiskMark 3.0.2 x64 (C) 2007-2013 hiyohiyo
                           Crystal Dew World : http://crystalmark.info/
-----------------------------------------------------------------------
* MB/s = 1,000,000 byte/s [SATA/300 = 300,000,000 byte/s]

           Sequential Read :   194.352 MB/s
          Sequential Write :   194.577 MB/s
         Random Read 512KB :    72.506 MB/s
        Random Write 512KB :   123.474 MB/s
    Random Read 4KB (QD=1) :     0.938 MB/s [   229.0 IOPS]
   Random Write 4KB (QD=1) :     2.777 MB/s [   678.0 IOPS]
   Random Read 4KB (QD=32) :     2.689 MB/s [   656.5 IOPS]
  Random Write 4KB (QD=32) :     2.917 MB/s [   712.0 IOPS]

  Test : 4000 MB [E: 11.0% (51.4/465.8 GB)] (x5)
  Date : 2013/04/20 19:24:20
    OS : Windows 7 Ultimate Edition SP1 [6.1 Build 7601] (x64)
    WD VelociRaptor 10K RPM 500GB
	
-----------------------------------------------------------------------
CrystalDiskMark 3.0.2 x64 (C) 2007-2013 hiyohiyo
                           Crystal Dew World : http://crystalmark.info/
-----------------------------------------------------------------------
* MB/s = 1,000,000 byte/s [SATA/300 = 300,000,000 byte/s]

           Sequential Read :   320.813 MB/s
          Sequential Write :   325.493 MB/s
         Random Read 512KB :    48.393 MB/s
        Random Write 512KB :    70.716 MB/s
    Random Read 4KB (QD=1) :     0.543 MB/s [   132.6 IOPS]
   Random Write 4KB (QD=1) :     3.107 MB/s [   758.7 IOPS]
   Random Read 4KB (QD=32) :     2.531 MB/s [   618.0 IOPS]
  Random Write 4KB (QD=32) :     3.125 MB/s [   762.9 IOPS]

  Test : 4000 MB [D: 7.1% (47.8/675.5 GB)] (x5)
  Date : 2013/04/20 19:36:23
    OS : Windows 7 Ultimate Edition SP1 [6.1 Build 7601] (x64)
  	WD Black 7200K RPM 500GB Intel RST RAID0 500GB
	
-----------------------------------------------------------------------
CrystalDiskMark 3.0.2 x64 (C) 2007-2013 hiyohiyo
                           Crystal Dew World : http://crystalmark.info/
-----------------------------------------------------------------------
* MB/s = 1,000,000 byte/s [SATA/300 = 300,000,000 byte/s]

           Sequential Read :   133.935 MB/s
          Sequential Write :   112.881 MB/s
         Random Read 512KB :    34.773 MB/s
        Random Write 512KB :    31.217 MB/s
    Random Read 4KB (QD=1) :     0.461 MB/s [   112.5 IOPS]
   Random Write 4KB (QD=1) :     1.329 MB/s [   324.5 IOPS]
   Random Read 4KB (QD=32) :     2.113 MB/s [   516.0 IOPS]
  Random Write 4KB (QD=32) :     1.353 MB/s [   330.3 IOPS]

  Test : 4000 MB [C: 27.3% (34.9/127.9 GB)] (x5)
  Date : 2013/04/20 19:55:37
    OS : Windows 7 Ultimate Edition SP1 [6.1 Build 7601] (x64)
  	WD Black 7200K RPM 500GB Intel RST RAID1 5OOGB

April 19, 2013

DNS for RAC on VirtualBox

Filed under: 11g,linux,RAC — mdinh @ 4:44 am

Just completed RAC training and wanted to put into practice.

SCAN IPs MUST NOT be in the /etc/hosts file because it will result in only 1 SCAN IP for the entire cluster.

I started looking for simple DNS server to be used with RAC and came across dnsmasq.

LINUX VERSION

[root@rac01 ~]# uname -an
Linux rac01.localdomain 2.6.39-200.24.1.el6uek.x86_64 #1 SMP Sat Jun 23 02:39:07 EDT 2012 x86_64 x86_64 x86_64 GNU/Linux

HOSTS

[root@rac01 ~]# cat /etc/hosts
127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4
::1         localhost localhost.localdomain localhost6 localhost6.localdomain6
#NAT (VBox)
#eth0 (DHCP)
#Internal Networking (VBox)
#Private eth2
10.10.10.11    rac01-priv  rac01-priv.localdomain
10.10.10.12    rac02-priv  rac02-priv.localdoamin
#Host Networking (VBox)
#Public eth1
192.168.56.11  rac01       rac01.localdomain
192.168.56.12  rac02       rac02.localdomain
#Virtual IP
192.168.56.21  rac01-vip   rac01-vip.localdomain
192.168.56.22  rac02-vip   rac02-vip.localdomain
#SCAN IP
#192.168.56.31  scan        scan.localdomain
#192.168.56.32  scan        scan.localdomain
#192.168.56.33  scan        scan.localdomain
[root@rac01 ~]#

INSTALATION

yum install dnsmasq

VERIFY INSTALLATION

[root@rac01 ~]# yum list dnsmasq
Loaded plugins: refresh-packagekit, security
Installed Packages
dnsmasq.x86_64     2.48-13.el6     @ol6_latest

[root@rac01 ~]# rpm -qa dnsmasq
dnsmasq-2.48-13.el6.x86_64

ADD IP to resolv.conf MUST BE FIRST LINE

[root@rac01 ~]# cat /etc/resolv.conf
# Generated by NetworkManager
nameserver 192.168.56.11
domain gateway.2wire.net
search gateway.2wire.net localdomain
nameserver 172.16.0.1

WRITE PROTECTING /etc/resolv.conf FILE – resolve.conf changed on reboot due to DHCP

chattr +i /etc/resolv.conf

CONFIGURE dnsmasq

[root@rac01 ~]# cat /etc/dnsmasq.conf
listen-address=192.168.56.11
port=53
no-resolv
domain-needed
bogus-priv
dns-forward-max=150
cache-size=1000
neg-ttl=3600
no-poll
no-hosts
addn-hosts=/etc/racdns

CREATE DNS ENTRIES

[root@rac01 ~]# cat /etc/racdns 
192.168.56.31  scan        scan.localdomain
192.168.56.32  scan        scan.localdomain
192.168.56.33  scan        scan.localdomain
192.168.56.11  rac01       rac01.localdomain
192.168.56.12  rac02       rac02.localdomain
192.168.56.21  rac01-vip   rac01-vip.localdomain
192.168.56.22  rac02-vip   rac02-vip.localdomain

TEST NSLOOKUP

[root@rac01 ~]# nslookup scan
Server:		192.168.56.11
Address:	192.168.56.11#53

Name:	scan.localdomain
Address: 192.168.56.33
Name:	scan.localdomain
Address: 192.168.56.31
Name:	scan.localdomain
Address: 192.168.56.32

[root@rac01 ~]# nslookup scan
Server:		192.168.56.11
Address:	192.168.56.11#53

Name:	scan.localdomain
Address: 192.168.56.31
Name:	scan.localdomain
Address: 192.168.56.32
Name:	scan.localdomain
Address: 192.168.56.33

[root@rac01 ~]# nslookup scan
Server:		192.168.56.11
Address:	192.168.56.11#53

Name:	scan.localdomain
Address: 192.168.56.32
Name:	scan.localdomain
Address: 192.168.56.33
Name:	scan.localdomain
Address: 192.168.56.31

[root@rac01 ~]# nslookup rac01
Server:		192.168.56.11
Address:	192.168.56.11#53

Name:	rac01.localdomain
Address: 192.168.56.11

[root@rac01 ~]# nslookup rac02
Server:		192.168.56.11
Address:	192.168.56.11#53

Name:	rac02.localdomain
Address: 192.168.56.12

[root@rac01 ~]# nslookup rac01-vip
Server:		192.168.56.11
Address:	192.168.56.11#53

Name:	rac01-vip.localdomain
Address: 192.168.56.21

[root@rac01 ~]# nslookup rac02-vip
Server:		192.168.56.11
Address:	192.168.56.11#53

Name:	rac02-vip.localdomain
Address: 192.168.56.22

ADD SERVICE RESTART

[root@rac01 ~]# /sbin/chkconfig dnsmasq on
[root@rac01 ~]# /sbin/chkconfig dnsmasq --list
dnsmasq        	0:off	1:off	2:on	3:on	4:on	5:on	6:on

MANUAL SERVICE RESTART

[root@rac01 ~]# /etc/init.d/dnsmasq restart
Shutting down dnsmasq:                                     [  OK  ]
Starting dnsmasq:                                          [  OK  ]

April 5, 2013

Overclocking i7-3770k

Filed under: Uncategorized — mdinh @ 1:42 pm

oc

Create a free website or blog at WordPress.com.