查看oracle基本版本信息

查看库名和实例名
show parameter instance name;
show parameter db name;

查看版本
select INSTANCE_NUMBER,INSTANCE_NAME,HOST_NAME,VERSION from v$instance;
select * from product_component_version;
select * from v$version;
select  COMP_NAME, VERSION from dba_server_registry;
select * from dba_registry_history;
select * from product_component_version;


sys@TESTDB11>show parameter instance name;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
active_instance_count                integer
cluster_database_instances           integer     1
instance_groups                      string
instance_name                        string      TestDB11
instance_number                      integer     0
instance_type                        string      RDBMS
open_links_per_instance              integer     4
parallel_instance_group              string
parallel_server_instances            integer     1


sys@TESTDB11>select * from v$version;  

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

sys@TESTDB11>select * from product_component_version;

PRODUCT
----------------------------------------------------------------------------------------------------------------------------------------------------------------
VERSION
----------------------------------------------------------------------------------------------------------------------------------------------------------------
STATUS
----------------------------------------------------------------------------------------------------------------------------------------------------------------
NLSRTL
11.2.0.3.0
Production

Oracle Database 11g Enterprise Edition
11.2.0.3.0
Production

PL/SQL
11.2.0.3.0
Production

TNS for Linux:
11.2.0.3.0
Production
sys@TESTDB11>select  COMP_NAME, VERSION from dba_server_registry;

COMP_NAME
----------------------------------------------------------------------------------------------------------------------------------------------------------------
VERSION
------------------------------
OWB
11.2.0.3.0

Oracle Application Express
3.2.1.00.12

Oracle Enterprise Manager
11.2.0.3.0

OLAP Catalog
11.2.0.3.0

Spatial
11.2.0.3.0

Oracle Multimedia
11.2.0.3.0

Oracle XML Database
11.2.0.3.0

Oracle Text
11.2.0.3.0

Oracle Expression Filter
11.2.0.3.0

Oracle Rules Manager
11.2.0.3.0

Oracle Workspace Manager
11.2.0.3.0

Oracle Database Catalog Views
11.2.0.3.0

Oracle Database Packages and Types
11.2.0.3.0

JServer JAVA Virtual Machine
11.2.0.3.0

Oracle XDK
11.2.0.3.0

Oracle Database Java Packages
11.2.0.3.0

OLAP Analytic Workspace
11.2.0.3.0

Oracle OLAP API
11.2.0.3.0


18 rows selected.

sys@TESTDB11>select * from dba_registry_history;

ACTION_TIME                                                                 ACTION                         NAMESPACE
--------------------------------------------------------------------------- ------------------------------ ------------------------------
VERSION                                ID BUNDLE_SERIES
------------------------------ ---------- ------------------------------
COMMENTS
----------------------------------------------------------------------------------------------------------------------------------------------------------------
18-SEP-11 06.02.59.465921 PM                                                APPLY                          SERVER
11.2.0.3                                0 PSU
Patchset 11.2.0.2.0

08-AUG-14 01.42.26.475321 AM                                                APPLY                          SERVER
11.2.0.3                                0 PSU
Patchset 11.2.0.2.0






sys@TESTDB11>select * from product_component_version;

PRODUCT
----------------------------------------------------------------------------------------------------------------------------------------------------------------
VERSION
----------------------------------------------------------------------------------------------------------------------------------------------------------------
STATUS
----------------------------------------------------------------------------------------------------------------------------------------------------------------
NLSRTL
11.2.0.3.0
Production

Oracle Database 11g Enterprise Edition
11.2.0.3.0
Production

PL/SQL
11.2.0.3.0
Production

TNS for Linux:
11.2.0.3.0
Production



sys@TESTDB11>select INSTANCE_NUMBER,INSTANCE_NAME,HOST_NAME, VERSION from v$instance;

INSTANCE_NUMBER INSTANCE_NAME    HOST_NAME                                                        VERSION
--------------- ---------------- ---------------------------------------------------------------- -----------------
              1 TestDB11         OL54.cuug.net