how to know oracle architecture (32 or 64 bits)

[Roberto Martinez_6]

I've been assigned to a system with oracle 8.1.7 installed. I wish to know whether it's the 64bit or 32bit version. How can I know this? TIA.

[T G Manikandan · Accepted solution]

Just do a
$svrmgrl

it will list down whether it is a 64 bit or 32 bit version

"64 bit in production"

thanks

[Ravi_8]

Hi,

Only in case of oracle 8i you can execute svrmgrl, what about 9i? (no svrmgrl in 9i)
Oracle 9i is 64 bits.
all the information I have from Oracle is that there is no 32-bit version of the Oracle 9i RDBMS. They do provide you with the ability to build a 32-bit Oracle application but the database itself is 64-bit only.

[Jon Mattatall]

Check the executable -
cd $ORACLE_HOME/bin
chatr oracle

64-bit ELF executable
....

or, just look in $ORACLE_HOME for a lib64 directory. No directory, it's 32 bits...

Jon

[Yogeeraj_1]

hi,

connecting through SQLPLUS itself can also give you the desired information.

e.g.
$ sqlplus system/manager

SQL*Plus: Release 8.1.7.0.0 - Production on Fri Feb 28 16:58:31 2003

(c) Copyright 2000 Oracle Corporation. All rights reserved.


Connected to:
Oracle8i Enterprise Edition Release 8.1.7.4.0 - 64bit Production
With the Partitioning option
JServer Release 8.1.7.4.0 - 64bit Production

SQL>


hope this helps too!

Cheers
Yogeeraj