Can not find Oracle home / Points of Confusion
Posted: Tue 05 Apr 2011 00:25
Hello Devart folks,
I'm stuck and really need some help. If these questions sound basic to you all please be gentle, because as somebody brand new to the entire stack (MVC3 .NET 4.0, EF4, Oracle 10.2, Devart, IIS7) this seems very tricky.
The problem. When I execute my application I get the following:
System.Data.EntityException: The underlying provider failed on Open. ---> System.InvalidOperationException: Can not find Oracle home.
So, here are the steps I took to investigate. Feel free to give me a Harder, Better, Faster, Stronger(tm) way to work this:
To help narrow down the variables, I created a test MVC app that did nothing but query the Oracle database via EF on my laptop and report the number of rows back. Worked great there.
I'm now trying to deploy this test app to the development server. [edit: the development server and my laptop both connect to the same Oracle database, fyi]
So here are the steps I took on the server (Windows 2008). Just to be clear, the DBA has already gone home, so this may be an Oracle issue, but that being said, I still have tons of questions about DevArt, and hopefully you all can tell me if any of the steps below are not required or give me clarification.
1) I did a "minimal" install of Devart installer (dcoracle610pro.exe) which seemed to put Devart.Data and Devart.Data.Oracle into GAC.
2) I found my inventory.xml file in Oracle and located the following line HOME NAME="OraClient10g_home1" The client is 10.2.0
3) I then updated the web.config entity framework connection string so it said Home=OraClient10g_home1;
4) For good measure, though not sure it is needed, I created a system wide environment variable called ORACLE_HOME with the full path to the client install.
5) I then went to
http://www.devart.com/dotconnect/oracle ... yment.html
and followed the instructions to update my web.config on the server changing the version to 6.10.126.0
6) I'm confused about deploying the EF & Linq DLL being separate. Why doesn't the Minimal install take care of that? If I look under References in my Visual Studio project, I do not have *any* references to DevArt DLLs, but it works great. Should I add those in there and mark them as CopyLocal = True?
7) And this just made no sense to me at all:
http://www.devart.com/dotconnect/oracle ... ml#general
Maybe this is because of point #6 above, but if I'm deploying MVC and installing DevArt Minimal on the server, do I need to follow any of these steps? The Wizard said: License is not needed. The library does not have reference to Devart.Data.Oracle.
I'm sorry if these seems like a ton of stuff, but I figured if I was confused, then somebody else was probably confused too, and maybe this will help somebody else.
I'm stuck and really need some help. If these questions sound basic to you all please be gentle, because as somebody brand new to the entire stack (MVC3 .NET 4.0, EF4, Oracle 10.2, Devart, IIS7) this seems very tricky.
The problem. When I execute my application I get the following:
System.Data.EntityException: The underlying provider failed on Open. ---> System.InvalidOperationException: Can not find Oracle home.
So, here are the steps I took to investigate. Feel free to give me a Harder, Better, Faster, Stronger(tm) way to work this:
To help narrow down the variables, I created a test MVC app that did nothing but query the Oracle database via EF on my laptop and report the number of rows back. Worked great there.
I'm now trying to deploy this test app to the development server. [edit: the development server and my laptop both connect to the same Oracle database, fyi]
So here are the steps I took on the server (Windows 2008). Just to be clear, the DBA has already gone home, so this may be an Oracle issue, but that being said, I still have tons of questions about DevArt, and hopefully you all can tell me if any of the steps below are not required or give me clarification.
1) I did a "minimal" install of Devart installer (dcoracle610pro.exe) which seemed to put Devart.Data and Devart.Data.Oracle into GAC.
2) I found my inventory.xml file in Oracle and located the following line HOME NAME="OraClient10g_home1" The client is 10.2.0
3) I then updated the web.config entity framework connection string so it said Home=OraClient10g_home1;
4) For good measure, though not sure it is needed, I created a system wide environment variable called ORACLE_HOME with the full path to the client install.
5) I then went to
http://www.devart.com/dotconnect/oracle ... yment.html
and followed the instructions to update my web.config on the server changing the version to 6.10.126.0
6) I'm confused about deploying the EF & Linq DLL being separate. Why doesn't the Minimal install take care of that? If I look under References in my Visual Studio project, I do not have *any* references to DevArt DLLs, but it works great. Should I add those in there and mark them as CopyLocal = True?
7) And this just made no sense to me at all:
http://www.devart.com/dotconnect/oracle ... ml#general
Maybe this is because of point #6 above, but if I'm deploying MVC and installing DevArt Minimal on the server, do I need to follow any of these steps? The Wizard said: License is not needed. The library does not have reference to Devart.Data.Oracle.
I'm sorry if these seems like a ton of stuff, but I figured if I was confused, then somebody else was probably confused too, and maybe this will help somebody else.