How to check if oracle binary is 32 bit or 64 bit?


How can we check Oracle binaries are 64-bit or 32 bit. While some of the binaries associated with Oracle may be 32-bit, the important ones will be 64 bit. To check those, follow these steps from the command line:

$ cd $ORACLE_HOME/bin
$ file oracl*

file command is used to show file type.
This will display the file type of your oracle binaries. If you are running 64-bit binaries, the output should look like this:

oracle: ELF 64-bit MSB executable SPARCV9 Version 1, dynamically linked, not stripped
oracleO: ELF 64-bit MSB executable SPARCV9 Version 1, dynamically linked, not stripped

If your binaries are 32-bit, the output will look like this:

oracle: ELF 32-bit MSB executable SPARC Version 1, dynamically linked, not stripped

For linux operating system:

if you want to check whether your linux operating system is 32 bit or 64 bit use follow command to show kernel related information:

uname -m

if it shows x86_64 then your os is 64 Bit

if it shows i686 then it is 32 bit.

use manual command to get more information about uname arguments.

Login to sqlplus,

use the following query,

SQL> select metadata from sys.kopm$ ;

oracle_bit_version

Search in the output string if it has B023 string then the database is 32 bit else if it is B047then it is 64 bit

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s