Problem solve Get help with specific problems with your technologies, process and projects.

All about 64-bit Oracle

I understand from one of your replies that Oracle 10g is only 64-bit.

  1. 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)?

  2. 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 " is "Typical."
  3. 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?

  4. 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 - Production on Tue May 3 11:17:36 2005 Copyright (c) 1982, 2004, Oracle. All rights reserved.
I am connected to Oracle Database 10g Release with 64-bit production. Thanks and regards.
  1. 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.

  2. 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.

  3. 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.

  4. SQL*Plus is telling you that the database is 64-bit Oracle. That is correct.

Dig Deeper on Oracle database installation, upgrades and patches

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.