Showing posts with label 11GR2. Show all posts
Showing posts with label 11GR2. Show all posts

Monday, April 2, 2012

11GR2 Grid Infrastructure Processes


New 11GR2 Grid Infrastructure Processes.


COMPONENTPROCESSESOWNER
Cluster Ready Service (CRS) crsdroot
Cluster Synchronization Service (CSS)ocssd,cssdmonitor,cssdagentgrid owner, root, root
Event Manager (EVM)evmd, evmlogger grid owner
Cluster Time Synchronization Service (CTSS) octssdroot
Oracle Notification Service (ONS)ONS,eonsgrid owner
Oracle Agent oraagentgrid owner
Oracle Root Agent orarootagentroot
Grid Naming Service (GNS)gnsdroot
Grid Plug and Play (GPnP)gpnpdgrid owner
Multicast Domain Name service (mDNS)mdnsdgrid owner




Sunday, April 1, 2012

ASM disks are not visible at Installation


Hi
While installation of 11gR2,  ASM disk was not visible. 


permission were not given on ASMDISKS. 

ls -lart /dev/sd*
brw-r----- 1 root disk     8,  17 Apr  1 12:53 sdb1
brw-r----- 1 root disk     8,  33 Apr  1 12:53 sdc1
brw-r----- 1 root disk     8,  49 Apr  1 12:53 sdd1
brw-r----- 1 root disk     8,  65 Apr  1 12:53 sde1
brw-r----- 1 root disk     8,  81 Apr  1 12:53 sdf1
brw-r----- 1 root disk     8,  97 Apr  1 12:53 sdg1


Later on I remind myself that I forget to add below lines in /etc/rc.d/rc.local

chown oracle:dba /dev/sdb1

chown oracle:dba /dev/sdc1
chown oracle:dba /dev/sdd1
chown oracle:dba /dev/sde1       
chown oracle:dba /dev/sdf1      
chown oracle:dba /dev/sdg1       
chmod 660 /dev/sdb1
chmod 660 /dev/sdc1
chmod 660 /dev/sdd1
chmod 660 /dev/sde1
chmod 660 /dev/sdf1
chmod 660 /dev/sdg1


Define the Scanorder in /etc/sysconfig/oracleasm config file. For example, if the used multipathing device is /dev/md1, you have to force the ASMlib to scan the /dev/md* paths before the /dev/sd* paths


vi /etc/sysconfig/oracleasm

ORACLEASM_SCANORDER: Matching patterns to order disk scanning
ORACLEASM_SCANORDER="md sd"



ssh User equivalence



[oracle@RACG1 grid]$ ./runcluvfy.sh stage -pre crsinst -n RACG1,RACG2 -r 11gR2 -fixup -verbose

Performing pre-checks for cluster services setup

Checking node reachability...


Check: Node reachability from node "RACG1"

  Destination Node                      Reachable?
  ------------------------------------  ------------------------
  RACG1                                 yes
  RACG2                                 yes
Result: Node reachability check passed from node "RACG1"

Checking user equivalence...


Check: User equivalence for user "oracle"

  Node Name                             Comment
  ------------------------------------  ------------------------
  RACG1                                 failed
  RACG2                                 failed
Result: PRVF-4007 : User equivalence check failed for user "oracle"

ERROR:

User equivalence unavailable on all the specified nodes
Verification cannot proceed

Pre-check for cluster services setup was unsuccessful on all the nodes.

-- TO AVOID 

PRVF-4007 : User equivalence check failed for user "oracle 



Setup ssh User equivalence in 11gR2





In new 11GR2 ssh User equivalence can be setup as below. 


[oracle@RACG1 grid]$ ll
total 40
drwxrwxrwx  9 oracle oinstall 4096 Apr  1 08:11 doc
drwxrwxrwx  4 oracle oinstall 4096 Apr  1 08:11 install
drwxrwxrwx  2 oracle oinstall 4096 Apr  1 08:11 response
drwxrwxrwx  2 oracle oinstall 4096 Apr  1 08:11 rpm
-rwxrwxrwx  1 oracle oinstall 3795 Apr  1 08:11 runcluvfy.sh
-rwxrwxrwx  1 oracle oinstall 3227 Apr  1 08:11 runInstaller
drwxrwxrwx  2 oracle oinstall 4096 Apr  1 09:05 sshsetup
drwxrwxrwx 14 oracle oinstall 4096 Apr  1 08:11 stage
-rwxrwxrwx  1 oracle oinstall 4228 Apr  1 08:11 welcome.html


cd sshsetup
./sshUserSetup.sh -user oracle -hosts NODE1,NODE2 -advanced -exverify -confirm

Below is method to setup ssh Manually step-by-step. 



ON NODE-1

TESTP1@:/home/oracle : $mkdir -p ~/.ssh
TESTP1@:/home/oracle : $chmod 700 ~/.ssh
TESTP1@:/home/oracle : $/usr/bin/ssh-keygen -t rsa
Generating public/private rsa key pair.
Enter file in which to save the key (/home/oracle/.ssh/id_rsa):
Enter passphrase (empty for no passphrase):
Enter same passphrase again:
Your identification has been saved in /home/oracle/.ssh/id_rsa.
Your public key has been saved in /home/oracle/.ssh/id_rsa.pub.
The key fingerprint is:
4a:3b:fe:ea:03:d3:cf:6f:d3:06:fb:1a:ed:1e:b0:6b oracle@TESTP1.localdomain.com
TESTP1@:/home/oracle : $/usr/bin/ssh-keygen -t dsa
Generating public/private dsa key pair.
Enter file in which to save the key (/home/oracle/.ssh/id_dsa):
Enter passphrase (empty for no passphrase):
Enter same passphrase again:
Your identification has been saved in /home/oracle/.ssh/id_dsa.
Your public key has been saved in /home/oracle/.ssh/id_dsa.pub.
The key fingerprint is:
5e:cb:46:cc:d8:f1:01:44:3e:7a:20:eb:ce:5d:d4:15 oracle@TESTP1.localdomain.com

