Check whether Oracle32-bit or 64-bit (x86orx64)

How to check whether Oracle32-bit or 64-bit (x86orx64 ).

How to check whether Oracle is 32-bit or 64-bit (x86 or x64 ).

How to check whether Oracle is 32-bit or 64-bit (x86 or x64 ).

Method 1: Use sqlplus

### 64-bit:
[Oracle @ db01 ~] $ Sqlplus/as sysdba

SQL * Plus: Release 11.2.0.3.0 Production on Fri Oct 3 18:44:05 2014

Copyright (c) 1982,201 1, Oracle. All rights reserved.

Connected:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0-64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>
If it is 64-bit, the specific bit information is displayed after sqlplus is connected, and 32-bit information is not displayed.


### 32-bit:
[Oracle @ db01 ~] $ Sqlplus/as sysdba;

SQL * Plus: Release 11.2.0.1.0 Production onSun Sep 25 08:55:48 2011

Copyright (c) 1982,201 0, Oracle. All rights reserved.

Connected:
Oracle Database 11g Enterprise EditionRelease 11.2.0.1.0-Production
With the Partitioning, OLAP, Data Miningand Real Application Testing options

Method 2: view the v $ version view

### 32-bit:
SQL> select * from v $ version;

BANNER
--------------------------------------------------------------------------
Oracle Database 11g Enterprise EditionRelease 11.2.0.1.0-Production
PL/SQL Release 11.2.0.1.0-Production
CORE 11.2.0.1.0 Production
TNS for 32-bit Windows: Version 11.2.0.1.0-Production
NLSRTL Version 11.2.0.1.0-Production

### 64-bit:
SQL> select * from v $ version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0-64bit Production
PL/SQL Release 11.2.0.3.0-Production
CORE 11.2.0.3.0 Production
TNS for Linux: Version 11.2.0.3.0-Production
NLSRTL Version 11.2.0.3.0-Production
Like the first method, 64-bit displays the specific number of digits, and 32-bit does not.

Method 3: view the v $ SQL View

### 32-bit: the output is an 8-bit hexadecimal number.
SQL> select address from v $ SQL whererownum <2;

ADDRESS
--------
B50ACDAE

### 64-bit: the output is a 16-bit hexadecimal number.
SQL> select address from v $ SQL where rownum <2;

ADDRESS
----------------
00000000C18D79C8

Oracle 11g installation manual on RedHat Linux 5.8 _ x64 Platform

Installing Oracle 12C in Linux-6-64

Install Oracle 11gR2 (x64) in CentOS 6.4)

Steps for installing Oracle 11gR2 in vmwarevm

Install Oracle 11g XE R2 In Debian