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 10.1.0.2.0 " 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 10.1.0.2.0 - 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 10.1.0.2.0 with 64-bit production. Thanks and regards.

    Requires Free Membership to View

  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.

This was first published in May 2005

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: