Oracle MDB Installation Failing

Products

• CA Service Management - Service Desk Manager

Issue/Introduction

Trying to install Service Desk Manager on a new server but we are seeing the following error:

2022/12/27 11.34.03.777 ERROR [DeployThread: Configuring CA Service Desk Manager] [ConfigureSDM] SDM configuration failed with message : 12/27 11:30:16.380 WARN  ConfigThread.java      582 Configuration task (Start CA Service Desk Manager service(s) in db admin mode.) is failed in step : 18

configure.log contains the following:

12/21 11:14:18.466 INFO  ?                        ? Process C:\PROGRA~2\CA\SERVIC~1\bin\orcl_check_db.exe completed with exit code 999
12/21 11:14:18.466 WARN  PatchDatabaseTask.java   614 Unexpected return code from ing_check_db: 999
12/21 11:14:18.467 INFO  PatchDatabaseTask.java   133 Processing (C:\PROGRA~2\CA\SERVIC~1\pdmconf\AlterMDB.txt)
12/21 11:14:20.320 INFO  ?                        ? Process C:\PROGRA~2\CA\SERVIC~1\bin\orclbuild.exe completed with exit code 999
12/21 11:14:20.320 INFO  PatchDatabaseTask.java   163 SEVERE_ERROR: Unable to load OCI library (oci.dll)  RC(193)
SEVERE_ERROR: Unable to load OCI library (/lib/oci.dll)  RC(126)

 

Environment

Release : 17.3 and higher

Cause

Server does not have the necessary MDB client installed.

Resolution

The issue was resolved after the prerequisite 32 bit client of the Oracle client was installed.

Oracle database requirements