Posted in Database, ORACLE

Upgrade to Oracle Database 12c Release 2 (12.2.0.1.0) — Part 2

In this part will be Upgrading Grid Home and Database home to Oracle 12.2.0.1.0.

Desired Software need to be downloaded from below mentioned link:

Oracle Software

Once desired Software is downloaded will be Upgrading Grid home first and then will be Upgrading Oracle Database.

 

1)Upgrading Grid Infrastructure to Oracle 12.2.0.1.0.

 

Grid1

Grid2

Grid3

Grid 4

Grid 5

Grid 6

Grid 7

Grid 8

 

Grid 9

 

Note:– It may happen that rootupgrade.sh may fails during Grid Installation with below mentioned error message.

a) ORA-01078 and ORA-29701

–ERROR MESSAGE–

[root@SEP02PVVM392 rpm]# /ora00/app/grid/product/12.2.0/rootupgrade.sh
Performing root user operation.

The following environment variables are set as:
 ORACLE_OWNER= grid
 ORACLE_HOME= /ora00/app/grid/product/12.2.0

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]:
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.
Using configuration parameter file: /ora00/app/grid/product/12.2.0/crs/install/crsconfig_params
The log of current session can be found at:
 /ora00/app/grid/crsdata/sep02pvvm392/crsconfig/roothas_2017-03-23_04-46-20AM.log

Upgrade cannot proceed because the ASM instance failed to start. Fix the issue or startup the ASM instance, verify and try again.
ORA-01078: failure in processing system parameters
ORA-29701: unable to connect to Cluster Synchronization Service


2017/03/23 04:46:26 CLSRSC-164: ASM upgrade failed
2017/03/23 04:46:26 CLSRSC-304: Failed to upgrade ASM for Oracle Restart configuration
Died at /ora00/app/grid/product/12.2.0/crs/install/crsupgrade.pm line 3083.
The command '/ora00/app/grid/product/12.2.0/perl/bin/perl -I/ora00/app/grid/product/12.2.0/perl/lib -I/ora00/app/grid/product/12.2.0/crs/install /ora00/app/grid/product/12.2.0/crs/install/roothas.pl -upgrade' execution failed

 

Solution: Start ASM  on new Grid Home and try again to run rootupgrade.sh

[root@TESTINGrpm]# /ora00/app/grid/product/12.2.0/rootupgrade.sh
Performing root user operation.

The following environment variables are set as:
 ORACLE_OWNER= grid
 ORACLE_HOME= /ora00/app/grid/product/12.2.0

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]:
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.
Using configuration parameter file: /ora00/app/grid/product/12.2.0/crs/install/crsconfig_params
The log of current session can be found at:
 /ora00/app/grid/crsdata/testing/crsconfig/roothas_2017-03-23_04-50-44AM.log

ASM has been upgraded and started successfully.

Creating OCR keys for user 'grid', privgrp 'oinstall'..
Operation successful.
LOCAL ONLY MODE
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
CRS-4664: Node testing successfully pinned.
2017/03/23 04:51:10 CLSRSC-329: Replacing Clusterware entries in file 'oracle-ohasd.service'
CRS-4123: Oracle High Availability Services has been started.

2017/03/23 04:55:03 CLSRSC-482: Running command: 'srvctl upgrade model -s 12.1.0.2.0 -d 12.2.0.1.0 -p first'
2017/03/23 04:55:05 CLSRSC-482: Running command: 'srvctl upgrade model -s 12.1.0.2.0 -d 12.2.0.1.0 -p last'


testing 2017/03/23 04:55:06 /ora00/app/grid/product/12.2.0/cdata/testing/backup_20170323_045506.olr 0

testing 2016/07/20 10:18:23 /ora00/app/grid/product/12.1.0/cdata/testing/backup_20160720_101823.olr 0

CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'testing'
CRS-2673: Attempting to stop 'ora.evmd' on 'testing'
CRS-2677: Stop of 'ora.evmd' on 'testing' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'testing' has completed
CRS-4133: Oracle High Availability Services has been stopped.
CRS-4123: Oracle High Availability Services has been started.
2017/03/23 04:55:57 CLSRSC-327: Successfully configured Oracle Restart for a standalone server

 

b) DIA-49802 and DIA-49801 .

Above mentioned error i got in different Cloned VM of this source VM.

# /ora00/app/grid/product/12.2.0/rootupgrade.sh
Performing root user operation.

The following environment variables are set as:
 ORACLE_OWNER= grid
 ORACLE_HOME= /ora00/app/grid/product/12.2.0

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]:
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.
Using configuration parameter file: /ora00/app/grid/product/12.2.0/crs/install/crsconfig_params
The log of current session can be found at:
 /ora00/app/grid/crsdata/sep02pvvm-405/crsconfig/roothas_2017-04-17_06-07-09AM.log


ASM has been upgraded and started successfully.

Oracle Clusterware infrastructure error in OCRCONFIG (OS PID 20893): CLSD/ADR initialization failed with return value -1
1: clskec:has:CLSU:910 4 args[clsdAdrInit_CLSK_err][mod=clsdadr.c][loc=(:CLSD00281:)][msg=clsdAdrInit: Additional diagnostic data returned by the ADR component for dbgc_init_all failure:
 DIA-49802: missing read, write, or execute permission on specified ADR home directory [/ora00/app/grid/diag/crs/sep02pvvm-405/crs/log]
DIA-49801: actual permissions [rwxrwx---], expected minimum permissions [rwxrwxrwx] for effective user [grid]
DIA-48188: user missing read, write, or exec permission on specified directory
Linux-x86_64 Error: 13: Permission denied
Additional information: 2
Additional information: 511
Additional information: 16888
([all diagnostic data retrieved from ADR])]
2: clskec:has:CLSU:910 4 args[clsdAdrInit_CLSK_err][mod=clsdadr.c][loc=(:CLSD00050:)][msg=clsdAdrInit: call to dbgc_init_all failed. facility:[CRS] product:[CRS] line number:[1422] return code: [ORA-49802] Oracle Base: [/ora00/app/grid] Product Type: [CRS] Host Name: [sep02pvvm-405] Instance ID: [crs] User Name: [grid]]


Oracle Clusterware infrastructure error in CLSCFG (OS PID 20903): CLSD/ADR initialization failed with return value -1
1: clskec:has:CLSU:910 4 args[clsdAdrInit_CLSK_err][mod=clsdadr.c][loc=(:CLSD00281:)][msg=clsdAdrInit: Additional diagnostic data returned by the ADR component for dbgc_init_all failure:
 DIA-49802: missing read, write, or execute permission on specified ADR home directory [/ora00/app/grid/diag/crs/sep02pvvm-405/crs/log]
DIA-49801: actual permissions [rwxrwx---], expected minimum permissions [rwxrwxrwx] for effective user [grid]
DIA-48188: user missing read, write, or exec permission on specified directory
Linux-x86_64 Error: 13: Permission denied
Additional information: 2
Additional information: 511
Additional information: 16888
([all diagnostic data retrieved from ADR])]
2: clskec:has:CLSU:910 4 args[clsdAdrInit_CLSK_err][mod=clsdadr.c][loc=(:CLSD00050:)][msg=clsdAdrInit: call to dbgc_init_all failed. facility:[CRS] product:[CRS] line number:[1422] return code: [ORA-49802] Oracle Base: [/ora00/app/grid] Product Type: [CRS] Host Name: [sep02pvvm-405] Instance ID: [crs] User Name: [grid]]

