Oracle GI 12.2.0.1 and Chronyd Service

As we know, GI 12.1.0.2 still check ntpd though chronyd is running as per this blog

After upgrading to 12.2.0.1 GI, How can GI work with Chronyd ?

Subscribe to get access

Read more of this content when you subscribe today.

Restarting Oracle Clusterware GridSetup.sh OUI after rootupgrade.sh failed due to Network Issue

Due to the network issue, when upgrading 12.1.0.2 gird infrastructure to 12.2.0.1,  “rootupgrade.sh’ failed, and also ‘gridSetup.sh’ OUI disappeared.

Luckily we can continue to the upgrading process as following.

1) Rerun ‘rootupgrade.sh’ on racnode1.

2) then run ‘rootupgrade.sh’ on racnode2.

3) Run ‘gridSetup.sh’ OUI from VNC viewer X window:

[grid@racnode1 ~]$ /u01/app/12.2.0.1/grid/gridSetup.sh -skipPrereqs 
         -executeConfigTools -responseFile /home/grid/grid_12102_12201.rsp
Launching Oracle Grid Infrastructure Setup Wizard...

You can find the logs of this session at:
/u01/app/oraInventory/logs/GridSetupActions2020-01-14_00-37-21AM

The response file was manually saved from previous ‘gridSetup.sh’, which failed due to network issue.

Either you can find the same response file from directory ‘/u01/app/12.2.0.1/grid/install/response’.

Make sure to use the latest right response file.

[grid@racnode1 install]$ ls -ltr /home/grid/grid_12102_12201.rsp
-rw-r--r-- 1 grid oinstall 35310 Jan13 22:01/home/grid/grid_12102_12201.rsp

[grid@racnode1 install]$ ls -ltr /u01/app/12.2.0.1/grid/install/response
total 112
-rw-r----- 1 grid oinstall 1541 May21 2016 sample.ccf
-rw-r----- 1 grid oinstall 35087 Jan27 2017 gridsetup.rsp
-rw-r--r-- 1 grid oinstall 34357 Jan27 2017 grid_2017-01-26_04-10-28PM.rsp
-rw-r--r-- 1 grid oinstall 35310 Jan13 22:04 grid_2020-01-13_09-59-39PM.rsp
Start gridSetup.sh
Start gridSetup.sh
gridSetup.sh Upgrade GI
gridSetup.sh Upgrade GI
gridSetup.sh Finish
gridSetup.sh Finish

ORA-15032 ORA-59303 ORA-15221: ASM operation requires compatible.asm of 11.1.0.0.0 or higher

For upgrading 12.1.0.2 GI to 12.2.0.1 GI, after running rootupgrade.sh, there are some disk groups are not mounted.

NAME                  STATE       COMPATIBILITY      V
-------------------- ----------- ------------------- -
GIMR                  DISMOUNTED  0.0.0.0.0          N
FRA                   DISMOUNTED  0.0.0.0.0          N
DATA                  MOUNTED     12.1.0.0.0         N
OCR_VOTE              MOUNTED     11.2.0.4.0         Y
SQL> alter diskgroup FRA mount;
alter diskgroup FRA mount
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-59303: The attribute compatible.asm (10.1.0.0.0) of the 
           diskgroup being mounted should be 11.2.0.2.0 or higher.
ORA-15221: ASM operation requires compatible.asm of 11.1.0.0.0 
           or higher
SQL> alter diskgroup FRA mount restricted;

Diskgroup altered.

SQL> alter diskgroup FRA set attribute 'compatible.asm'='11.2.0.4';

Diskgroup altered.

SQL> alter diskgroup FRA dismount;

Diskgroup altered.

SQL> alter diskgroup GIMR mount restricted;

Diskgroup altered.

SQL> alter diskgroup GIMR set attribute 'compatible.asm'='11.2.0.4';

Diskgroup altered.

SQL> alter diskgroup GIMR dismount;

Diskgroup altered.

SQL> alter diskgroup FRA mount;

Diskgroup altered.

SQL> alter diskgroup GIMR mount;

Diskgroup altered.



SQL>   select NAME, STATE, COMPATIBILITY  from  v$asm_diskgroup;

NAME                           STATE       COMPATIBILITY
------------------------------ ----------- -------------------
DATA                           MOUNTED     12.1.0.0.0
FRA                            MOUNTED     11.2.0.4.0
OCR_VOTE                       MOUNTED     11.2.0.4.0
GIMR                           MOUNTED     11.2.0.4.0