How To Update OWB Store Parameters Host, Port, DB Service And Net Service

(Doc ID 2231813.1)

Last updated on FEBRUARY 23, 2017

Applies to:

Oracle Life Sciences Data Hub - Version 2.4.6 and later
Information in this document applies to any platform.

Goal

How to update Host, Port and Service parameter values in OWB? Database Health check log  "3 OWB Status: FAILURE"?

Example of the Database Health Check output after running script from <NOTE 1983060.1> : "Configuration Health Check Scripts for LSH and DMW Installations"

--------- 3 OWB Status: FAILURE ---------------

3.1) CDR execution operators
CDR execution operators have been registered
3.2) CDR BIP deployment adapters
CDR BIP deployment adapters have been registered
3.3) OWB service node connection

***** FAILURE: OWB service node connection spec. Expected result: <LOCALHOST>:10110:MYSERVICE1. Actual result: myhost1:99999:MYSERVICE1 *****

3.4) OWB Store Parameter
All NetServiceName values are correctly stored as MYSERVICE1

***** FAILURE: There are 126 Host values incorrectly stored. *****

Host value: myhost1-vip.domain count: 118
Host value: MYHOST1-VIP.DOMAIN count: 8

***** FAILURE: There are 126 Port values incorrectly stored. Expected value should be 10110 *****

Port value: 99999 count: 126

***** FAILURE: There are 8 Service values incorrectly stored. Expected value should be MYSERVICE1.DOMAIN *****

Service value: MYSERVICE1 count: 8

3.5) OWB Service
OWB is Available
Database managed service using MYHOST1:99999:MYSERVICE1 and home $ORACLE_HOME

 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms