26 September 2022

Quick install Oracle 19c+RU

Following Mike Dietrich's post https://mikedietrichde.com/2020/07/28/install-and-patch-in-one-single-action-with-oui/   I tried to do a quick install of 19c with the latest patchset (July 2022), in one go.

I didnt want to use any graphical interface, so a silent install would be needed.  Below I quickly note down my steps, use them at your own risk. 

I start with a compute node ('Instance') on OCI, with a OEL 8 image. 

Logon (ssh key) as opc user, and then...

sudo  yum -y install oracle-database-preinstall-19c

sudo mkdir /u01

sudo chown oracle: /u01

sudo su - oracle

mkdir /u01/software

cd /u01/software


Download 19.3 + patch + opatch:

The base installation is the V982063-01.zip. This is downloaded with the wget.sh script that is available from edelivery.

The quarterly patch, below is RU July 2022, that is found on MOS, and downloaded with wget script.

The OPatch, you can download in any way you like. I usually make a small wget script and use the link that can be derived from MOS.


[oracle@host01 software]$ ll *zip

-rw-r--r--. 1 oracle oinstall  124211908 Sep  1 13:33 newopatch.zip

-rw-r--r--. 1 oracle oinstall 1684302607 Jul 19 21:52 p34160831_190000_Linux-x86-64.zip

-rw-r--r--. 1 oracle oinstall 3059705302 Apr 23  2019 V982063-01.zip  


unzip -q p34160831_190000_Linux-x86-64.zip

mkdir -p /u01/app/oracle/product/19.0.0/dbhome_1

export ORACLE_HOME=/u01/app/oracle/product/19.0.0/dbhome_1

cd $ORACLE_HOME

unzip -q /u01/software/V982063-01.zip

mv OPatch/ OPatch.prev/

unzip -q /u01/software/newopatch.zip


Now create a responsefile /home/oracle/db_patched.rsp, as below example. After that,

export CV_ASSUME_DISTID=OEL7.8

cd $ORACLE_HOME

./runInstaller -silent -applyRU /u01/software/34160831/34133642 -applyOneOffs /u01/software/34160831/34086870 -responseFile /home/oracle/db_patched.rsp



---[ responsefile ]------------------

oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v19.0.0

oracle.install.option=INSTALL_DB_SWONLY

UNIX_GROUP_NAME=oinstall

INVENTORY_LOCATION=/u01/app/oraInventory

ORACLE_BASE=/u01/app/oracle

oracle.install.db.InstallEdition=EE

oracle.install.db.OSDBA_GROUP=dba

oracle.install.db.OSOPER_GROUP=oper

oracle.install.db.OSBACKUPDBA_GROUP=backupdba

oracle.install.db.OSDGDBA_GROUP=dgdba

oracle.install.db.OSKMDBA_GROUP=kmdba

oracle.install.db.OSRACDBA_GROUP=racdba

oracle.install.db.rootconfig.executeRootScript=false

---------------------------------------


Run as root:

/u01/app/oraInventory/orainstRoot.sh

/u01/app/oracle/product/19.0.0/dbhome_1/root.sh