Experience: is what you get soon after you need it.

Experience: is what you get soon after you need it.

****************Got the opportunity to pen a Book on Database Cloud Services.......More details to follow.***************

Title : Database Cloud Revealed
Publisher : Apress
Release Date : Jan-2021


My Cloud Certifications:

AWS Certified Solutions Architect Associate

Azure Certified Architect Expert

Azure Certified Architect

Azure Certified Administrator

Oracle Cloud Infrastructure 2018 Certified Architect Associate.

Oracle Cloud Infrastructure Classic 2018 Certified Architect Associate.

Oracle Database Cloud Administrator Certified Professional.

Oracle Database Cloud Service Operations Certified Associate.

Search This Blog

Thursday, August 20, 2015

Find Oracle database version

How to find which version of Oracle version is installed?

SQL> col product for a40
SQL> col version for a10
SQL> col status for a15

SQL> select * from product_component_version;

PRODUCT                  VERSION                                              STATUS
----------------------------------------                                   ---------- ---------------
NLSRTL                                                                   Production
Oracle Database 11g Enterprise Edition 64bit               Production
PL/SQL                                                                     Production
TNS for Linux:                                                          Production


SQL> select * from v$version;

Oracle Database 11g Enterprise Edition Release - 64bit Production
PL/SQL Release - Production
CORE    Production
TNS for Linux: Version - Production
NLSRTL Version - Production


SQL> select comp_id,version,comp_name,status from dba_registry;

COMP_ID                VERSION      COMP_NAME                   STATUS
------------------------------ ---------- ---------------------------------------- ---------------
OWB          OWB                                               VALID
APEX          Oracle Application Express           VALID
EM          Oracle Enterprise Manager                        VALID
AMD          OLAP Catalog                                   VALID
SDO          Spatial                                                 VALID
ORDIM          Oracle Multimedia                          VALID
XDB          Oracle XML Database                           VALID
CONTEXT       Oracle Text                                     VALID
EXF          Oracle Expression Filter                          VALID
RUL          Oracle Rules Manager                              VALID
OWM          Oracle Workspace Manager                     VALID
CATALOG       Oracle Database Catalog Views        VALID
CATPROC       Oracle Database Packages and Types       VALID
JAVAVM          JServer JAVA Virtual Machine           VALID
XML          Oracle XDK                                            VALID
CATJAVA       Oracle Database Java Packages        VALID
APS          OLAP Analytic Workspace                       VALID
XOQ          Oracle OLAP API                                    VALID

18 rows selected.




There could be many more ways you could find this info...

No comments: