Academic and Career Talks

Talk about Academic Life and Career

Codes and Scripts

Articles with Code Snippets, programming, source codes, and useful scripts for development

Computers, Gadgets and Mobile Reviews

Gadget and Mobile Reviews

IBM DB2, Lotus Notes, Cognos

IBM, DB2, Lotus Notes, Cognos

Wordpress, Blogging and Useful Stuffs

Wordpress, Blogging and Useful Stuffs

Home » Codes and Scripts, Computer Tips & Tricks, Database Administration

Tip for the Day: Checking Oracle DB Version

Submitted by on Tuesday, 15 July 2008No Comment

oralogo_smallI know a lot of developers/programmers know this tip already but for my personal reference i want to document this so that if i forgot i can refer this for future use. For those who are new to Oracle 10g or 11g Administration then this tip is for you. There are several ways where you can query or retrieve the version number of installed Oracle products:   

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 – Production on Tue Jul 15 10:08:32 2008

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Connected to:
Oracle9i Enterprise Edition Release – 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 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:

select * from v$version;

It should return something like this:

Oracle Database 10g Enterprise Edition Release – 64bi
PL/SQL Release – Production
CORE      Production
TNS for IBM/AIX RISC System/6000: Version – Productio
NLSRTL Version – 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. I have various versions on my machine as this is

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.

By the way, i am using Windows Vista Ultimate version in my PC. Oracle 9i is not compatible with Windows Vista so you have to install Oracle 10g Release 2. Look for the free download in the Oracle Website =)

 For more information, feel free to browse over the Techronnati boards

   [hungryfeed url=”” feed_fields=”” item_fields=”title,description,content,author,date” link_target=”_blank”]


For more information, feel free to browse over the Techronnati boards


Thank you for visiting I hope you enjoy your stay. =)
Close Box