Can not find Oracle Home

Can not find Oracle Home

Postby gala_l » Thu 31 Mar 2011 14:37

Hi,
We are using UNIDirect components to connect our web service to Oracle database. CoreLab.Unidirect.dll version is 2.5.7.0.
When we install the web service on the client computer, we keep all required DLLs in the BIN folder of the compiled service. Oracle Client always is installed before we create the web service.
Yesterday we got an error on the client side: "Can not find ORACLE HOME".
1. Client system: XP
2. Oracle client: several of them, starting 7.2 and higher

How can we fix the problem without reinstalling all Oracle Clients on the client computer?

Thank you.
gala_l
 
Posts: 13
Joined: Tue 31 Jul 2007 04:05

Postby Shalex » Tue 05 Apr 2011 14:38

1. a) Are you using "Provider=Oracle;" or "Provider=OracleClient" connection string parameter?
b) dotConnect Universal is a wrapper of dotConnect Oracle (the "Provider=Oracle;" case). The version of dotConnect for Oracle that corresponds to CoreLab.Unidirect.dll v 2.5.7 supports both x86 and x64 versions of the following Oracle clients: 10g, 9i, 8i and 8.0.
What version of Oracle Client is used on your client workstation?
2. Make sure that your application has capacity that corresponds to the capacity of your Oracle client (32-bit or 64-bit).
3. Please check that the Path system variable contains the path to the Oracle client location. Try setting Oracle client's path at the first place in Path.
4. Make sure that Oracle client is valid. Try connecting using it with any other tool.
Shalex
Devart Team
 
Posts: 7659
Joined: Thu 14 Aug 2008 12:44

Postby gala_l » Wed 06 Apr 2011 20:25

We update Path system variable, but it didn't work. Do we need to restart any other services after update? Refresh something to force UniDirect to see the path?
gala_l
 
Posts: 13
Joined: Tue 31 Jul 2007 04:05

Postby Shalex » Thu 07 Apr 2011 15:51

1.
gala_l wrote:We update Path system variable, but it didn't work. Do we need to restart any other services after update? Refresh something to force UniDirect to see the path?

Restarting web serivce that uses dotConnect Universal should be enough. For sure, restart your client computer if possible.
2. Please answer the question we have asked in the previous post.
3. Refer to this thread. Does it help?
Shalex
Devart Team
 
Posts: 7659
Joined: Thu 14 Aug 2008 12:44

Postby gala_l » Thu 07 Apr 2011 19:22

We are using: "Provider=Oracle;"
gala_l
 
Posts: 13
Joined: Tue 31 Jul 2007 04:05

Postby gala_l » Thu 07 Apr 2011 19:31

Finally it started to work, but we are not sure what exactly helped.
1. We updated Oracle Home path. Didn't help.
2. Rerun the iis. Didn't help.
3. Client administrator did something somewhere without explanation and application started to work.

I'd like to know what else need to be done in this situation, if we will run in it with other client.

I also will keep an eye on other thread, to see, how it will work out.
gala_l
 
Posts: 13
Joined: Tue 31 Jul 2007 04:05

Postby Shalex » Fri 08 Apr 2011 07:55

Please contact your client administrator to clarify what he actually did to make it work.

A common reasons for this error we have already mentioned in this thread (workability of Oracle client, matching capacities of Oracle client and the process of your application, the first position of the path to Oracle home in the system variable Path).

Your feedback concerning the reason of the "Can not find Oracle Home" error in your case will be appreciated.
Shalex
Devart Team
 
Posts: 7659
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect Universal