View Oracle Basic version Information ____oracle

Source: Internet
Author: User
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     
Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.