View the library name and instance name show parameter instance name;
Show parameter db name;
View version 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_grou PS 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 producti On TNS for linux:version 11.2.0.3.0-production nlsrtl Version 11.2.0.3.0-production sys@testdb11>select * from PR
Oduct_component_version; PRODUCT-------------------------------------------------------------------------------------------------------- --------------------------------------------------------VERSION------------------------------------------------ --------------------------------------------------------------------------------------------------------------- -STATUS-------------------------------------------------------------------------------------------------------- --------------------------------------------------------nlsrtl 11.2.0.3.0 Production Oracle Database 11g Enterprise
Edition 11.2.0.3.0 Production Pl/sql11.2.0.3.0 Production TNS for linux:11.2.0.3.0 Production sys@testdb11>select comp_name, VERSION from Dba_server_reg
Istry; 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 D Atabase 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 JAV
A Packages 11.2.0.3.0 OLAP analytic Workspace 11.2.0.3.0 Oracle OLAP API 11.2.0.3.0 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,i
Nstance_name,host_name, VERSION from V$instance; Instance_number instance_name host_name VERSION--------------- -------------------------------------------------------------------------------------------------1 TestDB One OL54. cuug.net