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:
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$ ;
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