19c autoupgrade prechecks fails with error TARGET_HOME_REGISTERED_INVENTORY

Issue:

Error Message:

Check failed for UAT1, manual intervention needed for the below checks

[TARGET_HOME_REGISTERED_INVENTORY]

Cause:

The 19c Oracle Home is not registered on the central inventory

Fix:

AttachHome or add 19c Oracle Home entries into central inventory

Error Logs and commands output:

1. Create config file using auto-upgrade jar file.

[oracle@oraclelab1 19c-autoupg]$ env |grep ORA

ORACLE_SID=UAT1

ORACLE_BASE=/u01/app/oracle

ORACLE_HOME=/u01/app/oracle/product/12.2.0.1/dbhome_1

[oracle@oraclelab1 19c-autoupg]$ /u01/app/oracle/product/19.0.0.0/dbhome_1/jdk/bin/java -jar /u01/app/oracle/product/19.0.0.0/dbhome_1/rdbms/admin/autoupgrade.jar -create_sample_file config

Created sample configuration file /u01/patches/19c-autoupg/sample_config.cfg

[oracle@oraclelab1 19c-autoupg]$

2. Modify the config file according to the target database which are planning to upgrade

[oracle@oraclelab1 19c-autoupg]$ cp sample_config.cfg UAT_config.cfg

[oracle@oraclelab1 19c-autoupg]$ vi UAT_config.cfg

3. Run the auto-upgrade prechks in ANALYZE mode which reported the failure

[oracle@oraclelab1 19c-autoupg]$ /u01/app/oracle/product/19.0.0.0/dbhome_1/jdk/bin/java -jar /u01/app/oracle/product/19.0.0.0/dbhome_1/rdbms/admin/autoupgrade.jar -config UAT_config.cfg -mode ANALYZE

AutoUpgrade 24.8.241119 launched with default internal options

Processing config file ...

+--------------------------------+

| Starting AutoUpgrade execution |

+--------------------------------+

1 Non-CDB(s) will be analyzed

Type 'help' to list console commands

upg> upg> upg>

upg> lsj

+----+-------+---------+---------+-------+----------+-------+----------------------------+

+----+-------+---------+---------+-------+----------+-------+----------------------------+

+----+-------+---------+---------+-------+----------+-------+----------------------------+

Total jobs 1

upg> lsj

+----+-------+---------+---------+-------+----------+-------+----------------------------+

+----+-------+---------+---------+-------+----------+-------+----------------------------+

+----+-------+---------+---------+-------+----------+-------+----------------------------+

Total jobs 1

upg> Job 101 completed

------------------- Final Summary --------------------

Number of databases [ 1 ]

Jobs finished [1]

Jobs failed [0]

Please check the summary report at:

/u01/patches/19c-autoupg/cfgtoollogs/upgrade/auto/status/status.html

/u01/patches/19c-autoupg/cfgtoollogs/upgrade/auto/status/status.log

[oracle@oraclelab1 19c-autoupg]$

4. Error message reported on the prechecks log

[oracle@oraclelab1 19c-autoupg]$ more /u01/patches/19c-autoupg/cfgtoollogs/upgrade/auto/status/status.log

==========================================

Autoupgrade Summary Report

==========================================

[Date] Thu May 08 10:32:38 IST 2025

[Number of Jobs] 1

==========================================

[Job ID] 101

==========================================

[DB Name] UAT

[Version Before Upgrade] 12.2.0.1.0

[Version After Upgrade] 19.17.0.0.0

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

[Stage Name] PRECHECKS

[Status] FAILURE

[Start Time] 2025-05-08 10:32:06

[Duration] 0:00:31

[Log Directory] /u01/patches/19c-autoupg/UAT/UAT1/101/prechecks

[Detail] /u01/patches/19c-autoupg/UAT/UAT1/101/prechecks/uat_preupgrade.log

Check failed for UAT1, manual intervention needed for the below checks

[TARGET_HOME_REGISTERED_INVENTORY]

Cause:The following checks have ERROR severity and no auto fixup is available or

the fixup failed to resolve the issue. Fix them before continuing:

UAT1 TARGET_HOME_REGISTERED_INVENTORY

Reason:Database Checks has Failed details in /u01/patches/19c-autoupg/UAT/UAT1/101/prechecks

Action:[MANUAL]

Info:Return status is ERROR

ExecutionError:No

Error Message:The following checks have ERROR severity and no auto fixup is available or

the fixup failed to resolve the issue. Fix them before continuing:

UAT1 TARGET_HOME_REGISTERED_INVENTORY

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

[oracle@oraclelab1 19c-autoupg]$

5. Check the precheck logs for the more details which indicated that Oracle Home is missing or not attached in central inventory

[root@oraclelab1 prechecks]# more uat_preupgrade.log

