My current environment:
By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
- AIX5.2 ML6
- Oracle 126.96.36.199 64-bit.
My problem is I have an application that does not support 64-bit Oracle. It needs to run on 32-bit Oracle.
My questions are:
- Can I install two Oracle engines (32-bit and 64-bit) on the same machine?
- If yes, how can it be done?
- Is there an installer for 32-bit Oracle 9i?
- How does 32-bit Oracle differ from 64-bit Oracle?
Thank you in advance.
- You can install Oracle 32-bit and Oracle 64-bit on the same server. The two installs must reside in different ORACLE_HOME directories though. So install Oracle 32-bit in a different directory than your 64-bit version and they will both coexist quite nicely.
- When you fire up the Oracle Universal Installer (OUI), enter a new ORACE_HOME directory when prompted.
- The OUI for the 32-bit version will be found with the media. In Disk1 of Oracle 9i, you will find a runInstaller utility.
- The difference between 32-bit and 64-bit software (not just limited to Oracle) lies at the difference in how your operating system executes code. The OS will look at code in chunks of memory called a "word." Those applications that are 32-bit apps have a word size of 32 bits. Those applications that are 64-bit apps have a word size of 64 bits. You must have a 64-bit OS (and processors) to be able to run 32-bit and 64-bit apps. You cannot run 64-bit software on a 32-bit OS (and processors). By addressing larger word sizes, many applications can run faster. A larger word size lets you address larger chunks of memory as well. If you want a SGA larger than 2GB, you need to use 64-bit Oracle.
Dig Deeper on Oracle database backup and recovery
Related Q&A from Brian Peasland
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs.continue reading
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command.continue reading
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming.continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.