One of the first thing that we should consider before any patching is to identify the type of software installed.Upgrading a 32bit intallation using a patch for 64bit would make your day hell.
Well, for Oracle RDBMS one could identify it from the messages while executing sqlplus uid/passwd from the oracle db home.
[]$ sqlplus / as sysdba SQL*Plus: Release 10.2.0.3.0 - Production on Thu Dec 4 11:02:28 2008 Copyright (c) 1982, 2006, Oracle. All Rights Reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production With the Partitioning, Real Application Clusters, OLAP and Data Mining options SQL>
But how about Oracle Agent, Oracle HTTP Server, Oracle Cluster etc.
The software type is mentioned in every ORACLE_HOME/inventory/ContentsXML/oraclehomeproperties.xml. I believe this file is available in almost all oracle products(i have checked for rdbms,cluster,agent,client,http server,Grid Control(oms)).
For 64 bit software installations on Solaris SPARC 64bit OS it will be
<ARU_PLATFORM_INFO>
<ARU_ID>23</ARU_ID>
<ARU_ID_DESCRIPTION>Solaris Operating System (SPARC 64-bit)
</ARU_ID_DESCRIPTION>
</ARU_PLATFORM_INFO>
For 32 bit software installations on Solaris SPARC 64bit OS it will be
<ARU_PLATFORM_INFO>
<ARU_ID>453</ARU_ID>
<ARU_ID_DESCRIPTION>Solaris Operating System (SPARC 32-bit)
</ARU_ID_DESCRIPTION>
</ARU_PLATFORM_INFO>
For 32 bit installations on Win2k 32bit OS it will be
<ARU_PLATFORM_INFO>
<ARU_ID>912</ARU_ID>
<ARU_ID_DESCRIPTION>Microsoft Windows (32-bit)
</ARU_ID_DESCRIPTION>
</ARU_PLATFORM_INFO>
For 32 bit installations on CentOS 32bit OS it will be
<ARU_PLATFORM_INFO>
<ARU_ID>46</ARU_ID>
<ARU_ID_DESCRIPTION>Linux x86
</ARU_ID_DESCRIPTION>
</ARU_PLATFORM_INFO>
On Solaris SPARC environments ARU_ID =23 is for 64bit and 453 is for 32bit software installations.
I ‘am not sure of other environments, may be some one can update me
.
[...] Index Filed under: oracle — John Jacob @ 11:43 pm How to identify the type(32 or 64bit) of software installed ? [...]
Pingback by Index « My confrontations with oracle — December 15, 2008 @ 8:10 pm |
da John u can give
file $ORACLE_HOME/bin/oracle and find the bit size
Comment by Vijay George — January 20, 2009 @ 1:57 pm |
oops!! i forgot that..
thnks vijay for bringing it out..
Comment by John Jacob — January 20, 2009 @ 2:39 pm |