• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2255
  • Last Modified:

Can I have Oracle 11g R2 32bit databases & 64bit databases on the same server (Windows 2008 r2 64bit)

We are installing the Citrix XenApp 6.5, which requires its data store database to be at Oracle 11g R2 32-bit ONLY. But we plan to upgrade our Oracle to 11g R2 64 bit (server:Windows 2008 R2 64bit) ; Is there a way to keep both versions on one database server?

Thank you very much!

3 Solutions
You should be able to keep this on the same server (64-bit). Are you getting any errors?
hanjgrAuthor Commented:
I haven't started it. You mean I could install Oracle 11g R2 32-bit database software & 64-bit software and creating/migrating databases to different ones?
Geert GOracle dbaCommented:
Isn't it the oracle client which is required to be 32-bit and the database can be either 32 or 64-bit ?

I have converted lots of 32-bit databases to 64-bit without ever touching the client or app running on the database. The 32-bit client takes care of the conversion.
Even apps stating they require a 32-bit database.

The only problem could be if the app uses addresses directly of v$ tables
If the app relies on those addresses as 32-bit then it's not a good design
> oracle states it can change it's v$ table to whatever it wants

looking at the specs, i'd give a 64db with a 32-bit client a try
> Do not install XenApp on a server hosting an Oracle database.
if using the 32-bit client on the XenApp server it won't event notice the database is 64-bit.
Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

Dirk KotteSECommented:
XenApp need the 32 Bit oracle client.
This client can be used with the 64 Bit oracle Server.
(I have configured this multiple times ...)

please note: the oracle client must be installed before xenapp ... otherwise the option to use the oracle is missing!
hanjgrAuthor Commented:
So I can install both 32-bit and 64 bit client on the same server (before XenApp) and just keep 64-bit database server? we hope to use 64-bit client for non-XenApp databases on the XenApp application servers as well .
Geert GOracle dbaCommented:
you'll need to make sure the 32-bit client is the first in path environment variable for windows
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now