how to verify if your oracle software binaries are 32 bit OR 64 bit

This can be done by either 2 methods:

Method 1:

Go to $ORACLE_HOME/bin

then execute the command:

$ file oracle

oracle: 64-bit XCOFF executable or object module not stripped

Method 2:-

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 B047 then it is 64 bit

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