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

  • KM03770168
  • 30-Dec-2020
  • 30-Dec-2020

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


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_*_"_



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.