Oracle Certified Master's - Blogs: June 2017

12.2.0.1 Upgrade from 12.1.0.2 (Apr-2017 PSU)

GRID INFRASTRUCTURE UPGRADE

Starting with this Oracle Grid Infrastructure 12c Release 2 (12.2), the Oracle Grid Infrastructure software is available as an image file for download and installation. In order to start the installation or upgrade we must extract the Grid Infrastructure image software into the directory where you want your Grid home to be located. Here in our case we used " /u01/app/12.2.0.1/GRID/ ", and then run the gridSetup.sh script to start the Oracle Grid Infrastructure installation.

Point need to remember before installation.

Starting from 12cR2 it is now mandatory that we have 33+ GB of free disk space in the ASM disk groups, without we can't process upgrade or any new installation.
I have applied Apr-2017 PSU on my 12.1.0.2 RAC Cluster, so this time I am not facing any kind of issue for rootupgrade.sh on every nodes.
In my other environment where we have not applied the APR-2017 PSU, we faced failure on rootupgrade.sh on upgrade and root.sh in fresh installation where each server bounce was necessary then after rerun the root.sh/rootupgrade.sh.

Pre-validation before starting upgrade:

[oracle@rac131 ~]$ . oraenv

ORACLE_SID = [+ASM1] ?

The Oracle base has been set to /u01/app/oracle

[oracle@rac131 12.2.0.1]$ crsctl query crs releaseversion

Oracle High Availability Services release version on the local node is [12.1.0.2.0]

[oracle@rac131 12.2.0.1]$ crsctl query crs activeversion

Oracle Clusterware active version on the cluster is [12.1.0.2.0]

[oracle@rac131 12.2.0.1]$ crsctl query crs softwareversion -all

Oracle Clusterware version on node [rac131] is [12.1.0.2.0]

Oracle Clusterware version on node [rac132] is [12.1.0.2.0]

[oracle@rac131 12.2.0.1]$ crsctl query crs administrator

CRS Administrator List: oracle root

[oracle@rac131 12.2.0.1]$ crsctl query crs softwarepatch

Oracle Clusterware patch level on node rac131 is [3924561976].

[oracle@rac131 12.2.0.1]$ crsctl query dns -servers

CRS-10018: the following configuration was found on the system:

CRS-10019: There are 1 domains in search order. They are:

ora.com

CRS-10022: There are 1 name servers. They are:

192.168.1.100

CRS-10020: number of retry attempts for name lookup is: 4

CRS-10021: timeout for each name lookup is: 5

[oracle@rac131 12.2.0.1]$ crsctl query css votedisk

## STATE File Universal Id File Name Disk group

-- ----- ----------------- --------- ---------

1. ONLINE e54d8c16d0d74f24bf3e8571390bb749 (ORCL:CRS01) [OCR_VOTING]

Located 1 voting disk(s).

[oracle@rac131 12.2.0.1]$ crsctl query crs softwarepatch rac131

Oracle Clusterware patch level on node rac131 is [3924561976].

[oracle@rac131 12.2.0.1]$ crsctl query crs softwarepatch rac132

Oracle Clusterware patch level on node rac132 is [3924561976].

[oracle@rac131 ~]$ crsctl stat res -t

----------------------------------------------------------------

Name Target State Server State details

----------------------------------------------------------------

Local Resources

----------------------------------------------------------------

ora.DATA.dg

ONLINE ONLINE rac131 STABLE

ONLINE ONLINE rac132 STABLE

ora.LISTENER.lsnr

ONLINE ONLINE rac131 STABLE

ONLINE ONLINE rac132 STABLE

ora.OCR_VOTING.dg

ONLINE ONLINE rac131 STABLE

ONLINE ONLINE rac132 STABLE

ora.asm

ONLINE ONLINE rac131 Started,STABLE

ONLINE ONLINE rac132 Started,STABLE

ora.net1.network

ONLINE ONLINE rac131 STABLE

ONLINE ONLINE rac132 STABLE

ora.ons

ONLINE ONLINE rac131 STABLE

ONLINE ONLINE rac132 STABLE

----------------------------------------------------------------

Cluster Resources

----------------------------------------------------------------

ora.LISTENER_SCAN1.lsnr

1 ONLINE ONLINE rac131 STABLE

ora.LISTENER_SCAN2.lsnr

1 ONLINE ONLINE rac131 STABLE

ora.LISTENER_SCAN3.lsnr

1 ONLINE ONLINE rac131 STABLE

ora.MGMTLSNR

1 ONLINE ONLINE rac132 169.254.104.131 10. 1

0.10.132 20.20.20.1 3

2,STABLE

ora.ccbprod.db

1 ONLINE ONLINE rac131 Open,STABLE

2 ONLINE ONLINE rac132 Open,STABLE

ora.cvu

1 ONLINE ONLINE rac131 STABLE

ora.mgmtdb

1 ONLINE ONLINE rac132 Open,STABLE

ora.oc4j

1 ONLINE ONLINE rac132 STABLE

ora.rac131.vip

1 ONLINE ONLINE rac131 STABLE

ora.rac132.vip

1 ONLINE ONLINE rac132 STABLE

ora.scan1.vip

1 ONLINE ONLINE rac131 STABLE

ora.scan2.vip

1 ONLINE ONLINE rac131 STABLE

ora.scan3.vip

1 ONLINE ONLINE rac131 STABLE

----------------------------------------------------------------

[oracle@rac131 ~]$ asmcmd -p lsdg

State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name

MOUNTED EXTERN N 512 4096 4194304 20472 14408 0 14408 0 N DATA/

MOUNTED EXTERN N 512 4096 4194304 40896 36236 0 36236 0 Y OCR_VOTING/

[oracle@rac131 app]$ cd /ora_nfs/software/Oracle/database/12.2.0.1/

[oracle@rac131 12.2.0.1]$ ls -ltrah

total 6.1G

drwxrwxrwx. 3 777 501 4.0K Nov 26 2016 .

drwxrwxrwx. 8 777 501 4.0K Nov 26 2016 ..

drwxrwxrwx. 7 777 501 4.0K Jan 26 21:52 database

-rwxrwxrwx. 1 777 501 2.8G Mar 2 03:20 linuxx64_12201_grid_home.zip

-rwxrwxrwx. 1 777 501 3.3G Mar 2 03:21 DB_soft_12cR2.zip

-rwxrwxrwx. 1 777 501 0 Mar 4 00:13 oracle-database-server-12cR2-preinstall-1.0-2.el7.x86_64.rpm

