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!

Jing
hanjgrAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

sventhanCommented:
You should be able to keep this on the same server (64-bit). Are you getting any errors?
0
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?
0
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
http://support.citrix.com/proddocs/topic/xenapp65-install/ps-database-ref-oracle.html
> 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.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Creating Active Directory Users from a Text File

If your organization has a need to mass-create AD user accounts, watch this video to see how its done without the need for scripting or other unnecessary complexities.

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!
0
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 .
0
Geert GOracle dbaCommented:
yes,
you'll need to make sure the 32-bit client is the first in path environment variable for windows
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.