Oracledna

Create a new ORACLE HOME using AutoUpgrade

This post demonstrates the creation of a new ORACLE HOME using AutoUpgrade utility.

Environemnt:
==========
RDBMS Version: 19.3
RU Patch: 19.27
ORACLE_HOME: /u01/app/oracle/product/19.27/db
OPatch: 12.2.0.1.52
OS: Oracle Linux 9.4

1. Install the preinstall package and Java (required by AutoUpgrade).

To fulfill teh pre requsites, run the oracle-database-preinstall-19c package.

dnf install oracle-database-preinstall-19c -y

AutoUpgrade requires Java 8 or Java 11.

dnf install java-1.8.0-openjdk

[root@prod ~]# dnf install java-1.8.0-openjdk
Last metadata expiration check: 0:00:51 ago on Wednesday 30 September 2026 04:55:11 PM.
Dependencies resolved.
=========================================================
Package Architecture Version Repository Size
=========================================================
Installing:
java-1.8.0-openjdk x86_64 1:1.8.0.504.b01-1.2.0.1.el9 ol9_appstream 462 k
Upgrading:
java-1.8.0-openjdk-headless x86_64 1:1.8.0.504.b01-1.2.0.1.el9 ol9_appstream 34 M
tzdata-java noarch 2026c-1.el9_8 ol9_appstream 507 k
Installing dependencies:
ttmkfdir x86_64 3.0.9-65.el9 ol9_appstream 53 k
xorg-x11-fonts-Type1 noarch 7.5-33.el9 ol9_appstream 526 k

Transaction Summary
==========================================================
Install 3 Packages
Upgrade 2 Packages

Total download size: 35 M
Is this ok [y/N]: y
Downloading Packages:
(1/5): ttmkfdir-3.0.9-65.el9.x86_64.rpm 35 kB/s | 53 kB 00:01
(2/5): java-1.8.0-openjdk-1.8.0.504.b01-1.2.0.1.el9.x86_64.rpm 36 kB/s | 462 kB 00:12
(3/5): xorg-x11-fonts-Type1-7.5-33.el9.noarch.rpm 39 kB/s | 526 kB 00:13
(4/5): tzdata-java-2026c-1.el9_8.noarch.rpm 40 kB/s | 507 kB 00:12
(5/5): java-1.8.0-openjdk-headless-1.8.0.504.b01-1.2.0.1.el9.x86_64.rpm 46 kB/s | 34 MB 12:33
———————————————————————————————————————————————
Total 48 kB/s | 35 MB 12:34
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
Running scriptlet: java-1.8.0-openjdk-headless-1:1.8.0.504.b01-1.2.0.1.el9.x86_64 1/1
Preparing : 1/1
Upgrading : tzdata-java-2026c-1.el9_8.noarch 1/7
Upgrading : java-1.8.0-openjdk-headless-1:1.8.0.504.b01-1.2.0.1.el9.x86_64 2/7
warning: /etc/java/java-1.8.0-openjdk/java-1.8.0-openjdk-1.8.0.504.b01-1.2.0.1.el9.x86_64/lib/net.properties created as /etc/java/java-1.8.0-openjdk/java-1.8.0-openjdk-1.8.0.504.b01-1.2.0.1.el9.x86_64/lib/net.properties.rpmnew
warning: /etc/java/java-1.8.0-openjdk/java-1.8.0-openjdk-1.8.0.504.b01-1.2.0.1.el9.x86_64/lib/security/java.security created as /etc/java/java-1.8.0-openjdk/java-1.8.0-openjdk-1.8.0.504.b01-1.2.0.1.el9.x86_64/lib/security/java.security.rpmnew
warning: /etc/java/java-1.8.0-openjdk/java-1.8.0-openjdk-1.8.0.504.b01-1.2.0.1.el9.x86_64/lib/security/nss.fips.cfg created as /etc/java/java-1.8.0-openjdk/java-1.8.0-openjdk-1.8.0.504.b01-1.2.0.1.el9.x86_64/lib/security/nss.fips.cfg.rpmnew

Running scriptlet: java-1.8.0-openjdk-headless-1:1.8.0.504.b01-1.2.0.1.el9.x86_64 2/7
restored /etc/java/java-1.8.0-openjdk/java-1.8.0-openjdk-1.8.0.504.b01-1.2.0.1.el9.x86_64/lib/security/nss.fips.cfg.rpmnew to /etc/java/java-1.8.0-openjdk/java-1.8.0-openjdk-1.8.0.504.b01-1.2.0.1.el9.x86_64/lib/security/nss.fips.cfg
restored /etc/java/java-1.8.0-openjdk/java-1.8.0-openjdk-1.8.0.504.b01-1.2.0.1.el9.x86_64/lib/security/java.security.rpmnew to /etc/java/java-1.8.0-openjdk/java-1.8.0-openjdk-1.8.0.504.b01-1.2.0.1.el9.x86_64/lib/security/java.security
restored /etc/java/java-1.8.0-openjdk/java-1.8.0-openjdk-1.8.0.504.b01-1.2.0.1.el9.x86_64/lib/net.properties.rpmnew to /etc/java/java-1.8.0-openjdk/java-1.8.0-openjdk-1.8.0.504.b01-1.2.0.1.el9.x86_64/lib/net.properties

