E-Business 12.2 adop fs_clone failed to register 10.1.2 Forms because of Grid Agent oraInventory /locks directory (Doc ID 3051389.1)

Last updated on OCTOBER 09, 2024

Applies to:

Symptoms

On : 12.2.12 version, Patch Application Issues

When attempting to run adop phase=fs_clone
the following error occurs.

ERROR
-----------------------
--> 1st error:
Filename = ...\TXK_SYNC_create\fsclone_apply\FSCloneApplyAppsTier_09251216.log
Running: /s01/oracle/DEV/fs2/FMW_Home/Oracle_EBS-app1/oui/bin/runInstaller -detachhome -silent ORACLE_HOME=/s01/oracle/DEV/fs1/FMW_Home/Oracle_EBS-app1 -invPtrLoc /etc/oraInst.loc -debug -waitforcompletion
You do not have sufficient permissions to access the inventory '/s01/oracle/DEV/oraInventory/locks'. Installation cannot continue. It is required that the primary group of the install user is same as the inventory owner group. Make sure that the install user is part of the inventory owner group and restart the installer.: Permission denied
ERROR: Failed to deregister Oracle Home Name=OH990623917 location=/s01/oracle/DEV/fs1/FMW_Home/Oracle_EBS-app1

--> 2nd error:
Filename = ohclone_20240925.log
Running OUI CLI home cloning from within OracleHomeCloner:
 /s01/oracle/DEV/fs1/EBSapps/10.1.2/oui/bin/runInstaller -debug -clone -silent -force -nolink -waitForCompletion -invPtrLoc /etc/oraInst.loc session:ORACLE_HOME=/s01/oracle/DEV/fs1/EBSapps/10.1.2 oracle.as.j2ee.top:s_asInstanceName=DEV_TOOLS__s01_oracle_DEV_fs1_EBSapps_10_1_2 oracle.as.j2ee.top:s_adminName=ias_admin ORACLE_HOME_NAME=DEV_TOOLS__s01_oracle_DEV_fs1_EBSapps_10_1_2 -J-Doracle.installer.noLink=true -ignorePrereq  -J-ms128m -J-mx512m
Command returned
Starting Oracle Universal Installer...
Error:*** Alert: Unable to create a new Oracle Home at /s01/oracle/DEV/fs1/EBSapps/10.1.2. Oracle Home already exists at this location. Select another location. ***
Initializing Java Virtual Machine from /tmp/OraInstall2024-09-25_01-44-10PM/jre/bin/java. Please wait...
ERRORCODE = 255
ERROR: Home may already be registered
ERROR: OUI CLI cloning returned non-zero.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. after abort and cleanup_full, running fs_clone
2. issue with permissions error on /oraInventory/locks/ when attempting to de-register FMW home (1st error: validate oraInventory/locks owner group)
3. changed the owner/group oracle:oinstall of the directory /locks and its contents to be owned by applmgr:ebsdba
4. retried fs_clone which still failed to register Forms 10.1.2 oracle home (2nd error: cannot register 10.1.2 Forms using 10.1.0.6 OUI)
5. attempting to detachHome manually the 10.1.2 Forms before re-trying fs_clone which still failed in registering Forms 10.1.2 oracle_home
    >>> tried to detach 10.1.2 oracle_home manually before re-running fs_clone
            To detachHome Forms 10.1.2, it was needed to download a standalone OUI 10.2, instead of the default Forms OUI 10.1.0.6
--     >  Forms 10.1.2 uses OUI 10.1.0.6 which does not offer "detachHome" command; a standalone OUI 10.2.0.5 can be used to Forms 10.1.2 detachHome command
            Refer to:     12.2 E-Business Suite Applications DBA Steps To Create, Update or Rebuild The Central Inventory For Oracle Applications (Doc ID 1588609.1), Procedure 2: Detaching an Oracle Home using the Oracle Universal Installer
                      YELLOW WARNING:
                              This can only be done using OUI 10.2 or higher, but using this OUI version also for a 10.1 Oracle Home.
                              A standalone copy of OUI 10.2.0.4 and OUI 10.2.0.5 is available for download via patch 6640752 as per Note 557291.1 - How to download OUI 10.2.0.4 and OUI 10.2.0.5

Even detaching 10.1.2 Forms oracle_home from the oraInventory did not allow fs_clone to go through
Since the customer ran fs_clone using force=yes which failed, /appl and .env files were now gone from PATCH side
which meant fixing fs_clone was required to run with force=yes until the adop command went through

Changes

 Grid OEM agent was started and created a lock in the oraInventory pointed to by E-Business Suite /etc/oraInst.loc and <s_base>/<oh>/oraInst.loc

>>In the oraInventory a sub-directory /locks was found with an inventory.lock 0-byte file inside
[applmgr@hostname oraInventory]$ pwd
/s01/oracle/oraInventory
[applmdpa@hostname oraInventory]$ ls -al
total 76
drwxrwx---. 8 applmgr ebsdba 4096 Jul 14 14:39 .
drwxrwxr-x. 14 applmgr ebsdba 4096 Aug 10 11:41 ..
drwxrwx---. 13 applmgr ebsdba 4096 Jul 14 01:52 backup
drwxrwx---. 2 applmgr ebsdba 4096 Jul 13 08:06 Contents
drwxrwx---. 2 applmgr ebsdba 4096 Jul 13 06:52 ContentsXML
-rw-rw----. 1 applmgr ebsdba 37 Jul 14 02:00 install.platform
drwxrwx---. 2 oracle oinstall 4096 Jul 14 14:39 locks                                      <<<< Grid OEM agent had created a sub-directory "locks" with oracle:oinstall ownership and applmgr did not have r/w on the directory
drwxrwx---. 2 applmgr ebsdba 40960 Sep 9 09:55 logs
-rw-rw----. 1 applmgr ebsdba 403 Jul 14 01:59 oraInstaller.properties
drwxrwx---. 2 applmgr ebsdba 4096 Jul 13 06:56 oui

Filename =  oraInventory.zip
...
/locks
  inventory.lock   -- 0 byte size       <<< the file was created by OEM agent

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.