11.2.0.2, 11.2.0.3, 11.2.0.4 or 12.1.0.1 to 12.1.0.2 Grid Infrastructure and Database Upgrade on Exadata Database Machine running Oracle Solaris and Solaris Supercluster

Asset ID:	1-71-1908556.1
Update Date:	2016-07-29
Keywords:

Solution Type Technical Instruction Sure

Solution 1908556.1 : 11.2.0.2, 11.2.0.3, 11.2.0.4 or 12.1.0.1 to 12.1.0.2 Grid Infrastructure and Database Upgrade on Exadata Database Machine running Oracle Solaris and Solaris Supercluster

Applies to:

Exadata X3-2 Hardware - Version All Versions and later
SPARC SuperCluster T4-4 - Version All Versions and later
Exadata X4-2 Hardware - Version All Versions and later
Exadata Database Machine V2 - Version All Versions and later
Oracle SuperCluster T5-8 Hardware - Version All Versions and later
Oracle Solaris on SPARC (64-bit)
Oracle Solaris on x86-64 (64-bit)

Goal

This document provides Solaris specific steps and remarks for upgrading Oracle Database and Oracle Grid Infrastructure to 12.1.0.2 on Solaris x86-64 (Exadata) and Solaris SPARC (Oracle SuperCluster) according to <Note 1681467.1> .

Solution

Note: Customers upgrading to 12.1.0.2 on Solaris are advised to start with the detailed instructions in <Note 1681467.1> and follow the links to appropriate sections in this document

This document provides additional instructions for upgrading Oracle Database and Oracle Grid Infrastructure from release 11.2.0.2, 11.2.0.3, 11.2.0.4 or 12.1.0.1 to 12.1.0.2 on Oracle Exadata Database Machine and Oracle SuperCluster. Solaris Updates and additional IDRs are required before upgrading to Oracle Database 12.1.0.2 (12c) and Oracle Grid Infrastructure 12.1.0.2 (12c).

Solaris-specific software requirements and recommendations

Upgrade to current recommended Solaris Version on Exadata

Update Solaris using Upgrading to Solaris 11.3 on Solaris x86-64 Exadata Compute nodes <Note 2121725.1>

(root)# pkg list entire
NAME (PUBLISHER) VERSION IFO
entire 0.5.11-0.175.3.4.0.5.0 i--

Upgrade to current recommended Solaris Version on Oracle SuperCluster

Install current recommended QFSDP <Note 1567979.1>

(root)# pkg list entire
NAME (PUBLISHER) VERSION IFO
entire 0.5.11-0.175.3.4.0.5.0 i--

(root)# pkg list|grep idr
idr2266 3 i--
idr2271 1 i--
idr2272 1 i--
idr2275 1 i--

Solaris-specific guidelines for GI software installation prerequisite check failure

Perform the 12.1.0.2 Grid Infrastructure software installation and upgrade using OUI

On "Prerequisite Checks" screen, resolve any failed checks or warnings before continuing.

Ignore following Prereq Checks for GI HOME and RDBMS HOME as proper packages already exist on Exadata:

Package: make-0.5.11 - This is a prerequisite condition to test whether the package "make-0.5.11" is available on the system.

Expected Value
: make-0.5.11
Actual Value
: i386-null
Details:
-
PRVF-7533 : Proper version of package "make" is not found on node "scao06adm02" [Required = "make-0.5.11" ; Found = "i386-null"].
- Cause: Package does not meet the requirement.
- Action: Upgrade the package to meet the requirement.

(root)# pkg list |grep make
developer/build/make 0.5.11-0.175.1.19.0.4.0 i--

Package: assembler-0.5.11 - This is a prerequisite condition to test whether the package "assembler-0.5.11" is available on the system.

Expected Value
: assembler-0.5.11
Actual Value
: i386-null
Details:
-
PRVF-7533 : Proper version of package "assembler" is not found on node "scao06adm02" [Required = "assembler-0.5.11" ; Found = "i386-null"].
- Cause: Package does not meet the requirement.
- Action: Upgrade the package to meet the requirement.

