Saturday, February 25, 2012

Upgrading from 10.2.0.4 to 10.2.0.5 (Clusterware, RAC, ASM)

Two node cluster (node names rac1 and rac2) running 10.2.0.4 on RHEL 4 (kernel 2.6.9-89). The 10.2.0.4 has PSU January 2012 applied on the Oracle homes. The accompanying patch set note describe the steps needed to apply the patch set (unlike 11gR2 where information has to found from multiple sources).

One of the pre-reqs is time zone value
SQL> SELECT version FROM v$timezone_file;
   VERSION
----------
         4
If this query reports version 4 (as in this case), no action is required. If this reports a version lower or higher than 4, see 1086400.1 for more information.
Current clusterware version
$ crsctl query crs activeversion
CRS active version on the cluster is [10.2.0.4.0]
$ crsctl query crs softwareversion
CRS software version on node [rac1] is [10.2.0.4.0]
10gR2 clusterware could be upgraded in a rolling manner even though it's an in-place upgrade but as the Oracle home in-place upgrades does requires database to be shutdown. If not following warning will be shown.

1. Before the start of the clusterware upgrade all cluster applications are online.
crs_stat -t
Name           Type           Target    State     Host
------------------------------------------------------------
ora....SM1.asm application    ONLINE    ONLINE    rac1
ora....C1.lsnr application    ONLINE    ONLINE    rac1
ora.rac1.gsd   application    ONLINE    ONLINE    rac1
ora.rac1.ons   application    ONLINE    ONLINE    rac1
ora.rac1.vip   application    ONLINE    ONLINE    rac1
ora.rac10g2.db application    ONLINE    ONLINE    rac2
ora....21.inst application    ONLINE    ONLINE    rac1
ora....22.inst application    ONLINE    ONLINE    rac2
ora....SM2.asm application    ONLINE    ONLINE    rac2
ora....C2.lsnr application    ONLINE    ONLINE    rac2
ora.rac2.gsd   application    ONLINE    ONLINE    rac2
ora.rac2.ons   application    ONLINE    ONLINE    rac2
ora.rac2.vip   application    ONLINE    ONLINE    rac2
2. Start the clusterware upgrade by executing runInstaller
Even though it is a rolling upgrade all nodes are selected by default.



When the installation has finished it will ask to run the root script on each node. This is where the rolling upgrade happens.

3. Stop the clusterware stack on first node
stop on first node
crsctl stop crs
Stopping resources. This could take several minutes.
Successfully stopped CRS resources.
Stopping CSSD.
Shutting down CSS daemon.
Shutdown request successfully issued.
Cluster stack is running on other node(s) and could be used by applications.
rac2 ~]$ crs_stat -t
Name           Type           Target    State     Host
------------------------------------------------------------
ora....SM1.asm application    ONLINE    OFFLINE
ora....C1.lsnr application    ONLINE    OFFLINE
ora.rac1.gsd   application    ONLINE    OFFLINE
ora.rac1.ons   application    ONLINE    OFFLINE
ora.rac1.vip   application    ONLINE    ONLINE    rac2
ora.rac10g2.db application    ONLINE    ONLINE    rac2
ora....21.inst application    ONLINE    OFFLINE
ora....22.inst application    ONLINE    ONLINE    rac2
ora....SM2.asm application    ONLINE    ONLINE    rac2
ora....C2.lsnr application    ONLINE    ONLINE    rac2
ora.rac2.gsd   application    ONLINE    ONLINE    rac2
ora.rac2.ons   application    ONLINE    ONLINE    rac2
ora.rac2.vip   application    ONLINE    ONLINE    rac2
4. Run the root102.sh on first node
# /opt/crs/oracle/product/10.2.0/crs/install/root102.sh
Creating pre-patch directory for saving pre-patch clusterware files
Completed patching clusterware files to /opt/crs/oracle/product/10.2.0/crs
Relinking some shared libraries.
Relinking of patched files is complete.
Preparing to recopy patched init and RC scripts.
Recopying init and RC scripts.
Startup will be queued to init within 30 seconds.
Starting up the CRS daemons.
Waiting for the patched CRS daemons to start.
  This may take a while on some systems.
.
10205 patch successfully applied.
clscfg: EXISTING configuration version 3 detected.
clscfg: version 3 is 10G Release 2.
Successfully deleted 1 values from OCR.
Successfully deleted 1 keys from OCR.
Successfully accumulated necessary OCR keys.
Using ports: CSS=49895 CRS=49896 EVMC=49898 and EVMR=49897.
node :   
node 1: rac1 rac1-pvt rac1
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
clscfg -upgrade completed successfully
Creating '/opt/crs/oracle/product/10.2.0/crs/install/paramfile.crs' with data used for CRS configuration
Setting CRS configuration values in /opt/crs/oracle/product/10.2.0/crs/install/paramfile.crs
At the end of this clusterware stack will be up and running on this node (rac1) and will be available for use while root script is run on other nodes.
rac1 oracle]# crs_stat -t
Name           Type           Target    State     Host
------------------------------------------------------------
ora....SM1.asm application    ONLINE    ONLINE    rac1
ora....C1.lsnr application    ONLINE    ONLINE    rac1
ora.rac1.gsd   application    ONLINE    ONLINE    rac1
ora.rac1.ons   application    ONLINE    ONLINE    rac1
ora.rac1.vip   application    ONLINE    ONLINE    rac1
ora.rac10g2.db application    ONLINE    ONLINE    rac2
ora....21.inst application    ONLINE    ONLINE    rac1
ora....22.inst application    ONLINE    ONLINE    rac2
ora....SM2.asm application    ONLINE    ONLINE    rac2
ora....C2.lsnr application    ONLINE    ONLINE    rac2
ora.rac2.gsd   application    ONLINE    ONLINE    rac2
ora.rac2.ons   application    ONLINE    ONLINE    rac2
ora.rac2.vip   application    ONLINE    ONLINE    rac2
5. Carry out the same steps on other node(s) (rac2)
$ crsctl stop crs
Stopping resources. This could take several minutes.
Successfully stopped CRS resources.
Stopping CSSD.
Shutting down CSS daemon.
Shutdown request successfully issued.
Run root102.sh
[root@rac2 oracle]# /opt/crs/oracle/product/10.2.0/crs/install/root102.sh
Creating pre-patch directory for saving pre-patch clusterware files
Completed patching clusterware files to /opt/crs/oracle/product/10.2.0/crs
Relinking some shared libraries.
Relinking of patched files is complete.
Preparing to recopy patched init and RC scripts.
Recopying init and RC scripts.
Startup will be queued to init within 30 seconds.
Starting up the CRS daemons.
Waiting for the patched CRS daemons to start.
  This may take a while on some systems.
.
10205 patch successfully applied.
clscfg: EXISTING configuration version 3 detected.
clscfg: version 3 is 10G Release 2.
Successfully deleted 1 values from OCR.
Successfully deleted 1 keys from OCR.
Successfully accumulated necessary OCR keys.
Using ports: CSS=49895 CRS=49896 EVMC=49898 and EVMR=49897.
node :   
node 2: rac2 rac2-pvt rac2
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
clscfg -upgrade completed successfully
Creating '/opt/crs/oracle/product/10.2.0/crs/install/paramfile.crs' with data used for CRS configuration
Setting CRS configuration values in /opt/crs/oracle/product/10.2.0/crs/install/paramfile.crs
6. Verify clusterware is upgraded
$ crsctl query crs activeversion
CRS active version on the cluster is [10.2.0.5.0]
$ crsctl query crs softwareversion
CRS software version on node [rac2] is [10.2.0.5.0]
7. After the upgrade opatch exhbit an error which could be resolved by installing the latest version of opatch.



8. Create a pfile of the database before the Oracle Home is upgraded. Shutdown all applications running out of the Oracle home before Oracle home ugprades
[oracle@rac1 ~]$ srvctl stop database -d rac10g2
[oracle@rac1 ~]$ srvctl stop asm -n rac1
[oracle@rac1 ~]$ srvctl stop asm -n rac2
[oracle@rac1 ~]$ srvctl stop nodeapps -n rac2
[oracle@rac1 ~]$ srvctl stop nodeapps -n rac1
9. Execute runInstaller and upgrade Oracle Home across the cluster


10. From the 10g Upgrade guide
The DBUA provides support for Real Application Clusters (RAC) and Automatic Storage Management (ASM). Support for Real Application Clusters In a Real Application Clusters (RAC) environment, the DBUA upgrades all the database and configuration files on all nodes in the cluster.

Support for Automatic Storage Management The DBUA supports upgrades of databases that use Automatic Storage Management (ASM). If an ASM instance is detected, you have the choice of updating both the database and ASM or only the ASM instance.


In this ASM is upgrade is not necessary.

11. Database upgrade could be done manually or using DBUA. If database upgrade is done manually then set cluster_database=false before starting the database in upgrade mode. If DBUA is used setting cluster_database=false will be done by DBUA itself.

Since the 10.2.0.4 database and Oracle home had the PSU Jan 2012 applied and a new initialization parameter (_external_scn_rejection_threshold_hours) was introduced.

As the newly upgrade 10.2.0.5 home doesn't have this patch (PSU Jan 2012) yet trying to start the database for upgrade could be a problem.
SQL> startup nomount
ORA-01078: failure in processing system parameters
LRM-00101: unknown parameter name '_external_scn_rejection_threshold_hours'
This could be resolved with either by starting the database with the pfile created earlier (step 8) or applying the PSU Jan 2012 on the new 10.2.0.5 homes before running the DBUA.

In this case the latter option was selected. After the PSU Jan 2012 was applied on 10.2.0.5 DBUA ran without an issue.



12. After the upgrade has finished apply the post installation script of the PSU. This concludes the 10.2.0.4 to 10.2.0.5 upgrade.

Useful metalink notes
Oracle Clusterware (CRS or GI) Rolling Upgrades [ID 338706.1]

Tuesday, February 21, 2012

Upgrading from 11.2.0.1 to 11.2.0.3 with in-place upgrade for RAC

Two previous blog posts showed steps to upgrade from 11.2.0.1 to 11.2.0.2 and 11.2.0.2 to 11.2.0.3. Earlier posts all had out of place upgrades for a single node cluster stack. This post is for a two node cluster with out of place upgrade for Grid Infrastructure (GI) and in-place upgrade for Oracle Home.

Following text is from GI install guide (sections that relates to the upgrade).
"Oracle recommends that you leave Oracle RAC instances running. When you start the root script on each node, that node's instances are shut down and then started up again by the rootupgrade.sh script. If you upgrade from release 11.2.0.1 to any later version (11.2.0.2 or 11.2.0.3), then all nodes are selected by default. You cannot select or de-select the nodes. For single instance Oracle Databases on the cluster, only those that use Oracle ASM need to be shut down. Listeners do not need to be shut down."

"Oracle recommends that you select all cluster member nodes for the upgrade, and then shut down database instances on each node before you run the upgrade root script, starting the database instance up again on each node after the upgrade is complete. You can also use this procedure to upgrade a subset of nodes in the cluster."

"Oracle recommends that you upgrade Oracle ASM at the same time that you upgrade the Oracle Clusterware binaries. Until Oracle ASM is upgraded, Oracle databases that use Oracle ASM cannot be created. Until Oracle ASM is upgraded, the 11g release 2 (11.2) Oracle ASM management tools in the Grid home (for example, srvctl) will not work."

"At the end of the upgrade, if you set the OCR backup location manually to the older release Oracle Clusterware home (CRS home), then you must change the OCR backup location to the Oracle Grid Infrastructure home (Grid home). If you did not set the OCR backup location manually, then this issue does not concern you."

"To upgrade existing 11.2.0.1 Oracle Grid Infrastructure installations to Oracle Grid Infrastructure 11.2.0.2, you must first verify if you need to apply any mandatory patches for upgrade to succeed. Refer to Section F.6 for steps to check readiness.
To upgrade existing Oracle Grid Infrastructure from 11.2.0.2, to 11.2.0.3 or later, you must apply patch 11.2.0.2.1 (11.2.0.2 PSU 1) or later.
"

From the upgrade guide
"Known Issue with the Deinstallation Tool for This Release
Cause: After upgrading from 11.2.0.1 or 11.2.0.2 to 11.2.0.3, deinstallation of the Oracle home in the earlier release of Oracle Database may result in the deletion of the old Oracle base that was associated with it. This may also result in the deletion of data files, audit files, etc., which are stored under the old Oracle base.
Action: Before deinstalling the Oracle home in the earlier release, edit the orabase_cleanup.lst file found in the $Oracle_Home/utl directory and remove the "oradata" and "admin" entries. Then, deinstall the Oracle home using the 11.2.0.3 deinstallation tool.
"

Combination of patches used in the two upgrades mentioned above are not needed here (9706490 or 12539000). 11.2.0.1 to 11.2.0.2 ASM Rolling Upgrade [ID 1274629.1] has a new section for upgrading to 11.2.0.3.

Cluster verification utility can check the required patches for the platform before the upgrade. For Linux x86_64 the required patch was 9413827. Running cluvfy with pre upgrade mode would check the pre-reqs needed. Only two stood out in this case
Checking for Oracle patch "9413827" in home "/opt/app/11.2.0/grid".
  Node Name     Applied                   Required                  Comment
  ------------  ------------------------  ------------------------  ----------
  rac5          missing                   9413827                   failed
  rac4          missing                   9413827                   failed
Result: Check for Oracle patch "9413827" in home "/opt/app/11.2.0/grid" failed

There are no oracle patches required for home "/opt/app/11.2.0/grid3".

Check: Kernel parameter for "shmmni"
  Node Name         Current       Configured    Required      Status        Comment
  ----------------  ------------  ------------  ------------  ------------  ------------
  rac5              4096          unknown       4096          failed        Configured value too low.
  rac4              4096          unknown       4096          failed        Configured value too low.
Result: Kernel parameter check failed for "shmmni"
After applying the required patch and running the fixup script all the checks passed.

Below is the full output from the pre-reqs check.
./runcluvfy.sh stage -pre crsinst -upgrade -n rac4,rac5 -rolling -src_crshome /opt/app/11.2.0/grid -dest_crshome /opt/app/11.2.0/grid3 -dest_version 11.2.0.3.0 -fixup -fixupdir /home/oracle/fixupscript -verbose

Performing pre-checks for cluster services setup

Checking node reachability...

Check: Node reachability from node "rac4"
  Destination Node                      Reachable?
  ------------------------------------  ------------------------
  rac4                                  yes
  rac5                                  yes
Result: Node reachability check passed from node "rac4"


Checking user equivalence...

Check: User equivalence for user "oracle"
  Node Name                             Status
  ------------------------------------  ------------------------
  rac5                                  passed
  rac4                                  passed
Result: User equivalence check passed for user "oracle"

Checking CRS user consistency
Result: CRS user consistency check successful

Checking node connectivity...

Checking hosts config file...
  Node Name                             Status
  ------------------------------------  ------------------------
  rac5                                  passed
  rac4                                  passed

Verification of the hosts config file successful


Interface information for node "rac5"
 Name   IP Address      Subnet          Gateway         Def. Gateway    HW Address        MTU
 ------ --------------- --------------- --------------- --------------- ----------------- ------
 eth0   192.168.0.85    192.168.0.0     0.0.0.0         192.168.0.100   08:00:27:68:31:61 1500
 eth0   192.168.0.89    192.168.0.0     0.0.0.0         192.168.0.100   08:00:27:68:31:61 1500
 eth1   192.168.0.87    192.168.0.0     0.0.0.0         192.168.0.100   08:00:27:2B:9C:30 1500


Interface information for node "rac4"
 Name   IP Address      Subnet          Gateway         Def. Gateway    HW Address        MTU
 ------ --------------- --------------- --------------- --------------- ----------------- ------
 eth0   192.168.0.86    192.168.0.0     0.0.0.0         192.168.0.100   08:00:27:C1:59:A3 1500
 eth0   192.168.0.91    192.168.0.0     0.0.0.0         192.168.0.100   08:00:27:C1:59:A3 1500
 eth0   192.168.0.90    192.168.0.0     0.0.0.0         192.168.0.100   08:00:27:C1:59:A3 1500
 eth1   192.168.0.88    192.168.0.0     0.0.0.0         192.168.0.100   08:00:27:7C:F4:94 1500


Check: Node connectivity for interface "eth0"
  Source                          Destination                     Connected?
  ------------------------------  ------------------------------  ----------------
  rac5[192.168.0.85]              rac5[192.168.0.89]              yes
  rac5[192.168.0.85]              rac5[192.168.0.87]              yes
  rac5[192.168.0.85]              rac4[192.168.0.86]              yes
  rac5[192.168.0.85]              rac4[192.168.0.91]              yes
  rac5[192.168.0.85]              rac4[192.168.0.90]              yes
  rac5[192.168.0.85]              rac4[192.168.0.88]              yes
  rac5[192.168.0.89]              rac5[192.168.0.87]              yes
  rac5[192.168.0.89]              rac4[192.168.0.86]              yes
  rac5[192.168.0.89]              rac4[192.168.0.91]              yes
  rac5[192.168.0.89]              rac4[192.168.0.90]              yes
  rac5[192.168.0.89]              rac4[192.168.0.88]              yes
  rac5[192.168.0.87]              rac4[192.168.0.86]              yes
  rac5[192.168.0.87]              rac4[192.168.0.91]              yes
  rac5[192.168.0.87]              rac4[192.168.0.90]              yes
  rac5[192.168.0.87]              rac4[192.168.0.88]              yes
  rac4[192.168.0.86]              rac4[192.168.0.91]              yes
  rac4[192.168.0.86]              rac4[192.168.0.90]              yes
  rac4[192.168.0.86]              rac4[192.168.0.88]              yes
  rac4[192.168.0.91]              rac4[192.168.0.90]              yes
  rac4[192.168.0.91]              rac4[192.168.0.88]              yes
  rac4[192.168.0.90]              rac4[192.168.0.88]              yes
Result: Node connectivity passed for interface "eth0"