-rwxrwxrwx. 1 777 501 0 Mar 4 19:36 oracle-database-server-12cR2-preinstall-1.0-1.el7.x86_64.rpm

Unzipping Grid Binary to /u01/app/12.2.0.1/GRID/

[oracle@rac131 12.2.0.1]$ unzip -d /u01/app/12.2.0.1/GRID/ linuxx64_12201_grid_home.zip

Archive: linuxx64_12201_grid_home.zip

creating: /u01/app/12.2.0.1/GRID/addnode/

inflating: /u01/app/12.2.0.1/GRID/addnode/addnode_oraparam.ini.sbs

inflating: /u01/app/12.2.0.1/GRID/addnode/addnode.pl

inflating: /u01/app/12.2.0.1/GRID/addnode/addnode.sh

inflating: /u01/app/12.2.0.1/GRID/addnode/addnode_oraparam.ini

creating: /u01/app/12.2.0.1/GRID/assistants/

creating: /u01/app/12.2.0.1/GRID/assistants/jlib/

inflating: /u01/app/12.2.0.1/GRID/assistants/jlib/initconfig

inflating: /u01/app/12.2.0.1/GRID/assistants/jlib/appfwk.jar

inflating: /u01/app/12.2.0.1/GRID/assistants/jlib/rconfig.jar

inflating: /u01/app/12.2.0.1/GRID/xdk/mesg/jznpt.msb

inflating: /u01/app/12.2.0.1/GRID/xdk/mesg/lsxja.msb

finishing deferred symbolic links:

/u01/app/12.2.0.1/GRID/bin/lbuilder -> ../nls/lbuilder/lbuilder

/u01/app/12.2.0.1/GRID/javavm/admin/libjtcjt.so -> ../../javavm/jdk/jdk8/admin/libjtcjt.so

/u01/app/12.2.0.1/GRID/javavm/admin/lfclasses.bin -> ../../javavm/jdk/jdk8/admin/lfclasses.bin

/u01/app/12.2.0.1/GRID/javavm/admin/classes.bin -> ../../javavm/jdk/jdk8/admin/classes.bin

/u01/app/12.2.0.1/GRID/javavm/admin/cbp.jar -> ../../javavm/jdk/jdk8/admin/cbp.jar

/u01/app/12.2.0.1/GRID/javavm/lib/sunjce_provider.jar -> ../../javavm/jdk/jdk8/lib/sunjce_provider.jar

/u01/app/12.2.0.1/GRID/javavm/lib/jce.jar -> ../../javavm/jdk/jdk8/lib/jce.jar

/u01/app/12.2.0.1/GRID/javavm/lib/security/US_export_policy.jar -> ../../../javavm/jdk/jdk8/lib/security/US_export_policy.jar

/u01/app/12.2.0.1/GRID/javavm/lib/security/java.security -> ../../../javavm/jdk/jdk8/lib/security/java.security

/u01/app/12.2.0.1/GRID/javavm/lib/security/local_policy.jar -> ../../../javavm/jdk/jdk8/lib/security/local_policy.jar

/u01/app/12.2.0.1/GRID/javavm/lib/security/cacerts -> ../../../javavm/jdk/jdk8/lib/security/cacerts

/u01/app/12.2.0.1/GRID/jdk/bin/ControlPanel -> jcontrol

/u01/app/12.2.0.1/GRID/jdk/jre/bin/ControlPanel -> jcontrol

/u01/app/12.2.0.1/GRID/jdk/jre/lib/amd64/server/libjsig.so -> ../libjsig.so

/u01/app/12.2.0.1/GRID/lib/libclntshcore.so -> libclntshcore.so.12.1

/u01/app/12.2.0.1/GRID/lib/libjavavm12.a -> ../javavm/jdk/jdk8/lib/libjavavm12.a

/u01/app/12.2.0.1/GRID/lib/libodm12.so -> libodmd12.so

/u01/app/12.2.0.1/GRID/lib/libagtsh.so -> libagtsh.so.1.0

/u01/app/12.2.0.1/GRID/lib/libclntsh.so -> libclntsh.so.12.1

/u01/app/12.2.0.1/GRID/lib/libocci.so -> libocci.so.12.1

[oracle@rac131 12.2.0.1]$

Starting 12cR2 Grid Infrastructure Upgrade

To use upgrade Oracle Grid Infrastructure for a cluster:

Go to Unzipped directory and start the Grid Setup wizard:

$ /u01/app/12.2.0.1/GRID/gridSetup.sh

On the Select Installation Wizard page, select Upgrade Oracle Grid Infrastructure

Select the Upgrade Option

Ensure all node selected

Select appropriate group

Select correct Oracle Base

Here I am running rootupgrade.sh manually, so I am not clicking automatic run configuration scripts

Fix any found failure

Checking OCR Integrity Failure

During upgrade I found OLR integrity failure. I used below approach to fix the issue.

[oracle@rac131 12.2.0.1]$ cat -n /etc/oraInst.loc

1 inventory_loc=/u01/app/oraInventory

2 inst_group=oinstall

[oracle@rac131 12.2.0.1]$

[oracle@rac131 12.2.0.1]$ cluvfy comp olr -verbose

Verifying OLR integrity

Checking OLR integrity...

Check of existence of OLR configuration file "/etc/oracle/olr.loc" passed

Check of attributes of OLR configuration file "/etc/oracle/olr.loc" passed

PRVG-2031 : Owner of file "/u01/app/12.1.0.2/GRID/cdata/rac131.olr" did not match the expected value on node "rac131". [Expected = "root" ; Found = "oracle"]

WARNING:

This check does not verify the integrity of the OLR contents. Execute 'ocrcheck -local' as a privileged user to verify the contents of OLR.

OLR integrity check passed

Verification of OLR integrity was successful.

[oracle@rac131 12.2.0.1]$ sudo /u01/app/12.1.0.2/GRID/bin/ocrcheck -local

Status of Oracle Local Registry is as follows :

Version : 4

Total space (kbytes) : 409568

Used space (kbytes) : 972

Available space (kbytes) : 408596

ID : 2106775746

Device/File Name : /u01/app/12.1.0.2/GRID/cdata/rac131.olr

Device/File integrity check succeeded

Local registry integrity check succeeded

Logical corruption check succeeded

[root@rac131 12.2.0.1]$ ls -ltrah /u01/app/12.1.0.2/GRID/cdata/rac131.olr

-rw-------. 1 oracle oinstall 481M Jun 18 11:37 /u01/app/12.1.0.2/GRID/cdata/rac131.olr

