- Oracle DBA – A Helping Hand
- Rajeev Kumar Jha – Domain Head Oracle (OCP 9i, 10g, 11g, 12c & Oracle Certified Expert, Oracle Real Application Clusters 11g and Grid Infrastructure Administrator)
- How to check if your Oracle Client is 32 bit or 64 bit.
- Detect all Oracle versions installed
- 3 Answers 3
- Not the answer you’re looking for? Browse other questions tagged oracle command-line version detect or ask your own question.
- Linked
- Related
- Hot Network Questions
- Subscribe to RSS
- How to know installed Oracle Client is 32 bit or 64 bit?
- 9 Answers 9
- How do we check version of Oracle
- 6 Answers 6
- Not the answer you’re looking for? Browse other questions tagged sql oracle version or ask your own question.
- Linked
- Related
- Hot Network Questions
- Subscribe to RSS
- Check Oracle Version
Oracle DBA – A Helping Hand
Rajeev Kumar Jha – Domain Head Oracle (OCP 9i, 10g, 11g, 12c & Oracle Certified Expert, Oracle Real Application Clusters 11g and Grid Infrastructure Administrator)
How to check if your Oracle Client is 32 bit or 64 bit.
RESOLUTION 1:
If logged into Toad and connected to your database, go to Help | Support Bundle and review the section noted as “ORACLE CLIENT INFORMATION”
RESOLUTION 2:
If logged into SQL Plus, the banner will tell you 64-bit if the 64-bit version is installed. If it does not specify 64-bit then it is 32-bit (even though it does not explicitly say so).
RESOLUTION 3:
You can specifically query the info by running the following:
SELECT * FROM V$VERSION;
The banner will tell you 64-bit if the 64-bit version is installed. If it does not specify 64-bit then it is 32-bit.
RESOLUTION 4:
Run the query to check the following:
SQL> select distinct address from v$sql where rownum select distinct address from v$sql where rownum Properties –> Advanced system settings –>Advanced Tab —> Environment Variables –> then check Path Option in the System variables to see Oracle client HOME dir.
Bring up a command-line prompt.
cd into the Oracle client directory. In the oracle client directory, there should be a bin folder. In the bin folder, there should be an executable called tnsping.exe
If you run this utility without any command-line options it will tell you what version is installed. The bit-level shown is the bit level of the oracle client. This will display client information and should note 64-bit or 32-bit.
For More Details, you can reach us using the below link.
Detect all Oracle versions installed
How can I check all oracle versions and platforms that installed on windows machine from a command line or by script ? Till now I was using tnsping and check for the output but it only show the first version according to the path environment variable. Is there a way to get this info from the registry and without actually connect to DB ?
3 Answers 3
Simplest method is to run command prompt and type sqlplus it will show you the oracle version without actually logging into it.
Example: Run -> cmd
Microsoft Windows [Version 6.1.7601] Copyright (c) 2009 Microsoft Corporation. All rights reserved.
C:\Users\xyz>sqlplus
SQL*Plus: Release 11.2.0.1.0 Production on Wed Jan 1 16:46:40 2014
Copyright (c) 1982, 2010, Oracle. All rights reserved.
You’ll want to query the Oracle Inventory.
For every Oracle installation, there is an entry in the «Oracle inventory». By default, the Oracle inventory is located under «C:\Program Files\Oracle\Inventory». However, this location can be changed.
In the Registry, the location of the Oracle inventory is in «HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE», where you’ll find the key «inst_loc». There, you’ll find an XML file containing all installed versions (inventory.xml). See the Oracle documentation for an example.
Go here and open with Notepad:
- C:\Program Files (x86)\Oracle\Inventory\ContentsXML
- C:\Program Files\Oracle\Inventory\ContentsXML
Open File: inventory.xml
Not the answer you’re looking for? Browse other questions tagged oracle command-line version detect or ask your own question.
Linked
Related
Hot Network Questions
Subscribe to RSS
To subscribe to this RSS feed, copy and paste this URL into your RSS reader.
site design / logo © 2021 Stack Exchange Inc; user contributions licensed under cc by-sa. rev 2021.4.16.39093
By clicking “Accept all cookies”, you agree Stack Exchange can store cookies on your device and disclose information in accordance with our Cookie Policy.
How to know installed Oracle Client is 32 bit or 64 bit?
OS: Windows 2008 Server R2
Oracle Client: 11.2
9 Answers 9
A simple way to find this out in Windows is to run SQLPlus from your Oracle homes’s bin directory and then check Task Manager. If it is a 32-bit version of SQLPlus, you’ll see a process on the Processes tab that looks like this:
If it is 64-bit, the process will look like this:
Go to %ORACLE_HOME%\inventory\ContentsXML folder and open comps.xml file
second screen.
If following lines have
You may have both 32-bit and 64-bit Oracle Homes installed.
One thing that was super easy and worked well for me was doing a TNSPing from a cmd prompt:
1) find where is sqlplus located,
2) Determine the file type,
[oracle@LINUX db_1]$ file /app/oracle/product/11.2.0/db_1/bin/sqlplus
/app/oracle/product/11.2.0/db_1/bin/sqlplus: ELF 64-bit LSB executable, x86-64, version 1 (SYSV), dynamically linked (uses shared libs). For GNU/Linux 2.6.18, not stripped.
None of the links above about lib and lib32 folder worked for me with Oracle Client 11.2.0 But I found this on the OTN community:
As far as inspecting a client install to try to tell if it’s 32 bit or 64 bit, you can check the registry, a 32 bit home will be located in HKLM>Software>WOW6432Node>Oracle, whereas a 64 bit home will be in HKLM>Software>Oracle.
The following, taken from here, was not mentioned here:
If the Oracle Client is 32 bit, it will contain a «lib» folder; but if it is a 64 bit Oracle Client it will have both «lib» and «lib32» folders.
Also, starting in Oracle 11.2.0.1, the client version for 64-bit and the Oracle client for 32-bit are shipped separately, and there is an $ORACLE_HOME/lib64 directory.
$ORACLE_HOME/lib/ ==> 32 bit $ORACLE_HOME/lib64 ==> 64 bit
$ORACLE_HOME/lib/ ==> 64 bit $ORACLE_HOME/lib32 ==> 32 bit
How do we check version of Oracle
How do we check version of Oracle on which we are working?
How do we check the version of the interface on which we are working?
6 Answers 6
select banner from v$version;
you can also use.
select version from PRODUCT_COMPONENT_VERSION where rownum = 1;
There are multiple ways, to list a few of them :
For serverside versions:
For client side versions, it depends on the client. i.e for python:
As a complement, if you are using an OCI-based client interface:
- OCIServerVersion will return the version string of the Oracle server
- OCIClientVersion will return the version string of your Oracle client
There are multiple ways to check the version in Oracle.
Oracle maintains version information in V$VERSION, PRODUCT_COMPONENT_VERSION data dictionary Views, or Metadata Table. Just run a query against these views to find out the database version.
Use dbms_utility.Db_version package to check oracle version
Not the answer you’re looking for? Browse other questions tagged sql oracle version or ask your own question.
Linked
Related
Hot Network Questions
Subscribe to RSS
To subscribe to this RSS feed, copy and paste this URL into your RSS reader.
site design / logo © 2021 Stack Exchange Inc; user contributions licensed under cc by-sa. rev 2021.4.16.39093
By clicking “Accept all cookies”, you agree Stack Exchange can store cookies on your device and disclose information in accordance with our Cookie Policy.
Check Oracle Version
1. If you just want to check the version information of the Oracle database, simply connect and login to the Oracle database with SQL *Plus. Upon login, you will see:
SQL*Plus: Release 9.2.0.6.0 – Production on Tue Oct 18 17:58:57 2005
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.6.0 – 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.6.0 – Production
The first italic number is the version of the SQL*Plus client and the second italic number is the version of Oracle database which you are connected to .
2. Retrieve the version information from v$version table by using SQL*Plus. In this table you can find version information on Oracle, PL/SQL, etc.
To retrieve the version information for Oracle, you execute the following SQL statement:
It should return something like this:
Banner
————————————————————————————–
Oracle9i Enterprise Edition Release 9.2.0.1.0 – 64bit Production
3. Version information can also be checked from Installed Products from the Oracle Universal Installer. It will tells you what products is installed on the machine and also its version information too.
In Unix, the installer is located at $ORACLE_HOME/bin/runInstaller.
In Windows, access the installer by Start -> All Programs -> Oracle Installed Products -> Universal Installer.
