Tag Archives: 64-bit

Check version of binaries 32/64 bit and database Oracle

Check version of binaries 32/64 bit and database Oracle

Check version of installed binaries Client or Server
Tnsping command from Command shell also let you know the version of Oracle Binaries
Note: i am taking example of server binaries if you set client binaries then it will let you know client version and its 32/64 bit software.

-- Setting Server Oracle Home and PATH
Set oracle_home= E:\oracle\dbhome_1
set path=%oracle_home%\bin;%PATH%
C:\oracle>tnsping
TNS Ping Utility for 64-bit Windows: Version 11.2.0.2.0 - Production on 07-SEP-2018 14:38:28
Copyright (c) 1997, 2014, Oracle. All rights reserved.
TNS-03502: Insufficient arguments. Usage: tnsping

Check the Version of Oracle Database.

select * from v$version;
BANNER
------------------------------------------------------------------------------
Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production
PL/SQL Release 11.2.0.2.0 - Production
CORE 11.2.0.2.0 Production
TNS for 64-bit Windows: Version 11.2.0.2.0 - Production
NLSRTL Version 11.2.0.2.0 - Production

Check database version which is connected with 64-bit or 32-bit status

column product for a36
col version for a10
col status for a20
select * from product_component_version ;
PRODUCT VERSION STATUS
------------------------------------ ---------- -----------------
NLSRTL 11.2.0.2.0 Production
Oracle Database 11g Express Edition 11.2.0.2.0 64bit Production
PL/SQL 11.2.0.2.0 Production
TNS for 64-bit Windows: 11.2.0.2.0 Production

Check the database version which connected.

SQL> SELECT version FROM v$instance;
VERSION
-----------------
11.2.0.2.0

Check the version of SQLPLUS (it will give you version of binaries Oracle Client or Server)
Note: it depend upon its path from which sqlplus is running it may be client or Server. If you set client binaries path then it will give you client version.

-- Setting Server Oracle Home and PATH
Set oracle_home= E:\oracle\dbhome_1
set path=%oracle_home%\bin;%PATH%
C:\oracle>sqlplus -version
SQL*Plus: Release 11.2.0.2.0 Production

Advertisements