ON NODE-2

TESTP2@:/home/oracle : $mkdir -p ~/.ssh
TESTP2@:/home/oracle : $chmod 700 ~/.ssh
TESTP2@:/home/oracle : $/usr/bin/ssh-keygen -t rsa
Generating public/private rsa key pair.
Enter file in which to save the key (/home/oracle/.ssh/id_rsa):
Enter passphrase (empty for no passphrase):
Enter same passphrase again:
Your identification has been saved in /home/oracle/.ssh/id_rsa.
Your public key has been saved in /home/oracle/.ssh/id_rsa.pub.
The key fingerprint is:
dc:4e:e7:c3:ee:71:84:e7:2e:72:99:3d:b0:0a:2b:f9 oracle@TESTP2.localdomain.com
TESTP2@:/home/oracle : $/usr/bin/ssh-keygen -t dsa
Generating public/private dsa key pair.
Enter file in which to save the key (/home/oracle/.ssh/id_dsa):
Enter passphrase (empty for no passphrase):
Enter same passphrase again:
Your identification has been saved in /home/oracle/.ssh/id_dsa.
Your public key has been saved in /home/oracle/.ssh/id_dsa.pub.
The key fingerprint is:
5a:49:d4:e2:b9:5d:e9:f8:f5:bb:ce:7c:4b:f4:dd:6c oracle@TESTP2.localdomain.com

ON NODE-1

TESTP1@:/home/oracle : $ssh TESTP1 cat ~/.ssh/id_rsa.pub >> ~/.ssh/authorized_keys
The authenticity of host 'testp1 (192.168.100.181)' can't be established.
RSA key fingerprint is 27:ac:4b:9a:e3:d2:ae:6d:2b:71:99:8d:b9:c0:b1:a7.
Are you sure you want to continue connecting (yes/no)? yes
Warning: Permanently added 'testp1,192.168.100.181' (RSA) to the list of known hosts.
oracle@testp1's password:
TESTP1@:/home/oracle : $ssh TESTP1 cat ~/.ssh/id_dsa.pub >> ~/.ssh/authorized_keys
TESTP1@:/home/oracle : $scp /home/oracle/.ssh/authorized_keys oracle@TESTP2:~/.ssh/
oracle@testp2's password:
authorized_keys                                                                                                          100% 1030     1.0KB/s   00:00

ON NODE-2

TESTP2@:/home/oracle/.ssh : $ssh TESTP2 cat ~/.ssh/id_rsa.pub >> ~/.ssh/authorized_keys
The authenticity of host 'testp2 (192.168.100.182)' can't be established.
RSA key fingerprint is 27:ac:4b:9a:e3:d2:ae:6d:2b:71:99:8d:b9:c0:b1:a7.
Are you sure you want to continue connecting (yes/no)? yes
Warning: Permanently added 'testp2,192.168.100.182' (RSA) to the list of known hosts.
oracle@testp2's password:
TESTP2@:/home/oracle/.ssh : $ssh TESTP2 cat ~/.ssh/id_dsa.pub >> ~/.ssh/authorized_keys
TESTP2@:/home/oracle/.ssh : $scp /home/oracle/.ssh/authorized_keys oracle@TESTP1:~/.ssh/
The authenticity of host 'testp1 (192.168.100.181)' can't be established.
RSA key fingerprint is 27:ac:4b:9a:e3:d2:ae:6d:2b:71:99:8d:b9:c0:b1:a7.
Are you sure you want to continue connecting (yes/no)? yes
Warning: Permanently added 'testp1,192.168.100.181' (RSA) to the list of known hosts.
oracle@testp1's password:
authorized_keys                                                                                                          100% 2060     2.0KB/s   00:00

--Confirm ssh on both Nodes. 

TESTP1@:/home/oracle : $ssh TESTP2 date
Mon Aug  6 09:20:48 EDT 2012
TESTP1@:/home/oracle : $ssh TESTP1 date
Mon Aug  6 09:20:43 EDT 2012

TESTP2@:/home/oracle/.ssh : $ssh TESTP2 date
Mon Aug  6 09:20:37 EDT 2012
TESTP2@:/home/oracle/.ssh : $ssh TESTP1 date
Mon Aug  6 09:20:31 EDT 2012



It should Ask for password only first time.  if it ask ,,,Do as below temporary 

------perform below step on BOTH NODE. 

exec /usr/bin/ssh-agent $SHELL
/usr/bin/ssh-add
Identity added: /home/oracle/.ssh/id_rsa (/home/oracle/.ssh/id_rsa)

  • login as root
  • vi /etc/sshd_config 
  • mark no instead of yes at line 
passwordauthentication no 



Wednesday, February 22, 2012

11gR2 - Restore OCR/ VOTEDISK based on ASM, when loss of CRS Diskgroup.

1. Locate the latest automatic OCR backup

When using a non-shared CRS home, automatic OCR backups can be located on any node of the cluster, consequently all nodes need to be checked for the most recent backup:

$ ls -lrt $CRS_HOME/cdata/rac_cluster1/
-rw------- 1 root root 7331840 Mar 10 18:52 week.ocr
-rw------- 1 root root 7651328 Mar 26 01:33 week_.ocr
-rw------- 1 root root 7651328 Mar 29 01:33 day.ocr
-rw------- 1 root root 7651328 Mar 30 01:33 day_.ocr
-rw------- 1 root root 7651328 Mar 30 01:33 backup02.ocr
-rw------- 1 root root 7651328 Mar 30 05:33 backup01.ocr
-rw------- 1 root root 7651328 Mar 30 09:33 backup00.ocr

