Solved

How do I run 1 windows service a with 32 bit Oracle client library and another application with a 64 bit Oracle client library?

Posted on 2011-09-27
9
745 Views
Last Modified: 2013-11-11
Hi guys,

I have the task of finding out on Windows if you can have a 64 bit installation and 32 bit installation of the Oracle client libraries installed at the same time (I am using Oracle 11g client libraries). The 32 bit application runs as a service, and I don't know about the 64 bit application yet. Is this possible as they both need a different ORACLE_HOME variable?  If the 32 bit application ran in the foreground I would just use a batch file to set the variable, but I don't know how to set the environment for a service.

Is there an Oracle solution for this?  Or is this a windows thing?

Thanks
Grant
0
Comment
Question by:Grant Rogers
  • 5
  • 4
9 Comments
 
LVL 15

Expert Comment

by:Franck Pachot
ID: 36719654
Hi,
You need to know how your service is calling oracle.
The ORACLE_HOME that will be used is the one from the oracle executable (.exe ou .dll) that is called.
Regards,
Franck.
0
 

Author Comment

by:Grant Rogers
ID: 36890908
Hi Frank,

The service is using the native Oracle client libraries and relies on the ORACLE_HOME environment to be set correctly.

The problem is when you set ORACLE_HOME in the enivronment in Windows it is global for all applications.  How do you set this individually for a service?

Thanks
0
 
LVL 15

Accepted Solution

by:
Franck Pachot earned 500 total points
ID: 36901872
Hi,
I don't know an easy way to do that. You may try to launch the service with another user that has his own ORACLE_HOME environment variable.
But remember that Oracle recommendation on windows is that ORACLE_HOME is not set so that all environment relies on the registry key entries.
Regards,
Franck.
0
 

Author Comment

by:Grant Rogers
ID: 36902485
Hi Frank,

Can you tell me which registry keys are being used instead?  Can you set these keys per user / application?

Thanks
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 15

Expert Comment

by:Franck Pachot
ID: 36903021
Here is how it works on windows:
- you call Oracle by calling a binary (oracle.exe, or a dll,...)
- oracle look into the directory where that binary comes from
- it reads the file oracle.key that has the nme of the registry key
- then it looks into the registry for that key under Oracle software branch
- and gets all values from here

So you need to know how you application service calls oracle dll...
0
 

Author Comment

by:Grant Rogers
ID: 36908863
The application uses a wrapper library called sqlapi and this then calls the oracle dlls.

How do I set either oracle.key or the registry setting per application then?

Thanks
0
 
LVL 15

Expert Comment

by:Franck Pachot
ID: 36912182
<b>per application</b>, it is only dependent of the application. The application calls the dll. Only the application can choose another Oracle home.
0
 

Author Comment

by:Grant Rogers
ID: 36924999
Hi Franc,

I am going to give the second user solution a go,

Thanks for you help
Grant
0
 

Author Closing Comment

by:Grant Rogers
ID: 36925027
Hi Franc,

I have chosen B as the grade for your answer as it a solution, but not really the answer to my original question.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
If you have done a reformat of your hard drive and proceeded to do a successful Windows XP installation, you may notice that a choice between two operating systems when you start up the machine. Here is how to get rid of this: Click Start Clic…
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…

932 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now