Report generated by AutoUpgrade 24.8.241119 (#b404cf007) on 2025-05-08 10:32:37

Upgrade-To version: 19.0.0.0.0

=======================================

Status of the database prior to upgrade

=======================================

Database Name: UAT1

Container Name: UAT1

Container ID: 0

Version: 12.2.0.1.0

DB Patch Level: UNKNOWN

Compatible: 12.2.0

Blocksize: 8192

Platform: Linux x86 64-bit

Timezone File: 26

Database log mode: ARCHIVELOG

Readonly: false

Edition: EE

==============

BEFORE UPGRADE

==============

REQUIRED ACTIONS

================

1. Execute command $ORACLE_HOME/oui/bin/attachHome to attach the target

ORACLE HOME on each listed node.

The target ORACLE HOME must be registered on the Oracle Inventory.

The target ORACLE HOME for the following hostnames

[oraclelab2.localdomain.com] are not registered on the Oracle Inventory.

Deploy mode will be stopped.

6. Verify the central inventory and confirmed the the target 19c Oracle Home is missing or not attached

[root@oraclelab1 prechecks]# cd /u01/app/oraInventory/ContentsXML/

[root@oraclelab1 ContentsXML]# cat inventory.xml

<?xml version="1.0" standalone="yes" ?>

<VERSION_INFO>

<SAVED_WITH>12.2.0.1.4</SAVED_WITH>

<MINIMUM_VER>2.1.0.6.0</MINIMUM_VER>

</VERSION_INFO>

<HOME_LIST>

</HOME_LIST>

<COMPOSITEHOME_LIST>

</COMPOSITEHOME_LIST>

</INVENTORY>

[root@oraclelab1 ContentsXML]#

7. Fix the issue by attaching or adding missing 19c Oracle Home into central inventory

[oracle@oraclelab1 ~]$ . oraenv

ORACLE_SID = [oracle] ? DEV1

ORACLE_HOME = [/home/oracle] ? /u01/app/oracle/product/12.2.0.1/dbhome_1

The Oracle base has been set to /u01/app/oracle

[oracle@oraclelab1 ~]$ cd /u01/app/oracle/product/12.2.0.1/dbhome_1/oui/bin/

[oracle@oraclelab1 bin]$ ll

total 292

-rwxr-x---. 1 oracle oinstall 227 May 5 14:11 addLangs.sh

-rwxr-x---. 1 oracle oinstall 297 May 5 14:11 attachHome.sh

-rwxr-x---. 1 oracle oinstall 203 May 5 14:11 detachHome.sh

-rwxr-x---. 1 oracle oinstall 658 May 26 2016 filesList.bat

-rw-r-----. 1 oracle oinstall 201 May 26 2016 filesList.properties

-rwxr-x---. 1 oracle oinstall 837 May 26 2016 filesList.sh

-rwxr-x---. 1 oracle oinstall 57662 Jan 26 2017 lsnodes

drwxr-x---. 2 oracle oinstall 4096 May 5 14:10 resource

-rwxr-x---. 1 oracle oinstall 1716 May 5 14:11 runConfig.sh

-rwxr-x---. 1 oracle oinstall 175066 Nov 22 2016 runInstaller

-rwxr-x---. 1 oracle oinstall 81 May 5 14:11 runInstaller.sh

-rwxr-x---. 1 oracle oinstall 21862 Nov 9 2015 runSSHSetup.sh

[oracle@oraclelab1 bin]$

[oracle@oraclelab1 bin]$ /u01/app/oracle/product/12.2.0.1/dbhome_1/oui/bin/attachHome.sh

Starting Oracle Universal Installer...

Checking swap space: must be greater than 500 MB. Actual 16190 MB Passed

The inventory pointer is located at /etc/oraInst.loc

'AttachHome' was successful.

[oracle@oraclelab1 bin]$

[root@oraclelab1 ContentsXML]# cat inventory.xml

<?xml version="1.0" standalone="yes" ?>

<VERSION_INFO>

<SAVED_WITH>12.2.0.1.4</SAVED_WITH>

<MINIMUM_VER>2.1.0.6.0</MINIMUM_VER>

</VERSION_INFO>

<HOME_LIST>

</HOME_LIST>

<COMPOSITEHOME_LIST>

</COMPOSITEHOME_LIST>

</INVENTORY>

[root@oraclelab1 ContentsXML]#

8. Rerun the auto-upgrade prechks in ANALYZE mode which got completed successfully

[oracle@oraclelab1 19c-autoupg]$ /u01/app/oracle/product/19.0.0.0/dbhome_1/jdk/bin/java -jar /u01/app/oracle/product/19.0.0.0/dbhome_1/rdbms/admin/autoupgrade.jar -config UAT_config.cfg -mode ANALYZE

AutoUpgrade 24.8.241119 launched with default internal options

Processing config file ...

+--------------------------------+

| Starting AutoUpgrade execution |

+--------------------------------+

1 Non-CDB(s) will be analyzed

Type 'help' to list console commands

upg> lsj

+----+-------+---------+---------+-------+----------+-------+----------------+

+----+-------+---------+---------+-------+----------+-------+----------------+

+----+-------+---------+---------+-------+----------+-------+----------------+

Total jobs 1

upg> Job 102 completed

------------------- Final Summary --------------------

Number of databases [ 1 ]

Jobs finished [1]

Jobs failed [0]

Please check the summary report at:

/u01/patches/19c-autoupg/cfgtoollogs/upgrade/auto/status/status.html

/u01/patches/19c-autoupg/cfgtoollogs/upgrade/auto/status/status.log

[oracle@oraclelab1 19c-autoupg]$ more /u01/patches/19c-autoupg/cfgtoollogs/upgrade/auto/status/status.log

==========================================

Autoupgrade Summary Report

==========================================

[Date] Thu May 08 10:41:42 IST 2025

[Number of Jobs] 1

==========================================

[Job ID] 102

==========================================

[DB Name] UAT

[Version Before Upgrade] 12.2.0.1.0

[Version After Upgrade] 19.17.0.0.0

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

[Stage Name] PRECHECKS

[Status] SUCCESS

[Start Time] 2025-05-08 10:41:22

[Duration] 0:00:20

[Log Directory] /u01/patches/19c-autoupg/UAT/UAT1/102/prechecks

[Detail] /u01/patches/19c-autoupg/UAT/UAT1/102/prechecks/uat_preupgrade.log

Check passed and no manual intervention needed

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

[oracle@oraclelab1 19c-autoupg]$

Mallik034 (Vismo Technologies)

Friday, May 9, 2025