Home » RDBMS Server » Server Administration » Oracle Version 32 bit or 64 bit
Oracle Version 32 bit or 64 bit [message #297046] Wed, 30 January 2008 00:13 Go to next message
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




Re: Oracle Version 32 bit or 64 bit [message #297053 is a reply to message #297046] Wed, 30 January 2008 00:37 Go to previous messageGo to next message
BlackSwan
Messages: 25046
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 Go to previous message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
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:
  


Current Time: Thu Dec 08 18:36:58 CST 2016

Total time taken to generate the page: 0.17280 seconds