Oracle version info and option info

Oracle version info .. 
col comp_name format a40
select comp_name, status, version from dba_registry;

COMP_NAME                                STATUS                                       VERSION
---------------------------------------- -------------------------------------------- ------------------------------
Oracle Database Catalog Views            VALID                                        12.2.0.1.0
Oracle Database Packages and Types       VALID                                        12.2.0.1.0
Oracle XML Database                      VALID                                        12.2.0.1.0



set pagesize 200
select parameter, value from v$option;

PARAMETER                                                        VALUE
---------------------------------------------------------------- ----------------------------------------------------------------
Partitioning                                                     TRUE
Objects                                                          TRUE
Real Application Clusters                                        FALSE
Advanced replication                                             TRUE
Bit-mapped indexes                                               TRUE
Connection multiplexing                                          TRUE
Connection pooling                                               TRUE
Database queuing                                                 TRUE
Incremental backup and recovery                                  TRUE
Instead-of triggers                                              TRUE
Parallel backup and recovery                                     TRUE


col PRODUCT format a50
col VERSION format a20
select product, version from product_component_version ;

PRODUCT                                            VERSION
-------------------------------------------------- --------------------
NLSRTL                                             12.2.0.1.0
Oracle Database 12c Enterprise Edition             12.2.0.1.0
PL/SQL                                             12.2.0.1.0
TNS for Linux:                                     12.2.0.1.0


select * from v$version ;

BANNER                                                                               CON_ID
-------------------------------------------------------------------------------- ----------
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production              0
PL/SQL Release 12.2.0.1.0 - Production                                                    0
CORE    12.2.0.1.0      Production                                                                0
TNS for Linux: Version 12.2.0.1.0 - Production                                            0
NLSRTL Version 12.2.0.1.0 - Production                                                    0

 SELECT version FROM v$instance;

VERSION
--------------------
12.2.0.1.0

$ORACLE_HOME/OPatch/opatch lsinventory | awk '/^Oracle Database/ {print $NF}'
12.2.0.1.0

SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
[oracle@cloud-ora ~]$ $ORACLE_HOME/OPatch/opatch lsinventory | awk '/^Oracle Database/ {print $NF}'
12.2.0.1.0
[oracle@cloud-ora ~]$ $ORACLE_HOME/OPatch/opatch lsinventory
Oracle Interim Patch Installer version 12.2.0.1.6
Copyright (c) 2017, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/oracle/product/12.1.0/db_2
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/12.1.0/db_2/oraInst.loc
OPatch version    : 12.2.0.1.6
OUI version       : 12.2.0.1.4
Log file location : /u01/app/oracle/product/12.1.0/db_2/cfgtoollogs/opatch/opatch2017-09-24_03-56-50AM_1.log

Lsinventory Output file location : /u01/app/oracle/product/12.1.0/db_2/cfgtoollogs/opatch/lsinv/lsinventory2017-09-24_03-56-50AM.txt

--------------------------------------------------------------------------------
Local Machine Information::
Hostname: cloud-ora
ARU platform id: 226
ARU platform description:: Linux x86-64

Installed Top-level Products (1):

Oracle Database 12c                                                  12.2.0.1.0
There are 1 products installed in this Oracle Home.


There are no Interim patches installed in this Oracle Home.


--------------------------------------------------------------------------------