Changing the permission to root:oinstall

[root@rac131 12.2.0.1]$ chmod root:oinstall /u01/app/12.1.0.2/GRID/cdata/rac131.olr

Validating permission to root:oinstall

[root@rac131 12.2.0.1]$ ls -ltrah /u01/app/12.1.0.2/GRID/cdata/rac131.olr

-rw-------. 1 root oinstall 481M Jun 18 11:59 /u01/app/12.1.0.2/GRID/cdata/rac131.olr

[oracle@rac131 12.2.0.1]$ sudo /tmp/GridSetupActions2017-06-18_12-06-46PM/CVU_12.2.0.1.0_oracle/runfixup.sh

All Fix-up operations were completed successfully.

Now Up-gradation of GI is in progress

rootupgrade.sh is pointing so running on both node.

Run rootupgrade.sh as root user

[oracle@rac131 ~]$ sudo /u01/app/12.2.0.1/GRID/rootupgrade.sh

Performing root user operation.

The following environment variables are set as:

ORACLE_OWNER= oracle

ORACLE_HOME= /u01/app/12.2.0.1/GRID

Enter the full pathname of the local bin directory: [/usr/local/bin]:

The contents of "dbhome" have not changed. No need to overwrite.

The file "oraenv" already exists in /usr/local/bin. Overwrite it? (y/n)

[n]: y

Copying oraenv to /usr/local/bin ...

The contents of "coraenv" have not changed. No need to overwrite.

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.

Relinking oracle with rac_on option

Using configuration parameter file: /u01/app/12.2.0.1/GRID/crs/install/crsconfig

The log of current session can be found at:

/u01/app/oracle/crsdata/rac131/crsconfig/rootcrs_rac131_2017-06-18_12-56-54AM.

2017/06/18 12:56:58 CLSRSC-595: Executing upgrade step 1 of 19: 'UpgradeTFA'.

2017/06/18 12:56:58 CLSRSC-4015: Performing install or upgrade action for Oracle

2017/06/18 12:57:25 CLSRSC-4003: Successfully patched Oracle Trace File Analyzer (TFA) Collector.

2017/06/18 12:57:25 CLSRSC-595: Executing upgrade step 2 of 19: 'ValidateEnv'.

2017/06/18 12:57:38 CLSRSC-595: Executing upgrade step 3 of 19: 'GenSiteGUIDs'.

2017/06/18 12:57:39 CLSRSC-595: Executing upgrade step 4 of 19: 'GetOldConfig'.

2017/06/18 12:57:39 CLSRSC-464: Starting retrieval of the cluster configuration data

2017/06/18 12:57:50 CLSRSC-515: Starting OCR manual backup.

2017/06/18 12:57:55 CLSRSC-516: OCR manual backup successful.

2017/06/18 12:58:13 CLSRSC-486:

At this stage of upgrade, the OCR has changed.

Any attempt to downgrade the cluster after this point will require a complete cluster outage to restore the OCR.

2017/06/18 12:58:13 CLSRSC-541:

To downgrade the cluster:

1. All nodes that have been upgraded must be downgraded.

2017/06/18 12:58:13 CLSRSC-542:

2. Before downgrading the last node, the Grid Infrastructure stack on all other cluster nodes must be down.

2017/06/18 12:58:13 CLSRSC-615:

3. The last node to downgrade cannot be a Leaf node.

2017/06/18 12:58:22 CLSRSC-465: Retrieval of the cluster configuration data has successfully completed.

2017/06/18 12:58:22 CLSRSC-595: Executing upgrade step 5 of 19: 'UpgPrechecks'.

2017/06/18 12:58:39 CLSRSC-595: Executing upgrade step 6 of 19: 'SaveParamFile'.

2017/06/18 12:58:48 CLSRSC-595: Executing upgrade step 7 of 19: 'SetupOSD'.

2017/06/18 12:59:03 CLSRSC-595: Executing upgrade step 8 of 19: 'PreUpgrade'.

2017/06/18 12:59:08 CLSRSC-468: Setting Oracle Clusterware and ASM to rolling migration mode

2017/06/18 12:59:08 CLSRSC-482: Running command: '/u01/app/12.1.0.2/GRID/bin/crsctl start rollingupgrade 12.2.0.1.0'

CRS-1131: The cluster was successfully set to rolling upgrade mode.

2017/06/18 12:59:12 CLSRSC-482: Running command: '/u01/app/12.2.0.1/GRID/bin/asmca -silent -upgradeNodeASM -nonRolling false -oldCRSHome /u01/app/12.1.0.2/GRID -oldCRSVersion 12.1.0.2.0 -firstNode true -startRolling false '

ASM configuration upgraded in local node successfully.

2017/06/18 12:59:16 CLSRSC-469: Successfully set Oracle Clusterware and ASM to rolling migration mode

2017/06/18 12:59:28 CLSRSC-466: Starting shutdown of the current Oracle Grid Infrastructure stack

2017/06/18 12:59:54 CLSRSC-467: Shutdown of the current Oracle Grid Infrastructure stack has successfully completed.

2017/06/18 12:59:56 CLSRSC-595: Executing upgrade step 9 of 19: 'CheckCRSConfig'.

2017/06/18 12:59:57 CLSRSC-595: Executing upgrade step 10 of 19: 'UpgradeOLR'.

2017/06/18 13:00:04 CLSRSC-595: Executing upgrade step 11 of 19: 'ConfigCHMOS'.

2017/06/18 13:00:04 CLSRSC-595: Executing upgrade step 12 of 19: 'InstallAFD'.

2017/06/18 13:00:11 CLSRSC-595: Executing upgrade step 13 of 19: 'createOHASD'.

2017/06/18 13:00:17 CLSRSC-595: Executing upgrade step 14 of 19: 'ConfigOHASD'.

2017/06/18 13:00:33 CLSRSC-329: Replacing Clusterware entries in file 'oracle-ohasd.conf'

2017/06/18 13:00:54 CLSRSC-595: Executing upgrade step 15 of 19: 'InstallACFS'.

CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'rac131'

CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'rac131' has completed

CRS-4133: Oracle High Availability Services has been stopped.

CRS-4123: Oracle High Availability Services has been started.

2017/06/18 13:01:41 CLSRSC-595: Executing upgrade step 16 of 19: 'InstallKA'.

2017/06/18 13:01:48 CLSRSC-595: Executing upgrade step 17 of 19: 'UpgradeCluster'.

CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'rac131'

CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'rac131' has completed