Check: TCP connectivity of subnet "192.168.0.0"
  Source                          Destination                     Connected?
  ------------------------------  ------------------------------  ----------------
  rac4:192.168.0.86               rac5:192.168.0.85               passed
  rac4:192.168.0.86               rac5:192.168.0.89               passed
  rac4:192.168.0.86               rac5:192.168.0.87               passed
  rac4:192.168.0.86               rac4:192.168.0.91               passed
  rac4:192.168.0.86               rac4:192.168.0.90               passed
  rac4:192.168.0.86               rac4:192.168.0.88               passed
Result: TCP connectivity check passed for subnet "192.168.0.0"


Check: Node connectivity for interface "eth1"
Checking subnet mask consistency...
Subnet mask consistency check passed for subnet "192.168.0.0".
Subnet mask consistency check passed.

Result: Node connectivity check passed

Checking multicast communication...

Checking subnet "192.168.0.0" for multicast communication with multicast group "230.0.1.0"...
Check of subnet "192.168.0.0" for multicast communication with multicast group "230.0.1.0" passed.

Check of multicast communication passed.

Checking OCR integrity...

OCR integrity check passed

Checking ASMLib configuration.
  Node Name                             Status
  ------------------------------------  ------------------------
  rac5                                  passed
  rac4                                  passed
Result: Check for ASMLib configuration passed.

Check: Total memory
  Node Name     Available                 Required                  Status
  ------------  ------------------------  ------------------------  ----------
  rac5          1.9641GB (2059516.0KB)    1.5GB (1572864.0KB)       passed
  rac4          1.9641GB (2059516.0KB)    1.5GB (1572864.0KB)       passed
Result: Total memory check passed

Check: Available memory
  Node Name     Available                 Required                  Status
  ------------  ------------------------  ------------------------  ----------
  rac5          1004.918MB (1029036.0KB)  50MB (51200.0KB)          passed
  rac4          744.9531MB (762832.0KB)   50MB (51200.0KB)          passed
Result: Available memory check passed

Check: Swap space
  Node Name     Available                 Required                  Status
  ------------  ------------------------  ------------------------  ----------
  rac5          3.9987GB (4192956.0KB)    2.9462GB (3089274.0KB)    passed
  rac4          3.9987GB (4192956.0KB)    2.9462GB (3089274.0KB)    passed
Result: Swap space check passed

Check: Free disk space for "rac5:/opt/app/11.2.0/grid3,rac5:/tmp"
  Path              Node Name     Mount point   Available     Required      Status
  ----------------  ------------  ------------  ------------  ------------  ------------
  /opt/app/11.2.0/grid3  rac5          /             10.4014GB     7.5GB         passed
  /tmp              rac5          /             10.4014GB     7.5GB         passed
Result: Free disk space check passed for "rac5:/opt/app/11.2.0/grid3,rac5:/tmp"

Check: Free disk space for "rac4:/opt/app/11.2.0/grid3,rac4:/tmp"
  Path              Node Name     Mount point   Available     Required      Status
  ----------------  ------------  ------------  ------------  ------------  ------------
  /opt/app/11.2.0/grid3  rac4          /             10.8156GB     7.5GB         passed
  /tmp              rac4          /             10.8156GB     7.5GB         passed
Result: Free disk space check passed for "rac4:/opt/app/11.2.0/grid3,rac4:/tmp"

Check: User existence for "oracle"
  Node Name     Status                    Comment
  ------------  ------------------------  ------------------------
  rac5          passed                    exists(500)
  rac4          passed                    exists(500)

Checking for multiple users with UID value 500
Result: Check for multiple users with UID value 500 passed
Result: User existence check passed for "oracle"

Check: Group existence for "oinstall"
  Node Name     Status                    Comment
  ------------  ------------------------  ------------------------
  rac5          passed                    exists
  rac4          passed                    exists
Result: Group existence check passed for "oinstall"

Check: Membership of user "oracle" in group "oinstall" [as Primary]
  Node Name         User Exists   Group Exists  User in Group  Primary       Status
  ----------------  ------------  ------------  ------------  ------------  ------------
  rac5              yes           yes           yes           yes           passed
  rac4              yes           yes           yes           yes           passed
Result: Membership check for user "oracle" in group "oinstall" [as Primary] passed

Check: Run level
  Node Name     run level                 Required                  Status
  ------------  ------------------------  ------------------------  ----------
  rac5          3                         3,5                       passed
  rac4          3                         3,5                       passed
Result: Run level check passed

Check: Hard limits for "maximum open file descriptors"
  Node Name         Type          Available     Required      Status
  ----------------  ------------  ------------  ------------  ----------------
  rac5              hard          65536         65536         passed
  rac4              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      Status
  ----------------  ------------  ------------  ------------  ----------------
  rac5              soft          1024          1024          passed
  rac4              soft          65536         1024          passed
Result: Soft limits check passed for "maximum open file descriptors"

Check: Hard limits for "maximum user processes"
  Node Name         Type          Available     Required      Status
  ----------------  ------------  ------------  ------------  ----------------
  rac5              hard          16384         16384         passed
  rac4              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      Status
  ----------------  ------------  ------------  ------------  ----------------
  rac5              soft          16383         2047          passed
  rac4              soft          16383         2047          passed
Result: Soft limits check passed for "maximum user processes"

Checking for Oracle patch "9413827" in home "/opt/app/11.2.0/grid".
  Node Name     Applied                   Required                  Comment
  ------------  ------------------------  ------------------------  ----------
  rac5          9413827                   9413827                   passed
  rac4          9413827                   9413827                   passed
Result: Check for Oracle patch "9413827" in home "/opt/app/11.2.0/grid" passed

There are no oracle patches required for home "/opt/app/11.2.0/grid3".

Check: System architecture
  Node Name     Available                 Required                  Status
  ------------  ------------------------  ------------------------  ----------
  rac5          x86_64                    x86_64                    passed
  rac4          x86_64                    x86_64                    passed
Result: System architecture check passed

Check: Kernel version
  Node Name     Available                 Required                  Status
  ------------  ------------------------  ------------------------  ----------
  rac5          2.6.18-194.el5            2.6.18                    passed
  rac4          2.6.18-194.el5            2.6.18                    passed
Result: Kernel version check passed

Check: Kernel parameter for "semmsl"
  Node Name         Current       Configured    Required      Status        Comment
  ----------------  ------------  ------------  ------------  ------------  ------------
  rac5              3010          3010          250           passed
  rac4              3010          3010          250           passed
Result: Kernel parameter check passed for "semmsl"

Check: Kernel parameter for "semmns"
  Node Name         Current       Configured    Required      Status        Comment
  ----------------  ------------  ------------  ------------  ------------  ------------
  rac5              385280        385280        32000         passed
  rac4              385280        385280        32000         passed
Result: Kernel parameter check passed for "semmns"

Check: Kernel parameter for "semopm"
  Node Name         Current       Configured    Required      Status        Comment
  ----------------  ------------  ------------  ------------  ------------  ------------
  rac5              3010          3010          100           passed
  rac4              3010          3010          100           passed
Result: Kernel parameter check passed for "semopm"

Check: Kernel parameter for "semmni"
  Node Name         Current       Configured    Required      Status        Comment
  ----------------  ------------  ------------  ------------  ------------  ------------
  rac5              128           128           128           passed
  rac4              128           128           128           passed
Result: Kernel parameter check passed for "semmni"

Check: Kernel parameter for "shmmax"
  Node Name         Current       Configured    Required      Status        Comment
  ----------------  ------------  ------------  ------------  ------------  ------------
  rac5              68719476736   68719476736   1054472192    passed
  rac4              68719476736   68719476736   1054472192    passed
Result: Kernel parameter check passed for "shmmax"

Check: Kernel parameter for "shmmni"
  Node Name         Current       Configured    Required      Status        Comment
  ----------------  ------------  ------------  ------------  ------------  ------------
  rac5              4096          4096          4096          passed
  rac4              4096          4096          4096          passed
Result: Kernel parameter check passed for "shmmni"

Check: Kernel parameter for "shmall"
  Node Name         Current       Configured    Required      Status        Comment
  ----------------  ------------  ------------  ------------  ------------  ------------
  rac5              4294967296    4294967296    2097152       passed
  rac4              4294967296    4294967296    2097152       passed
Result: Kernel parameter check passed for "shmall"

Check: Kernel parameter for "file-max"
  Node Name         Current       Configured    Required      Status        Comment
  ----------------  ------------  ------------  ------------  ------------  ------------
  rac5              6815744       6815744       6815744       passed
  rac4              6815744       6815744       6815744       passed
Result: Kernel parameter check passed for "file-max"

Check: Kernel parameter for "ip_local_port_range"
  Node Name         Current       Configured    Required      Status        Comment
  ----------------  ------------  ------------  ------------  ------------  ------------
  rac5              between 9000.0 & 65500.0  between 9000.0 & 65500.0  between 9000.0 & 65500.0  passed
  rac4              between 9000.0 & 65500.0  between 9000.0 & 65500.0  between 9000.0 & 65500.0  passed
Result: Kernel parameter check passed for "ip_local_port_range"

Check: Kernel parameter for "rmem_default"
  Node Name         Current       Configured    Required      Status        Comment
  ----------------  ------------  ------------  ------------  ------------  ------------
  rac5              262144        262144        262144        passed
  rac4              262144        262144        262144        passed
Result: Kernel parameter check passed for "rmem_default"

Check: Kernel parameter for "rmem_max"
  Node Name         Current       Configured    Required      Status        Comment
  ----------------  ------------  ------------  ------------  ------------  ------------
  rac5              4194304       4194304       4194304       passed
  rac4              4194304       4194304       4194304       passed
Result: Kernel parameter check passed for "rmem_max"

Check: Kernel parameter for "wmem_default"
  Node Name         Current       Configured    Required      Status        Comment
  ----------------  ------------  ------------  ------------  ------------  ------------
  rac5              262144        262144        262144        passed
  rac4              262144        262144        262144        passed
Result: Kernel parameter check passed for "wmem_default"

Check: Kernel parameter for "wmem_max"
  Node Name         Current       Configured    Required      Status        Comment
  ----------------  ------------  ------------  ------------  ------------  ------------
  rac5              1048576       1048576       1048576       passed
  rac4              1048576       1048576       1048576       passed
Result: Kernel parameter check passed for "wmem_max"

Check: Kernel parameter for "aio-max-nr"
  Node Name         Current       Configured    Required      Status        Comment
  ----------------  ------------  ------------  ------------  ------------  ------------
  rac5              1048576       1048576       1048576       passed
  rac4              1048576       1048576       1048576       passed
Result: Kernel parameter check passed for "aio-max-nr"

Check: Package existence for "make"
  Node Name     Available                 Required                  Status
  ------------  ------------------------  ------------------------  ----------
  rac5          make-3.81-3.el5           make-3.81                 passed
  rac4          make-3.81-3.el5           make-3.81                 passed
Result: Package existence check passed for "make"

Check: Package existence for "binutils"
  Node Name     Available                 Required                  Status
  ------------  ------------------------  ------------------------  ----------
  rac5          binutils-2.17.50.0.6-14.el5  binutils-2.17.50.0.6      passed
  rac4          binutils-2.17.50.0.6-14.el5  binutils-2.17.50.0.6      passed
Result: Package existence check passed for "binutils"

Check: Package existence for "gcc(x86_64)"
  Node Name     Available                 Required                  Status
  ------------  ------------------------  ------------------------  ----------
  rac5          gcc(x86_64)-4.1.2-48.el5  gcc(x86_64)-4.1.2         passed
  rac4          gcc(x86_64)-4.1.2-48.el5  gcc(x86_64)-4.1.2         passed
Result: Package existence check passed for "gcc(x86_64)"

Check: Package existence for "libaio(x86_64)"
  Node Name     Available                 Required                  Status
  ------------  ------------------------  ------------------------  ----------
  rac5          libaio(x86_64)-0.3.106-5  libaio(x86_64)-0.3.106    passed
  rac4          libaio(x86_64)-0.3.106-5  libaio(x86_64)-0.3.106    passed
Result: Package existence check passed for "libaio(x86_64)"

Check: Package existence for "glibc(x86_64)"
  Node Name     Available                 Required                  Status
  ------------  ------------------------  ------------------------  ----------
  rac5          glibc(x86_64)-2.5-49      glibc(x86_64)-2.5-24      passed
  rac4          glibc(x86_64)-2.5-49      glibc(x86_64)-2.5-24      passed
Result: Package existence check passed for "glibc(x86_64)"

Check: Package existence for "compat-libstdc++-33(x86_64)"
  Node Name     Available                 Required                  Status
  ------------  ------------------------  ------------------------  ----------
  rac5          compat-libstdc++-33(x86_64)-3.2.3-61  compat-libstdc++-33(x86_64)-3.2.3  passed
  rac4          compat-libstdc++-33(x86_64)-3.2.3-61  compat-libstdc++-33(x86_64)-3.2.3  passed
Result: Package existence check passed for "compat-libstdc++-33(x86_64)"

Check: Package existence for "elfutils-libelf(x86_64)"
  Node Name     Available                 Required                  Status
  ------------  ------------------------  ------------------------  ----------
  rac5          elfutils-libelf(x86_64)-0.137-3.el5  elfutils-libelf(x86_64)-0.125  passed
  rac4          elfutils-libelf(x86_64)-0.137-3.el5  elfutils-libelf(x86_64)-0.125  passed
Result: Package existence check passed for "elfutils-libelf(x86_64)"

Check: Package existence for "elfutils-libelf-devel"
  Node Name     Available                 Required                  Status
  ------------  ------------------------  ------------------------  ----------
  rac5          elfutils-libelf-devel-0.137-3.el5  elfutils-libelf-devel-0.125  passed
  rac4          elfutils-libelf-devel-0.137-3.el5  elfutils-libelf-devel-0.125  passed
Result: Package existence check passed for "elfutils-libelf-devel"

Check: Package existence for "glibc-common"
  Node Name     Available                 Required                  Status
  ------------  ------------------------  ------------------------  ----------
  rac5          glibc-common-2.5-49       glibc-common-2.5          passed
  rac4          glibc-common-2.5-49       glibc-common-2.5          passed
Result: Package existence check passed for "glibc-common"

Check: Package existence for "glibc-devel(x86_64)"
  Node Name     Available                 Required                  Status
  ------------  ------------------------  ------------------------  ----------
  rac5          glibc-devel(x86_64)-2.5-49  glibc-devel(x86_64)-2.5   passed
  rac4          glibc-devel(x86_64)-2.5-49  glibc-devel(x86_64)-2.5   passed
Result: Package existence check passed for "glibc-devel(x86_64)"

Check: Package existence for "glibc-headers"
  Node Name     Available                 Required                  Status
  ------------  ------------------------  ------------------------  ----------
  rac5          glibc-headers-2.5-49      glibc-headers-2.5         passed
  rac4          glibc-headers-2.5-49      glibc-headers-2.5         passed
Result: Package existence check passed for "glibc-headers"

Check: Package existence for "gcc-c++(x86_64)"
  Node Name     Available                 Required                  Status
  ------------  ------------------------  ------------------------  ----------
  rac5          gcc-c++(x86_64)-4.1.2-48.el5  gcc-c++(x86_64)-4.1.2     passed
  rac4          gcc-c++(x86_64)-4.1.2-48.el5  gcc-c++(x86_64)-4.1.2     passed
Result: Package existence check passed for "gcc-c++(x86_64)"

Check: Package existence for "libaio-devel(x86_64)"
  Node Name     Available                 Required                  Status
  ------------  ------------------------  ------------------------  ----------
  rac5          libaio-devel(x86_64)-0.3.106-5  libaio-devel(x86_64)-0.3.106  passed
  rac4          libaio-devel(x86_64)-0.3.106-5  libaio-devel(x86_64)-0.3.106  passed
Result: Package existence check passed for "libaio-devel(x86_64)"

Check: Package existence for "libgcc(x86_64)"
  Node Name     Available                 Required                  Status
  ------------  ------------------------  ------------------------  ----------
  rac5          libgcc(x86_64)-4.1.2-48.el5  libgcc(x86_64)-4.1.2      passed
  rac4          libgcc(x86_64)-4.1.2-48.el5  libgcc(x86_64)-4.1.2      passed
Result: Package existence check passed for "libgcc(x86_64)"

Check: Package existence for "libstdc++(x86_64)"
  Node Name     Available                 Required                  Status
  ------------  ------------------------  ------------------------  ----------
  rac5          libstdc++(x86_64)-4.1.2-48.el5  libstdc++(x86_64)-4.1.2   passed
  rac4          libstdc++(x86_64)-4.1.2-48.el5  libstdc++(x86_64)-4.1.2   passed
Result: Package existence check passed for "libstdc++(x86_64)"

Check: Package existence for "libstdc++-devel(x86_64)"
  Node Name     Available                 Required                  Status
  ------------  ------------------------  ------------------------  ----------
  rac5          libstdc++-devel(x86_64)-4.1.2-48.el5  libstdc++-devel(x86_64)-4.1.2  passed
  rac4          libstdc++-devel(x86_64)-4.1.2-48.el5  libstdc++-devel(x86_64)-4.1.2  passed
Result: Package existence check passed for "libstdc++-devel(x86_64)"

Check: Package existence for "sysstat"
  Node Name     Available                 Required                  Status
  ------------  ------------------------  ------------------------  ----------
  rac5          sysstat-7.0.2-3.el5       sysstat-7.0.2             passed
  rac4          sysstat-7.0.2-3.el5       sysstat-7.0.2             passed
Result: Package existence check passed for "sysstat"

Check: Package existence for "ksh"
  Node Name     Available                 Required                  Status
  ------------  ------------------------  ------------------------  ----------
  rac5          ksh-20100202-1.el5        ksh-20060214              passed
  rac4          ksh-20100202-1.el5        ksh-20060214              passed
Result: Package existence check passed for "ksh"

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

