探索 Oracle 之資料庫升級（九）：12.1.0.1 升級至 12.1.0.2

探索 Oracle 之資料庫升級（九）：12.1.0.1 升級至 12.1.0.2

記錄 Oracle 12c 資料庫從 12.1.0.1 升級至 12.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/Linux

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

所有元件均為 VALID，RAC 選項關閉。此為升級前基準快照，後續將記錄 preupgrade 腳本執行、升級步驟與升級後驗證。