R12.2 installation failed with Cannot find oraInventory error

Issue: R12.2.0 installation failed with Cannot find oraInventory error on Linux

    Trying local inventory in Oracle Home...
    Cannot find oraInventory
    Please create oraInst.loc in the proper directory for your operating system.
    The contents should look like this:
    inventory_loc=/oracle/oraInventory
    where "/oracle/oraInventory" is the direcotry where the central inventory is to be located.

When I checked the oraInst.loc in the /etc location, it was not there. So, I have manually created.

In cases where the OraInventory is missing or otherwise corrupt, recreate the oraInventory directory on UNIX systems, using the following steps.

[root@Test]# vi /etc/oraInst.loc
inventory_loc=/oracle/product/oraInventory
inst_group=dba

Change the inventory location as the per your directory structure.

[root@Test]# ls -lrt /etc/oraInst.loc
-rw-r--r--. 1 root root 58 Dec  9 00:26 /etc/oraInst.loc

[root@Test]# chmod 644 /etc/oraInst.loc

[root@Test]# ls -lrt /etc/oraInst.loc
-rw-r--r--. 1 root root 58 Dec  9 00:26 /etc/oraInst.loc

Retry the R12 installation

Limitation of ILM Assistant tool

Few days back I got chance to work on ILM Assistant tool.

I faced lots of challenges in ILM Assistant tool. Few are mentioned below:
1) There is no support for ILM Assistant tool on My Oracle Support site (SR)
2) There are lots of bugs in ILM Assistant
3) ILM Assistant can manage one database at a time
4) ILM Assistant can not move data automatically.It only recommends data to be moved
5) ILM Assistant would not archive data.Its only recommend when it is time to archive
6) We can not manage all the EBS tables by ILM Assistant.Only range partitioned by date tables can be managed
7) ILM Assistant would not purge/delete data
8) Modifying pre-partitioned Oracle E-Business Suite indexes and tables is not recommended or supported as it can cause application errors
9) ILM Assistant recommends partitioning only on DATE column.