OraFAQ Forum: Server Administration » Oracle Version 32 bit or 64 bit

Home » RDBMS Server » Server Administration » Oracle Version 32 bit or 64 bit

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

Oracle Version 32 bit or 64 bit [message #297046]

Wed, 30 January 2008 00:13

tkmittal1
Messages: 143
Registered: May 2007
Location: Delhi

Senior Member

HI M

can u give me the command thru which i can found the oracle version installed is 32 bit or 64 bit

Thanks & Regards

Report message to a moderator

Re: Oracle Version 32 bit or 64 bit [message #297053 is a reply to message #297046]

Wed, 30 January 2008 00:37

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

nevermind....

[Updated on: Wed, 30 January 2008 00:38] by Moderator

Report message to a moderator

Re: Oracle Version 32 bit or 64 bit [message #297055 is a reply to message #297046]

Wed, 30 January 2008 00:41

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

Senior Member
Account Moderator

Easiest way:
64-bit:

SQL> select * from v$version where rownum=1;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bi

32-bit:

SQL> select * from v$version where rownum=1;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Prod

Note the "64bit" in 64bit version.
If you are on Unix, in $ORACLE_HOME/bin:

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

Regards
Michel

[Updated on: Wed, 30 January 2008 00:42]

Report message to a moderator

Previous Topic:	Create DB using commands instead of DBCA
Next Topic:	Deinstall 10g

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jan 26 19:34:02 CST 2025