查看库名和实例名
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
查看oracle基本版本信息
最新推荐文章于 2022-08-20 22:32:21 发布