Frequent Contributor.. hyllplan Frequent Contributor..
Frequent Contributor..
308 views

Oracle "Service name" and HP PPM

Hi

PPM 9.32.0002

We are migrating our databases to new environments. The new environments utilizes Oracle Data Guard with failover functionality. Beacuse of this we need HP PPM to adress a Service name (instead of a SID). We cannot get this to work properly.

Any guidelines how to configure this in server.conf, environments and tnsnames.ora?

Thanks!

Johan

0 Likes
2 Replies
Trusted Contributor.. Jeison_R_PPM Trusted Contributor..
Trusted Contributor..

Re: Oracle "Service name" and HP PPM

Hello  hyllplan,

I hope you're doing great.

As you've mentioned the failover feature I'm assuming that you're working with an Oracle cluster. If so, the JDBC_URL on the PPM's server.conf needs to have a differen format that host:port:sid.

In the page 101 of the Installation and Administration guide (KM01161943) you will find information about the DB_CONNECTION_STRING, here is an exctract of the functionality of this parameter:

If the JDBC_URL parameter is specified, then the security identifier (SID) of the database on which the PPM Center schema resides is requested. It is assumed that the connect string for this database is the same as the SID. However, this is not always the case.
If the connect string (for connecting to the database using SQL*Plus from the server machine) is different than the database SID, add this parameter and supply the correct connect string.

This should resolve your issue.

I hope it helps.

Regards,

Jason

0 Likes
Established Member.. von Thadden
Established Member..

Re: Oracle "Service name" and HP PPM

Hi,

please note that the syntax for JDBC Urls is slightly different when you use Oracle SID and a Oracle service name.

This is a simple connection string using the Oracle SID (system identifier).

jdbc:oracle:thin:@ppmdemo.local:1521:PPM

Here is an example using the servicename "pdbppmdemo.local". Please note that there is a slash / (as opposed to the colon used for a SID style JDBC Url).

jdbc:oracle:thin:@ppmdemo.local:1521/pdbppmdemo.local

You can also specify something in the tnsnames.ora style in the jdbc connection string. This example includes failover on Client to Oracle Listener connectivity.

jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=myoraclehost1)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=myoraclehost2)(PORT=1521))(LOAD_BALANCE=yes))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=MYPPMTEST.test.local)(FAILOVER_MODE=(TYPE=SELECT)(METHOD=BASIC)(RETRIES=180)(DELAY=5))))

One thing that might go wrong is using a local Oracle service name (e.g. PPM) while a global Oracle servicename is expected(e.g. PPM.mydomain.com). So IMHO the best option is to ask your DBA. (I have seen different Oracle connectivity strategies having been implemented by DBAs and often the best solution was to ask them directly.)

Best regards

Kai

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.