Currently I have two node Grid Infrastructure on 11.2.0.4. The node names are node1 and node2:
[grid@node1 ~]$ crsctl query crs activeversion Oracle Clusterware active version on the cluster is [11.2.0.4.0] [grid@node1 ~]$ crsctl query crs softwareversion Oracle Clusterware version on node [node1] is [11.2.0.4.0] [grid@node1 ~]$ crsctl query crs softwareversion node2 Oracle Clusterware version on node [node2] is [11.2.0.4.0]
Now we are extracting the source files for 12.1.0.2 and make necessary folder.
[grid@node1 ~]$ cd /u01/app/oracle/software/ [grid@node1 software]$ ls -l total 2337928 -rw-r--r--. 1 grid oinstall 1747043545 Aug 5 15:14 linuxamd64_12102_grid_1of2.zip -rw-r--r--. 1 grid oinstall 646972897 Aug 5 15:14 linuxamd64_12102_grid_2of2.zip [grid@node1 software]$ unzip linuxamd64_12102_grid_1of2.zip [grid@node1 software]$ unzip linuxamd64_12102_grid_2of2.zip
[root@node1 app] mkdir /u01/app/12.1.0.2/ [root@node1 app] chown grid:oinstall /u01/app/12.1.0.2/ [root@node1 app] ssh node2 root@node2's password: Last login: Thu Nov 5 14:52:57 2015 from node1 [root@racp1vm2 ~] mkdir /u01/app/12.1.0.2/ [root@racp1vm2 ~] chown grid:oinstall /u01/app/12.1.0.2/
Now we creating the response file for installation of new grid on both nodes.
cat /tmp/grid_install.rsp ORACLE_HOSTNAME=node1.localhost INVENTORY_LOCATION=/u01/app/oraInventory SELECTED_LANGUAGES=en oracle.install.option=UPGRADE ORACLE_BASE=/u01/app/grid ORACLE_HOME=/u01/app/12.1.0.2/ oracle.install.asm.OSDBA=asmdba oracle.install.asm.OSOPER=asmoper oracle.install.asm.OSASM=asmadmin oracle.install.crs.config.clusterName=racp1vm-cluster oracle.install.crs.config.gpnp.configureGNS=false oracle.install.crs.config.autoConfigureClusterNodeVIP=true oracle.install.crs.config.gpnp.gnsOption=CREATE_NEW_GNS oracle.install.crs.config.clusterNodes=node1:,node2: oracle.install.crs.config.storageOption=LOCAL_ASM_STORAGE oracle.install.crs.config.sharedFileSystemStorage.votingDiskRedundancy=NORMAL oracle.install.crs.config.sharedFileSystemStorage.ocrRedundancy=NORMAL oracle.install.asm.diskGroup.name=CRS oracle.install.asm.diskGroup.AUSize=1 oracle.install.crs.config.ignoreDownNodes=false oracle.install.config.managementOption=NONE
Now we are installing grid home with response file.
[grid@node1 software]$ cd grid [grid@node1 software]$ ./runInstaller -slient -responseFile /tmp/db_install.rsp -ignoreSysPrereqs -ignorePrereq -waitforcompletion
After completion we get the output
As a root user, execute the following script(s): 1. /u01/app/12.1.0.2/rootupgrade.sh Execute /u01/app/12.1.0.2/rootupgrade.sh on the following nodes: [node1, node2] Run the script on the local node first. After successful completion, you can start the script in parallel on all other nodes, except a node you designate as the last node. When all the nodes except the last node are done successfully, run the script on the last node. Successfully Setup Software. As install user, execute the following script to complete the configuration. 1. /u01/app/12.1.0.2/cfgtoollogs/configToolAllCommands RESPONSE_FILE= Note: 1. This script must be run on the same host from where installer was run. 2. This script needs a small password properties file for configuration assistants that require passwords (refer to install guide documentation).
Upgrade on the first node:
[root@node1 ~] /u01/app/12.1.0.2/rootupgrade.sh Check /u01/app/12.1.0.2/install/root_node1.localhost_2017-07-23_12-32-03.log for the output of root script
Log Output for Node 1
<<Output Truncated>> 2017/07/23 12:41:44 CLSRSC-474: Initiating upgrade of resource types 2017/07/23 12:41:50 CLSRSC-482: Running command: 'upgrade model -s 11.2.0.4.0 -d 12.1.0.2.0 -p first' 2017/07/23 12:41:50 CLSRSC-475: Upgrade of resource types successfully initiated. 2017/07/23 12:41:52 CLSRSC-325: Configure Oracle Grid Infrastructure for a Cluster ... succeeded
Now upgrade the second node
[root@node2 ~] /u01/app/12.1.0.2/rootupgrade.sh Check /u01/app/12.1.0.2/install/root_node2.localhost_2017-07-23_13-43-30.log for the output of root script
Log Output for Node 2
<<Output Truncated>> We can confirm the version 2017/07/23 12:41:44 CLSRSC-474: Initiating upgrade of resource types 2017/07/23 12:41:50 CLSRSC-482: Running command: 'upgrade model -s 11.2.0.4.0 -d 12.1.0.2.0 -p first' 2017/07/23 12:41:50 CLSRSC-475: Upgrade of resource types successfully initiated. 2017/07/23 12:41:52 CLSRSC-325: Configure Oracle Grid Infrastructure for a Cluster ... succeeded
We can confirm the version
[root@node2 ~] /u01/app/12.1.0.2/bin/crsctl query crs activeversion Oracle Clusterware active version on the cluster is [12.1.0.2.0] [root@node2 ~] /u01/app/12.1.0.2/bin/crsctl query crs softwareversion Oracle Clusterware version on node [node2] is [12.1.0.2.0]
Cheers!! Upgrade done
where is preupgrade script ..?
Hi Narendra
This upgrade for Grid Infrastructure, preupgrade script is needed for DB home not for GI.
What about 12cR2 upgrade? Same procedure?
Yes it might be same procedure
But i didn’t try