Simpler Navigation for Servers and Operating Systems
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
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