Oracle DB Server installs on AIX Server are not licensed. Relationship between LPAR instance and AIX server is reversed. - Known Error

Oracle DB Server installs on AIX Server are not licensed. Relationship between LPAR instance and AIX server is reversed. Description Unlicensed installs present for Oracle Database Server although there are enough entitlements. The reason for this is a recent change from discovery that reversed the relationship between AIX Server and LPAR instance, which are used in Oracle calculators

Earlier cmdb_rel_ci records were populated by discovery as below: Child: AIX Server, Parent: LPAR Instance, Type: Owns::Owned by

Discovery has reversed earlier relationship and now discovery populates cmdb_rel_ci records as below: Parent: AIX Server, Child: LPAR Instance, Type: Owns::Owned by

Steps to Reproduce

1. Upgrade store app app-itom-patterns to version 1.0.85. OR Upgrade to San Diego

2. Run discovery

3. Observe the relationship between AIX Server and LPAR instance

4. Run reconciliation and observe that Oracle DB Server installs are not correctly licensed

Workaround Fix below files:

1. Table: sys_db_view_table, sys_id: 71ac01c1db67330039ad55535e9619e0

Replace "relci_parent" with "relci_child" in the "Where clause" field

2. Table: sys_db_view_table, sys_id: b23b0181db67330039ad55535e9619bb

Replace "relci_child" with "relci_parent" in the "Where clause" field

3. Table: sys_script_include, sys_id: 260d2bf97df30010fa9bc0da56df7717, Name: SamOracleLicenseCalculator

Replace "relci_child" with "relci_parent" in the "Script" field (3 occurrences)

4. Table: sys_script_include, sys_id: aedd199b77423010a2bb6f0068106182, Name: SamCalSyncDbUsers

If the script include exists, then Replace "relci_child" with "relci_parent" in the "Script" field (2 occurrences)