探索Oracle之數據庫升級九12.1.0.1Update12.1.0.2

探索Oracle之數據庫升級九12.1.0.1Update12.1.0.2

一、檢查當前數據庫版本及系統信息

[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.