How to check whether oracle is 32bit/64bit and running OS platform is 32bit/64bit?

For Oracle:
Go to ORACLE_HOME/bin directory and type file oracle
cd $ORACLE_HOME/bin
file oracle
$ file oracle
oracle:         ELF 64-bit MSB executable SPARCV9 Version 1, dynamically linked, not stripped

For Unix OS:
          Solaris: $ /usr/bin/isainfo -kv
$  /usr/bin/isainfo -kv

64-bit sparcv9 kernel modules

Linux: uname –m
adba@premieradba bin/ $ uname -m
x86_64
For Oracle Client SQLPLUS:
% file $ORACLE_HOME/bin/sqlplus 64-bit will show 64-bit.
32-bit will show 32-bit or not specify wordsize
Check for directories
$ORACLE_HOME/lib32
$ORACLE_HOME/lib

$ ls -l $ORACLE_HOME/lib32
$ ls -l $ORACLE_HOME/lib
DBA Tips Data Pump Reference

0 comments:

Post a Comment

 

dba topics. Copyright 2011-16 All Rights Reserved | Site Map | Contact | Disclaimer | Google