OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » 32 bit oracle

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

32 bit oracle [message #250591]

Tue, 10 July 2007 10:35

vijaychauhan
Messages: 106
Registered: December 2005

Senior Member

how to check if oracle is 32 bit or 64 bit.
Thanks.

Report message to a moderator

Re: 32 bit oracle [message #250594 is a reply to message #250591]

Tue, 10 July 2007 10:41

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

Report message to a moderator

Re: 32 bit oracle [message #250596 is a reply to message #250591]

Tue, 10 July 2007 10:42

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

Report message to a moderator

Re: 32 bit oracle [message #250597 is a reply to message #250591]

Tue, 10 July 2007 10:42

BlackSwan
Messages: 26766
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)!

Report message to a moderator

Re: 32 bit oracle [message #250603 is a reply to message #250591]

Tue, 10 July 2007 10:58

vijaychauhan
Messages: 106
Registered: December 2005

Senior Member

how to check the same for os(linux)

Report message to a moderator

Re: 32 bit oracle [message #250605 is a reply to message #250603]

Tue, 10 July 2007 11:05

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??

Report message to a moderator

Re: 32 bit oracle [message #250606 is a reply to message #250591]

Tue, 10 July 2007 11:07

vijaychauhan
Messages: 106
Registered: December 2005

Senior Member

whether it is 32 bit or 64 bit.

Report message to a moderator

Re: 32 bit oracle [message #250607 is a reply to message #250591]

Tue, 10 July 2007 11:08

BlackSwan
Messages: 26766
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

Report message to a moderator

Re: 32 bit oracle [message #250609 is a reply to message #250606]

Tue, 10 July 2007 11:12

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

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.

Report message to a moderator

Re: 32 bit oracle [message #250615 is a reply to message #250603]

Tue, 10 July 2007 11:24

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

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

Report message to a moderator

Previous Topic:	Dynamic Memory Allocation Question
Next Topic:	Maintain Logical Transaction Integrity in a High Availability ODS

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 02 09:34:51 CST 2024