Starting check for consistency of primary group of root user
  Node Name                             Status
  ------------------------------------  ------------------------
  rac5                                  passed
  rac4                                  passed

Check for consistency of root user's primary group passed

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
No NTP Daemons or Services were found to be running

Result: Clock synchronization check using Network Time Protocol(NTP) 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
  ------------  ------------------------  ------------------------
  rac5          passed                    does not exist
  rac4          passed                    does not exist
Result: User "oracle" is not part of "root" group. Check passed

Check default user file creation mask
  Node Name     Available                 Required                  Comment
  ------------  ------------------------  ------------------------  ----------
  rac5          0022                      0022                      passed
  rac4          0022                      0022                      passed
Result: Default user file creation mask check passed
Checking consistency of file "/etc/resolv.conf" across nodes

Checking the file "/etc/resolv.conf" to make sure only one of domain and search entries is defined
File "/etc/resolv.conf" does not have both domain and search entries defined
Checking if domain entry in file "/etc/resolv.conf" is consistent across the nodes...
domain entry in file "/etc/resolv.conf" is consistent across nodes
Checking if search entry in file "/etc/resolv.conf" is consistent across the nodes...
search entry in file "/etc/resolv.conf" is consistent across nodes
Checking file "/etc/resolv.conf" to make sure that only one search entry is defined
All nodes have one search entry defined in file "/etc/resolv.conf"
Checking all nodes to make sure that search entry is "domain.net" as found on node "rac5"
All nodes of the cluster have same value for 'search'
Checking DNS response time for an unreachable node
  Node Name                             Status
  ------------------------------------  ------------------------
  rac5                                  passed
  rac4                                  passed
The DNS response time for an unreachable node is within acceptable limit on all nodes

File "/etc/resolv.conf" is consistent across nodes


UDev attributes check for OCR locations started...
Result: UDev attributes check passed for OCR locations


UDev attributes check for Voting Disk locations started...
Result: UDev attributes check passed for Voting Disk locations

Check: Time zone consistency
Result: Time zone consistency check passed
Checking VIP configuration.
Checking VIP Subnet configuration.
Check for VIP Subnet configuration passed.
Checking VIP reachability
Check for VIP reachability passed.

Checking Oracle Cluster Voting Disk configuration...
ASM Running check passed. ASM is running on all specified nodes
Oracle Cluster Voting Disk configuration check passed
Clusterware version consistency passed
Pre-check for cluster services setup was successful.
Resolve any failed pre-reqs steps before proceeding. Metalink notes at the end and from two earlier posts may help in resolving some of the issues.

As stated on Oracle documentation GI upgrades are rolling upgrades even though all instances are selected. Below is the status of the cluster before the start of software installation.(crs_stat is depreciated)
crs_stat -t
Name           Type           Target    State     Host
------------------------------------------------------------
ora....ERDG.dg ora....up.type ONLINE    ONLINE    rac4
ora.DATA.dg    ora....up.type ONLINE    ONLINE    rac4
ora.FLASH.dg   ora....up.type ONLINE    ONLINE    rac4
ora....ER.lsnr ora....er.type ONLINE    ONLINE    rac4
ora....N1.lsnr ora....er.type ONLINE    ONLINE    rac4
ora.asm        ora.asm.type   ONLINE    ONLINE    rac4
ora.eons       ora.eons.type  ONLINE    ONLINE    rac4
ora.gsd        ora.gsd.type   OFFLINE   OFFLINE
ora....network ora....rk.type ONLINE    ONLINE    rac4
ora.oc4j       ora.oc4j.type  OFFLINE   OFFLINE
ora.ons        ora.ons.type   ONLINE    ONLINE    rac4
ora.rac11g2.db ora....se.type ONLINE    ONLINE    rac4
ora....SM1.asm application    ONLINE    ONLINE    rac4
ora....C4.lsnr application    ONLINE    ONLINE    rac4
ora.rac4.gsd   application    OFFLINE   OFFLINE
ora.rac4.ons   application    ONLINE    ONLINE    rac4
ora.rac4.vip   ora....t1.type ONLINE    ONLINE    rac4
ora....SM2.asm application    ONLINE    ONLINE    rac5
ora....C5.lsnr application    ONLINE    ONLINE    rac5
ora.rac5.gsd   application    OFFLINE   OFFLINE
ora.rac5.ons   application    ONLINE    ONLINE    rac5
ora.rac5.vip   ora....t1.type ONLINE    ONLINE    rac5
ora....ry.acfs ora....fs.type ONLINE    ONLINE    rac4
ora.scan1.vip  ora....ip.type ONLINE    ONLINE    rac4
Unset Oracle environment variables
$ unset ORACLE_BASE
$ unset ORACLE_HOME
$ unset ORACLE_SID
and run the 11.2.0.3 installer

By default all the nodes are selected but cluster could be upgraded in a rolling fashion.

Select a new location for the out of place upgrade

The rolling upgrade begins with the running of rootupgrade.sh. Up until this point the exisitng cluster was up and running. Running rootupgrade.sh one node at a time will achieve the rolling upgrade.

To illustrate the rolling upgrade one instance is shutdown before the running of rootupgrade.sh (this is not necessary as rootupgrade.sh will shutdown all cluster related resources on the node which rootupgrade.sh is run).
srvctl stop home -o $ORACLE_HOME -s status -n rac4
srvctl status database -d rac11g2
Instance rac11g21 is not running on node rac4
Instance rac11g22 is running on node rac5
Instance rac11g22 will remain open on rac5 while rac4 is being upgraded.
# ./rootupgrade.sh
Performing root user operation for Oracle 11g

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 script.
Now product-specific root actions will be performed.
Using configuration parameter file: /opt/app/11.2.0/grid3/crs/install/crsconfig_params
Creating trace directory

ASM upgrade has started on first node.

CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'rac4'
CRS-2673: Attempting to stop 'ora.crsd' on 'rac4'
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'rac4'
CRS-2673: Attempting to stop 'ora.CLUSTERDG.dg' on 'rac4'
CRS-2673: Attempting to stop 'ora.registry.acfs' on 'rac4'
CRS-2673: Attempting to stop 'ora.DATA.dg' on 'rac4'
CRS-2673: Attempting to stop 'ora.FLASH.dg' on 'rac4'
CRS-2673: Attempting to stop 'ora.LISTENER_SCAN1.lsnr' on 'rac4'
CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'rac4'
CRS-2677: Stop of 'ora.registry.acfs' on 'rac4' succeeded
CRS-2677: Stop of 'ora.LISTENER_SCAN1.lsnr' on 'rac4' succeeded
CRS-2673: Attempting to stop 'ora.scan1.vip' on 'rac4'
CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'rac4' succeeded
CRS-2673: Attempting to stop 'ora.rac4.vip' on 'rac4'
CRS-2677: Stop of 'ora.scan1.vip' on 'rac4' succeeded
CRS-2672: Attempting to start 'ora.scan1.vip' on 'rac5'
CRS-2677: Stop of 'ora.rac4.vip' on 'rac4' succeeded
CRS-2672: Attempting to start 'ora.rac4.vip' on 'rac5'
CRS-2676: Start of 'ora.scan1.vip' on 'rac5' succeeded
CRS-2672: Attempting to start 'ora.LISTENER_SCAN1.lsnr' on 'rac5'
CRS-2676: Start of 'ora.rac4.vip' on 'rac5' succeeded
CRS-2676: Start of 'ora.LISTENER_SCAN1.lsnr' on 'rac5' succeeded
CRS-2677: Stop of 'ora.CLUSTERDG.dg' on 'rac4' succeeded
CRS-2677: Stop of 'ora.DATA.dg' on 'rac4' succeeded
CRS-2677: Stop of 'ora.FLASH.dg' on 'rac4' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'rac4'
CRS-2677: Stop of 'ora.asm' on 'rac4' succeeded
CRS-2673: Attempting to stop 'ora.eons' on 'rac4'
CRS-2673: Attempting to stop 'ora.ons' on 'rac4'
CRS-2677: Stop of 'ora.ons' on 'rac4' succeeded
CRS-2673: Attempting to stop 'ora.net1.network' on 'rac4'
CRS-2677: Stop of 'ora.net1.network' on 'rac4' succeeded
CRS-2677: Stop of 'ora.eons' on 'rac4' succeeded
CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'rac4' has completed
CRS-2677: Stop of 'ora.crsd' on 'rac4' succeeded
CRS-2673: Attempting to stop 'ora.gpnpd' on 'rac4'
CRS-2673: Attempting to stop 'ora.cssdmonitor' on 'rac4'
CRS-2673: Attempting to stop 'ora.ctssd' on 'rac4'
CRS-2673: Attempting to stop 'ora.evmd' on 'rac4'
CRS-2673: Attempting to stop 'ora.asm' on 'rac4'
CRS-2673: Attempting to stop 'ora.mdnsd' on 'rac4'
CRS-2673: Attempting to stop 'ora.drivers.acfs' on 'rac4'
CRS-2677: Stop of 'ora.cssdmonitor' on 'rac4' succeeded
CRS-2677: Stop of 'ora.gpnpd' on 'rac4' succeeded
CRS-2677: Stop of 'ora.evmd' on 'rac4' succeeded
CRS-2677: Stop of 'ora.mdnsd' on 'rac4' succeeded
CRS-2677: Stop of 'ora.ctssd' on 'rac4' succeeded
CRS-2677: Stop of 'ora.drivers.acfs' on 'rac4' succeeded
CRS-2677: Stop of 'ora.asm' on 'rac4' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'rac4'
CRS-2677: Stop of 'ora.cssd' on 'rac4' succeeded
CRS-2673: Attempting to stop 'ora.diskmon' on 'rac4'
CRS-2673: Attempting to stop 'ora.gipcd' on 'rac4'
CRS-2677: Stop of 'ora.gipcd' on 'rac4' succeeded
CRS-2677: Stop of 'ora.diskmon' on 'rac4' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'rac4' has completed
CRS-4133: Oracle High Availability Services has been stopped.
OLR initialization - successful
Replacing Clusterware entries in inittab
clscfg: EXISTING configuration version 5 detected.
clscfg: version 5 is 11g Release 2.
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
Preparing packages for installation...
cvuqdisk-1.0.9-1
Configure Oracle Grid Infrastructure for a Cluster ... succeeded
At the end of the upgrade script run the shutdown instance will be up.
srvctl status database -d rac11g2
Instance rac11g21 is running on node rac4
Instance rac11g22 is running on node rac5
Node rac5 is upgraded next.
srvctl stop home -o $ORACLE_HOME -s status -n rac5
srvctl status database -d rac11g2
Instance rac11g21 is running on node rac4
Instance rac11g22 is not running on node rac5
Now rac11g21 on rac4 will remain open while rac5 is upgraded. (shutdown of instance is not necessary)
# ./rootupgrade.sh
Performing root user operation for Oracle 11g

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 script.
Now product-specific root actions will be performed.
Using configuration parameter file: /opt/app/11.2.0/grid3/crs/install/crsconfig_params
Creating trace directory
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'rac5'
CRS-2673: Attempting to stop 'ora.crsd' on 'rac5'
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'rac5'
CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'rac5'
CRS-2673: Attempting to stop 'ora.CLUSTERDG.dg' on 'rac5'
CRS-2673: Attempting to stop 'ora.registry.acfs' on 'rac5'
CRS-2673: Attempting to stop 'ora.DATA.dg' on 'rac5'
CRS-2673: Attempting to stop 'ora.FLASH.dg' on 'rac5'
CRS-2673: Attempting to stop 'ora.LISTENER_SCAN1.lsnr' on 'rac5'
CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'rac5' succeeded
CRS-2673: Attempting to stop 'ora.rac5.vip' on 'rac5'
CRS-2677: Stop of 'ora.rac5.vip' on 'rac5' succeeded
CRS-2672: Attempting to start 'ora.rac5.vip' on 'rac4'
CRS-2677: Stop of 'ora.registry.acfs' on 'rac5' succeeded
CRS-2677: Stop of 'ora.LISTENER_SCAN1.lsnr' on 'rac5' succeeded
CRS-2673: Attempting to stop 'ora.scan1.vip' on 'rac5'
CRS-2676: Start of 'ora.rac5.vip' on 'rac4' succeeded
CRS-2677: Stop of 'ora.scan1.vip' on 'rac5' succeeded
CRS-2672: Attempting to start 'ora.scan1.vip' on 'rac4'
CRS-2676: Start of 'ora.scan1.vip' on 'rac4' succeeded
CRS-2672: Attempting to start 'ora.LISTENER_SCAN1.lsnr' on 'rac4'
CRS-2676: Start of 'ora.LISTENER_SCAN1.lsnr' on 'rac4' succeeded
CRS-2677: Stop of 'ora.CLUSTERDG.dg' on 'rac5' succeeded
CRS-2677: Stop of 'ora.DATA.dg' on 'rac5' succeeded
CRS-2677: Stop of 'ora.FLASH.dg' on 'rac5' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'rac5'
CRS-2677: Stop of 'ora.asm' on 'rac5' succeeded
CRS-2673: Attempting to stop 'ora.eons' on 'rac5'
CRS-2673: Attempting to stop 'ora.ons' on 'rac5'
CRS-2677: Stop of 'ora.ons' on 'rac5' succeeded
CRS-2673: Attempting to stop 'ora.net1.network' on 'rac5'
CRS-2677: Stop of 'ora.net1.network' on 'rac5' succeeded
CRS-2677: Stop of 'ora.eons' on 'rac5' succeeded
CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'rac5' has completed
CRS-2677: Stop of 'ora.crsd' on 'rac5' succeeded
CRS-2673: Attempting to stop 'ora.cssdmonitor' on 'rac5'
CRS-2673: Attempting to stop 'ora.ctssd' on 'rac5'
CRS-2673: Attempting to stop 'ora.evmd' on 'rac5'
CRS-2673: Attempting to stop 'ora.asm' on 'rac5'
CRS-2673: Attempting to stop 'ora.drivers.acfs' on 'rac5'
CRS-2673: Attempting to stop 'ora.mdnsd' on 'rac5'
CRS-2677: Stop of 'ora.cssdmonitor' on 'rac5' succeeded
CRS-2677: Stop of 'ora.evmd' on 'rac5' succeeded
CRS-2677: Stop of 'ora.mdnsd' on 'rac5' succeeded
CRS-2677: Stop of 'ora.ctssd' on 'rac5' succeeded
CRS-2677: Stop of 'ora.drivers.acfs' on 'rac5' succeeded
CRS-2677: Stop of 'ora.asm' on 'rac5' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'rac5'
CRS-2677: Stop of 'ora.cssd' on 'rac5' succeeded
CRS-2673: Attempting to stop 'ora.gpnpd' on 'rac5'
CRS-2673: Attempting to stop 'ora.diskmon' on 'rac5'
CRS-2677: Stop of 'ora.gpnpd' on 'rac5' succeeded
CRS-2673: Attempting to stop 'ora.gipcd' on 'rac5'
CRS-2677: Stop of 'ora.diskmon' on 'rac5' succeeded
CRS-2677: Stop of 'ora.gipcd' on 'rac5' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'rac5' has completed
CRS-4133: Oracle High Availability Services has been stopped.
OLR initialization - successful
Replacing Clusterware entries in inittab
clscfg: EXISTING configuration version 5 detected.
clscfg: version 5 is 11g Release 2.
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
Started to upgrade the Oracle Clusterware. This operation may take a few minutes.
Started to upgrade the CSS.
Started to upgrade the CRS.
The CRS was successfully upgraded.
Oracle Clusterware operating version was successfully set to 11.2.0.3.0
ASM upgrade has finished on last node.
Preparing packages for installation...
cvuqdisk-1.0.9-1
Configure Oracle Grid Infrastructure for a Cluster ... succeeded
After the uprade script run instance is up and running
srvctl status database -d rac11g2
Instance rac11g21 is running on node rac4
Instance rac11g22 is running on node rac5
Click the ok button on the popup window and continue the remaining steps.
Check the clusterware version has changed to 11.2.0.3
crsctl query crs activeversion
Oracle Clusterware active version on the cluster is [11.2.0.3.0]
crsctl query crs softwareversion
Oracle Clusterware version on node [rac5] is [11.2.0.3.0]
crsctl query crs softwareversion rac4
Oracle Clusterware version on node [rac4] is [11.2.0.3.0]
Next step is to upgrade the Oracle database software. In this case it will be done as an in-place upgrade (which is not recommended by Oracle). Oracle In-place documentation.




Inplace upgrade would require all instances to be shutdown.
srvctl stop home -o $ORACLE_HOME -s status -n `hostname -s`  # run on all nodes
Make a backup of following files and folders in the existing Oracle home (11.2.0.1 in this case)
ORACLE_HOME/dbs
ORACLE_HOME/network/admin
ORACLE_HOME/owb/bin/admin
ORACLE_HOME/hostname_dbname
ORACLE_HOME/oc4j/j2ee/OC4J_DBConsole_hostname_dbname
Following shell command can speed things up

cd $ORACLE_HOME
tar -cvzf 11.2.tgz ./dbs ./network/admin ./owb/bin/admin ./`hostname`_$ORACLE_SID ./oc4j/j2ee/OC4J_DBConsole_`hostname`_$ORACLE_SID
To install the new software inplace the current oracle home must be detached from the inventory.
cat inventory.xml
...
<HOME NAME="OraDb11g_home1" LOC="/opt/app/oracle/product/11.2.0/db_1" TYPE="O" IDX="2">
   <NODE_LIST>
      <NODE NAME="rac4"/>
      <NODE NAME="rac5"/>
   </NODE_LIST>
</HOME>
...

/opt/app/oracle/product/11.2.0/db_1/oui/bin/runInstaller -detachHome ORACLE_HOME="/opt/app/oracle/product/11.2.0/db_1"
Starting Oracle Universal Installer...

Checking swap space: must be greater than 500 MB.   Actual 3912 MB    Passed
The inventory pointer is located at /etc/oraInst.loc
The inventory is located at /opt/app/oraInventory
'DetachHome' was successful.
If there's space move the existing Oracle home to a temporary location. If not remove it and create an empty directory for the new software.