CRS-4133: Oracle High Availability Services has been stopped.

CRS-4123: Starting Oracle High Availability Services-managed resources

CRS-2672: Attempting to start 'ora.mdnsd' on 'rac131'

CRS-2672: Attempting to start 'ora.evmd' on 'rac131'

CRS-2676: Start of 'ora.evmd' on 'rac131' succeeded

CRS-2676: Start of 'ora.mdnsd' on 'rac131' succeeded

CRS-2672: Attempting to start 'ora.gpnpd' on 'rac131'

CRS-2676: Start of 'ora.gpnpd' on 'rac131' succeeded

CRS-2672: Attempting to start 'ora.gipcd' on 'rac131'

CRS-2676: Start of 'ora.gipcd' on 'rac131' succeeded

CRS-2672: Attempting to start 'ora.cssdmonitor' on 'rac131'

CRS-2676: Start of 'ora.cssdmonitor' on 'rac131' succeeded

CRS-2672: Attempting to start 'ora.cssd' on 'rac131'

CRS-2672: Attempting to start 'ora.diskmon' on 'rac131'

CRS-2676: Start of 'ora.diskmon' on 'rac131' succeeded

CRS-2676: Start of 'ora.cssd' on 'rac131' succeeded

CRS-2672: Attempting to start 'ora.cluster_interconnect.haip' on 'rac131'

CRS-2672: Attempting to start 'ora.ctssd' on 'rac131'

CRS-2676: Start of 'ora.ctssd' on 'rac131' succeeded

CRS-2676: Start of 'ora.cluster_interconnect.haip' on 'rac131' succeeded

CRS-2672: Attempting to start 'ora.asm' on 'rac131'

CRS-2676: Start of 'ora.asm' on 'rac131' succeeded

CRS-2672: Attempting to start 'ora.storage' on 'rac131'

CRS-2676: Start of 'ora.storage' on 'rac131' succeeded

CRS-2672: Attempting to start 'ora.crf' on 'rac131'

CRS-2676: Start of 'ora.crf' on 'rac131' succeeded

CRS-2672: Attempting to start 'ora.crsd' on 'rac131'

CRS-2676: Start of 'ora.crsd' on 'rac131' succeeded

CRS-6017: Processing resource auto-start for servers: rac131

CRS-6016: Resource auto-start has completed for server rac131

CRS-6024: Completed start of Oracle Cluster Ready Services-managed resources

CRS-4123: Oracle High Availability Services has been started.

clscfg: EXISTING configuration version 5 detected.

clscfg: version 5 is 12c Release 1.

Successfully taken the backup of node specific configuration in OCR.

Successfully accumulated necessary OCR keys.

Creating OCR keys for user 'root', privgrp 'root'..

Operation successful.

CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'rac131'

CRS-2673: Attempting to stop 'ora.crsd' on 'rac131'

CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'rac131'

CRS-2673: Attempting to stop 'ora.asm' on 'rac131'

CRS-2677: Stop of 'ora.asm' on 'rac131' succeeded

CRS-2673: Attempting to stop 'ora.net1.network' on 'rac131'

CRS-2677: Stop of 'ora.net1.network' on 'rac131' succeeded

CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'rac131' has completed

CRS-2677: Stop of 'ora.crsd' on 'rac131' succeeded

CRS-2673: Attempting to stop 'ora.asm' on 'rac131'

CRS-2673: Attempting to stop 'ora.crf' on 'rac131'

CRS-2673: Attempting to stop 'ora.drivers.acfs' on 'rac131'

CRS-2673: Attempting to stop 'ora.gpnpd' on 'rac131'

CRS-2673: Attempting to stop 'ora.mdnsd' on 'rac131'

CRS-2677: Stop of 'ora.drivers.acfs' on 'rac131' succeeded

CRS-2677: Stop of 'ora.crf' on 'rac131' succeeded

CRS-2677: Stop of 'ora.gpnpd' on 'rac131' succeeded

CRS-2677: Stop of 'ora.mdnsd' on 'rac131' succeeded

CRS-2677: Stop of 'ora.asm' on 'rac131' succeeded

CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'rac131'

CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'rac131' succeeded

CRS-2673: Attempting to stop 'ora.ctssd' on 'rac131'

CRS-2673: Attempting to stop 'ora.evmd' on 'rac131'

CRS-2677: Stop of 'ora.ctssd' on 'rac131' succeeded

CRS-2677: Stop of 'ora.evmd' on 'rac131' succeeded

CRS-2673: Attempting to stop 'ora.cssd' on 'rac131'

CRS-2677: Stop of 'ora.cssd' on 'rac131' succeeded

CRS-2673: Attempting to stop 'ora.gipcd' on 'rac131'

CRS-2677: Stop of 'ora.gipcd' on 'rac131' succeeded

CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'rac131' has completed

CRS-4133: Oracle High Availability Services has been stopped.

CRS-4123: Starting Oracle High Availability Services-managed resources

CRS-2672: Attempting to start 'ora.evmd' on 'rac131'

CRS-2672: Attempting to start 'ora.mdnsd' on 'rac131'

CRS-2676: Start of 'ora.evmd' on 'rac131' succeeded

CRS-2676: Start of 'ora.mdnsd' on 'rac131' succeeded

CRS-2672: Attempting to start 'ora.gpnpd' on 'rac131'

CRS-2676: Start of 'ora.gpnpd' on 'rac131' succeeded

CRS-2672: Attempting to start 'ora.gipcd' on 'rac131'

CRS-2676: Start of 'ora.gipcd' on 'rac131' succeeded

CRS-2672: Attempting to start 'ora.cssdmonitor' on 'rac131'

CRS-2676: Start of 'ora.cssdmonitor' on 'rac131' succeeded

CRS-2672: Attempting to start 'ora.cssd' on 'rac131'

CRS-2672: Attempting to start 'ora.diskmon' on 'rac131'

CRS-2676: Start of 'ora.diskmon' on 'rac131' succeeded

CRS-2676: Start of 'ora.cssd' on 'rac131' succeeded

CRS-2672: Attempting to start 'ora.cluster_interconnect.haip' on 'rac131'

CRS-2672: Attempting to start 'ora.ctssd' on 'rac131'

CRS-2676: Start of 'ora.ctssd' on 'rac131' succeeded

CRS-2676: Start of 'ora.cluster_interconnect.haip' on 'rac131' succeeded

CRS-2672: Attempting to start 'ora.asm' on 'rac131'

CRS-2676: Start of 'ora.asm' on 'rac131' succeeded