Installing : ttmkfdir-3.0.9-65.el9.x86_64 3/7
Installing : xorg-x11-fonts-Type1-7.5-33.el9.noarch 4/7
Running scriptlet: xorg-x11-fonts-Type1-7.5-33.el9.noarch 4/7
Installing : java-1.8.0-openjdk-1:1.8.0.504.b01-1.2.0.1.el9.x86_64 5/7
Running scriptlet: java-1.8.0-openjdk-1:1.8.0.504.b01-1.2.0.1.el9.x86_64 5/7
Cleanup : java-1.8.0-openjdk-headless-1:1.8.0.402.b06-2.0.1.el9.x86_64 6/7
Running scriptlet: java-1.8.0-openjdk-headless-1:1.8.0.402.b06-2.0.1.el9.x86_64 6/7
Cleanup : tzdata-java-2024a-1.el9.noarch 7/7
Running scriptlet: java-1.8.0-openjdk-headless-1:1.8.0.504.b01-1.2.0.1.el9.x86_64 7/7
Running scriptlet: java-1.8.0-openjdk-1:1.8.0.504.b01-1.2.0.1.el9.x86_64 7/7
Running scriptlet: tzdata-java-2024a-1.el9.noarch 7/7
Verifying : java-1.8.0-openjdk-1:1.8.0.504.b01-1.2.0.1.el9.x86_64 1/7
Verifying : ttmkfdir-3.0.9-65.el9.x86_64 2/7
Verifying : xorg-x11-fonts-Type1-7.5-33.el9.noarch 3/7
Verifying : java-1.8.0-openjdk-headless-1:1.8.0.504.b01-1.2.0.1.el9.x86_64 4/7
Verifying : java-1.8.0-openjdk-headless-1:1.8.0.402.b06-2.0.1.el9.x86_64 5/7
Verifying : tzdata-java-2026c-1.el9_8.noarch 6/7
Verifying : tzdata-java-2024a-1.el9.noarch 7/7

Upgraded:
java-1.8.0-openjdk-headless-1:1.8.0.504.b01-1.2.0.1.el9.x86_64 tzdata-java-2026c-1.el9_8.noarch
Installed:
java-1.8.0-openjdk-1:1.8.0.504.b01-1.2.0.1.el9.x86_64 ttmkfdir-3.0.9-65.el9.x86_64 xorg-x11-fonts-Type1-7.5-33.el9.noarch

Complete!

2. Create directories for ORACLE HOME, inventory and for software location.

 

[oracle@prod ~]$ mkdir -p /u01/app/oracle/product/19.27/db

 

[oracle@prod ~]$ mkdir -p /u01/app/oraInventory

 

[oracle@prod ~]$ mkdir -p /misc/oracle/softwares/

3. Download Softwares and place them at softwares location.


[oracle@prod softwares]$ ls -lrt
total 5352056
-rw-r–r–. 1 oracle oinstall 3059705302 Feb 5 2022 LINUX.X64_193000_db_home.zip
-rw-r–r–. 1 oracle oinstall 2284324411 May 2 2025 p37642901_190000_Linux-x86-64.zip
-rw-r–r–. 1 oracle oinstall 136460315 Jul 22 16:16 p6880880_190000_Linux-x86-64.zip


Oracle 19c (19.3) Base version: LINUX.X64_193000_db_home.zip
RU 19.27 Patch: p37642901_190000_Linux-x86-64.zip
OPatch 12.2.0.1.52 for DB 19.0.0.0.0 : p6880880_190000_Linux-x86-64.zip

4. Download AutoUpgrade utility.

Create a directory to hold AutoUpgrade jar file and logs.

[oracle@prod ~]$ mkdir -p /misc/oracle/autoupgrade

[oracle@prod ~]$ mkdir -p /misc/oracle/autoupgrade/logs

Download the latest AutoUpgrade utility by using below URL and copy to the AutoUpgrade directory.

https://download.oracle.com/otn-pub/otn_software/autoupgrade.jar

[oracle@prod autoupgrade]$ ls -lrt
total 7060
-rw-r–r–. 1 oracle oinstall 7227888 Sep 30 12:29 autoupgrade.jar