Run installer from the new Oracle software directory and select software only option.
Specify the same location as the installation path
SCAN IP now must be resolved through DNS. (This could be ignored and continue)
Once the installation is completed copy back the files that were backed up earlier.

Run DBUA from the newly installed Oracle home.
After upgrade

To uninstall old GI
# chmod -R 755 /opt/app/11.2.0/grid
# chown -R oracle /opt/app/11.2.0/grid
# chown oracle /opt/app/11.2.0 (change it back to root after uninstall if not old GI home directory will not be removed)
Use the standalone deinstall tool to remove the old GI home
./deinstall -home /opt/app/11.2.0/grid -local
Location of logs /opt/app/oraInventory/logs/

############ ORACLE DEINSTALL & DECONFIG TOOL START ############
######################### CHECK OPERATION START #########################
## [START] Install check configuration ##

Checking for existence of the Oracle home location /opt/app/11.2.0/grid
Oracle Home type selected for deinstall is: Oracle Grid Infrastructure for a Cluster
Oracle Base selected for deinstall is: /opt/app/oracle
Checking for existence of central inventory location /opt/app/oraInventory
Checking for existence of the Oracle Grid Infrastructure home /opt/app/11.2.0/grid3
The following nodes are part of this cluster: rac4,rac5
Checking for sufficient temp space availability on node(s) : 'rac4,rac5'

## [END] Install check configuration ##

Traces log file: /opt/app/oraInventory/logs//crsdc.log
Network Configuration check config START
Network de-configuration trace file location: /opt/app/oraInventory/logs/netdc_check2012-02-17_06-14-02-PM.log
Network Configuration check config END
Asm Check Configuration START
ASM de-configuration trace file location: /opt/app/oraInventory/logs/asmcadc_check2012-02-17_06-14-03-PM.log

######################### CHECK OPERATION END #########################
####################### CHECK OPERATION SUMMARY #######################
Oracle Grid Infrastructure Home is: /opt/app/11.2.0/grid3
The cluster node(s) on which the Oracle home deinstallation will be performed are:rac4,rac5
Since -local option has been specified, the Oracle home will be deinstalled only on the local node, 'rac4', and the global configuration will be removed.
Oracle Home selected for deinstall is: /opt/app/11.2.0/grid
Inventory Location where the Oracle home registered is: /opt/app/oraInventory
The home being deconfigured is NOT a configured Grid Infrastructure home (/opt/app/11.2.0/grid3)
Option -local will not modify any ASM configuration.
Do you want to continue (y - yes, n - no)? [n]: Y
A log of this session will be written to: '/opt/app/oraInventory/logs/deinstall_deconfig2012-02-17_06-13-57-PM.out'
Any error messages from this session will be written to: '/opt/app/oraInventory/logs/deinstall_deconfig2012-02-17_06-13-57-PM.err'

######################## CLEAN OPERATION START ########################
ASM de-configuration trace file location: /opt/app/oraInventory/logs/asmcadc_clean2012-02-17_06-14-29-PM.log
ASM Clean Configuration END
Network Configuration clean config START
Network de-configuration trace file location: /opt/app/oraInventory/logs/netdc_clean2012-02-17_06-14-29-PM.log
De-configuring Naming Methods configuration file...
Naming Methods configuration file de-configured successfully.

De-configuring backup files...
Backup files de-configured successfully.
The network configuration has been cleaned up successfully.
Network Configuration clean config END
Setting the force flag to false
Setting the force flag to cleanup the Oracle Base
Oracle Universal Installer clean START

Detach Oracle home '/opt/app/11.2.0/grid' from the central inventory on the local node : Done
The Oracle Base directory '/opt/app/oracle' will not be removed on local node. The directory is in use by Oracle Home '/opt/app/11.2.0/grid3'.

Oracle Universal Installer cleanup was successful.
Oracle Universal Installer clean END

## [START] Oracle install clean ##

Clean install operation removing temporary directory '/tmp/deinstall2012-02-17_06-13-56PM' on node 'rac4'

## [END] Oracle install clean ##


######################### CLEAN OPERATION END #########################
####################### CLEAN OPERATION SUMMARY #######################
The home being deconfigured is NOT a configured Grid Infrastructure home (/opt/app/11.2.0/grid3)
Successfully detached Oracle home '/opt/app/11.2.0/grid' from the central inventory on the local node.
Failed to delete directory '/opt/app/11.2.0/grid' on the local node.
Oracle Universal Installer cleanup was successful.

Oracle deinstall tool successfully cleaned up temporary directories.
#######################################################################
############# ORACLE DEINSTALL & DECONFIG TOOL END #############


Useful metalink notes
Oracle Grid Infrastructure 11.2.0.2 Installation or Upgrade may fail due to Multicasting Requirement [ID 1212703.1]
Pre-requsite for 11.2.0.1 to 11.2.0.2 ASM Rolling Upgrade [ID 1274629.1]
11.2.0.1 to 11.2.0.2 ASM Rolling Upgrade [ID 1274629.1]
Things to Consider Before Upgrading to 11.2.0.3 Grid Infrastructure/ASM [ID 1363369.1]
Oracle Clusterware (CRS or GI) Rolling Upgrades [ID 338706.1]
More metalink notes

Monday, February 13, 2012

In-place upgrade from 11.2.0.2 to 11.2.0.3

When using 11.2 the preferred method for upgrade is out of place upgrade. But it is possible to do an in-place upgrade if the situation offer no other option (eg. hard disk space constraints). It is possible to do in-place upgrade to single instance and RAC Oracle homes. Oracle upgrade guide provide more information on this. Before proceeding it must be stated that "Oracle strongly recommends that you do not upgrade Oracle Database to release 11.2.0.2 or 11.2.0.3 using the existing Oracle home." (from upgrade guide)

This blog uses a single instance standard edition oracle home to upgrade from 11.2.0.2 to 11.2.0.3.

1. Make a backup of following files and folders in the existing Oracle home (11.2.0.2 in this case)
ORACLE_HOME/dbs
ORACLE_HOME/network/admin
ORACLE_HOME/owb/bin/admin
ORACLE_HOME/hostname_dbname
ORACLE_HOME/oc4j/j2ee/OC4J_DBConsole_hostname_dbname
Following shell command can speed things up
cd $ORACLE_HOME
tar -cvzf 11.2.tgz ./dbs ./network/admin ./owb/bin/admin ./`hostname`_$ORACLE_SID ./oc4j/j2ee/OC4J_DBConsole_`hostname`_$ORACLE_SID
2. Find out the Oracle Home name from the inventory.xml
<HOME_LIST>
<HOME NAME="enterprise_11g1" LOC="/opt/app/oracle/product/11.1.0/ent" TYPE="O" IDX="4"/>
<HOME NAME="standard_11g1" LOC="/opt/app/oracle/product/11.1.0/std" TYPE="O" IDX="5"/>
<HOME NAME="enterprise_10g2" LOC="/opt/app/oracle/product/10.2.0/ent" TYPE="O" IDX="6"/>
<HOME NAME="standard_10g2" LOC="/opt/app/oracle/product/10.2.0/std" TYPE="O" IDX="7"/>
<HOME NAME="OraDb11g_home1" LOC="/opt/app/oracle/product/11.2.0/std3" TYPE="O" IDX="1"/>
<HOME NAME="OraDb11g_home2" LOC="/opt/app/oracle/product/11.2.0/ent11.2.0.3" TYPE="O" IDX="10"/>
<HOME NAME="agent12g1" LOC="/opt/app/oracle/grid_agent/agent11g/agent12g/core/12.1.0.1.0" TYPE="O" IDX="12">
   <REFHOMELIST>
      <REFHOME LOC="/opt/app/oracle/grid_agent/agent11g/agent12g/plugins/oracle.sysman.db.agent.plugin_12.1.0.1.0"/>
      <REFHOME LOC="/opt/app/oracle/grid_agent/agent11g/agent12g/plugins/oracle.sysman.db.discovery.plugin_12.1.0.1.0"/>
      <REFHOME LOC="/opt/app/oracle/grid_agent/agent11g/agent12g/plugins/oracle.sysman.oh.agent.plugin_12.1.0.1.0"/>
      <REFHOME LOC="/opt/app/oracle/grid_agent/agent11g/agent12g/plugins/oracle.sysman.oh.discovery.plugin_12.1.0.1.0"/>
   </REFHOMELIST>
</HOME>
3. Detach the Oracle home from the inventory
$ORACLE_HOME/oui/bin/runInstaller -detachHome ORACLE_HOME="/opt/app/oracle/product/11.2.0/std3"
Starting Oracle Universal Installer...