2. Make sure the Grid Infrastructure is shutdown on all nodes
Given that the OCR diskgroup is missing, the GI stack will not be functional on any node, however there may still be various daemon processes running.  On each node shutdown the GI stack using the force (-f) option:

# $CRS_HOME/bin/crsctl stop crs -f

3. Start the CRS stack in exclusive mode

On the node that has the most recent OCR backup, log on as root and start CRS in exclusive mode, this mode will allow ASM to start & stay up without the presence of a Voting disk and without the CRS daemon process (crsd.bin) running.

11.2.0.1:

# $CRS_HOME/bin/crsctl start crs -excl
...CRS-2672: Attempting to start 'ora.asm' on 'racnode1'
CRS-2676: Start of 'ora.asm' on 'racnode1' succeeded
CRS-2672: Attempting to start 'ora.crsd' on 'racnode1'
CRS-2676: Start of 'ora.crsd' on 'racnode1' succeeded


11.2.0.2:

# $CRS_HOME/bin/crsctl start crs -excl -nocrs
CRS-4123: Oracle High Availability Services has been started.
...
CRS-2672: Attempting to start 'ora.cluster_interconnect.haip' on 'auw2k3'
CRS-2672: Attempting to start 'ora.ctssd' on 'racnode1'
CRS-2676: Start of 'ora.drivers.acfs' on 'racnode1' succeeded
CRS-2676: Start of 'ora.ctssd' on 'racnode1' succeeded
CRS-2676: Start of 'ora.cluster_interconnect.haip' on 'racnode1' succeeded
CRS-2672: Attempting to start 'ora.asm' on 'racnode1'
CRS-2676: Start of 'ora.asm' on 'racnode1' succeeded

4. Label the CRS disk for ASMLIB use

If using ASMLIB the disk to be used for the CRS disk group needs to stamped first, as user root do:

# /usr/sbin/oracleasm createdisk ASMD40 /dev/sdh1

Writing disk header: done
Instantiating disk: done

5. Create the CRS diskgroup via sqlplus

The disk group can now be (re-)created via sqlplus from the grid user. The compatible.asm attribute must be set to 11.2 in order for the disk group to be used by CRS: 

$ sqlplus / as sysasm
SQL*Plus: Release 11.2.0.1.0 Production on Tue Mar 30 11:47:24 2010
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Real Application Clusters and Automatic Storage Management options

SQL> create diskgroup CRS external redundancy disk 'ORCL:ASMD40' attribute 'COMPATIBLE.ASM' = '11.2';

Diskgroup created.
SQL> exit


6. Restore the latest OCR backup

Now that the CRS disk group is created & mounted the OCR can be restored - must be done as the root user:

# cd $CRS_HOME/cdata/rac_cluster1/
# $CRS_HOME/bin/ocrconfig -restore backup00.ocr

7. Start the CRS daemon on the current node (11.2.0.1 only !)

Now that the OCR has been restored the CRS daemon can be started, this is needed to recreate the Voting file. Skip this step for 11.2.0.2.0.

# $CRS_HOME/bin/crsctl start res ora.crsd -init
CRS-2672: Attempting to start 'ora.crsd' on 'racnode1'
CRS-2676: Start of 'ora.crsd' on 'racnode1' succeeded

8. Recreate the Voting file

The Voting file needs to be initialized in the CRS disk group:

# $CRS_HOME/bin/crsctl replace votedisk +CRS
Successful addition of voting disk 00caa5b9c0f54f3abf5bd2a2609f09a9.
Successfully replaced voting disk group with +CRS.
CRS-4266: Voting file(s) successfully replaced


9. Recreate the SPFILE for ASM (optional)

Prepare a pfile (e.g. /tmp/asm_pfile.ora) with the ASM startup parameters - these may vary from the example below. If in doubt consult the ASM alert log  as the ASM instance startup should list all non-default parameter values. Please note the last startup of ASM (in step 2 via CRS start) will not have used an SPFILE, so a startup prior to the loss of the CRS disk group would need to be located.
*.asm_power_limit=1
*.diagnostic_dest='/u01/app/oragrid'
*.instance_type='asm'
*.large_pool_size=12M
*.remote_login_passwordfile='EXCLUSIVE'
Now the SPFILE can be created using this PFILE:
$ sqlplus / as sysasm
SQL*Plus: Release 11.2.0.1.0 Production on Tue Mar 30 11:52:39 2010
Copyright (c) 1982, 2009, Oracle. All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Real Application Clusters and Automatic Storage Management options

SQL> create spfile='+CRS' from pfile='/tmp/asm_pfile.ora';

File created.
SQL> exit

10. Shutdown CRS 

Since CRS is running in exclusive mode, it needs to be shutdown  to allow CRS to run on all nodes again. Use of the force (-f) option may be required:

# $CRS_HOME/bin/crsctl stop crs -f
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'auw2k3' has completed
CRS-4133: Oracle High Availability Services has been stopped.

11. Rescan ASM disks

If using ASMLIB rescan all ASM disks on each node as the root user:

# /usr/sbin/oracleasm scandisks
Reloading disk partitions: done
Cleaning any stale ASM disks...
Scanning system for ASM disks...
Instantiating disk "ASMD40"


12. Start CRS 
As the root user submit the CRS startup on all cluster nodes:

# $CRS_HOME/bin/crsctl start crs
CRS-4123: Oracle High Availability Services has been started.

13. Verify CRS 

To verify that CRS is fully functional again:
# $CRS_HOME/bin/crsctl check cluster -all
**************************************************************
racnode1:
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
**************************************************************
racnode2:
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
**************************************************************

# $CRS_HOME/bin/crsctl

