RE: Database is 32 or 64 Bit ? - Clarification

From: VIVEK_SHARMA <VIVEK_SHARMA_at_infosys.com>
Date: Fri, 04 Oct 2002 04:08:28 -0800
Message-ID: <F001.004E0802.20021004040828@fatcity.com>

Hi

Qs What do you mean by raw(4) / raw(8) ? Does it mean Length of the Field Data Value ?

>From my Database :-

SQL> select saddr from v$session where rownum < 2   2 /

SADDR

---

313941C0

CASE - Assuming on receiving a Database from a 3rd party 1) My Existing Installed ORACLE_HOME software is 64 - Bit 2) Assuming the Database Sent is a 32-Bit Database ( which i am Ignorant of )

Qs When i Bring up this 32-Bit Database using my 64-Bit Oracle Software will SADDR Still show raw(4) values ?

Thanks

-----Original Message-----
Sent: Friday, October 04, 2002 1:03 PM
To: Multiple recipients of list ORACLE-L

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).
--

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). Received on Fri Oct 04 2002 - 07:08:28 CDT