一、檢查當前數據庫版本及系統信息
[oracle@db01 ~]$ lsb_release -a LSB Version: :core-4.0-amd64:core-4.0-ia32:core-4.0-noarch:graphics-4.0-amd64:graphics-4.0-ia32:graphics-4.0-noarch:printing-4.0-amd64:printing-4.0-ia32:printing-4.0-noarch Distributor ID: RedHatEnterpriseServer Description: Red Hat Enterprise Linux Server release 5.8 (Tikanga) Release: 5.8 Codename: Tikanga [oracle@db01 ~]$ uname -a Linux db01 2.6.18-308.el5 #1 SMP Fri Jan 27 17:17:51 EST 2012 x86_64 x86_64 x86_64 GNU/Li [oracle@db01 DBData]$ df -h Filesystem Size Used Avail Use% Mounted on /dev/mapper/VolGroup00-LogVol00 53G 26G 24G 52% / /dev/sda1 99M 13M 82M 14% /boot tmpfs 4.0G 1.1G 3.0G 26% /dev/shm SQL> select * from v$version; BANNER CON_ID -------------------------------------------------------------------------------- ---------- Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production 0 PL/SQL Release 12.1.0.1.0 - Production 0 CORE 12.1.0.1.0 Production 0 TNS for Linux: Version 12.1.0.1.0 - Production 0 NLSRTL Version 12.1.0.1.0 - Production 0 SQL> col comp_name format a40 SQL> col version format a13 SQL> col control format a8 SQL> col status format a15 SQL> set line 300 SQL> set pagesize 800 SQL> select comp_name,version,control,status from dba_server_registry; COMP_NAME VERSION CONTROL STATUS ---------------------------------------- ------------- -------- --------------- Oracle Database Vault 12.1.0.1.0 SYS VALID Oracle Application Express 4.2.0.00.27 SYS VALID Oracle Label Security 12.1.0.1.0 SYS VALID Spatial 12.1.0.1.0 SYS VALID Oracle Multimedia 12.1.0.1.0 SYS VALID Oracle Text 12.1.0.1.0 SYS VALID Oracle Workspace Manager 12.1.0.1.0 SYS VALID Oracle XML Database 12.1.0.1.0 SYS VALID Oracle Database Catalog Views 12.1.0.1.0 SYS VALID Oracle Database Packages and Types 12.1.0.1.0 SYS VALID JServer JAVA Virtual Machine 12.1.0.1.0 SYS VALID Oracle XDK 12.1.0.1.0 SYS VALID Oracle Database Java Packages 12.1.0.1.0 SYS VALID OLAP Analytic Workspace 12.1.0.1.0 SYS VALID Oracle OLAP API 12.1.0.1.0 SYS VALID Oracle Real Application Clusters 12.1.0.1.0 SYS OPTION OFF 16 rows selected.