Checking swap space: must be greater than 500 MB.   Actual 12001 MB    Passed
The inventory pointer is located at /etc/oraInst.loc
The inventory is located at /opt/app/oraInventory
'DetachHome' was successful.
This would remove the Oracle home entry from the inventory.xml
<HOME_LIST>
<HOME NAME="enterprise_11g1" LOC="/opt/app/oracle/product/11.1.0/ent" TYPE="O" IDX="4"/>
<HOME NAME="standard_11g1" LOC="/opt/app/oracle/product/11.1.0/std" TYPE="O" IDX="5"/>
<HOME NAME="enterprise_10g2" LOC="/opt/app/oracle/product/10.2.0/ent" TYPE="O" IDX="6"/>
<HOME NAME="standard_10g2" LOC="/opt/app/oracle/product/10.2.0/std" TYPE="O" IDX="7"/>
<HOME NAME="OraDb11g_home2" LOC="/opt/app/oracle/product/11.2.0/ent11.2.0.3" TYPE="O" IDX="10"/>
<HOME NAME="agent12g1" LOC="/opt/app/oracle/grid_agent/agent11g/agent12g/core/12.1.0.1.0" TYPE="O" IDX="12">
   <REFHOMELIST>
      <REFHOME LOC="/opt/app/oracle/grid_agent/agent11g/agent12g/plugins/oracle.sysman.db.agent.plugin_12.1.0.1.0"/>
      <REFHOME LOC="/opt/app/oracle/grid_agent/agent11g/agent12g/plugins/oracle.sysman.db.discovery.plugin_12.1.0.1.0"/>
      <REFHOME LOC="/opt/app/oracle/grid_agent/agent11g/agent12g/plugins/oracle.sysman.oh.agent.plugin_12.1.0.1.0"/>
      <REFHOME LOC="/opt/app/oracle/grid_agent/agent11g/agent12g/plugins/oracle.sysman.oh.discovery.plugin_12.1.0.1.0"/>
   </REFHOMELIST>
</HOME>
4. Remove or move the existing Oracle home to new location
mv std3 std3.bak
5. Install the new version from the patch set using the same location
6.Untar (unzip) the earlier backed up folders into new oracle home.
7. Start listener on the new oracle home.

8. Run DBUA from new oracle home and upgrade the database. Below screenshot shows Oracle home value for current and target database is same.
Upgrade summary
Useful metalink notes
Important Changes to Oracle Database Patch Sets Starting With 11.2.0.2 [ID 1189783.1]
Oracle Database Upgrade Path Reference List [ID 730365.1]

Saturday, February 11, 2012

Upgrading Grid Control 11g to 12c - 2

Earlier post showed the installing of pre-upgrade patch and switching agents to 12c. This post shows the rest of the upgrade steps which is upgrading of OMS and deinstalling the old OMS and agents.

Download the new Grid control software, copy the downloaded files to the host where grid control is currently installed and unzip the two files.

Shutdown the OMS with
emctl stop oms
It is important to stop it without the "-all" option. If the OMS is stopped with "-all" option then following warning will appear during the upgrade.
Another thing that can come up is the following error.
To fix this start the OMS and run
emctl config emkey -copy_to_repos -sysman_pwd gridb321
Oracle Enterprise Manager 11g Release 1 Grid Control
Copyright (c) 1996, 2010 Oracle Corporation.  All rights reserved.
The EMKey has been copied to the Management Repository. This operation will cause the EMKey to become unsecure.
After the required operation has been completed, secure the EMKey by running "emctl config emkey -remove_from_repos".
After this stop the oms again (without the -all option) and rerun the installer.

There other warnings and errors where some would allow to continue whereas others would require some steps to correct these warnings.



To fix these warnings
SQL> grant execute on dbms_random to dbsnmp;
Grant succeeded.

SQL> grant execute on dbms_random to sysman;
Grant succeeded.

SQL> select account_status,username from dba_users where username='ORACLE_OCM';

ACCOUNT_STATUS     USERNAME
------------------ -----------
EXPIRED & LOCKED   ORACLE_OCM

SQL> alter user oracle_ocm account unlock;
User altered.

SQL> alter user oracle_ocm identified by ******;
User altered.

SQL> select * from v$log;

    GROUP#    THREAD#  SEQUENCE#      BYTES    MEMBERS ARC STATUS           FIRST_CHANGE# FIRST_TIM
---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ---------
         1          1        376   52428800          2 YES INACTIVE               6438727 10-FEB-12
         2          1        377   52428800          2 YES INACTIVE               6452498 10-FEB-12
         3          1        378   52428800          2 NO  CURRENT                6483486 10-FEB-12

SQL> alter database drop logfile group 1; -- do for other groups as well
Database altered.

SQL> alter database add logfile group 1 size 300M;
Database altered.

SQL>  select * from v$log;

    GROUP#    THREAD#  SEQUENCE#      BYTES    MEMBERS ARC STATUS           FIRST_CHANGE# FIRST_TIM
---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ---------
         1          1        379  314572800          2 NO  CURRENT                6521242 10-FEB-12
         2          1          0  314572800          2 YES UNUSED                       0
         3          1          0  314572800          2 YES UNUSED                       0
Some steps (eg step 5) in the install process take longer to complete and at times there will be movement on the progress bar. It is not stuck and it will help to keep and eye on the logs as well. Logs for installation is available in Middleware12/oms/sysman/logs (Middleware12 is directory for new installation). As part of the install WebLogic server 10.3.5 will be installed.











# /opt/app/oracle/Middleware12/oms/allroot.sh

Starting to execute allroot.sh .........

Starting to execute /opt/app/oracle/Middleware12/oms/root.sh ......
Running Oracle 11g root.sh script...

The following environment variables are set as:
    ORACLE_OWNER= oracle
    ORACLE_HOME=  /opt/app/oracle/Middleware12/oms

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.
/etc exist
/opt/app/oracle/Middleware12/oms
Finished execution of  /opt/app/oracle/Middleware12/oms/root.sh ......
At the end of the upgrade the 12c agents switched earlier can now communicate with the OMS. Checking the status of the agents shows
emctl  status agent
Oracle Enterprise Manager 12c Cloud Control 12.1.0.1.0
Copyright (c) 1996, 2011 Oracle Corporation.  All rights reserved.
---------------------------------------------------------------
Agent Version     : 12.1.0.1.0
OMS Version       : 12.1.0.1.0
Protocol Version  : 12.1.0.1.0
Agent Home        : /opt/app/oracle/grid_agent/agent12g/agent_inst
Agent Binaries    : /opt/app/oracle/grid_agent/agent12g/core/12.1.0.1.0
Agent Process ID  : 4072
Parent Process ID : 3935
Agent URL         : https://rac1. .net:3872/emd/main
Repository URL    : https://hpc4. .net:4900/empbs/upload
Started at        : 2012-02-09 16:26:48
Started by user   : oracle
Last Reload       : (none)
Last successful upload                       : 2012-02-10 12:59:01
Last attempted upload                        : 2012-02-10 12:59:01
Total Megabytes of XML files uploaded so far : 2.44
Number of XML files pending upload           : 0
Size of XML files pending upload(MB)         : 0
Available disk space on upload filesystem    : 13.31%
Collection Status                            : Collections enabled
Last attempted heartbeat to OMS              : 2012-02-10 13:02:12
Last successful heartbeat to OMS             : 2012-02-10 13:02:12

---------------------------------------------------------------
Agent is Running and Ready
Status from old agent shows it's running but not communicating with OMS anymore
emctl status agent
Oracle Enterprise Manager 11g Release 1 Grid Control 11.1.0.1.0
Copyright (c) 1996, 2010 Oracle Corporation.  All rights reserved.
---------------------------------------------------------------
Content-Length: 0
Server: Jetty(7.0.1.v20091125)

---------------------------------------------------------------
Agent is Running but Not Ready
This completes the upgrade part of grid control from 11g
to 12c

12c grid control Home page.

It could be seen that agents from exisiting hosts have already started communicating with new OMS.

12c's new ASH Analytics page

Last step is to deinstall the old agents and OMS.
To deinstall the agents from local and remote hosts including RAC follow the agent deinstall post or How to Remove the 11.1.0.1.0 Grid Control Management Agent with the Silent Method [ID 1068036.1].

For OMS use How to Deinstall 11g Grid Control Components in Graphical Mode

More inforation is available from Enterprise Manager Grid Control Advanced Installation and Configuration Guide

To enable/disable the auto start of any agent
chkconfig gcstartup on/off
chkconfig --list | grep gcstartup
gcstartup       0:off   1:off   2:on    3:on    4:on    5:on    6:off

Useful metalink notes
How to Remove the 11.1.0.1.0 Grid Control Management Agent with the Silent Method [ID 1068036.1]
12c: Cluster Database Target Remains in Pending Delete Status Indefinetely after Re-adding [ID 1403833.1]
12C Cloud Control: How to De-install 12C Agent [ID 1368088.1]
How To De-Install EM 12c Cloud Control [ID 1363418.1]
How to Delete One Node from a RAC Cluster in EM 12c? [ID 1391107.1]
How to Deploy the Latest Database Plugin to the OMS and the Agent in 12C Cloud Control [ID 1388143.1]
EM 12c: How to Install EM 12c Agent using Silent Install Method with Response File [ID 1360083.1]
EM 12c: How to Install Enterprise Manager 12.1.0.1 Using Silent Method [ID 1361643.1]
How to install Enterprise Manager Cloud Control 12c Agent on Linux [ID 1360183.1]