Skip to main content

How to Tell if the Oracle Software is 32-Bit or 64-Bit

How to find if the Oracle Client Software is 32-Bit or 64-Bit ?

here you can have some ways to find it.

You can find whether Oracle Client Software is 32-Bit or 64-Bit by using the following :


1.Check the sqlplus binary

% file $ORACLE_HOME/bin/sqlplus

64-bit will show 64-bit.
32-bit will show 32-bit or not specify wordsize

2.Check for the directories :

$ORACLE_HOME/lib32
$ORACLE_HOME/lib

% ls -l $ORACLE_HOME/lib32
% ls -l $ORACLE_HOME/lib


If the two directories $ORACLE_HOME/lib32 and $ORACLE_HOME/lib exist, then it is 64 bit client.
If you have only $ORACLE_HOME/lib you need to use method 1 as there are client versions (11.2)where $ORACLE_HOME/lib32 directory does not exist on 64-bit client installations.

Refernce:
How To Find If The Oracle Client Software Is 32-Bit Or 64-Bit on UNIX platforms [ID 434295.1]

NOTE:119707.1 - How to Tell if the Oracle Software is 32-Bit or 64-Bit

Comments

mahakk01 said…
This is an interesting question. Although I know the answer of this question but I like the way you explained answer of this question and each concept related to Oracle software. You are doing an excellent work.Thanks for the wonderful post.
sap support pack implementation
November 1, 2011 at 1:04 AM
All Good Knowledge said…
Hi,

How can you tell for Windows Oracle client install, is it 32 or 64 bits?
So are I can only see $ORACLE_HOME/lib. lib32 is not there. So looks like it is 64 bit??
August 3, 2012 at 3:17 PM
Post a Comment

Popular posts from this blog

ORA-20200 Error while running AWR report from PDB level

Issue: In 19c database, while generating AWR report from PDB level, got the below error.  In 12cR1 - We can only generate statistics and run the Workload Repository (AWR) report from CDB level.  Since 12.2, if we want to generate statistics and run AWR report from PDB level, we have to change  awr_pdb_autoflush_enabled parameter to TRUE. Error: ERROR at line 1: ORA-20200: Database/Instance 2832289441/1 does not exist in AWR_PDB_DATABASE_INSTANCE ORA-06512: at line 27 Solution: alter session set container=ORCL; >>>>   Set the container Name alter system set awr_pdb_autoflush_enabled=true; conn system/<pwd>@orclcdb     >>>> Login into PDB database alter system set AWR_SNAPSHOT_TIME_OFFSET=1000000 scope=both;   >>> Set the arameter to avoid performance issue while generating snapshot at the same time in CDB and PDB level. exec dbms_workload_repository.create_snapshot(); SQL> @?/rdbms/admin/awrrpt.sql Console Log: SQL> show pdbs       CON_ID CON
Post a Comment
Read more

EBS 12.2 - Script to monitor JVM Heap Memory for the weblogic managed servers

#!/bin/sh # Script to monitor JVM Heap Memory for the managed servers # Author : Ramasubbu Sunadaravel # Date   : 23-Aug-2016 # Usage  : sh jvm_heap_mem_mon.sh run  ## VARIABLES save_date=`date +%d_%b_%y` LOGFILE=/export/home/applmgr/oraprocs/logs HISTFILE=/export/home/applmgr/oraprocs/histfile threshold=10 MAIL_LIST=rsundaravel@yahoo.com SCRIPT=/export/home/applmgr/oraprocs/.jvm_check.py ## SCRIPTS STARTS HERE . /r11/app/FLRPRD/R12apps/EBSapps.env . $FMW_HOME/wlserver_10.3/server/bin/setWLSEnv.sh java weblogic.WLST $SCRIPT > $LOGFILE/jvm_heap_monitoring.log date '+Start Time: %m/%d/%y %H:%M:%S' >> $HISTFILE/jvm_heap_monitoring_$save_date.log cat $LOGFILE/jvm_heap_monitoring.log|grep "%" >> $HISTFILE/jvm_heap_monitoring_$save_date.log date '+End Time: %m/%d/%y %H:%M:%S' >> $HISTFILE/jvm_heap_monitoring_$save_date.log #Alert DBA's if any of the managed server heap size reached more than $threshold value current=`
Post a Comment
Read more

EBS 12.2 - Script to monitor Weblogic Managed servers

#!/bin/sh # Script to monitor Weblogic managed server status # Author : Ramasubbu Sunadaravel # Date   : 23-Aug-2016 . /r11/app/FLRPRD/R12apps/EBSapps.env ## VARIABLES ### LOGFILE=/export/home/applmgr/oraprocs/logs MAIL_LIST=rsundaravel@yahoo.com ADMIN_URL=http://test.domain.int:7014/console PARFILE=/export/home/applmgr/oraprocs/mgd_server_list.par ## - place all the managed servers name. WEBLOGIC_PWD = /export/home/applmgr/oraprocs/.weblogicpwd ## SCRIPT STARTS cat $PARFILE |while read line do managed_server=`echo $line | awk '{print $1}'` LOGFILE=/export/home/applmgr/oraprocs/logs echo $managed_server echo `cat $WEBLOGIC_PWD`|$ADMIN_SCRIPTS_HOME/admanagedsrvctl.sh status $managed_server|grep $managed_server|grep -v logs > $LOGFILE/$managed_server.log status=`cat $LOGFILE/$managed_server.log|grep "is running"|wc -l` if test $status -eq 1 then echo "$managed_server is Running" else echo "$managed
Post a Comment
Read more