Friday, August 14, 2020
dbametrix
More
    Home Oracle Internals Oracle version number detail explaination

    Oracle version number detail explaination

    Oracle version number detail explaination:

    Hi friends,

    - Advertisement -
    dbametrix

    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

    - Advertisement -
    dbametrix

    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

    0
    - Advertisement -
    dbametrix
    - Advertisment -
    dbametrix

    Most Popular

    ORA-01940: Cannot drop a user that is currently connected

    Detail explanation and solution of ORA-01940: Cannot drop a user that is currently connected error.

    Ubuntu and Oracle SQL Developer

    Blog post explains how to install and use of Oracle SQL Developer on Ubuntu linux server

    Create Schema in Oracle 18c XE

    Article explain how to create new user in Oracle 18c XE and grant some system privileges with connect as new schema user in database.

    Oracle Autonomous JSON database

    The blog article explains about What is the Oracle autonomous JSON database, usage and how to get it from Oracle Cloud.

    Recent Comments

    Margareta Combes on nosql Security Vulnerabilities
    Gordon Coleclough on Oracle Tuning Basics Part-1
    Gordon Coleclough on ASM Disk creation issue