- Does it mean that my applications should be in 64-bit only (Please explain if you meant this in a server and or client environment)?
- I have installed Oracle 10g on AIX 5.3 (64-bit). In the log file I have the following entry, but it is confusing -- is it 32-bit Oracle or 64-bit Oracle? The CD reads as Oracle 10g for AIX 5L-based systems (64-bit). Here is the log file entry:
Install type for "Oracle Database 10G 32 bit 10.1.0.2.0 " is "Typical."
- I also installed a client on the same machine. If I write an application using Pro*COBOL or Pro*C, what will be the application bit mode? 32-bit or 64-bit?
- When I connect via SQLPLUS to the default database that is created during installation, the resulting message is confusing me. Does it mean that the database created is 64-bit?
SQL*Plus: Release 10.1.0.2.0 - Production on Tue May 3 11:17:36 2005 Copyright (c) 1982, 2004, Oracle. All rights reserved.
- Your applications do not have to be 64-bit to use Oracle 10g. For instance, I run SQL*Plus on my 32-bit Windows desktop. This 32-bit application connects to 64-bit Oracle just fine.
Most but not all of Oracle 10g is 64-bit. Oracle 10g on Linux and Windows does have a 32-bit flavor. But Oracle 10g for the Unix platforms is almost all 64-bit now.
- Sometimes the log entries were not "updated" when the database version was updated. Unfortunately, it is not uncommon to find such inconsistencies. The best way to know if the installation is 32-bit or 64-bit is to fire up SQL*Plus for that software installation and connect to the database. It will tell you if the installation is 32-bit or 64-bit.
- If you compile a Pro*C program with 64-bit Oracle's precompilers, then the resulting program will be 64-bit. After running your code through the precompiler, you will need to use a 64-bit compiler to finish compilation of your program. If you want a 32-bit program, then install the 32-bit version of client software, complete with precompilers and use that installation instead of the RDBMS installation.
- SQL*Plus is telling you that the database is 64-bit Oracle. That is correct.
Dig Deeper on Oracle database installation, upgrades and patches
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