Highlighted
Micro Focus Frequent Contributor
Micro Focus Frequent Contributor
130 views

UCMDB Support Tip: How to connect to an Oracle RAC when using a generic database adapter?

Hello All,

 

If you need to connect to Oracle RAC using a generic database adapter, you will need do some changes to the adapter's XML file. You need tocdescribe the connection using user name (schema), password, and a connection URL string.

 

In order to define this, you need to edit the adapter's XML parameters section as follows:

 

<parameters>

<!--The description attribute may be written in simple text or HTML.-->

<!--The host attribute is treated as a special case by CMDBRTSM-->

<!--and will automatically select the probe name (if possible) -->

<!--according to this attribute's value.-->

<!--Display name and description may be overwritten by I18N values-->

<parameter name="url" display-name="Connection String" type="string" description="The connection string to connect to the database" mandatory="true" order-index="10" />

<parameter name="credentialsId" display-name="Credentials ID" type="integer" description="The credentials to be used"  mandatory="true" order-index="12" />

</parameters>

 

Here is an example of a URL that connects to an Oracle RAC using the out-of-the- box Data Direct driver:

 

jdbc:mercury:oracle://labm3amdb17:1521;ServiceName=RACQA;AlternateServers=(labm3amdb18:1521);LoadBalancing=true

 

Regards,

Irina

“HP Support
If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution.”

Click the KUDOS star on the left to say 'Thanks'
Labels (1)
Tags (1)
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.