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.
Day: January 14, 2020
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
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
Make DBA Life Easy 