1. Marco Meoni
  2. PowerServer
  3. Tuesday, 22 February 2022 17:27 PM UTC


PS 2021 and Oracle 12c.

Web APIs -> DB configuration results in ORA-01017, as simple as "invalid username/password; connection denied". Same parameters work from PB DB profile.

Technically, I have been provided with an Oracle proxy user (https://docs.oracle.com/database/121/ODPNT/featConnecting.htm#ODPNT188). As easy as it sounds, it may have some configuration difference that at the moment is unclear to me.

Have been through a variety of posts and questions trying to find an answer here, but so far I've had no luck. Most relevant thread: 

Oracle.ManagedDataAccess and ORA-01017: invalid username/password; logon denied

Provided that username contains some special chars but the error is stil there when they are prefixed by back quotes, I may go for the FIPS security policy suggestion.
However, changing HKLM registry settings on a server is not my ideal test and would like beforehand to know if anyone has same configuration or has experience with Oracle proxy and .NET.

Last but not least, PS 2021 project -> DB configuration -> Advanced  has indeed Security proxy user and proxy password entries, but no luck too.