Oracle version number detail explaination

December 22, 2009 | By

Oracle version number detail explaination:

Hi friends,

How to check Oracle version from installed Oracle database RDBMS?

Using following queries we can check version of Oracle has been installed.

SQL>select * from v$version;
BANNER
—————————————————————-
Oracle Database 10g Express Edition Release 10.2.0.1.0 – Product
PL/SQL Release 10.2.0.1.0 – Production
CORE 10.2.0.1.0 Production
TNS for 32-bit Windows: Version 10.2.0.1.0 – Production
NLSRTL Version 10.2.0.1.0 – Production

SQL>select * from product_component_version;
PRODUCT VERSION STATUS
—————————————- ———— ———-
NLSRTL 10.2.0.1.0 Production
Oracle Database 10g Enterprise Edition 10.2.0.1.0 Prod
PL/SQL 10.2.0.1.0 Production
TNS for 32-bit Windows: 10.2.0.1.0 Production

Interpretation and understanding of Oracle version numbering:

First digit is Major database release number
Second digit is Database maintenance release number
Third digit is Application server release number
Fourth digit is Component specific release number
Fifth digit is Platform specific release number

For Example take output of above sample:
Oracle 10.2.0.1.0

Explained:

Oracle 10 <=Major database release number
.2 <=Database maintenance release number
.0 <=Application server release number
.1 <=Component specific release number
.0 <=Platform specific release number

Thanks and regards,
Rajiv Shah
http://www.dbametrix.com
http://www.dbametrix.com/remote-dba.html

Be Sociable, Share!

Tags: , , , , , , , , ,

Category: blog, blogging, DBA, howto, oracle internals

Comments are closed.