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
744 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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
Hi Frank,

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

Thanks
0
Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

 
LVL 15

Expert Comment

by:Franck Pachot
Comment Utility
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
Comment Utility
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
Comment Utility
<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
Comment Utility
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
Comment Utility
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

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

763 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

10 Experts available now in Live!

Get 1:1 Help Now