CRS-2672: Attempting to start 'ora.storage' on 'rac131'

CRS-2676: Start of 'ora.storage' on 'rac131' succeeded

CRS-2672: Attempting to start 'ora.crf' on 'rac131'

CRS-2676: Start of 'ora.crf' on 'rac131' succeeded

CRS-2672: Attempting to start 'ora.crsd' on 'rac131'

CRS-2676: Start of 'ora.crsd' on 'rac131' succeeded

CRS-6017: Processing resource auto-start for servers: rac131

CRS-2673: Attempting to stop 'ora.rac131.vip' on 'rac132'

CRS-2672: Attempting to start 'ora.ons' on 'rac131'

CRS-2673: Attempting to stop 'ora.LISTENER_SCAN1.lsnr' on 'rac132'

CRS-2677: Stop of 'ora.LISTENER_SCAN1.lsnr' on 'rac132' succeeded

CRS-2673: Attempting to stop 'ora.scan1.vip' on 'rac132'

CRS-2677: Stop of 'ora.rac131.vip' on 'rac132' succeeded

CRS-2672: Attempting to start 'ora.rac131.vip' on 'rac131'

CRS-2677: Stop of 'ora.scan1.vip' on 'rac132' succeeded

CRS-2672: Attempting to start 'ora.scan1.vip' on 'rac131'

CRS-2676: Start of 'ora.scan1.vip' on 'rac131' succeeded

CRS-2672: Attempting to start 'ora.LISTENER_SCAN1.lsnr' on 'rac131'

CRS-2676: Start of 'ora.rac131.vip' on 'rac131' succeeded

CRS-2672: Attempting to start 'ora.LISTENER.lsnr' on 'rac131'

CRS-2676: Start of 'ora.ons' on 'rac131' succeeded

CRS-2676: Start of 'ora.LISTENER_SCAN1.lsnr' on 'rac131' succeeded

CRS-2676: Start of 'ora.LISTENER.lsnr' on 'rac131' succeeded

CRS-2672: Attempting to start 'ora.ccbprod.db' on 'rac131'

CRS-2676: Start of 'ora.ccbprod.db' on 'rac131' succeeded

CRS-6016: Resource auto-start has completed for server rac131

CRS-6024: Completed start of Oracle Cluster Ready Services-managed resources

CRS-4123: Oracle High Availability Services has been started.

2017/06/18 13:06:26 CLSRSC-343: Successfully started Oracle Clusterware stack

2017/06/18 13:06:26 CLSRSC-595: Executing upgrade step 18 of 19: 'UpgradeNode'.

2017/06/18 13:06:44 CLSRSC-474: Initiating upgrade of resource types

2017/06/18 13:07:48 CLSRSC-482: Running command: 'srvctl upgrade model -s 12.1.0.2.0 -d 12.2.0.1.0 -p first'

2017/06/18 13:07:48 CLSRSC-475: Upgrade of resource types successfully initiated.

2017/06/18 13:08:23 CLSRSC-595: Executing upgrade step 19 of 19: 'PostUpgrade'.

2017/06/18 13:08:29 CLSRSC-325: Configure Oracle Grid Infrastructure for a Cluster ... succeeded

Run rootupgrade.sh on Node2 (rac132)

[oracle@rac132 ~]$ sudo /u01/app/12.2.0.1/GRID/rootupgrade.sh

Performing root user operation.

The following environment variables are set as:

ORACLE_OWNER= oracle

ORACLE_HOME= /u01/app/12.2.0.1/GRID

Enter the full pathname of the local bin directory: [/usr/local/bin]:

The contents of "dbhome" have not changed. No need to overwrite.

The file "oraenv" already exists in /usr/local/bin. Overwrite it? (y/n)

[n]: y

Copying oraenv to /usr/local/bin ...

The contents of "coraenv" have not changed. No need to overwrite.

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.

Relinking oracle with rac_on option

Using configuration parameter file: /u01/app/12.2.0.1/GRID/crs/install/crsconfig_params

The log of current session can be found at:

/u01/app/oracle/crsdata/rac132/crsconfig/rootcrs_rac132_2017-06-18_01-28-28PM.log

2017/06/18 13:28:30 CLSRSC-595: Executing upgrade step 1 of 19: 'UpgradeTFA'.

2017/06/18 13:28:30 CLSRSC-4015: Performing install or upgrade action for Oracle Trace File Analyzer (TFA) Collector.

2017/06/18 13:28:55 CLSRSC-4003: Successfully patched Oracle Trace File Analyzer (TFA) Collector.

2017/06/18 13:28:55 CLSRSC-595: Executing upgrade step 2 of 19: 'ValidateEnv'.

2017/06/18 13:29:00 CLSRSC-595: Executing upgrade step 3 of 19: 'GenSiteGUIDs'.

2017/06/18 13:29:00 CLSRSC-595: Executing upgrade step 4 of 19: 'GetOldConfig'.

2017/06/18 13:29:00 CLSRSC-464: Starting retrieval of the cluster configuration data

2017/06/18 13:29:10 CLSRSC-465: Retrieval of the cluster configuration data has successfully completed.

2017/06/18 13:29:10 CLSRSC-595: Executing upgrade step 5 of 19: 'UpgPrechecks'.

2017/06/18 13:29:12 CLSRSC-595: Executing upgrade step 6 of 19: 'SaveParamFile'.

2017/06/18 13:29:15 CLSRSC-595: Executing upgrade step 7 of 19: 'SetupOSD'.

2017/06/18 13:29:17 CLSRSC-595: Executing upgrade step 8 of 19: 'PreUpgrade'.

ASM configuration upgraded in local node successfully.

2017/06/18 13:29:22 CLSRSC-466: Starting shutdown of the current Oracle Grid Infrastructure stack

2017/06/18 13:29:49 CLSRSC-467: Shutdown of the current Oracle Grid Infrastructure stack has successfully completed.

2017/06/18 13:29:54 CLSRSC-595: Executing upgrade step 9 of 19: 'CheckCRSConfig'.

2017/06/18 13:29:54 CLSRSC-595: Executing upgrade step 10 of 19: 'UpgradeOLR'.

2017/06/18 13:29:56 CLSRSC-595: Executing upgrade step 11 of 19: 'ConfigCHMOS'.

2017/06/18 13:29:56 CLSRSC-595: Executing upgrade step 12 of 19: 'InstallAFD'.

2017/06/18 13:29:57 CLSRSC-595: Executing upgrade step 13 of 19: 'createOHASD'.

2017/06/18 13:29:59 CLSRSC-595: Executing upgrade step 14 of 19: 'ConfigOHASD'.

2017/06/18 13:30:14 CLSRSC-329: Replacing Clusterware entries in file 'oracle-ohasd.conf'

2017/06/18 13:30:31 CLSRSC-595: Executing upgrade step 15 of 19: 'InstallACFS'.

CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'rac132'

CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'rac132' has completed

CRS-4133: Oracle High Availability Services has been stopped.

CRS-4123: Oracle High Availability Services has been started.

2017/06/18 13:31:11 CLSRSC-595: Executing upgrade step 16 of 19: 'InstallKA'.

2017/06/18 13:31:13 CLSRSC-595: Executing upgrade step 17 of 19: 'UpgradeCluster'.

CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'rac132'

CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'rac132' has completed

CRS-4133: Oracle High Availability Services has been stopped.

CRS-4123: Starting Oracle High Availability Services-managed resources

CRS-2672: Attempting to start 'ora.mdnsd' on 'rac132'

CRS-2672: Attempting to start 'ora.evmd' on 'rac132'

CRS-2676: Start of 'ora.evmd' on 'rac132' succeeded

CRS-2676: Start of 'ora.mdnsd' on 'rac132' succeeded

CRS-2672: Attempting to start 'ora.gpnpd' on 'rac132'

CRS-2676: Start of 'ora.gpnpd' on 'rac132' succeeded

CRS-2672: Attempting to start 'ora.gipcd' on 'rac132'

CRS-2676: Start of 'ora.gipcd' on 'rac132' succeeded

CRS-2672: Attempting to start 'ora.cssdmonitor' on 'rac132'

CRS-2676: Start of 'ora.cssdmonitor' on 'rac132' succeeded

CRS-2672: Attempting to start 'ora.cssd' on 'rac132'

CRS-2672: Attempting to start 'ora.diskmon' on 'rac132'

CRS-2676: Start of 'ora.diskmon' on 'rac132' succeeded

CRS-2676: Start of 'ora.cssd' on 'rac132' succeeded

CRS-2672: Attempting to start 'ora.cluster_interconnect.haip' on 'rac132'

CRS-2672: Attempting to start 'ora.ctssd' on 'rac132'

CRS-2676: Start of 'ora.ctssd' on 'rac132' succeeded

CRS-2676: Start of 'ora.cluster_interconnect.haip' on 'rac132' succeeded

CRS-2672: Attempting to start 'ora.asm' on 'rac132'

CRS-2676: Start of 'ora.asm' on 'rac132' succeeded

CRS-2672: Attempting to start 'ora.storage' on 'rac132'

CRS-2676: Start of 'ora.storage' on 'rac132' succeeded

CRS-2672: Attempting to start 'ora.crf' on 'rac132'

CRS-2676: Start of 'ora.crf' on 'rac132' succeeded

CRS-2672: Attempting to start 'ora.crsd' on 'rac132'

CRS-2676: Start of 'ora.crsd' on 'rac132' succeeded

CRS-6023: Starting Oracle Cluster Ready Services-managed resources

CRS-6017: Processing resource auto-start for servers: rac132

CRS-2673: Attempting to stop 'ora.rac132.vip' on 'rac131'

CRS-2672: Attempting to start 'ora.ons' on 'rac132'

CRS-2673: Attempting to stop 'ora.LISTENER_SCAN1.lsnr' on 'rac131'

CRS-2677: Stop of 'ora.LISTENER_SCAN1.lsnr' on 'rac131' succeeded

CRS-2673: Attempting to stop 'ora.scan1.vip' on 'rac131'

CRS-2677: Stop of 'ora.rac132.vip' on 'rac131' succeeded

CRS-2672: Attempting to start 'ora.rac132.vip' on 'rac132'

CRS-2677: Stop of 'ora.scan1.vip' on 'rac131' succeeded

CRS-2672: Attempting to start 'ora.scan1.vip' on 'rac132'

CRS-2676: Start of 'ora.rac132.vip' on 'rac132' succeeded

CRS-2672: Attempting to start 'ora.LISTENER.lsnr' on 'rac132'

CRS-2676: Start of 'ora.scan1.vip' on 'rac132' succeeded

CRS-2672: Attempting to start 'ora.LISTENER_SCAN1.lsnr' on 'rac132'

CRS-2676: Start of 'ora.ons' on 'rac132' succeeded

CRS-2676: Start of 'ora.LISTENER.lsnr' on 'rac132' succeeded

CRS-2672: Attempting to start 'ora.asm' on 'rac132'

CRS-2676: Start of 'ora.LISTENER_SCAN1.lsnr' on 'rac132' succeeded

CRS-2676: Start of 'ora.asm' on 'rac132' succeeded

CRS-2672: Attempting to start 'ora.DATA.dg' on 'rac132'

CRS-2676: Start of 'ora.DATA.dg' on 'rac132' succeeded

CRS-2672: Attempting to start 'ora.ccbprod.db' on 'rac132'

CRS-2676: Start of 'ora.ccbprod.db' on 'rac132' succeeded

CRS-6016: Resource auto-start has completed for server rac132

CRS-6024: Completed start of Oracle Cluster Ready Services-managed resources

CRS-4123: Oracle High Availability Services has been started.

2017/06/18 13:33:11 CLSRSC-343: Successfully started Oracle Clusterware stack

clscfg: EXISTING configuration version 5 detected.

clscfg: version 5 is 12c Release 2.

Successfully taken the backup of node specific configuration in OCR.

Successfully accumulated necessary OCR keys.

Creating OCR keys for user 'root', privgrp 'root'..

Operation successful.

2017/06/18 13:33:42 CLSRSC-595: Executing upgrade step 18 of 19: 'UpgradeNode'.

Start upgrade invoked..

2017/06/18 13:34:13 CLSRSC-478: Setting Oracle Clusterware active version on the last node to be upgraded

2017/06/18 13:34:13 CLSRSC-482: Running command: '/u01/app/12.2.0.1/GRID/bin/crsctl set crs activeversion'

Started to upgrade the active version of Oracle Clusterware. This operation may take a few minutes.

Started to upgrade CSS.

CSS was successfully upgraded.

Started to upgrade Oracle ASM.

Started to upgrade CRS.

CRS was successfully upgraded.

Successfully upgraded the active version of Oracle Clusterware.

Oracle Clusterware active version was successfully set to 12.2.0.1.0.

2017/06/18 13:35:26 CLSRSC-479: Successfully set Oracle Clusterware active version

