How to determine the version of Oracle client and server software

Procedure Steps

There are several methods for checking the Oracle client version and the Oracle server version:

Method 1:

Open a command prompt.
Type SQLPLUS lenel/MULTIMEDIA@lenel.

The following is shown:


C:\Documents and Settings\atal1>sqlplus lenel/MULTIMEDIA@bamba
 
SQL*Plus: Release 11.1.0.7.0 - Production on Tue Jul 13 09:41:55 2010
 
Copyright (c) 1982, 2008, Oracle. All rights reserved.
 
 
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options

The first bold number is the version of the SQL*Plus client (in this example, the client version is 11.1.0.7.) and the second bold number is the version of Oracle database to which you are connected (the database version in this example is 10.2.0.3).

Method 2:

Another option is to type SELECT * from v$version; at the command prompt. This will return the database version for the database to which you are connected.


 
SQL> select * from v$version
 2 /
 
BANNER


Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Prod
PL/SQL Release 10.2.0.3.0 - Production
CORE    10.2.0.3.0      Production
TNS for 32-bit Windows: Version 10.2.0.3.0 - Production
NLSRTL Version 10.2.0.3.0 – Production

Method 3:

If you cannot connect to Oracle, you can always run the Oracle installer and click [Installed Product]. This will tell you what products are installed on the machine and the version information.

Applies To

Oracle (All versions)

OnGuard (All versions)

Additional Information

None

How to determine the version of Oracle client and server software

Procedure Steps

Applies To

Additional Information

Related Articles