cancel
Showing results for 
Search instead for 
Did you mean: 

ORACLE 32 o 64 Bit Instaled

Isaac_4
Frequent Advisor

ORACLE 32 o 64 Bit Instaled

Hi

How I can know if the database ORACLE that I am running this in 32 or 64 bits

Thank you for your response!
The time is gold
8 REPLIES
A. Clay Stephenson
Acclaimed Contributor

Re: ORACLE 32 o 64 Bit Instaled

select * from v$version;

If it ain't broke, I can fix that.
Dave Chamberlin
Trusted Contributor

Re: ORACLE 32 o 64 Bit Instaled

the 64 bit has the directory lib64 in $ORACLE_HOME.
harry d brown jr
Honored Contributor

Re: ORACLE 32 o 64 Bit Instaled

Your version number should tell you that plus your OS.

live free or die
harry
Live Free or Die
Kurt Beyers.
Honored Contributor

Re: ORACLE 32 o 64 Bit Instaled

If you launch a server manager session (svrmgrl), in the startup messages it will be declared if the database is 64bit.

Kurt
H.Merijn Brand (procura
Honored Contributor

Re: ORACLE 32 o 64 Bit Instaled

Or use the 'file' command on sqlplus
see https://www.beepz.com/personal/merijn in the FAQ section
Enjoy, Have FUN! H.Merijn
Kurt Beyers.
Honored Contributor

Re: ORACLE 32 o 64 Bit Instaled

Here is the output of svrmgrl:

Oracle Server Manager Release 3.1.6.0.0 - Production

Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.

Oracle8i Enterprise Edition Release 8.1.6.3.0, 64 bit - Production
With the Partitioning option
JServer Release 8.1.6.3.0 - Production

Or you could use the chatr command:

$ORACLE_HOME/bin/chatr oracle

if it is 64 bit, it will be on the first line.

Kurt
Yogeeraj_1
Honored Contributor

Re: ORACLE 32 o 64 Bit Instaled

hi,

you get this information also when you connect using SQLPLUS.
============================================================
K250: home/yd>sqlplus user

SQL*Plus: Release 3.2.3.0.0 - Production on Mon Aug 19 08:34:03 2002

Copyright (c) Oracle Corporation 1979, 1994. All rights reserved.

Enter password:

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

Hope this Helps!
Best Regards
Yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
T G Manikandan
Honored Contributor

Re: ORACLE 32 o 64 Bit Instaled

file $ORACLE_HOME/bin/oracle

it should return something like:

ELF-64 executable object file - PA-RISC 2.0 (LP64)

if its 64-bit, otherwise you will get:

PA-RISC1.1 shared executable dynamically linked -not stripped