Your Doorstep to the Temple of Oracle

Oracle EBS

how to Find Database is 32 bit or 64 Bit

Posted by appsdba11i on May 4, 2011

1)login as oracle user in Linux Box And go to $ORACLE_HOME/bin

2) give the following command  ” file  rman ”

example : file  Any executable (like sqlplus,rman)

You can get header of that executable if you find 32 it/64 Number there

Then that is database Bit version

Example:

 $  file    $ORACLE_HOME/bin/sqlplus 

you should see output like
/u01/db/bin/sqlplus:  ELF 64-bit MSB executable
which means you are on 64 bit oracle
If your oracle is 32 bit you should see output like
oracle: ELF 32-bit MSB executable

One Response to “how to Find Database is 32 bit or 64 Bit”

  1. Mohammad said

    Nice blog. Regarding the platform we can also use this query:

    SQL> select platform_name from v$database;

    PLATFORM_NAME
    ——————————————————————————–
    Microsoft Windows IA (32-bit)

Leave a comment