RE: Database is 32 or 64 Bit ?

From: <John.Hallas_at_vodafone.co.uk>
Date: Thu, 03 Oct 2002 23:33:18 -0800
Message-ID: <F001.004E0662.20021003233318@fatcity.com>

I posted the note below a few weeks ago, hope it helps

John
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

Listers,
Here is a little summary of commands to identify the bit version of an o/s and 2 methods of identifying whether a database is a 32 bit or 64 bit installation

Operating System

Compaq Tru 64 - will be 64 bit

HP-UX  	/usr/sbin/swlist | grep -E '32|64' returns 
	HPUXEng64RT           B.11.00.01     English HP-UX 64-bit Runtime
Environment if 64 bit
Sun 		isalist -v

If the return contains the phrase 'sparcv9' then it is a 64 bit o/s Oracle Version
To check Oracle version - 2 methods
do a file on $ORACLEHOME/bin/oracle returns either ELF-32 or ELF-64 executable
Within sqlplus desc v$session and look for the definition of saddr (if raw(4) then 32 bit else if raw(8) 64 bit)
>>>>>>>>>>>>>>>>>>>>>>>>>>>

-----Original Message-----
Sent: 04 October 2002 07:53
To: Multiple recipients of list ORACLE-L

Given a Database . It is 32 Bit or 64 Bit , how can it be found ?

Assuming Cold Backup of Database Sent from Elsewhere

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: VIVEK_SHARMA
  INET: VIVEK_SHARMA_at_infosys.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: John.Hallas_at_vodafone.co.uk

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Fri Oct 04 2002 - 02:33:18 CDT