CA Client Automation

  • Private Community
 View Only

 Error During Client Automation 14.5 Install MDB in Oracle Database

CARLOS JUPIA's profile image
CARLOS JUPIA posted Feb 06, 2025 07:44 AM
error with oracle
Hi, Please, any tips about this problem will be appreciated:
Environment: Windows 2019 - ORACLE 19c - ITCM 14.5
SETUP MDB LOG:
1: 2-6-2025 - 08:24:16 - INFO    - File: CAUniITRM_Setup.rul       - Line: 13499 - local ComputerName: ITCMDOMAIN.cloudlab.local 
1: 2-6-2025 - 08:24:16 - INFO    - File: CAUniITRM_Setup.rul       - Line: 13506 - itcmdomain.cloudlab.local = itcmdomain.cloudlab.local -> local 
1: 2-6-2025 - 08:24:16 - INFO    - File: CAUniITRM_Setup.rul       - Line: 13610 - ITCMDOMAIN.cloudlab.local is the local computer 
1: 2-6-2025 - 08:24:16 - INFO    - File: CAUniITRM_Properties.rul  - Line:  1863 - ciGetPropertyBoolValue(#37 :FAILOVER_ENABLED) Enter 
1: 2-6-2025 - 08:24:16 - INFO    - File: CAUniITRM_Setup.rul       - Line: 13269 - Enter ciLoadDLL() 
1: 2-6-2025 - 08:24:16 - INFO    - File: CAUniITRM_Setup.rul       - Line: 13276 - DLL name: 'cainf.dll' 
1: 2-6-2025 - 08:24:16 - INFO    - File: CAUniITRM_Setup.rul       - Line: 13278 - DLL path: 'E:\WindowsProductFiles_x86' 
1: 2-6-2025 - 08:24:16 - INFO    - File: CAUniITRM_Manager.rul     - Line:  1521 - DisableCluster() returned 5 
1: 2-6-2025 - 08:24:16 - INFO    - File: CAUniITRM_Manager.rul     - Line:  1528 - DB provider 'Oracle' is selected 
1: 2-6-2025 - 08:24:16 - INFO    - File: CAUniITRM_Setup.rul       - Line: 13428 - String('ID_STRING_ORACLE') = 'Oracle' 
1: 2-6-2025 - 08:24:16 - INFO    - File: CAUniITRM_Properties.rul  - Line:  2076 - ciSetPropertyStringValue(#32 :DB=Oracle) Enter 
1: 2-6-2025 - 08:24:16 - INFO    - File: CAUniITRM_Properties.rul  - Line:  1845 - DB.bValue=0, .nvValue=0, .svValue='Oracle' 
1: 2-6-2025 - 08:24:16 - INFO    - File: CAUniITRM_Properties.rul  - Line:  2076 - ciSetPropertyStringValue(#28 :DBSERVER=ITCMDOMAIN.cloudlab.local) Enter 
1: 2-6-2025 - 08:24:16 - INFO    - File: CAUniITRM_Properties.rul  - Line:  1845 - DBSERVER.bValue=0, .nvValue=0, .svValue='ITCMDOMAIN.cloudlab.local' 
1: 2-6-2025 - 08:24:16 - INFO    - File: CAUniITRM_Properties.rul  - Line:  2056 - ciGetPropertyStringValue returned 'Oracle' 
1: 2-6-2025 - 08:24:16 - INFO    - File: CAUniITRM_Properties.rul  - Line:  2073 - ciSetPropertyStringValue(#31 :DBPASSWORD=XXX Enter 
1: 2-6-2025 - 08:24:16 - INFO    - File: CAUniITRM_Properties.rul  - Line:  1842 - DBPASSWORD.bValue=0, .nvValue=0, .svValue='XXX' 
1: 2-6-2025 - 08:24:16 - INFO    - File: CAUniITRM_Properties.rul  - Line:  2076 - ciSetPropertyStringValue(#118 :OracleAdminUser=sys) Enter 
1: 2-6-2025 - 08:24:16 - INFO    - File: CAUniITRM_Properties.rul  - Line:  1845 - OracleAdminUser.bValue=0, .nvValue=0, .svValue='sys' 
1: 2-6-2025 - 08:24:16 - INFO    - File: CAUniITRM_Properties.rul  - Line:  2073 - ciSetPropertyStringValue(#119 :OracleAdminUserPwd=XXX) Enter 
1: 2-6-2025 - 08:24:16 - INFO    - File: CAUniITRM_Properties.rul  - Line:  1842 - OracleAdminUserPwd.bValue=0, .nvValue=0, .svValue='XXX' 
1: 2-6-2025 - 08:24:16 - INFO    - File: CAUniITRM_Properties.rul  - Line:  2076 - ciSetPropertyStringValue(#125 :Oracle_MDB=ORCL) Enter 
1: 2-6-2025 - 08:24:16 - INFO    - File: CAUniITRM_Properties.rul  - Line:  1845 - Oracle_MDB.bValue=0, .nvValue=0, .svValue='ORCL' 
1: 2-6-2025 - 08:24:16 - INFO    - File: CAUniITRM_Properties.rul  - Line:  1745 - ciSetPropertyValue(#125 :Oracle_MDB) Enter 
1: 2-6-2025 - 08:24:16 - INFO    - File: CAUniITRM_Properties.rul  - Line:  1764 - String property 
1: 2-6-2025 - 08:24:16 - INFO    - File: CAUniITRM_Properties.rul  - Line:  2076 - ciSetPropertyStringValue(#125 :Oracle_MDB=ORCL) Enter 
1: 2-6-2025 - 08:24:16 - INFO    - File: CAUniITRM_Properties.rul  - Line:  1845 - Oracle_MDB.bValue=0, .nvValue=0, .svValue='ORCL' 
1: 2-6-2025 - 08:24:16 - INFO    - File: CAUniITRM_Properties.rul  - Line:  1795 - MsiSetProperty (Oracle_MDB) to ORCL 
1: 2-6-2025 - 08:24:16 - INFO    - File: CAUniITRM_Properties.rul  - Line:  1813 - RegDBSetKeyValueEx('SOFTWARE\ComputerAssociates\Unicenter ITRM\Installer\Dialogs\Manager', Oracle_MDB) to ORCL 
1: 2-6-2025 - 08:24:16 - INFO    - File: CAUniITRM_Setup.rul       - Line: 13499 - local ComputerName: ITCMDOMAIN.cloudlab.local 
1: 2-6-2025 - 08:24:16 - INFO    - File: CAUniITRM_Setup.rul       - Line: 13506 - itcmdomain.cloudlab.local = itcmdomain.cloudlab.local -> local 
1: 2-6-2025 - 08:24:16 - INFO    - File: CAUniITRM_Setup.rul       - Line: 13610 - ITCMDOMAIN.cloudlab.local is the local computer 
1: 2-6-2025 - 08:24:16 - INFO    - File: CAUniITRM_Setup.rul       - Line: 13499 - local ComputerName: ITCMDOMAIN.cloudlab.local 
1: 2-6-2025 - 08:24:16 - INFO    - File: CAUniITRM_Setup.rul       - Line: 13506 - itcmdomain.cloudlab.local = itcmdomain.cloudlab.local -> local 
1: 2-6-2025 - 08:24:16 - INFO    - File: CAUniITRM_Setup.rul       - Line: 13610 - ITCMDOMAIN.cloudlab.local is the local computer 
1: 2-6-2025 - 08:24:16 - INFO    - File: CAUniITRM_Properties.rul  - Line:  2056 - ciGetPropertyStringValue returned 'ORCL' 
1: 2-6-2025 - 08:24:16 - INFO    - File: CAUniITRM_Setup.rul       - Line: 13428 - String('ID_MSG_NO_ORACLI') = 'You have selected Oracle database provider. There is no Oracle database access interface installed. You must install an Oracle database access interface to support this selection.' 
Harold Martin's profile image
Harold Martin posted Feb 07, 2025 09:06 AM

Hello Carlos,

I have Client Automation up and running on Oracle 19, with the DM and SS on Windows 2019 standard and the MDB on RH Linux.

First, the DM requires installing the Oracle Client: This one needs to be installed by your DBA, or anyone from the DB group can assist you.

What I did to make it work on this Oracle version, was as follows:

  • turn the user running the install as full admin on the Oracle DB.. this is just a temporary adjustment to avoid any security issues when installing
  • install the MDB Only, from the setup
  • finally, Install Client Automation.

let me know if you need more help on this.

CARLOS JUPIA's profile image
CARLOS JUPIA posted Feb 07, 2025 11:24 AM

Hi Harold , Thank you very much for the quick response! In my case, I am setting up a LAB with Oracle 19c running on CentOS 7 and DSM on Windows Server 2019.  I believe the issue may be related to Oracle environment variables, such as ORACLE_HOME, PATH, among others, on the Windows machine.