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
748 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

 

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

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

734 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