C#.NET - Oracle cloud DB Connectivity issue

Sadachar, Abhijeet (Cognizant) 1 Reputation point
2022-03-04T06:25:07.96+00:00

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

C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
10,995 questions
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.