Test connection to OBM Management DB is failing, when Oracle DB is selected

  • Document ID:KM03770168
  • Creation Date:30-Dec-2020
  • Modified Date:30-Dec-2020
    • Micro Focus Products:
      operations bridge reporter 10.40

This document has not been formally reviewed for accuracy and is provided "as is" for your convenience.

Summary

Usually we are using the below URL to connect to Oracle DB: "_jdbc:hp:oracle:TNSNamesFile=/opt/HP/BSM/PMDB/config/omi-tnsnames.ora;TNSServerName=EAGLEOBM"_ But it should be modified to support Oracle DB, when it is enabled for OAS: "_jdbc:hp:oracle:TNSNamesFile=/opt/HP/BSM/PMDB/config/omi-tnsnames.ora;TNSServerName=EAGLEOBM;_*_DataIntegrityLevel=accepted;EncryptionLevel=accepted_*_"_

Fix

Solution:

Run below query in Postgres DB to update the URL in dict_ds_ds table:

update dwabc.dict_db_ds set url='jdbc:hp:oracle:TNSNamesFile=/opt/HP/BSM/PMDB/config/omi_tnsnames.ora;TNSServerName=TMONOMIP;DataIntegrityLevel=accepted;EncryptionLevel=accepted' where db_id=<db_id>;

Then test the connection from Admin UI again.