2017/06/18 13:35:46 CLSRSC-476: Finishing upgrade of resource types

2017/06/18 13:36:10 CLSRSC-482: Running command: 'srvctl upgrade model -s 12.1.0.2.0 -d 12.2.0.1.0 -p last'

2017/06/18 13:36:10 CLSRSC-477: Successfully completed upgrade of resource types

2017/06/18 13:36:47 CLSRSC-595: Executing upgrade step 19 of 19: 'PostUpgrade'.

2017/06/18 13:36:57 CLSRSC-325: Configure Oracle Grid Infrastructure for a Cluster ... succeeded

Click OK to continue the installation

GI Upgrade has successfully completed.

Finally we have upgraded to 12cR2 GI.

Post validation the upgrade:

[oracle@rac132 ~]$ crsctl query css votedisk

## STATE File Universal Id File Name Disk group

-- ----- ----------------- --------- ---------

1. ONLINE e54d8c16d0d74f24bf3e8571390bb749 (ORCL:CRS01) [OCR_VOTING]

Located 1 voting disk(s).

[oracle@rac132 ~]$ crsctl query cluster site -all

Site 'rac-cluster' identified by GUID 'ae47291ec170cf03bfbd8b2ec3b4456c' in state 'ENABLED' contains nodes 'rac131,rac132' and no disk.

[oracle@rac132 ~]$ crsctl query crs activeversion -f

Oracle Clusterware active version on the cluster is [12.2.0.1.0]. The cluster upgrade state is [NORMAL]. The cluster active patch level is [0].

[oracle@rac132 ~]$ crsctl query crs releaseversion

Oracle High Availability Services release version on the local node is [12.2.0.1.0]

[oracle@rac132 ~]$ crsctl query crs softwareversion -all

Oracle Clusterware version on node [rac131] is [12.2.0.1.0]

Oracle Clusterware version on node [rac132] is [12.2.0.1.0]

[oracle@rac132 ~]$ crsctl query crs softwarepatch rac131

Oracle Clusterware patch level on node rac131 is [0].

[oracle@rac132 ~]$ crsctl query crs softwarepatch rac132

Oracle Clusterware patch level on node rac132 is [0].

[oracle@rac132 ~]$ crsctl query dns -servers

CRS-10018: the following configuration was found on the system:

CRS-10019: There are 1 domains in search order. They are:

ora.com

CRS-10022: There are 1 name servers. They are:

192.168.1.100

CRS-10020: number of retry attempts for name lookup is: 4

CRS-10021: timeout for each name lookup is: 5

[oracle@rac132 ~]$ crsctl check cluster -all

**************************************************************

rac131:

CRS-4537: Cluster Ready Services is online

CRS-4529: Cluster Synchronization Services is online

CRS-4533: Event Manager is online

**************************************************************

rac132:

CRS-4537: Cluster Ready Services is online

CRS-4529: Cluster Synchronization Services is online

CRS-4533: Event Manager is online

**************************************************************

[oracle@rac132 ~]$ crsctl stat res -t

-----------------------------------------------------------------

Name Target State Server State details

-----------------------------------------------------------------

Local Resources

-----------------------------------------------------------------

ora.ASMNET1LSNR_ASM.lsnr

ONLINE ONLINE rac131 STABLE

ONLINE ONLINE rac132 STABLE

ora.ASMNET2LSNR_ASM.lsnr

ONLINE ONLINE rac131 STABLE

ONLINE ONLINE rac132 STABLE

ora.DATA.dg

ONLINE ONLINE rac131 STABLE

ONLINE ONLINE rac132 STABLE

ora.LISTENER.lsnr

ONLINE ONLINE rac131 STABLE

ONLINE ONLINE rac132 STABLE

ora.OCR_VOTING.dg

ONLINE ONLINE rac131 STABLE

ONLINE ONLINE rac132 STABLE

ora.chad

ONLINE ONLINE rac131 STABLE

ONLINE ONLINE rac132 STABLE

ora.net1.network

ONLINE ONLINE rac131 STABLE

ONLINE ONLINE rac132 STABLE

ora.ons

ONLINE ONLINE rac131 STABLE

ONLINE ONLINE rac132 STABLE

ora.proxy_advm

OFFLINE OFFLINE rac131 STABLE

OFFLINE OFFLINE rac132 STABLE

-----------------------------------------------------------------

Cluster Resources

-----------------------------------------------------------------

ora.LISTENER_SCAN1.lsnr

1 ONLINE ONLINE rac132 STABLE

ora.LISTENER_SCAN2.lsnr

1 ONLINE ONLINE rac131 STABLE

ora.LISTENER_SCAN3.lsnr

1 ONLINE ONLINE rac131 STABLE

ora.MGMTLSNR

1 ONLINE ONLINE rac131 169.254.96.83 10.10.

10.131 20.20.20.131,

STABLE

ora.asm

1 ONLINE ONLINE rac131 STABLE

2 ONLINE ONLINE rac132 STABLE

ora.ccbprod.db

1 ONLINE ONLINE rac131 Open,HOME=/u01/app/o

racle/product/12.1.0

.2/DB_1,STABLE

2 ONLINE ONLINE rac132 Open,HOME=/u01/app/o

racle/product/12.1.0

.2/DB_1,STABLE

ora.cvu

1 ONLINE ONLINE rac132 STABLE

ora.mgmtdb

1 ONLINE ONLINE rac131 Open,STABLE

ora.qosmserver

1 ONLINE ONLINE rac132 STABLE

ora.rac131.vip

1 ONLINE ONLINE rac131 STABLE

ora.rac132.vip

1 ONLINE ONLINE rac132 STABLE

ora.scan1.vip

1 ONLINE ONLINE rac132 STABLE

ora.scan2.vip

1 ONLINE ONLINE rac131 STABLE

ora.scan3.vip

1 ONLINE ONLINE rac131 STABLE

-----------------------------------------------------------------

Now seems every thing is OK..

Moving to Database Upgrade to 12.2.0.1

[oracle@rac131 ~]$ cd /ora_nfs/software/Oracle/database/12.2.0.1/database/

[oracle@rac131 database]$ ls -ltrah

total 44K

-rwxrwxrwx. 1 777 501 500 Feb 7 2013 welcome.html

drwxrwxrwx. 3 777 501 4.0K Nov 26 2016 ..

drwxrwxrwx. 4 777 501 4.0K Jan 26 20:09 install

-rwxrwxrwx. 1 777 501 8.6K Jan 26 20:09 runInstaller

