查看oracle基本版本資訊____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                integercluster_database_instances           integer     1instance_groups                      stringinstance_name                        string      TestDB11instance_number                      integer     0instance_type                        string      RDBMSopen_links_per_instance              integer     4parallel_instance_group              stringparallel_server_instances            integer     1sys@TESTDB11>select * from v$version;  BANNER--------------------------------------------------------------------------------Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - ProductionPL/SQL Release 11.2.0.3.0 - ProductionCORE    11.2.0.3.0      ProductionTNS for Linux: Version 11.2.0.3.0 - ProductionNLSRTL Version 11.2.0.3.0 - Productionsys@TESTDB11>select * from product_component_version;PRODUCT----------------------------------------------------------------------------------------------------------------------------------------------------------------VERSION----------------------------------------------------------------------------------------------------------------------------------------------------------------STATUS----------------------------------------------------------------------------------------------------------------------------------------------------------------NLSRTL11.2.0.3.0ProductionOracle Database 11g Enterprise Edition11.2.0.3.0ProductionPL/SQL11.2.0.3.0ProductionTNS for Linux:11.2.0.3.0Productionsys@TESTDB11>select  COMP_NAME, VERSION from dba_server_registry;COMP_NAME----------------------------------------------------------------------------------------------------------------------------------------------------------------VERSION------------------------------OWB11.2.0.3.0Oracle Application Express3.2.1.00.12Oracle Enterprise Manager11.2.0.3.0OLAP Catalog11.2.0.3.0Spatial11.2.0.3.0Oracle Multimedia11.2.0.3.0Oracle XML Database11.2.0.3.0Oracle Text11.2.0.3.0Oracle Expression Filter11.2.0.3.0Oracle Rules Manager11.2.0.3.0Oracle Workspace Manager11.2.0.3.0Oracle Database Catalog Views11.2.0.3.0Oracle Database Packages and Types11.2.0.3.0JServer JAVA Virtual Machine11.2.0.3.0Oracle XDK11.2.0.3.0Oracle Database Java Packages11.2.0.3.0OLAP Analytic Workspace11.2.0.3.0Oracle OLAP API11.2.0.3.018 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                          SERVER11.2.0.3                                0 PSUPatchset 11.2.0.2.008-AUG-14 01.42.26.475321 AM                                                APPLY                          SERVER11.2.0.3                                0 PSUPatchset 11.2.0.2.0sys@TESTDB11>select * from product_component_version;PRODUCT----------------------------------------------------------------------------------------------------------------------------------------------------------------VERSION----------------------------------------------------------------------------------------------------------------------------------------------------------------STATUS----------------------------------------------------------------------------------------------------------------------------------------------------------------NLSRTL11.2.0.3.0ProductionOracle Database 11g Enterprise Edition11.2.0.3.0ProductionPL/SQL11.2.0.3.0ProductionTNS for Linux:11.2.0.3.0Productionsys@TESTDB11>select INSTANCE_NUMBER,INSTANCE_NAME,HOST_NAME, VERSION from v$instance;INSTANCE_NUMBER INSTANCE_NAME    HOST_NAME                                                        VERSION--------------- ---------------- ---------------------------------------------------------------- -----------------              1 TestDB11         OL54.cuug.net