Home » RDBMS Server » Server Administration » 32 bit oracle
32 bit oracle [message #250591] Tue, 10 July 2007 10:35 Go to next message
vijaychauhan
Messages: 106
Registered: December 2005
Senior Member
how to check if oracle is 32 bit or 64 bit.
Thanks.
Re: 32 bit oracle [message #250594 is a reply to message #250591] Tue, 10 July 2007 10:41 Go to previous messageGo to next message
Cthulhu
Messages: 381
Registered: September 2006
Location: UK
Senior Member
Log into SQL*Plus ?

SQL*Plus: Release 9.2.0.4.0 - Production on Tue Jul 10 16:38:03 2007

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.


Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
Re: 32 bit oracle [message #250596 is a reply to message #250591] Tue, 10 July 2007 10:42 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
vijaychauhan wrote on Tue, 10 July 2007 09:35
how to check if oracle is 32 bit or 64 bit.
Thanks.


When you are buying are downloading there are options 32 bit or 64-bit.

SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bi
PL/SQL Release 10.2.0.3.0 - Production
CORE    10.2.0.3.0      Production
TNS for Solaris: Version 10.2.0.3.0 - Production
NLSRTL Version 10.2.0.3.0 - Production
Re: 32 bit oracle [message #250597 is a reply to message #250591] Tue, 10 July 2007 10:42 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
Since the answer is Operating System dependent & you chose not to share that fact, You're On Your Own (YOYO)!
Re: 32 bit oracle [message #250603 is a reply to message #250591] Tue, 10 July 2007 10:58 Go to previous messageGo to next message
vijaychauhan
Messages: 106
Registered: December 2005
Senior Member
how to check the same for os(linux)
Re: 32 bit oracle [message #250605 is a reply to message #250603] Tue, 10 July 2007 11:05 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
vijaychauhan wrote on Tue, 10 July 2007 09:58
how to check the same for os(linux)


Check what??
Re: 32 bit oracle [message #250606 is a reply to message #250591] Tue, 10 July 2007 11:07 Go to previous messageGo to next message
vijaychauhan
Messages: 106
Registered: December 2005
Senior Member
whether it is 32 bit or 64 bit.
Re: 32 bit oracle [message #250607 is a reply to message #250591] Tue, 10 July 2007 11:08 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
file $ORACLE_HOME/bin/oracle
/a/oracle/product/10.2.0/bin/oracle: ELF 32-bit LSB executable, Intel 80386, version 1 (SYSV), for GNU/Linux 2.2.5, dynamically linked (uses shared libs), not stripped
Re: 32 bit oracle [message #250609 is a reply to message #250606] Tue, 10 July 2007 11:12 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
omzimp14ESPSVCS:/export/home/oracle: /usr/bin/isainfo -kv
64-bit sparcv9 kernel modules


for linux use

uname -m

[Updated on: Tue, 10 July 2007 11:13]

Report message to a moderator

Re: 32 bit oracle [message #250610 is a reply to message #250591] Tue, 10 July 2007 11:14 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
vijaychauhan wrote on Tue, 10 July 2007 09:35
how to check if oracle is 32 bit or 64 bit.
Thanks.

How about this Oracle install? Is it 64-bit?

The question here is weather your Oracle binaries are 64-bit. While some of the binaries associated with Oracle may be 32-bit, the important ones will be 64 bit. To check those, follow these steps from the command line:

cd $ORACLE_HOME/bin
file oracl*

This will display the file type of your oracle binaries. If you are running 64-bit binaries, the output should look like this:

oracle: ELF 64-bit MSB executable SPARCV9 Version 1, dynamically linked, not stripped
oracleO: ELF 64-bit MSB executable SPARCV9 Version 1, dynamically linked, not stripped

If your binaries are 32-bit, the output will look like this:

oracle: ELF 32-bit MSB executable SPARC Version 1, dynamically linked, not stripped

If you find you are running 32-bit and decide to go to 64 be careful.
Re: 32 bit oracle [message #250615 is a reply to message #250603] Tue, 10 July 2007 11:24 Go to previous messageGo to next message
Michel Cadot
Messages: 64133
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The following returns the number of bits for your OS:
/usr/bin/file /bin/ps|awk '{print substr($3,1,2)}' | tr -d '\n'

Regards
Michel

[Updated on: Tue, 10 July 2007 11:24]

Report message to a moderator

Re: 32 bit oracle [message #250634 is a reply to message #250591] Tue, 10 July 2007 13:20 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Another way:

SQL> desc v$session
 Name                                      Null?    Type
 ----------------------------------------- -------- -------
 SADDR                                              RAW(4)

The RAW(4) implies 32 bits (4*8). You would expect to see RAW(8) if you were on 64 bit (8*8).
Previous Topic: Dynamic Memory Allocation Question
Next Topic: Maintain Logical Transaction Integrity in a High Availability ODS
Goto Forum:
  


Current Time: Thu Dec 08 04:24:28 CST 2016

Total time taken to generate the page: 0.06289 seconds