How to prepare a response file for a grid 18c silent upgrade

Posted in: Technical Track

Due to security and complexity of the environment, the option to use Graphical User Interface (GUI) is not always available. Upgrade operations will need to be performed from the command line interface (CLI).

Determine groups assigned to grid and oracle user:

[[email protected] ~]$ id grid
uid=54320(grid) gid=54321(oinstall) groups=54321(oinstall),54318(asmdba),54319(asmoper),54320(asmadmin),54322(dba)
[[email protected] ~]$ id oracle
uid=54321(oracle) gid=54321(oinstall) groups=54321(oinstall),54318(asmdba),54320(asmadmin),54322(dba),54323(backupdba),54324(oper),54325(dgdba),54326(kmdba)
[[email protected] ~]$

Create response file gridsetup_upgrade.rsp from gridsetup.rsp. There are 667 lines from gridsetup.rsp and it’s not efficient to view the entire file to identify modifications.

[[email protected] 18cLinux]$ wc -l gridsetup.rsp
667 gridsetup.rsp
[[email protected] 18cLinux]$

One method to identify change:

[[email protected] 18cLinux]$ egrep -v "^#" gridsetup_upgrade.rsp | awk -F'=' '$2'

Another option is to use sdiff; however, a disadvantage is that it does not provide a version for a response file:

[[email protected] 18cLinux]$ sdiff -iEZbWBst -w 120 gridsetup.rsp gridsetup_upgrade.rsp
INVENTORY_LOCATION=                                        |  INVENTORY_LOCATION=/u01/app/oraInventory
oracle.install.option=                                     |  oracle.install.option=UPGRADE
ORACLE_BASE=                                               |  ORACLE_BASE=/u01/app/oracle
oracle.install.asm.OSDBA=                                  |  oracle.install.asm.OSDBA=asmdba
oracle.install.asm.OSOPER=                                 |  oracle.install.asm.OSOPER=asmoper
oracle.install.asm.OSASM=                                  |  oracle.install.asm.OSASM=asmadmin                        |            |      |               |                 |
[[email protected] 18cLinux]$
-i, --ignore-case
-E, --ignore-tab-expansion
-Z, --ignore-trailing-space
-b, --ignore-space-change
-W, --ignore-all-space
-B, --ignore-blank-lines
-s, --suppress-common-lines
-t, --expand-tabs (expand tabs to spaces in output)
-w, --width=NUM

In conclusion, the steps outlined should provide for a more efficient method to provide only pertinent changes for the response file.



Want to talk with an expert? Schedule a call with our team to get the conversation started.

No comments

Leave a Reply

Your email address will not be published. Required fields are marked *