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
