I'm developing a very simple application which I intend to use to troubleshoot an issue I am having on a few machines but before I even got that far I ran into a few issues, including cpu architecture differences and Oracle database libraries. I have a database server listed in
However Oracle.DataAccess is dependent on the architecture of the system it runs on. I saw that there is another library Oracle.ManagedDataAccess which is architecture independent. When I use this library it no longer is able to connect to the server. An Why is this the case? What is different between these two libraries because based upon what I've read thus far this shouldn't be an issue. Extra information:
If I move tnsnames.ora to the same location as my .exe file, it works. Why can Oracle.DataAccess find tnsnames.ora in the asked Jul 3, 2013 at 18:56
JeffJeff 1,7272 gold badges17 silver badges28 bronze badges 2 The order of precedence for resolving TNS names in ODP.NET, Managed Driver is this (see here):
I believe the reason your sample works with Oracle.DataAccess but not with Oracle.ManagedDataAccess is that Windows registry based configuration is not supported for the latter (see documentation) - the ODP.NET installation sets an ORACLE_HOME registry key (HLKM\SOFTWARE\Oracle\Key_NAME\ORACLE_HOME) which is recognized only by the unmanaged part. answered Nov 18, 2013 at 14:41
metalheartmetalheart 3,67621 silver badges29 bronze badges 5 Try to add the path to tnsnames.ora to the config file:
answered Aug 6, 2013 at 7:05
kolbasovkolbasov 1,51811 silver badges15 bronze badges 5 To avoid all the Oracle mess of not knowing where it is looking for the TNSNAMES.ORA (I have the added confusion of multiple Oracle versions and 32/64 bit), you can copy the setting from your existing TNSNAMES.ORA to your own config file and use that for your connection. DSDSDS=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(Host=DSDSDSHost)(Port=4521)))(CONNECT_DATA=(SERVICE_NAME=DSDSDSService)))
You can take the text after the first '=' and use that wherever you are using 'DSDSDS' and it won't need to find TNSNAMES.ORA to know how to connect. answered Oct 5, 2016 at 16:02
ValidValid 7476 silver badges12 bronze badges 3 Once I found what format it was looking for in the connection string, it worked just fine like this with Oracle.ManagedDataAccess. Without having to mess around with anything separately.
answered Sep 30, 2015 at 15:18
I had the similar issue......to solve this what I did was to uninstall the ODP. Net and re-install in the same directory as oracle server......with server option you will notice that most of the products are already installed (while 12c database installation) so just select the other features and finally finish the installation.... Please note that this workaround works only if you have installed 12c on the same machine i.e. on your laptop............ If your database is located on the server machine other than your laptop then please select client option and not the server and then include TNS_ADMIN in your app.config and do not forget to specify the version... since my installation is on my laptop so my App.config is as below:
answered Mar 22, 2014 at 16:02
1 A "little" late to the party but the
real answer to this - if you use Here is what you need
To summarize - with managed, no need for heavy Oracle Client, answered Apr 18, 2019 at 16:37
T.S.T.S. 17.1k10 gold badges56 silver badges76 bronze badges In my case everything said above was OK, but I still have been receiving I tried to ping the Oracle machine and found out I cannot see it and added it to the hosts file. Then I received another error message I'm bothering to write my experience as it seems obvious, but although I was sure the problem is in the above settings I totally forgot to check if I really can see the remote DB machine out there. Keep it in mind when you are out of ideas what is going on..... These links helped me a lot: http://www.moreajays.com/2013/03/ora-12545-connect-failed-because-target.html http://www.orafaq.com/wiki/ORA-12541 answered Feb 18, 2019 at 12:39
ppenchevppenchev 1191 silver badge10 bronze badges Just removing Oracle.ManagedDataAccess and leaving just Oracle.ManagedDataAccess.Core works for me. answered Jul 27 at 20:11
VilmoVilmo 112 bronze badges I received the same error message. To resolve this I just replaced the
Irshad 3,0135 gold badges28 silver badges51 bronze badges answered Jun 12, 2015 at 15:18
0 |