Getting ORA-12545: Unable to resolve connect hostname due to MY_Wallet_Directory path in a .NET application

0

Hey i am asking this question again even after going through som many resources related to it i am not finding any solution.

I have a connection string which looks something like this

Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL = TCPS)(HOST =XXX)(PORT = 1523))(CONNECT_DATA=(SERVER = dedicated)(SERVICE_NAME=XXX))(SECURITY=(SSL_SERVER_CERT_DN= CN=XXX)(MY_WALLET_DIRECTORY=C:\Wallet)));User Id=XXX;PASSWORD=XXX;

I configured this in the web.config file as

<connectionStrings>
         <add name="ConnectionString" connectionString="{connection string encrypted form}" providerName="Oracle.ManagedDataAccess.Client" />
   </connectionStrings>

My application is a ASP.NET application

When i try to connect with this i am getting

System.Exception: Database Connectivity Exception, GetMaxDatabaseConnectivityTries Tries of 10 ended, Exception : Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-12545: Network Transport: Unable to resolve connect hostname --->

Diffrent methods i tried

1.I configured the same TNS in my tnsnames.ora and tried to connect using toad. I was able to connect. 2. I tried to ping the host name, I got response from the host. 3. Preveious to this the connection string which was working looked something like this

Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL = TCPS)(HOST =XXX)(PORT = 1523))(CONNECT_DATA=(SERVER = dedicated)(SERVICE_NAME=XXX));User Id=XXX;PASSWORD=XXX;

I am assuming the problem occured solely because of addition of the new security parameters.

Any help is deeply appreciated, Thanks in advance.

oracle12c
asked on Stack Overflow May 8, 2020 by Disha S

0 Answers

Nobody has answered this question yet.


User contributions licensed under CC BY-SA 3.0