My confrontations with oracle

December 4, 2008

How to identify the type(32 or 64bit) of software installed ?

Filed under: oracle — John Jacob @ 11:25 am
Tags: ,

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 :D .

3 Comments »

  1. [...] 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 | Reply

  2. 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 | Reply

  3. oops!! i forgot that.. :)
    thnks vijay for bringing it out..

    Comment by John Jacob — January 20, 2009 @ 2:39 pm | Reply


RSS feed for comments on this post. TrackBack URI

Leave a comment

Blog at WordPress.com.