5. Create an AutoUpgrade config file called install-home.cfg

cd /misc/oracle/autoupgrade

vi install-home.cfg

global.global_log_dir=/misc/oracle/autoupgrade/logs
install1.patch=RU:19.27,OPATCH
install1.folder=/misc/oracle/softwares
install1.platform=LINUX.X64
install1.target_home=/u01/app/oracle/product/19.27/db
install1.home_settings.oracle_base=/u01/app/oracle
install1.home_settings.edition=EE
install1.home_settings.inventory_location=/u01/app/oraInventory
install1.home_settings.inventory_group=oinstall
install1.home_settings.osdba_group=dba
install1.home_settings.osbackupdba_group=backupdba
install1.home_settings.oskmdba_group=kmdba
install1.home_settings.osracdba_group=racdba
install1.home_settings.osdgdba_group=dgdba
install1.home_settings.osoper_group=oper
install1.download=no
install1.home_settings.ru_apply=yes
install1.target_version=19

6. start AutoUpgrade to create ORACLE HOME

[oracle@prod autoupgrade]$ java -jar autoupgrade.jar -config install-home.cfg -patch -mode create_home

AutoUpgrade Patching 26.6.260925 launched with default internal options
Processing config file …
+—————————————–+
| Starting AutoUpgrade Patching execution |
+—————————————–+
Type ‘help’ to list console commands
patch> lsj
+—-+————-+——-+———+——-+———-+——-+———————+
|Job#| DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+—-+————-+——-+———+——-+———-+——-+———————+
| 100|create_home_1|EXTRACT|EXECUTING|RUNNING| 06:58:13|35s ago|Extracting Base Image|
+—-+————-+——-+———+——-+———-+——-+———————+
Total jobs 1

 

 

patch> status

Config

User configuration file [/misc/oracle/autoupgrade/install-home.cfg]
General logs location [/misc/oracle/autoupgrade/logs/cfgtoollogs/patch/auto]
Mode [CREATE_HOME]
Jobs Summary

Total databases in configuration file [1]
Total Non-CDB being processed [1]
Total Containers being processed [0]

Jobs finished successfully [0]
Jobs finished/stopped [0]
Jobs in progress [1]

Progress
+—+———————————————————+
|Job| Progress|
+—+———————————————————+
|100|[|||||||||||||| ] 27 %|
+—+———————————————————+

 


patch> Job 100 completed
——————- Final Summary ——————–
Number of databases [ 1 ]

Jobs finished [1]
Jobs failed [0]
Jobs restored [0]
Jobs pending [0]

# Run the root.sh script as root for the following jobs:
For create_home_1 -> /u01/app/oracle/product/19.27/db/root.sh

# Run the orainstRoot.sh script as root for the following jobs:
For create_home_1 -> /u01/app/oraInventory/orainstRoot.sh

Please check the summary report at:
/misc/oracle/autoupgrade/logs/cfgtoollogs/patch/auto/status/status.html
/misc/oracle/autoupgrade/logs/cfgtoollogs/patch/auto/status/status.log

8. Check the contents.xml to verify the home is added or not.


[oracle@prod ~]$ cd /u01/app/oraInventory/ContentsXML/

[oracle@prod ContentsXML]$ cat inventory.xml
<?xml version=”1.0″ standalone=”yes” ?>
<!– Copyright (c) 1999, 2026, Oracle and/or its affiliates.
All rights reserved. –>
<!– Do not modify the contents of this file by hand. –>
<INVENTORY>
<VERSION_INFO>
<SAVED_WITH>12.2.0.7.0</SAVED_WITH>
<MINIMUM_VER>2.1.0.6.0</MINIMUM_VER>
</VERSION_INFO>
<HOME_LIST>
<HOME NAME=”OraDB19Home1″ LOC=”/u01/app/oracle/product/19.27/db” TYPE=”O” IDX=”1″/>
</HOME_LIST>
<COMPOSITEHOME_LIST>
</COMPOSITEHOME_LIST>
</INVENTORY>

9. Verify the RDBMS version.

[oracle@prod ~]$ export ORACLE_HOME=/u01/app/oracle/product/19.27/db

[oracle@prod ~]$ export PATH=$ORACLE_HOME/bin:$PATH

[oracle@prod ~]$ sqlplus -V

SQL*Plus: Release 19.0.0.0.0 – Production
Version 19.27.0.0.0

Disclaimer:

Please note the above information is only for educational purpose and practised in personal test database only. Always test in test database before implementing in production database. The pre-requisites and ways of implementing may vary from one environment to another. Hence, not providing guarantee that it will work in your environment.