C#.NET - Oracle cloud DB Connectivity issue

Question

Hi Team,

We are finding issue while connecting to Oracle Cloud database from .NET (4.7.2 framework) code. We have checked and ensured all pre-requisites are in place."

1. Oracle Managed Data Access 4.122.19.1 (Nugget package)
2. 64 bit – ODAC 19.3 (installed on server)
3. 32 bit – ODAC 19.3 (installed on server)
4. Managed ODP.NET 12.2.0.1.0 (installed on server)
5. Wallet file placed in "D:" drive and same path updated in sqlnet.ora

Firewall is opened between Application Server and Oracle Cloud DB. Telnet is working on mentioned Port 2484.

We tried using below 2 different connection string.

Connection String 1:

"DATA SOURCE=xxx_medium_tls;PERSIST SECURITY INFO=True;USER ID=uid;Password=pwd;Connection Timeout =7200";

Connection String 2:

"Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCPS)(HOST=host_url)(PORT=2484))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = xxx.adw.oraclecloud.com)));User Id=uid;Password=pwd;Connection Timeout=7200";

We are getting below exception when we try to access to access DB.

"Exception:Network Transport: SSL failure in parsing wallet locationOracleInternal.Network.NetworkException (0x80004005): Network Transport: SSL failure in parsing wallet location ---> System.Security.Cryptography.CryptographicException: The profile for the user is a temporary profile" --- To establish connection to Oracle ADW from .Net program using TCPS (Port-2484)"

Can you please help to know the cause and fix for this issue?

Thanks,

Abhijeet