Oracle DBA – A lifelong learning experience

More on detecting whether 32 or 64 bit installation

Posted by John Hallas on August 26, 2010

I came across a blog about how to detect if your database version was 32 or 64 bit. I would have responded via  a comment but I could not see an option on the blog site to do this.

The two suggested methods are below

Method 1:
Go to ORACLE_HOME/bin
<em>$ file oracle</em>
oracle: ELF <strong>32-bit MSB</strong> executable SPARC Version 1, dynamically linked, not stripped
Method 2:-
Login to sqlplus,
use the following query,
<em>SQL> select metadata from sys.kopm$ ;</em>
-----------------------
METADATA
-----------------------
0000006001240F050B0C030C0C0504050D06090708050F0505050F05
050505050A050505050504050607080823472323081123081141<strong>B023</strong>0
083001F07D01300000000000000000000000000000000000000000
000000000000000000000000000000000

If the output has 'B023' string then the database is 32 bit else if it is B047 then it is 64 bit 

For method 1 my notes on Solaris tell me to use the isainfo -v command to see if we have a 32 or 64 bit server, which I am aware is different from seeing what verion of the software has been installed. If sparcv9 then 64 bit and if only sparc then 32 bit.

#isainfo -v
64-bit sparcv9 applications
32-bit sparc applications

However for method two, a much easier method to remember is just  to describe v$session

SQL>desc v$session
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 SADDR                                              RAW(8)
 SID                                                NUMBER
 SERIAL#                                            NUMBER
 AUDSID                                             NUMBER
 PADDR                                              RAW(8)

If PADDR and SADDR are RAW(8) then 64 bit, if RAW(4) then 32 bit

About these ads

One Response to “More on detecting whether 32 or 64 bit installation”

  1. Taral Desai said

    This is different from requirement. This is to find OS Version

    In 11g it logs platform name here

    select platform_name from DBA_HIST_DATABASE_INSTANCE where rownum=1;

    PLATFORM_NAME
    ————————————-
    Microsoft Windows IA (32-bit)

    select platform_name from DBA_HIST_DATABASE_INSTANCE where rownum=1;

    PLATFORM_NAME
    ————————————-
    Linux 64-bit for AMD

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
Follow

Get every new post delivered to your Inbox.

Join 184 other followers

%d bloggers like this: