探索Oracle之資料庫升級九 12.1.0.1 Update 12.1.0.2
探索Oracle之資料庫升級九
12.1.0.1
Update 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/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.
二、刪除EM
-
[oracle@db01 ~]$ emctl stop dbconsole
-
SQL> @$ORACLE_HOME/rdbms/admin/emremove.sql
-
old 69: IF (upper('&LOGGING') = 'VERBOSE')
-
new 69: IF (upper('VERBOSE') = 'VERBOSE')
-
-
PL/SQL procedure successfully completed.
-
[oracle@db01 ~]$ rm –rf $ORACLE_HOME/$HOSTNAME
- [oracle@db01 ~]$ rm –rf $ORACLE_HOME/oc4j/j2ee/OC4J_DBConsole_*
三、備份資料庫
- RMAN> backup database plus archivelog delete input format '/DBBackup/Phycal/full_%U.bak';
- Starting backup at 02-DEC-14
- current log archived
- using channel ORA_DISK_1
- channel ORA_DISK_1: starting archived log backup set
- channel ORA_DISK_1: specifying archived log(s) in backup set
- input archived log thread=1 sequence=48 RECID=1 STAMP=865232107
- input archived log thread=1 sequence=49 RECID=2 STAMP=865232108
- input archived log thread=1 sequence=50 RECID=3 STAMP=865232110
- input archived log thread=1 sequence=51 RECID=4 STAMP=865232124
- input archived log thread=1 sequence=52 RECID=5 STAMP=865232126
- input archived log thread=1 sequence=53 RECID=6 STAMP=865232129
- input archived log thread=1 sequence=54 RECID=7 STAMP=865232130
- input archived log thread=1 sequence=55 RECID=8 STAMP=865232199
- input archived log thread=1 sequence=56 RECID=9 STAMP=865232199
- input archived log thread=1 sequence=57 RECID=10 STAMP=865232203
- input archived log thread=1 sequence=58 RECID=11 STAMP=865232203
- input archived log thread=1 sequence=59 RECID=12 STAMP=865232203
- input archived log thread=1 sequence=60 RECID=13 STAMP=865232203
- input archived log thread=1 sequence=61 RECID=14 STAMP=865232209
- input archived log thread=1 sequence=62 RECID=15 STAMP=865232380
- channel ORA_DISK_1: starting piece 1 at 02-DEC-14
- channel ORA_DISK_1: finished piece 1 at 02-DEC-14
- piece handle=/DBBackup/Phycal/full_05pp4pfs_1_1.bak tag=TAG20141202T061940 comment=NONE
- channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
- channel ORA_DISK_1: deleting archived log(s)
- archived log file name=/DBData/fast_recovery_area/WOO12C/archivelog/2014_12_02/o1_mf_1_48_b7st3cbs_.arc RECID=1 STAMP=865232107
- archived log file name=/DBData/fast_recovery_area/WOO12C/archivelog/2014_12_02/o1_mf_1_49_b7st3d69_.arc RECID=2 STAMP=865232108
- archived log file name=/DBData/fast_recovery_area/WOO12C/archivelog/2014_12_02/o1_mf_1_50_b7st3fwr_.arc RECID=3 STAMP=865232110
- archived log file name=/DBData/fast_recovery_area/WOO12C/archivelog/2014_12_02/o1_mf_1_51_b7st3wto_.arc RECID=4 STAMP=865232124
- archived log file name=/DBData/fast_recovery_area/WOO12C/archivelog/2014_12_02/o1_mf_1_52_b7st3ydw_.arc RECID=5 STAMP=865232126
- archived log file name=/DBData/fast_recovery_area/WOO12C/archivelog/2014_12_02/o1_mf_1_53_b7st41h9_.arc RECID=6 STAMP=865232129
- archived log file name=/DBData/fast_recovery_area/WOO12C/archivelog/2014_12_02/o1_mf_1_54_b7st428n_.arc RECID=7 STAMP=865232130
- archived log file name=/DBData/fast_recovery_area/WOO12C/archivelog/2014_12_02/o1_mf_1_55_b7st66z1_.arc RECID=8 STAMP=865232199
- archived log file name=/DBData/fast_recovery_area/WOO12C/archivelog/2014_12_02/o1_mf_1_56_b7st67ox_.arc RECID=9 STAMP=865232199
- archived log file name=/DBData/fast_recovery_area/WOO12C/archivelog/2014_12_02/o1_mf_1_57_b7st6c1b_.arc RECID=10 STAMP=865232203
- archived log file name=/DBData/fast_recovery_area/WOO12C/archivelog/2014_12_02/o1_mf_1_58_b7st6c22_.arc RECID=11 STAMP=865232203
- archived log file name=/DBData/fast_recovery_area/WOO12C/archivelog/2014_12_02/o1_mf_1_59_b7st6c6y_.arc RECID=12 STAMP=865232203
- archived log file name=/DBData/fast_recovery_area/WOO12C/archivelog/2014_12_02/o1_mf_1_60_b7st6c7o_.arc RECID=13 STAMP=865232203
- archived log file name=/DBData/fast_recovery_area/WOO12C/archivelog/2014_12_02/o1_mf_1_61_b7st6kq8_.arc RECID=14 STAMP=865232209
- archived log file name=/DBData/fast_recovery_area/WOO12C/archivelog/2014_12_02/o1_mf_1_62_b7stcwmv_.arc RECID=15 STAMP=865232380
- Finished backup at 02-DEC-14
- Starting backup at 02-DEC-14
- using channel ORA_DISK_1
- channel ORA_DISK_1: starting full datafile backup set
- channel ORA_DISK_1: specifying datafile(s) in backup set
- input datafile file number=00004 name=/DBData/WOO12C/datafile/o1_mf_undotbs1_b7gh653v_.dbf
- input datafile file number=00001 name=/DBData/WOO12C/datafile/o1_mf_system_b7gh4dtv_.dbf
- input datafile file number=00003 name=/DBData/WOO12C/datafile/o1_mf_sysaux_b7gh21p2_.dbf
- input datafile file number=00006 name=/DBData/WOO12C/datafile/o1_mf_users_b7gh6409_.dbf
- channel ORA_DISK_1: starting piece 1 at 02-DEC-14
- channel ORA_DISK_1: finished piece 1 at 02-DEC-14
- piece handle=/DBData/fast_recovery_area/WOO12C/backupset/2014_12_02/o1_mf_nnndf_TAG20141202T061942_b7stcyyx_.bkp tag=TAG20141202T061942 comment=NONE
- channel ORA_DISK_1: backup set complete, elapsed time: 00:01:36
- channel ORA_DISK_1: starting full datafile backup set
- channel ORA_DISK_1: specifying datafile(s) in backup set
- input datafile file number=00014 name=/DBData/WOO12C/0847D2A3397B02B0E0533307A8C077E9/datafile/o1_mf_sysaux_b7gknfyd_.dbf
- input datafile file number=00013 name=/DBData/WOO12C/0847D2A3397B02B0E0533307A8C077E9/datafile/o1_mf_system_b7gknfmp_.dbf
- input datafile file number=00015 name=/DBData/WOO12C/0847D2A3397B02B0E0533307A8C077E9/datafile/o1_mf_users_b7gkngh6_.dbf
- channel ORA_DISK_1: starting piece 1 at 02-DEC-14
- channel ORA_DISK_1: finished piece 1 at 02-DEC-14
- piece handle=/DBData/fast_recovery_area/WOO12C/0847D2A3397B02B0E0533307A8C077E9/backupset/2014_12_02/o1_mf_nnndf_TAG20141202T061942_b7stgzdo_.bkp tag=TAG20141202T061942 comment=NONE
- channel ORA_DISK_1: backup set complete, elapsed time: 00:01:55
- channel ORA_DISK_1: starting full datafile backup set
- channel ORA_DISK_1: specifying datafile(s) in backup set
- input datafile file number=00009 name=/DBData/WOO12C/08D98EA3271835F9E0533307A8C068EE/datafile/o1_mf_sysaux_b7ghrvm2_.dbf
- input datafile file number=00008 name=/DBData/WOO12C/08D98EA3271835F9E0533307A8C068EE/datafile/o1_mf_system_b7ghrvnw_.dbf
- input datafile file number=00010 name=/DBData/WOO12C/08D98EA3271835F9E0533307A8C068EE/datafile/o1_mf_users_b7ght9rv_.dbf
- channel ORA_DISK_1: starting piece 1 at 02-DEC-14
- channel ORA_DISK_1: finished piece 1 at 02-DEC-14
- piece handle=/DBData/fast_recovery_area/WOO12C/08D98EA3271835F9E0533307A8C068EE/backupset/2014_12_02/o1_mf_nnndf_TAG20141202T061942_b7stlll8_.bkp tag=TAG20141202T061942 comment=NONE
- channel ORA_DISK_1: backup set complete, elapsed time: 00:00:55
- channel ORA_DISK_1: starting full datafile backup set
- channel ORA_DISK_1: specifying datafile(s) in backup set
- input datafile file number=00007 name=/DBData/WOO12C/datafile/o1_mf_sysaux_b7gh7gjq_.dbf
- input datafile file number=00005 name=/DBData/WOO12C/datafile/o1_mf_system_b7gh7gkl_.dbf
- channel ORA_DISK_1: starting piece 1 at 02-DEC-14
- channel ORA_DISK_1: finished piece 1 at 02-DEC-14
- piece handle=/DBData/fast_recovery_area/WOO12C/08D970F59616336FE0533307A8C03C35/backupset/2014_12_02/o1_mf_nnndf_TAG20141202T061942_b7stn9ly_.bkp tag=TAG20141202T061942 comment=NONE
- channel ORA_DISK_1: backup set complete, elapsed time: 00:01:05
- Finished backup at 02-DEC-14
- Starting backup at 02-DEC-14
- current log archived
- using channel ORA_DISK_1
- channel ORA_DISK_1: starting archived log backup set
- channel ORA_DISK_1: specifying archived log(s) in backup set
- input archived log thread=1 sequence=63 RECID=16 STAMP=865232715
- channel ORA_DISK_1: starting piece 1 at 02-DEC-14
- channel ORA_DISK_1: finished piece 1 at 02-DEC-14
- piece handle=/DBBackup/Phycal/full_0app4pqb_1_1.bak tag=TAG20141202T062515 comment=NONE
- channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
- channel ORA_DISK_1: deleting archived log(s)
- archived log file name=/DBData/fast_recovery_area/WOO12C/archivelog/2014_12_02/o1_mf_1_63_b7stpbxz_.arc RECID=16 STAMP=865232715
- Finished backup at 02-DEC-14
- Starting Control File and SPFILE Autobackup at 02-DEC-14
- piece handle=/DBData/fast_recovery_area/WOO12C/autobackup/2014_12_02/o1_mf_s_865232716_b7stpfto_.bkp comment=NONE
- Finished Control File and SPFILE Autobackup at 02-DEC-14
- [oracle@db01 ~]$ ll p17694377_121020*
- -rw-r--r-- 1 oracle oinstall 1673517582 Dec 2 05:38 p17694377_121020_Linux-x86-64_1of8.zip
- -rw-r--r-- 1 oracle oinstall 1014527110 Nov 28 02:44 p17694377_121020_Linux-x86-64_2of8.zip
- [oracle@db01 ~]$ unzip p17694377_121020_Linux-x86-64_1of8.zip
- [oracle@db01 ~]$ unzip p17694377_121020_Linux-x86-64_2of8.zip
五、建立使用者安裝12.1.0.2的軟體目錄
-
[oracle@db01 ~]$ cd /DBSoft/Product/
-
[oracle@db01 Product]$ ls
-
12.1.0
-
[oracle@db01 Product]$ mkdir -p 12.1.0.2/db_1
-
[oracle@db01 Product]$ ll
-
total 8
-
drwxr-xr-x 3 oracle oinstall 4096 Nov 20 05:39 12.1.0
- drwxr-xr-x 3 oracle oinstall 4096 Dec 2 07:57 12.1.0.2
六、開始安裝:
6.1 進入解壓後的安裝包執行./runInstall開始新版本的資料庫安裝
6.2 點選Next進入下一步
6.3 選擇Upgrade an existing database 升級選項,點選Next進入下一步
6.4 選中所有語言,點選Next進入下一步
6.5 點選Next進入下一步
6.6 指定新建立的Oracle 12.1.0.2安裝目錄,環境配置沒有問題的花,會自動選擇,點選Next進入下一步
6.7 制定Oracle使用者組,點選Next進入下一步
6.8 檢查所有元件,我們看到是沒有問題的,點選Next進入下一步
6.9 summary,看下沒有問題就點選Install開始安裝了
6.10 正在安裝軟體的過程
6.11 提示執行root.sh指令碼
七、軟體安裝完成之後執行root.sh指令碼
-
[root@db01 ~]# /DBSoft/Product/12.1.0.2/db_1/root.sh
Performing root user operation.
The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /DBSoft/Product/12.1.0.2/db_1
Enter the full pathname of the local bin directory: [/usr/local/bin]:
The contents of "dbhome" have not changed. No need to overwrite.
The file "oraenv" already exists in /usr/local/bin. Overwrite it? (y/n)
[n]: y
Copying oraenv to /usr/local/bin ...
The contents of "coraenv" have not changed. No need to overwrite.
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
[root@db01 ~]#
6.13 配置監聽名稱,點選Next進入下一步
6.14 選擇監聽所用的協議,通常TCP 就可以了,點選Next下一步
6.15 選擇預設的埠號,點選Next下一步即可
6.16 選擇No不配置其它監聽,點選Next進入下一步
6.17 點選Next進入下一步
6.18 選擇No,點選Next進入下一步
6.19 點選Finish完成監聽的配置
6.20 隨即彈出升級資料庫頁面,點選第一個選項Upgrade Oracle Database,點選Next進入下一步
6.21 選擇需要升級的資料庫,點選Next進入下一步
6.23 列出Pluggable資料庫,確認後點選Next進入下一步
6.24 升級前的檢查,點選Next進入下一步即可
6.25 配置升級選項,配置好後點選Next進入下一步即可
6.26 選擇EM所用的埠,點選Next進入下一步
6.27 點選該頁面不用做任何選擇,點選Next進入下一步
6.28 選擇資料庫監聽,點選Next進入下一步
6.29 升級執行前時候進行RMAN備份,選擇備份後點選Next進入下一步
6.30 檢查需要升級的資料庫資訊,沒有問題點選Finish開始進行升級操作
6.31 正在開始進行升級操作,等待過程約4個小時左右
6.32 至此已經升級完成,點選Cancel關閉升級視窗
八、至此升級安裝已經完成。
九、完成之後檢查資料庫版本:
-
SQL> set line 300
-
SQL> set pagesize 1000
-
SQL> r
-
1* select * from v$version
-
-
BANNER CON_ID
-
-------------------------------------------------------------------------------- ----------
-
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production 0
-
PL/SQL Release 12.1.0.2.0 - Production 0
-
CORE 12.1.0.2.0 Production 0
-
TNS for Linux: Version 12.1.0.2.0 - Production 0
- NLSRTL Version 12.1.0.2.0 - Production 0
十、檢查各元件版本:
-
SQL> select comp_name,version,control,status from dba_server_registry;
-
-
COMP_NAME VERSION CONTROL STATUS
-
---------------------------------------- ------------- -------- ---------------
-
Oracle Database Vault 12.1.0.2.0 SYS VALID
-
Oracle Application Express 4.2.5.00.08 SYS VALID
-
Oracle Label Security 12.1.0.2.0 SYS VALID
-
Spatial 12.1.0.2.0 SYS VALID
-
Oracle Multimedia 12.1.0.2.0 SYS VALID
-
Oracle Text 12.1.0.2.0 SYS VALID
-
Oracle Workspace Manager 12.1.0.2.0 SYS VALID
-
Oracle XML Database 12.1.0.2.0 SYS VALID
-
Oracle Database Catalog Views 12.1.0.2.0 SYS VALID
-
Oracle Database Packages and Types 12.1.0.2.0 SYS VALID
-
JServer JAVA Virtual Machine 12.1.0.2.0 SYS VALID
-
Oracle XDK 12.1.0.2.0 SYS VALID
-
Oracle Database Java Packages 12.1.0.2.0 SYS VALID
-
OLAP Analytic Workspace 12.1.0.2.0 SYS VALID
-
Oracle OLAP API 12.1.0.2.0 SYS VALID
-
Oracle Real Application Clusters 12.1.0.2.0 SYS OPTION OFF
-
- 16 rows selected.
-
SQL> select owner, object_name, object_type, status from dba_objects where status=\'INVALID\' order by 1, 2,3;
-
-
no rows selected
-
- SQL>
十一、open 所有PDBs,並檢視PDBs狀態
-
SQL> show pdbs
-
-
CON_ID CON_NAME OPEN MODE RESTRICTED
-
---------- ------------------------------ ---------- ----------
-
2 PDB$SEED READ ONLY NO
-
3 PDB01 MOUNTED
-
4 WOO_ORA11G MOUNTED
-
SQL> alter pluggable database all open;
-
-
Pluggable database altered.
-
-
SQL> show pdbs;
-
-
CON_ID CON_NAME OPEN MODE RESTRICTED
-
---------- ------------------------------ ---------- ----------
-
2 PDB$SEED READ ONLY NO
-
3 PDB01 READ WRITE NO
- 4 WOO_ORA11G READ WRITE NO
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/20674423/viewspace-1379944/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 探索Oracle之資料庫升級十 12c(12.1.0.2) CPU 19774304Oracle資料庫
- 探索Oracle之資料庫升級一 升級補丁修復概述Oracle資料庫
- 探索Oracle之資料庫升級二 11.2.0.3升級到11.2.0.4完整步驟Oracle資料庫
- 探索Oracle之資料庫升級四 11.2.0.4.0 PSU 11.2.0.4.3Oracle資料庫
- 探索Oracle之資料庫升級三 回退升級操作(11.2.0.4Downgrade 11.2.0.3)Oracle資料庫
- 探索Oracle之資料庫升級五 PSU 11.2.0.4.3 rollback 11.2.0.4.0Oracle資料庫
- 探索Oracle之資料庫升級七 11gR2 to 12c 升級完成後插入PDBOracle資料庫
- Oracle 資料庫升級Oracle資料庫
- 探索Oracle之資料庫升級八 12c Downgrade 11gR2Oracle資料庫
- 探索Oracle之資料庫升級六 11.2.0.4.3 Upgrade12c(12.2.0.1)Oracle資料庫
- 資料庫升級之-XTTS資料庫TTS
- 資料庫升級之-Dataguard滾動升級資料庫
- 資料庫升級之-資料泵資料庫
- Oracle資料庫升級(轉發)Oracle資料庫
- Oracle 資料庫 升級為 RACOracle資料庫
- rac 升級crs 升級資料庫軟體,升級資料庫資料庫
- oracle資料庫升級11.2.0.3升級到11.2.0.4Oracle資料庫
- Oracle資料庫升級與補丁Oracle資料庫
- Oracle 資料庫升級注意事項Oracle資料庫
- 靜默方式安裝、升級oracle(三): 升級資料庫軟體及資料庫Oracle資料庫
- android資料庫如何進行版本升級?架構之資料庫框架升級Android資料庫架構框架
- Oracle 12c系列(九) | 通過unplug與plug方式升級pdb資料庫Oracle資料庫
- 資料庫升級資料庫
- ♀♀資料庫升級♀♀資料庫
- (轉)資料庫oracle for update of和for update區別資料庫Oracle
- 單機升級11.2.0.1到12.1.0.2的實戰_11.2.0.1不能直接升級到到12.1.0.2
- ORACLE資料庫升級詳細步驟Oracle資料庫
- RAC 資料庫升級 10.2.0.1.0 到 10.2.0.2.0 之升級catalog資料庫
- Oracle 12c資料庫升級實戰Oracle資料庫
- oracle資料庫11.2.0.3升級到11.2.0.4Oracle資料庫
- ZT 升級和移植Oracle資料庫方法若干Oracle資料庫
- 資料庫升級和工具資料庫
- 資料庫升級報錯資料庫
- Oracle資料庫異機升級(10.2.0.5 --> 11.2.0.4)Oracle資料庫
- oracle 資料庫從10.2.0.4升級到11.2.0.3Oracle資料庫
- Oracle資料庫升級前必要的準備工作Oracle資料庫
- Oracle資料庫升級或資料遷移的方法探討Oracle資料庫
- 生產庫升級:oracle 9.2.0.1升級oracle 9.2.0.8Oracle