Monday, October 17, 2011

Upgrade CRS to 11.2.0.1 Grid Infrastructre. / Upgrade clusterware to Grid Infrastructure

As we all know that, In 11gR2 CRS and ASM has been consolidate in one binaries and named as GRID Infrastructure.
In-place upgrade is not supported in 11gR2.
Upgrade to GRID can be done in two methods.
1) CRS and ASM separate Upgrade.
2) CRS and ASM in together in single Installation.
Its recommended to Upgrade both together.
1. RUN CLUVFY
RACN1:/u00/grid-> ./runcluvfy.sh stage -pre crsinst -n racn1,racn2 -fixup -ve>
Performing pre-checks for cluster services setup
Checking node reachability...
Check: Node reachability from node "RACN1"
Destination Node Reachable?
------------------------------------ ------------------------
racn1 yes
racn2 yes
Result: Node reachability check passed from node "RACN1"
Checking user equivalence...
Check: User equivalence for user "oracle"
Node Name Comment
------------------------------------ ------------------------
racn2 passed
racn1 passed
Result: User equivalence check passed for user "oracle"
Checking node connectivity...
Checking hosts config file...
Node Name Status Comment
------------ ------------------------ ------------------------
racn2 passed
racn1 passed
Verification of the hosts config file successful
Interface information for node "racn2"
Name IP Address Subnet Gateway Def. Gateway HW Address MTU
------ --------------- --------------- --------------- --------------- ----------------- ------
eth0 192.168.133.152 192.168.133.0 0.0.0.0 192.168.133.1 00:0C:29:BA:2F:B6 1500
eth0 192.168.133.156 192.168.133.0 0.0.0.0 192.168.133.1 00:0C:29:BA:2F:B6 1500
eth1 192.168.131.78 192.168.131.0 0.0.0.0 192.168.133.1 00:0C:29:BA:2F:C0 1500
virbr0 192.168.122.1 192.168.122.0 0.0.0.0 192.168.133.1 00:00:00:00:00:00 1500
Interface information for node "racn1"
Name IP Address Subnet Gateway Def. Gateway HW Address MTU
------ --------------- --------------- --------------- --------------- ----------------- ------
eth0 192.168.133.151 192.168.133.0 0.0.0.0 192.168.133.1 00:0C:29:71:48:34 1500
eth0 192.168.133.155 192.168.133.0 0.0.0.0 192.168.133.1 00:0C:29:71:48:34 1500
eth1 192.168.131.76 192.168.131.0 0.0.0.0 192.168.133.1 00:0C:29:71:48:3E 1500
virbr0 192.168.122.1 192.168.122.0 0.0.0.0 192.168.133.1 00:00:00:00:00:00 1500
Check: Node connectivity of subnet "192.168.133.0"
Source Destination Connected?
------------------------------ ------------------------------ ----------------
racn2:eth0 racn2:eth0 yes
racn2:eth0 racn1:eth0 yes
racn2:eth0 racn1:eth0 yes
racn2:eth0 racn1:eth0 yes
racn2:eth0 racn1:eth0 yes
racn1:eth0 racn1:eth0 yes
Result: Node connectivity passed for subnet "192.168.133.0" with node(s) racn2,racn1
Check: TCP connectivity of subnet "192.168.133.0"
Source Destination Connected?
------------------------------ ------------------------------ ----------------
RACN1:192.168.133.151 racn2:192.168.133.152 passed
RACN1:192.168.133.151 racn2:192.168.133.156 passed
RACN1:192.168.133.151 racn1:192.168.133.155 passed
Result: TCP connectivity check failed for subnet "192.168.133.0"
Check: Node connectivity of subnet "192.168.131.0"
Source Destination Connected?
------------------------------ ------------------------------ ----------------
racn2:eth1 racn1:eth1 yes
Result: Node connectivity passed for subnet "192.168.131.0" with node(s) racn2,racn1
Check: TCP connectivity of subnet "192.168.131.0"
Source Destination Connected?
------------------------------ ------------------------------ ----------------
RACN1:192.168.133.151 racn2:192.168.131.78 passed
RACN1:192.168.133.151 racn1:192.168.131.76 passed
Result: TCP connectivity check passed for subnet "192.168.131.0"
Check: Node connectivity of subnet "192.168.122.0"
Source Destination Connected?
------------------------------ ------------------------------ ----------------
racn2:virbr0 racn1:virbr0 yes
Result: Node connectivity passed for subnet "192.168.122.0" with node(s) racn2,racn1
Check: TCP connectivity of subnet "192.168.122.0"
Source Destination Connected?
------------------------------ ------------------------------ ----------------
RACN1:192.168.133.151 racn2:192.168.122.1 passed
RACN1:192.168.133.151 racn1:192.168.122.1 passed
Result: TCP connectivity check passed for subnet "192.168.122.0"
Interfaces found on subnet "192.168.133.0" that are likely candidates for VIP are:
racn2 eth0:192.168.133.152 eth0:192.168.133.156
racn1 eth0:192.168.133.151 eth0:192.168.133.155
Interfaces found on subnet "192.168.131.0" that are likely candidates for a private interconnect are:
racn2 eth1:192.168.131.78
racn1 eth1:192.168.131.76
Interfaces found on subnet "192.168.122.0" that are likely candidates for a private interconnect are:
racn2 virbr0:192.168.122.1
racn1 virbr0:192.168.122.1
Result: Node connectivity check passed
Check: Total memory
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
racn2 947.4MB (970140.0KB) 1.5GB (1572864.0KB) failed
racn1 947.4MB (970140.0KB) 1.5GB (1572864.0KB) failed
Result: Total memory check failed
Check: Available memory
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
racn2 557.55MB (570932.0KB) 50MB (51200.0KB) passed
racn1 485.21MB (496860.0KB) 50MB (51200.0KB) passed
Result: Available memory check passed
Check: Swap space
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
Result: Swap space check failed
Check: Free disk space for "racn2:/tmp"
Path Node Name Mount point Available Required Comment
---------------- ------------ ------------ ------------ ------------ ------------
/tmp racn2 / 12.39GB 1GB passed
Result: Free disk space check passed for "racn2:/tmp"
Check: Free disk space for "racn1:/tmp"
Path Node Name Mount point Available Required Comment
---------------- ------------ ------------ ------------ ------------ ------------
/tmp racn1 / 11.31GB 1GB passed
Result: Free disk space check passed for "racn1:/tmp"
Check: User existence for "oracle"
Node Name Status Comment
------------ ------------------------ ------------------------
racn2 exists passed
racn1 exists passed
Result: User existence check passed for "oracle"
Check: Group existence for "oinstall"
Node Name Status Comment
------------ ------------------------ ------------------------
racn2 exists passed
racn1 exists passed
Result: Group existence check passed for "oinstall"
Check: Group existence for "dba"
Node Name Status Comment
------------ ------------------------ ------------------------
racn2 exists passed
racn1 exists passed
Result: Group existence check passed for "dba"
Check: Membership of user "oracle" in group "oinstall" [as Primary]
Node Name User Exists Group Exists User in Group Primary Comment
---------------- ------------ ------------ ------------ ------------ ------------
racn2 yes yes yes yes passed
racn1 yes yes yes yes passed
Result: Membership check for user "oracle" in group "oinstall" [as Primary] passed
Check: Membership of user "oracle" in group "dba"
Node Name User Exists Group Exists User in Group Comment
---------------- ------------ ------------ ------------ ----------------
racn2 yes yes yes passed
racn1 yes yes yes passed
Result: Membership check for user "oracle" in group "dba" passed
Check: Run level
Node Name run level Required Comment
------------ ------------------------ ------------------------ ----------
racn2 5 3,5 passed
racn1 5 3,5 passed
Result: Run level check passed
Check: Hard limits for "maximum open file descriptors"
Node Name Type Available Required Comment
---------------- ------------ ------------ ------------ ----------------
racn2 hard 65536 65536 passed
racn1 hard 65536 65536 passed
Result: Hard limits check passed for "maximum open file descriptors"
Check: Soft limits for "maximum open file descriptors"
Node Name Type Available Required Comment
---------------- ------------ ------------ ------------ ----------------
racn2 soft 1024 1024 passed
racn1 soft 1024 1024 passed
Result: Soft limits check passed for "maximum open file descriptors"
Check: Hard limits for "maximum user processes"
Node Name Type Available Required Comment
---------------- ------------ ------------ ------------ ----------------
racn2 hard 16384 16384 passed
racn1 hard 16384 16384 passed
Result: Hard limits check passed for "maximum user processes"
Check: Soft limits for "maximum user processes"
Node Name Type Available Required Comment
---------------- ------------ ------------ ------------ ----------------
racn2 soft 2047 2047 passed
racn1 soft 2047 2047 passed
Result: Soft limits check passed for "maximum user processes"
Check: System architecture
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
racn2 i686 x86 passed
racn1 i686 x86 passed
Result: System architecture check passed
Check: Kernel version
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
racn2 2.6.18-164.el5PAE 2.6.18 passed
racn1 2.6.18-164.el5PAE 2.6.18 passed
Result: Kernel version check passed
Check: Kernel parameter for "semmsl"
Node Name Configured Required Comment
------------ ------------------------ ------------------------ ----------
racn2 250 250 passed
racn1 250 250 passed
Result: Kernel parameter check passed for "semmsl"
Check: Kernel parameter for "semmns"
Node Name Configured Required Comment
------------ ------------------------ ------------------------ ----------
racn2 32000 32000 passed
racn1 32000 32000 passed
Result: Kernel parameter check passed for "semmns"
Check: Kernel parameter for "semopm"
Node Name Configured Required Comment
------------ ------------------------ ------------------------ ----------
racn2 100 100 passed
racn1 100 100 passed
Result: Kernel parameter check passed for "semopm"
Check: Kernel parameter for "semmni"
Node Name Configured Required Comment
------------ ------------------------ ------------------------ ----------
racn2 128 128 passed
racn1 128 128 passed
Result: Kernel parameter check passed for "semmni"
Check: Kernel parameter for "shmmax"
Node Name Configured Required Comment
------------ ------------------------ ------------------------ ----------
racn2 4294967295 536870912 passed
racn1 4294967295 536870912 passed
Result: Kernel parameter check passed for "shmmax"
Check: Kernel parameter for "shmmni"
Node Name Configured Required Comment
------------ ------------------------ ------------------------ ----------
racn2 4096 4096 passed
racn1 4096 4096 passed
Result: Kernel parameter check passed for "shmmni"
Check: Kernel parameter for "shmall"
Node Name Configured Required Comment
------------ ------------------------ ------------------------ ----------
racn2 1073741824 2097152 passed
racn1 1073741824 2097152 passed
Result: Kernel parameter check passed for "shmall"
Check: Kernel parameter for "file-max"
Node Name Configured Required Comment
------------ ------------------------ ------------------------ ----------
racn2 6553600 6815744 failed
racn1 6553600 6815744 failed
Result: Kernel parameter check failed for "file-max"
Check: Kernel parameter for "ip_local_port_range"
Node Name Configured Required Comment
------------ ------------------------ ------------------------ ----------
racn2 between 1024 & 65000 between 9000 & 65500 failed (ignorable)
racn1 between 1024 & 65000 between 9000 & 65500 failed (ignorable)
Result: Kernel parameter check passed for "ip_local_port_range"
Check: Kernel parameter for "rmem_default"
Node Name Configured Required Comment
------------ ------------------------ ------------------------ ----------
racn2 4194304 262144 passed
racn1 4194304 262144 passed
Result: Kernel parameter check passed for "rmem_default"
Check: Kernel parameter for "rmem_max"
Node Name Configured Required Comment
------------ ------------------------ ------------------------ ----------
racn2 4194304 4194304 passed
racn1 4194304 4194304 passed
Result: Kernel parameter check passed for "rmem_max"
Check: Kernel parameter for "wmem_default"
Node Name Configured Required Comment
------------ ------------------------ ------------------------ ----------
racn2 262144 262144 passed
racn1 262144 262144 passed
Result: Kernel parameter check passed for "wmem_default"
Check: Kernel parameter for "wmem_max"
Node Name Configured Required Comment
------------ ------------------------ ------------------------ ----------
racn2 262144 1048576 failed
racn1 262144 1048576 failed
Result: Kernel parameter check failed for "wmem_max"
Check: Kernel parameter for "aio-max-nr"
Node Name Configured Required Comment
------------ ------------------------ ------------------------ ----------
racn2 3145728 1048576 passed
racn1 3145728 1048576 passed
Result: Kernel parameter check passed for "aio-max-nr"
Check: Package existence for "make-3.81"
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
racn2 make-3.81-3.el5 make-3.81 passed
racn1 make-3.81-3.el5 make-3.81 passed
Result: Package existence check passed for "make-3.81"
Check: Package existence for "binutils-2.17.50.0.6"
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
racn2 binutils-2.17.50.0.6-12.el5 binutils-2.17.50.0.6 passed
racn1 binutils-2.17.50.0.6-12.el5 binutils-2.17.50.0.6 passed
Result: Package existence check passed for "binutils-2.17.50.0.6"
Check: Package existence for "gcc-4.1.2"
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
racn2 gcc-4.1.2-46.el5 gcc-4.1.2 passed
racn1 gcc-4.1.2-46.el5 gcc-4.1.2 passed
Result: Package existence check passed for "gcc-4.1.2"
Check: Package existence for "gcc-c++-4.1.2"
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
racn2 gcc-c++-4.1.2-46.el5 gcc-c++-4.1.2 passed
racn1 gcc-c++-4.1.2-46.el5 gcc-c++-4.1.2 passed
Result: Package existence check passed for "gcc-c++-4.1.2"
Check: Package existence for "libgomp-4.1.2"
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
racn2 libgomp-4.4.0-6.el5 libgomp-4.1.2 passed
racn1 libgomp-4.4.0-6.el5 libgomp-4.1.2 passed
Result: Package existence check passed for "libgomp-4.1.2"
Check: Package existence for "libaio-0.3.106"
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
racn2 libaio-0.3.106-3.2 libaio-0.3.106 passed
racn1 libaio-0.3.106-3.2 libaio-0.3.106 passed
Result: Package existence check passed for "libaio-0.3.106"
Check: Package existence for "glibc-2.5-24"
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
racn2 glibc-2.5-42 glibc-2.5-24 passed
racn1 glibc-2.5-42 glibc-2.5-24 passed
Result: Package existence check passed for "glibc-2.5-24"
Check: Package existence for "compat-libstdc++-33-3.2.3"
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
racn2 compat-libstdc++-33-3.2.3-61 compat-libstdc++-33-3.2.3 passed
racn1 compat-libstdc++-33-3.2.3-61 compat-libstdc++-33-3.2.3 passed
Result: Package existence check passed for "compat-libstdc++-33-3.2.3"
Check: Package existence for "elfutils-libelf-0.125"
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
racn2 elfutils-libelf-0.137-3.el5 elfutils-libelf-0.125 passed
racn1 elfutils-libelf-0.137-3.el5 elfutils-libelf-0.125 passed
Result: Package existence check passed for "elfutils-libelf-0.125"
Check: Package existence for "elfutils-libelf-devel-0.125"
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
racn2 elfutils-libelf-devel-0.137-3.el5 elfutils-libelf-devel-0.125 passed
racn1 elfutils-libelf-devel-0.137-3.el5 elfutils-libelf-devel-0.125 passed
Result: Package existence check passed for "elfutils-libelf-devel-0.125"
Check: Package existence for "glibc-common-2.5"
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
racn2 glibc-common-2.5-42 glibc-common-2.5 passed
racn1 glibc-common-2.5-42 glibc-common-2.5 passed
Result: Package existence check passed for "glibc-common-2.5"
Check: Package existence for "glibc-devel-2.5"
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
racn2 glibc-devel-2.5-42 glibc-devel-2.5 passed
racn1 glibc-devel-2.5-42 glibc-devel-2.5 passed
Result: Package existence check passed for "glibc-devel-2.5"
Check: Package existence for "glibc-headers-2.5"
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
racn2 glibc-headers-2.5-42 glibc-headers-2.5 passed
racn1 glibc-headers-2.5-42 glibc-headers-2.5 passed
Result: Package existence check passed for "glibc-headers-2.5"
Check: Package existence for "libaio-devel-0.3.106"
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
racn2 libaio-devel-0.3.106-3.2 libaio-devel-0.3.106 passed
racn1 libaio-devel-0.3.106-3.2 libaio-devel-0.3.106 passed
Result: Package existence check passed for "libaio-devel-0.3.106"
Check: Package existence for "libgcc-4.1.2"
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
racn2 libgcc-4.1.2-46.el5 libgcc-4.1.2 passed
racn1 libgcc-4.1.2-46.el5 libgcc-4.1.2 passed
Result: Package existence check passed for "libgcc-4.1.2"
Check: Package existence for "libstdc++-4.1.2"
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
racn2 libstdc++-4.1.2-46.el5 libstdc++-4.1.2 passed
racn1 libstdc++-4.1.2-46.el5 libstdc++-4.1.2 passed
Result: Package existence check passed for "libstdc++-4.1.2"
Check: Package existence for "libstdc++-devel-4.1.2"
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
racn2 libstdc++-devel-4.1.2-46.el5 libstdc++-devel-4.1.2 passed
racn1 libstdc++-devel-4.1.2-46.el5 libstdc++-devel-4.1.2 passed
Result: Package existence check passed for "libstdc++-devel-4.1.2"
Check: Package existence for "sysstat-7.0.2"
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
racn2 sysstat-7.0.2-3.el5 sysstat-7.0.2 passed
racn1 sysstat-7.0.2-3.el5 sysstat-7.0.2 passed
Result: Package existence check passed for "sysstat-7.0.2"
Check: Package existence for "unixODBC-2.2.11"
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
racn2 unixODBC-2.2.11-7.1 unixODBC-2.2.11 passed
racn1 unixODBC-2.2.11-7.1 unixODBC-2.2.11 passed
Result: Package existence check passed for "unixODBC-2.2.11"
Check: Package existence for "unixODBC-devel-2.2.11"
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
racn2 unixODBC-devel-2.2.11-7.1 unixODBC-devel-2.2.11 passed
racn1 unixODBC-devel-2.2.11-7.1 unixODBC-devel-2.2.11 passed
Result: Package existence check passed for "unixODBC-devel-2.2.11"
Check: Package existence for "ksh-20060214"
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
racn2 ksh-20080202-14.el5 ksh-20060214 passed
racn1 ksh-20080202-14.el5 ksh-20060214 passed
Result: Package existence check passed for "ksh-20060214"
Checking for multiple users with UID value 0
Result: Check for multiple users with UID value 0 passed
Check: Current group ID
Result: Current group ID check passed
Checking Core file name pattern consistency...
Core file name pattern consistency check passed.
Checking to make sure user "oracle" is not in "root" group
Node Name Status Comment
------------ ------------------------ ------------------------
racn2 does not exist passed
racn1 does not exist passed
Result: User "oracle" is not part of "root" group. Check passed
Check default user file creation mask
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
racn2 0022 0022 passed
racn1 0022 0022 passed
Result: Default user file creation mask check passed
Starting Clock synchronization checks using Network Time Protocol(NTP)...
NTP Configuration file check started...
The NTP configuration file "/etc/ntp.conf" is available on all nodes
NTP Configuration file check passed
Checking daemon liveness...
Check: Liveness for "ntpd"
Node Name Running?
------------------------------------ ------------------------
racn2 no
racn1 no
Result: Liveness check failed for "ntpd"
PRVF-5415 : Check to see if NTP daemon is running failed
Result: Clock synchronization check using Network Time Protocol(NTP) failed
Fixup information has been generated for following node(s):
racn1,racn2
Please run the following script on each node as "root" user to execute the fixups:
'/tmp/CVU_11.2.0.1.0_oracle/runfixup.sh'
Pre-check for cluster services setup was unsuccessful on all the nodes.
2. FIX KERNAL PARAMETER ERRORS FROM GENERATED SCRIPT (if any) on BOTH NODES.
[root@RACN1 CVU_11.2.0.1.0_oracle]# ./runfixup.sh
Response file being used is :./fixup.response
Enable file being used is :./fixup.enable
Log file location: ./orarun.log
Setting Kernel Parameters...
fs.file-max = 6553600
fs.file-max = 6815744
net.ipv4.ip_local_port_range = 9000 65500
net.core.wmem_max = 262144
net.core.wmem_max=262144
./orarun.sh: line 728: [: 262144net.core.wmem_max: integer expression expected
The value for wmem_max in response file is not greater than value for wmem_max in /etc/sysctl.conf file. Hence not changing it.
net.core.wmem_max = 1048576
[root@RACN2 CVU_11.2.0.1.0_oracle]# ./runfixup.sh
Response file being used is :./fixup.response
Enable file being used is :./fixup.enable
Log file location: ./orarun.log
Setting Kernel Parameters...
fs.file-max = 6553600
fs.file-max = 6815744
net.ipv4.ip_local_port_range = 9000 65500
net.core.wmem_max = 262144
net.core.wmem_max=262144
./orarun.sh: line 728: [: 262144net.core.wmem_max: integer expression expected
The value for wmem_max in response file is not greater than value for wmem_max in /etc/sysctl.conf file. Hence not changing it.
net.core.wmem_max = 1048576
.3. NTP ERROR FIXED
Move /etc/ntp.conf
[root@RACN1 ~]# mv /etc/ntp.conf /etc/ntp.conf.old
[root@RACN2 ~]# mv /etc/ntp.conf /etc/ntp.conf.old
Starting Clock synchronization checks using Network Time Protocol(NTP)...
NTP Configuration file check started...
Network Time Protocol(NTP) configuration file not found on any of the nodes. Oracle Cluster Time Synchronization Service(CTSS) can be used instead of NTP for time synchronization on the cluster nodes
Result: Clock synchronization check using Network Time Protocol(NTP) passed
CONFIGURE SCAN IP
SET ASM ROLLING PARAMETER
asmca_rolling_upgrade=true
Oracle strongly recommends that you configure the SCAN either on DNS or GNS, with a maximum of three IPs in a round-robin fashion


4. Configure DNS files or /etc/hosts
Editing needed in DNS, since I m not using DNS I will edit my /etc/hosts and Add a new IP.
5. Create GRID_HOME and set environment
export GRID_HOME=/u01/app/grid
To Upgrade ASM alone with GRID , we need to export below parameter.
export asmca_rolling_upgrade=true
CRS don’t need to shutdown as its Rolling Upgrade.
While Running rootupgrade.sh after installation .it will shutdown old (11.1.0.7) and start new CRS (11.2.0.1).
RACN1:/home/oracle-> crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....SM1.asm application ONLINE ONLINE racn1
ora....N1.lsnr application ONLINE ONLINE racn1
ora.racn1.gsd application ONLINE ONLINE racn1
ora.racn1.ons application ONLINE ONLINE racn1
ora.racn1.vip application ONLINE ONLINE racn1
ora....SM2.asm application ONLINE ONLINE racn2
ora....N2.lsnr application ONLINE ONLINE racn2
ora.racn2.gsd application ONLINE ONLINE racn2
ora.racn2.ons application ONLINE ONLINE racn2
ora.racn2.vip application ONLINE ONLINE racn2
6.Run Installer of Grid Infrastructure setup and select to upgrade Grid Infrastructure.
7. It will detect if its Running on ASM.


8. Node selection / Choose if you want to upgrade ASM along with CRS.

9.enter SCAN detail .


8. 10.Enter ASM pwd.

10. Select OS group for ASM.

11. Enter Installation Location Detail. ($GRID_HOME)



12.Installation in progress.


13.Run the Rootupgrade.sh on both node.



[root@RACN1 grid]# ./rootupgrade.sh
Running Oracle 11g root.sh script...
The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /u01/app/grid
Enter the full pathname of the local bin directory: [/usr/local/bin]:
The file "dbhome" already exists in /usr/local/bin. Overwrite it? (y/n)
[n]:
The file "oraenv" already exists in /usr/local/bin. Overwrite it? (y/n)
[n]:
The file "coraenv" already exists in /usr/local/bin. Overwrite it? (y/n)
[n]:
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root.sh script.
Now product-specific root actions will be performed.
2011-10-12 21:04:39: Parsing the host name
2011-10-12 21:04:39: Checking for super user privileges
2011-10-12 21:04:39: User has super user privileges
Using configuration parameter file: /u01/app/grid/crs/install/crsconfig_params
Creating trace directory
Cluster Synchronization Services appears healthy
Event Manager appears healthy
Cluster Ready Services appears healthy
Shutting down Oracle Cluster Ready Services (CRS):
Oct 12 21:05:11.420 | INF | daemon shutting down
Stopping resources.
This could take several minutes.
Successfully stopped Oracle Clusterware resources
Stopping Cluster Synchronization Services.
Shutting down the Cluster Synchronization Services daemon.
Shutdown request successfully issued.
Shutdown has begun. The daemons should exit soon.
LOCAL ADD MODE
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
root wallet
root wallet cert
root cert export
peer wallet
profile reader wallet
pa wallet
peer wallet keys
pa wallet keys
peer cert request
pa cert request
peer cert
pa cert
peer root cert TP
profile reader root cert TP
pa root cert TP
peer pa cert TP
pa peer cert TP
profile reader pa cert TP
profile reader peer cert TP
peer user cert
pa user cert
Adding daemon to inittab
CRS-4123: Oracle High Availability Services has been started.
ohasd is starting
CRS-2672: Attempting to start 'ora.mdnsd' on 'racn1'
CRS-2676: Start of 'ora.mdnsd' on 'racn1' succeeded
CRS-2672: Attempting to start 'ora.gipcd' on 'racn1'
CRS-2676: Start of 'ora.gipcd' on 'racn1' succeeded
CRS-2672: Attempting to start 'ora.gpnpd' on 'racn1'
CRS-2676: Start of 'ora.gpnpd' on 'racn1' succeeded
CRS-2672: Attempting to start 'ora.cssdmonitor' on 'racn1'
CRS-2676: Start of 'ora.cssdmonitor' on 'racn1' succeeded
CRS-2672: Attempting to start 'ora.cssd' on 'racn1'
CRS-2672: Attempting to start 'ora.diskmon' on 'racn1'
CRS-2676: Start of 'ora.diskmon' on 'racn1' succeeded
CRS-2676: Start of 'ora.cssd' on 'racn1' succeeded
CRS-2672: Attempting to start 'ora.ctssd' on 'racn1'
CRS-2676: Start of 'ora.ctssd' on 'racn1' succeeded
CRS-2672: Attempting to start 'ora.crsd' on 'racn1'
CRS-2676: Start of 'ora.crsd' on 'racn1' succeeded
CRS-2672: Attempting to start 'ora.evmd' on 'racn1'
CRS-2676: Start of 'ora.evmd' on 'racn1' succeeded
clscfg: EXISTING configuration version 4 detected.
clscfg: version 4 is 11 Release 1.
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
racn1 2011/10/12 21:11:27 /u01/app/grid/cdata/racn1/backup_20111012_211127.olr
Preparing packages for installation...
cvuqdisk-1.0.7-1
Configure Oracle Grid Infrastructure for a Cluster ... succeeded
Updating inventory properties for clusterware
Starting Oracle Universal Installer...
Checking swap space: must be greater than 500 MB. Actual 1139 MB Passed
The inventory pointer is located at /etc/oraInst.loc
The inventory is located at /u01/app/oraInventory
'UpdateNodeList' was successful.
Starting Oracle Universal Installer...
Checking swap space: must be greater than 500 MB. Actual 1022 MB Passed
The inventory pointer is located at /etc/oraInst.loc
The inventory is located at /u01/app/oraInventory
'UpdateNodeList' was successful.
[root@RACN1 grid]#

14. Now ASM will get upgrade.



15. validate all resources.

Validate All Resources are ONLINE with all new command.
./crsctl stat res -t
GSD will be OFFLINE by default in 11R2.
If any 9i database is cluster then GSD must be ONLINE.
To start GSD as ROOT.
./srvctl enable nodeapps -g
./srvctl start nodeapps