question

Upvotes
Accepted
1 1 1 1

DPS connectivity with Oracle 19

Hi Refinitiv team,


three years ago I asked the following question regarding DPS (https://customers.refinitiv.com/rmds/czrdp/ecopages/ApplicationDetails.aspx?temp=141):


--------------------------------------------

I tried to stick to the documentation, but connecting via Oracle PKI wallet is not described. So I played around a little, but so far I was not successful. Usually when using Oracle PKI wallet to connect to a database no password should be given, but DPS complains about not providing a password. When I just use an x or something and provide the Oracle TNS connect identifier in PKI wallet syntax (i.e. "/@Database") DPS throws this error:


FATAL: F108: DATABASE EXCEPTION: server/DpsDatabase.cxx(326): Unable to connect to the database: Error message 'ORA-12154' : : Fatal error from ORACLE Default database[] SERVER[] Alternate Server[] User[/@DATABASE] Password[x]

My connection config looks like this:


DATABASE_CONNECTION

{

Connect1

{

VENDOR ORACLE; # or SYBASE

USER /@DATABASE;

PASSWORD x;

}

}


Can you please either provide me an example how this should be configured or give me an official statement that Oracle PKI wallets aren't supported?

--------------------------------------------




And I received the following reply:


--------------------------------------------

I apologize it took so long, finally I managed to gain a confirmation from Development team that PKI wallet is not supported.


Regards

Piotr Gorazdowski

Lead Technical Specialist

Refinitv Customer Support

--------------------------------------------



Now I am working on migrating Oracle 11 to Oracle 19 and I want to know, whether or not this answer is still valid.


Maybe a new DPS version is available supporting this alongside with new Oracle 19 features.


Thank you,

Enrico Lippert

treporacle
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

Upvotes
Accepted
16.1k 41 12 19

Hi @el01,

I have raised a ticket #10721299 on your behalf, and someone from product team should get in touch with you over email.

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Hello @el01

According to the DPS support team, the DPS does not support Oracle 19 at the moment.