Which three are true about upgrading Oracle Grid Infrastructure? (Choose three.)
Which three are true about upgrading Oracle Grid Infrastructure? (Choose three.)
Upgrading Oracle Grid Infrastructure requires the new version to be installed in a separate Oracle Grid Infrastructure home on the same server as the existing version, this is known as an out-of-place upgrade. An existing Oracle base can be reused during the upgrade process, which simplifies the upgrade. Additionally, all Oracle Database instances on the nodes being upgraded must be shut down before starting the upgrade process to prevent any conflicts or issues during the upgrade. These steps ensure a smooth and effective upgrade process for Oracle Grid Infrastructure.
I Think BCE F is incorrect, grid OS system can be named anyway. D patches won't be apply automatically A Oracle Grid only supports out-of-place upgrades
BCF https://docs.oracle.com/en/database/oracle/oracle-database/19/cwlin/restrictions-for-oracle-grid-infrastructure-upgrades.html#GUID-76797070-C2C6-4817-902C-037A67A6EF94 Oracle Grid Infrastructure upgrades are always out-of-place upgrades. You cannot perform an in-place upgrade of Oracle Grid Infrastructure to existing homes. The same user that owned the earlier release Oracle Grid Infrastructure software must perform the Oracle Grid Infrastructure 19c upgrade.
I think it's BCF, cause the services are shutdown by the rootupgrade.sh: "The script shuts down the earlier release installation, replaces it with the new Oracle Clusterware release, and starts the new Oracle Clusterware installation." https://docs.oracle.com/en/database/oracle/oracle-database/19/cwlin/running-oui-to-upgrade-grid-infrastructure-from-an-earlier-release.html#GUID-3BE36DF3-EB62-4CD1-B53A-850A3E2129E3 While at the same time, F seems to be true since the upgrade can only be done by the same user who owned the previous installation: "The same user that owned the earlier release Oracle Grid Infrastructure software must perform the Oracle Grid Infrastructure 19c upgrade." https://docs.oracle.com/en/database/oracle/oracle-database/19/cwlin/restrictions-for-oracle-grid-infrastructure-upgrades.html#GUID-76797070-C2C6-4817-902C-037A67A6EF94
In a doc page for 12c, it's stated even more directly: "Oracle recommends that you leave Oracle RAC instances running when upgrading Oracle Clusterware. When you start the root script on each node, the database instances on that node are shut down and then the rootupgrade.sh script starts the instances again." https://docs.oracle.com/database/121/CWLIN/procstop.htm#CWLIN519
F is False. You run the installer software with the Oracle grid infrastructure installation owner user account (oracle or grid). https://docs.oracle.com/cd/E14804_01/doc/install.112/e10816/presolar.htm#CHDFAIBE
F is incorrect because in case of 'opatchauto', root is the user that can run the command. So, I think B is right because is about new version, that means OutOfPlace Upgrade. Upgrade can reuse an existing Oracle Base (C). And E for sure, because (at the moment) GI needs DBs from that node to be down. (E). So, most probably are B,C,E
bce ok
I agree with SimoneF - BCF.
BCD After grid upgrade, you can list the patches: $ORACLE_HOME/OPatch/opatch lspatches 31950577;TOO MUCH TRACING WHEN CONTENT CHECK DETECTS AND REPAIRS CORRUPTED BLOCKS 31683216;OCW Interim patch for 31683216 32240590;TOMCAT RELEASE UPDATE 19.0.0.0.0 (32240590) 32218663;ACFS RELEASE UPDATE 19.10.0.0.0 (32218663) 32218454;Database Release Update : 19.10.0.0.210119 (32218454) 29340594;DBWLM RELEASE UPDATE 19.0.0.0.0 (29340594)
i think BCE
BCE for me
I vote for BCE
between E or F, i agree with F "The same user that owned the earlier release Oracle Grid Infrastructure software must perform the Oracle Grid Infrastructure 19c upgrade." source : https://docs.oracle.com/en/database/oracle/oracle-database/19/cwlin/restrictions-for-oracle-grid-infrastructure-upgrades.html#GUID-76797070-C2C6-4817-902C-037A67A6EF94
E is not TRUE, because we can do a rolling upgrade
What About Single Instances Databases??
Sure, but all the database instances on the currently upgraded node have to be shut down.
F?? To be honest the upgrade process is doing by root user. I mean the physical process of upgrade not a prepare of home before upgrade
Yeah i agree now. Dont know why i was thinking grid owner cant be other than grid user. So F definitely wrong
B, C, F could also correct
But I found now this, so E is really also good: https://docs.oracle.com/database/121/RILIN/procstop.htm#RILIN1173 => If you are upgrading the Oracle Clusterware or Oracle ASM software, then you must first stop all Oracle RAC database instances and all Oracle database instances that use Oracle ASM for storage. After stopping the database instances, shut down the Oracle ASM instances and Oracle Clusterware, as described in the following steps ...
I think BEF
(Not F): "The same user that owned the earlier release Oracle Grid Infrastructure software must perform the Oracle Grid Infrastructure 19c upgrade." This formulation leaves open the possibility of having a user with a name other than 'grid'.