Unable to update IDM 8.0 MXMC Database due to SQLPLUS command issue

[former_member185327]

Dear Experts,

We had a requirement to update the SAP Netweaver component based on AS Java for our IDM System.
Netweaver components were upgraded without any issues.

However, when I was trying to update the MXMC Database update command I am getting this error as below.

=============================================
./util-functions.sh: line 76 : sqlplus command not found.

removing temporary files
=============================================

Now as SIDADM user I tried to execute the below command

sqlplus /nolog

Below is the output

sqlplus command not found

I then did some checks and tried to execute the same command from this path below
/oracle/SID/19.0.0/bin

sqlplus /nolog

Getting the below error.
======================================================================
could not load program sqlplus
could not load module /oracle/client/12x/instantclient/libsqlplus.so.
Dependent Module libttsh12.so could not be loaded.
Could not load module libttsh12.so.
System Error: No such file or directory
Could not load module sqlplus.
Dependent module /oracle/client/12x/instantclient/libsqlplus.so could not be loaded.
======================================================================

Can anyone kindly give some valuable suggestions to get passed this please ?

[former_member185327 · Accepted solution]

Hi Alex,

Thanks for your reply.

That SQLPLUS issue is now resolved.

Root Cause Analysis:

When the Database upgrade took place the client update 19x was not done on the DB Server and only configured on the Application server.

Also the dbenv.csh, dbenv_sid.csh, dbenv_sid.sh and debenv.sh all thos four environment variables were not updated properly.

After configuring the environment variable parameters ORACLE_HOME, ORACLE_BASE, the SQLPLUS command is now working.

Thanks and Regards
Anurag

[alexanderbrietz]

Hi Anurag,

from your post I take it you are using oracle as DB for SAP IdM. In terms of troubleshooting it would be helpful to know detailed version of all involved components e.g. OS of DB, DB and SAP IdM.

It seems that the client you are using to update the DB is not fully configured and thus cannot find sqlplus to execute the needed SQL statements.

I would recommend to get in touch with your DB-Administration to get this sorted. Once you can execute SQL statements correctly uisng sqlplus you should be fine to update the IdM DB.

Also I would recommend the installation / update guides with a very close look to the requirements to make sure everything is prepaired for the update.

As a side note I need to mention that the update on the DB should be the first step in the update procedure for SAP IdM!

Regards,

Alex