C#.NET - Oracle cloud DB Connectivity issue
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."
- Oracle Managed Data Access 4.122.19.1 (Nugget package)
- 64 bit – ODAC 19.3 (installed on server)
- 32 bit – ODAC 19.3 (installed on server)
- Managed ODP.NET 12.2.0.1.0 (installed on server)
- 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