?
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
Medium Priority
?
760 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 1500 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
Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

 

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
 
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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
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 explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.
Suggested Courses
Course of the Month14 days, 15 hours left to enroll

839 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