drwxrwxrwx. 2 777 501 4.0K Jan 26 20:09 rpm

drwxrwxrwx. 2 777 501 4.0K Jan 26 21:23 sshsetup

drwxrwxrwx. 2 777 501 4.0K Jan 26 21:23 response

drwxrwxrwx. 14 777 501 4.0K Jan 26 21:25 stage

drwxrwxrwx. 7 777 501 4.0K Jan 26 21:52 .

Click Next...

Select Upgrade Existing Database and Click Next...

Select Oracle RAC Database Installation and Click Next...

Select all nodes and Click Next...

Click Next...

Select the RDBMS HOME and Click Next...

Check appropriate Click Next...

Click Next...

Run the root.sh as root user

Run the root.sh as root user on node 1

[oracle@rac131 database]$ sudo /u01/app/oracle/product/12.2.0.2/DB_1/root.sh

Performing root user operation.

The following environment variables are set as:

ORACLE_OWNER= oracle

ORACLE_HOME= /u01/app/oracle/product/12.2.0.2/DB_1

Enter the full pathname of the local bin directory: [/usr/local/bin]:

The contents of "dbhome" have not changed. No need to overwrite.

The contents of "oraenv" have not changed. No need to overwrite.

The contents of "coraenv" have not changed. No need to overwrite.

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.

[oracle@rac131 database]$

Run the root.sh as root user on node 2

[oracle@rac132 ~]$ sudo /u01/app/oracle/product/12.2.0.2/DB_1/root.sh

Performing root user operation.

The following environment variables are set as:

ORACLE_OWNER= oracle

ORACLE_HOME= /u01/app/oracle/product/12.2.0.2/DB_1

Enter the full pathname of the local bin directory: [/usr/local/bin]:

The contents of "dbhome" have not changed. No need to overwrite.

The contents of "oraenv" have not changed. No need to overwrite.

The contents of "coraenv" have not changed. No need to overwrite.

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.

Click OK .. and type the sys dba password

Click Next....

Fix the any issue if prompting before upgrade. In my case I have remove all hidden "_your_parameter_name" parameter from my parameter in order to start the installation.

Select Enable Parallel Upgrade and all necessary in below list and Click Next....

Since I have taken backup before upgrade so I am skipping this step, Click Next....

Here I am configuring EM database express, if you don't want the you can unchecked the check box ... Click Next....

Validate the summary and Click Next....

In my case Upgrade was taking very long time (14 Hours) as I have set 8GB RAM for my virtual box of my each nodes, as minimum requirement for 12cR2 is 12GB. So total time taking is depends on system RAM.

My Database got upgraded to 12cR2.

Validating the upgraded database and pdbs

SQL> SELECT DISTINCT A.INST_ID,

NAME DB_NAME,

A.INSTANCE_NAME, VERSION, HOST_NAME , OPEN_MODE,

TO_CHAR(STARTUP_TIME,'DD-MON-RRRR HH:MI:SS AM') STARTUP_TIME,

TO_CHAR(CURRENT_SCN) CURR_SCN

FROM GV$INSTANCE A, GV$DATABASE B ;

INST_ID DB_NAME INSTANCE_NAME VERSION HOST_NAME OPEN_MODE STARTUP_TIME CURR_SCN

------- ---------- -------------- ----------- --------------- ----------- ------------------------- ---------

2 CCBPROD CCBPROD2 12.2.0.1.0 rac132.ora.com READ WRITE 18-JUN-2017 09:01:27 PM 5583974

1 CCBPROD CCBPROD1 12.2.0.1.0 rac131.ora.com READ WRITE 18-JUN-2017 09:01:21 PM 5583974

PDBS CHECKING

SQL> SELECT INST_ID,

CON_ID,

NAME,

OPEN_MODE,

OPEN_TIME,

CREATION_TIME,

LOCAL_UNDO,

RESTRICTED,

RECOVERY_STATUS

FROM GV$PDBS WHERE NAME <>'PDB$SEED';

INST_ID CON_ID NAME OPEN_MODE OPEN_TIME CREATION_ LOCAL_UNDO RES RECOVERY

------- ------ ---- ---------- -------------------------------- --------- ---------- --- --------

1 3 PCCB READ WRITE 18-JUN-17 11.51.18.229 PM +05:30 18-JUN-17 0 NO ENABLED

2 3 PCCB READ WRITE 18-JUN-17 11.51.18.238 PM +05:30 18-JUN-17 0 NO ENABLED

Validate the upgraded component

SQL> select COMP_ID,COMP_NAME,VERSION,STATUS,NAMESPACE,CONTROL,SCHEMA from dba_registry ;

COMP_ID COMP_NAME VERSION STATUS NAMESPACE CONTROL SCHEMA

---------- ----------------------------------- ---------- ------- --------- ------- ---------------

CATALOG Oracle Database Catalog Views 12.2.0.1.0 VALID SERVER SYS SYS

CATPROC Oracle Database Packages and Types 12.2.0.1.0 VALID SERVER SYS SYS

JAVAVM JServer JAVA Virtual Machine 12.2.0.1.0 VALID SERVER SYS SYS

XML Oracle XDK 12.2.0.1.0 VALID SERVER SYS SYS

CATJAVA Oracle Database Java Packages 12.2.0.1.0 VALID SERVER SYS SYS

APS OLAP Analytic Workspace 12.2.0.1.0 VALID SERVER SYS SYS

RAC Oracle Real Application Clusters 12.2.0.1.0 VALID SERVER SYS SYS

XDB Oracle XML Database 12.2.0.1.0 VALID SERVER SYS XDB

SDO Spatial 12.2.0.1.0 VALID SERVER SYS MDSYS

OWM Oracle Workspace Manager 12.2.0.1.0 VALID SERVER SYS WMSYS

CONTEXT Oracle Text 12.2.0.1.0 VALID SERVER SYS CTXSYS

ORDIM Oracle Multimedia 12.2.0.1.0 VALID SERVER SYS ORDSYS

DV Oracle Database Vault 12.2.0.1.0 VALID SERVER SYS DVSYS

XOQ Oracle OLAP API 12.2.0.1.0 VALID SERVER SYS OLAPSYS

OLS Oracle Label Security 12.2.0.1.0 VALID SERVER SYS LBACSYS

APEX Oracle Application Express 5.0.4.00.1 VALID SERVER SYS APEX_050000

....Hope this approach will help in your case. :)

Oracle Certified Master's - Blogs

Home

Friday, June 23, 2017

12cR2 RAC Upgrade from 12cR1 RAC