(root)# pkg list |grep assembler
developer/assembler 0.5.11-0.175.1.19.0.4.0 i--

Package: xcu4-0.5.11 - This is a prerequisite condition to test whether the package "xcu4-0.5.11" is available on the system.

Expected Value
: xcu4-0.5.11
Actual Value
: i386-null
Details:
-
PRVF-7533 : Proper version of package "xcu4" is not found on node "scao06adm02" [Required = "xcu4-0.5.11" ; Found = "i386-null"].
- Cause: Package does not meet the requirement.
- Action: Upgrade the package to meet the requirement.

(root)# pkg list |grep xcu
system/xopen/xcu4 0.5.11-0.175.1.13.0.4.2 i--

Ignore following Prereq Checks for GI HOME and RDBMS HOME on Oracle SuperCluster

Task resolv.conf Integrity - This task checks consistency of file /etc/resolv.conf file across nodes

PRVG-2016 : "search" and "domain" entries coexist in file "/etc/resolv.conf" on node "xxx"

Cause: Both ''search'' and ''domain'' entries were found in resolv.conf file on the node specified.

Action: Make sure that only one of these entries exist in file resolv.conf. It is preferable to use entry ''search'' in resolv.conf.

Solaris IPMP group fail-over consistency check - This is a check to verify the current selection of public and private network classifications is consistent with network interfaces in fail-over dependency of an IPMP group

Solaris-specific workaround required before running rootupgrade.sh

Note: <BUG 17065496> - ROOTUPGRADE TO 12.1 FAILS AT HAIP STARTUP ON EXADATA will cause rootupgrade.sh to fail on Exadata and Oracle SuperCluster.
This bug is not fixed at that time but workaround exists:

On all database servers, set environment variable HAIP_UNSUPPORTED=TRUE in the same terminal window that will be used to run rootupgrade.sh.

(root)# export HAIP_UNSUPPORTED=TRUE

Then run rootupgrade.sh as directed in <Document 1681467.1>.

Solaris-specific workaround required for DBUA on Oracle SuperCluster

Note: When upgrading 12.1.0.1 to 12.1.0.2 on Oracle SuperCluster <Bug 19251013> - DBUA FAILS WITH ORA-00205 ERROR IN IDENTIFYING CONTROLFILE TO START INSTANCE will prevent DBUA to startup the instance in exclusive mode. Workaround is available

Do not exit DBUA. In a separate terminal window run the following commands:

(root)# su - oracle
(oracle)# export ORACLE_HOME=/u01/app/oracle/product/12.1.0.1/dbhome_1
(oracle)# /u01/app/oracle/product/12.1.0.1/dbhome_1/bin/srvctl enable database -d <database>
(oracle)# /u01/app/oracle/product/12.1.0.1/dbhome_1/bin/srvctl start instance -d <database> -i <instance1>

Then click Ignore in DBUA to proceed with the upgrade.

Solaris-specific postupgrade Step required on Exadata and Oracle SuperCluster

Set initialization parameter _exafusion_enabled to false.

(oracle)# SYS@PRIM1>alter system set "_exafusion_enabled" = false scope = spfile sid='*';

Complete the remaining steps as documented in <Document 1681467.1> to restart the database for this parameter to take effect.

Due to <BUG 23205422> save existing /u01/app/11.x/grid/crs/install/crsconfig_params as /u01/app/12.1.0.2/grid/crs/install/crsconfig_params-11.orig which could be used to populate missing information into /u01/app/12.1.0.2/grid/crs/install/crsconfig_params if you plan to add another nodes to the cluster

References

<NOTE:1681467.1> - 11.2.0.2, 11.2.0.3, 11.2.0.4 or 12.1.0.1 to 12.1.0.2 Grid Infrastructure and Database Upgrade on Exadata Database Machine running Oracle Linux
<NOTE:1567979.1> - Oracle SuperCluster Supported Software Versions - All Hardware Types
<NOTE:1534482.1> - Upgrading to Solaris 11.1 on Solaris x86-64 Exadata Compute nodes

Attachments

This solution has no attachment