Creating OCR keys for user 'grid', privgrp 'oinstall'..
Operation successful.
LOCAL ONLY MODE
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
CRS-4664: Node sep02pvvm-405 successfully pinned.
2017/04/17 06:08:41 CLSRSC-329: Replacing Clusterware entries in file 'oracle-ohasd.service'
2017/04/17 06:10:46 CLSRSC-214: Failed to start the resource 'ohasd'
Failed to start the Clusterware. Last 20 lines of the alert log follow:
2017-04-17 06:09:23.605
[client(22558)]CRS-8500:Oracle Clusterware OHASD process is starting with operating system process ID 22558
2017-04-17 06:09:23.611
[client(22558)]CRS-2112:The OLR service started on node sep02pvvm-405.
2017-04-17 06:09:25.240
[client(22651)]CRS-8500:Oracle Clusterware OHASD process is starting with operating system process ID 22651
2017-04-17 06:09:25.247
[client(22651)]CRS-2112:The OLR service started on node sep02pvvm-405.
2017-04-17 06:09:26.901
[client(22743)]CRS-8500:Oracle Clusterware OHASD process is starting with operating system process ID 22743
2017-04-17 06:09:26.908
[client(22743)]CRS-2112:The OLR service started on node sep02pvvm-405.
2017-04-17 06:09:28.415
[client(22831)]CRS-8500:Oracle Clusterware OHASD process is starting with operating system process ID 22831
2017-04-17 06:09:28.422
[client(22831)]CRS-2112:The OLR service started on node sep02pvvm-405.
2017-04-17 06:09:30.014
[client(22914)]CRS-8500:Oracle Clusterware OHASD process is starting with operating system process ID 22914
2017-04-17 06:09:30.020
[client(22914)]CRS-2112:The OLR service started on node sep02pvvm-405.

2017/04/17 06:10:46 CLSRSC-318: Failed to start Oracle OHASD service
Died at /ora00/app/grid/product/12.2.0/crs/install/crsinstall.pm line 2775.
The command '/ora00/app/grid/product/12.2.0/perl/bin/perl -I/ora00/app/grid/product/12.2.0/perl/lib -I/ora00/app/grid/product/12.2.0/crs/install /ora00/app/grid/product/12.2.0/crs/install/roothas.pl -upgrade' execution failed

For above mentioned error i had to check ownership of  $GRID_HOME/diag/crs/testing/crs/* directories from root to grid user.

[root@SEP02PVVM-405 crs]# chown -R grid:oinstall alert
[root@SEP02PVVM-405 crs]# chown -R grid:oinstall cdump/
[root@SEP02PVVM-405 crs]# chown -R grid:oinstall incident/
[root@SEP02PVVM-405 crs]# chown -R grid:oinstall incpkg
[root@SEP02PVVM-405 crs]# chown -R grid:oinstall lck
[root@SEP02PVVM-405 crs]# chown -R grid:oinstall log
[root@SEP02PVVM-405 crs]# chown -R grid:oinstall metadata
[root@SEP02PVVM-405 crs]# chown -R grid:oinstall metadata_dgif
[root@SEP02PVVM-405 crs]# chown -R grid:oinstall metadata_pv
[root@SEP02PVVM-405 crs]# chown -R grid:oinstall stage
[root@SEP02PVVM-405 crs]# chown -R grid:oinstall sweep
[root@SEP02PVVM-405 crs]# chown -R grid:oinstall trace

Once this is done you will be able to start ASM services from New Grid Home.Don’t know why this came may be something happened during Cloning process but thought of sharing this information

 2) Once rootupgrade.sh has run try to see the Upgraded releaseversion.

[grid@TESTING bin]$ ./crsctl query has releaseversion
Oracle High Availability Services release version on the local node is [12.2.0.1.0]


[grid@TESTING bin]$ ./crsctl query has softwareversion
Oracle High Availability Services version on the local node is [12.2.0.1.0]

 

3) Once Grid is Upgraded we need to install Oracle Database 12.2.0.1.0 software.

db1

db2

db3

db4

db5

db6

db7

db8

db9

db10

4) Once Oracle 12.2.0.1.0 Software is installed you can easily Upgrade the Desired Database by Using DBUA.

Below mentioned metalink DOC ID contains all necessary information.

Complete Checklist for Upgrading to Oracle Database 12c Release 2 (12.2) using DBUA (Doc ID 2189854.1)

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s