探索Oracle之資料庫升級九 12.1.0.1 Update 12.1.0.2

dbhelper發表於2015-01-17
原文網址 : http://blog.itpub.net/8494287/viewspace-1405556/
Oracle資料庫

探索Oracle之資料庫升級九

12.1.0.1 Update 12.1.0.2

一、檢查當前資料庫版本及系統資訊

  1. [oracle@db01 ~]$ lsb_release -a
  2. 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
  3. Distributor ID: RedHatEnterpriseServer
  4. Description: Red Hat Enterprise Linux Server release 5.8 (Tikanga)
  5. Release: 5.8
  6. Codename: Tikanga
  7. [oracle@db01 ~]$ uname -a
  8. 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

  10. [oracle@db01 DBData]$ df -h
  11. Filesystem Size Used Avail Use% Mounted on
  12. /dev/mapper/VolGroup00-LogVol00
  13.                        53G 26G 24G 52% /
  14. /dev/sda1 99M 13M 82M 14% /boot
  15. tmpfs 4.0G 1.1G 3.0G 26% /dev/shm

  17. SQL> select * from v$version;

  19. BANNER CON_ID
  20. -------------------------------------------------------------------------------- ----------
  21. Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production 0
  22. PL/SQL Release 12.1.0.1.0 - Production 0
  23. CORE 12.1.0.1.0 Production 0
  24. TNS for Linux: Version 12.1.0.1.0 - Production 0
  25. NLSRTL Version 12.1.0.1.0 - Production 0

  27. SQL> col comp_name format a40
  28. SQL> col version format a13
  29. SQL> col control format a8
  30. SQL> col status format a15
  31. SQL> set line 300
  32. SQL> set pagesize 800
  33. SQL> select comp_name,version,control,status from dba_server_registry;

  35. COMP_NAME VERSION CONTROL STATUS
  36. ---------------------------------------- ------------- -------- ---------------
  37. Oracle Database Vault 12.1.0.1.0 SYS VALID
  38. Oracle Application Express 4.2.0.00.27 SYS VALID
  39. Oracle Label Security 12.1.0.1.0 SYS VALID
  40. Spatial 12.1.0.1.0 SYS VALID
  41. Oracle Multimedia 12.1.0.1.0 SYS VALID
  42. Oracle Text 12.1.0.1.0 SYS VALID
  43. Oracle Workspace Manager 12.1.0.1.0 SYS VALID
  44. Oracle XML Database 12.1.0.1.0 SYS VALID
  45. Oracle Database Catalog Views 12.1.0.1.0 SYS VALID
  46. Oracle Database Packages and Types 12.1.0.1.0 SYS VALID
  47. JServer JAVA Virtual Machine 12.1.0.1.0 SYS VALID
  48. Oracle XDK 12.1.0.1.0 SYS VALID
  49. Oracle Database Java Packages 12.1.0.1.0 SYS VALID
  50. OLAP Analytic Workspace 12.1.0.1.0 SYS VALID
  51. Oracle OLAP API 12.1.0.1.0 SYS VALID
  52. Oracle Real Application Clusters 12.1.0.1.0 SYS OPTION OFF

  54. 16 rows selected.

二、刪除EM

  1. [oracle@db01 ~]$ emctl stop dbconsole
  2. SQL> @$ORACLE_HOME/rdbms/admin/emremove.sql
  3. old 69: IF (upper('&LOGGING') = 'VERBOSE')
  4. new 69: IF (upper('VERBOSE') = 'VERBOSE')

  6. PL/SQL procedure successfully completed.
  7. [oracle@db01 ~]$ rm –rf $ORACLE_HOME/$HOSTNAME
  8. [oracle@db01 ~]$ rm –rf $ORACLE_HOME/oc4j/j2ee/OC4J_DBConsole_*

三、備份資料庫

  1. RMAN> backup database plus archivelog delete input format '/DBBackup/Phycal/full_%U.bak';
  4. Starting backup at 02-DEC-14
  5. current log archived
  6. using channel ORA_DISK_1
  7. channel ORA_DISK_1: starting archived log backup set
  8. channel ORA_DISK_1: specifying archived log(s) in backup set
  9. input archived log thread=1 sequence=48 RECID=1 STAMP=865232107
  10. input archived log thread=1 sequence=49 RECID=2 STAMP=865232108
  11. input archived log thread=1 sequence=50 RECID=3 STAMP=865232110
  12. input archived log thread=1 sequence=51 RECID=4 STAMP=865232124
  13. input archived log thread=1 sequence=52 RECID=5 STAMP=865232126
  14. input archived log thread=1 sequence=53 RECID=6 STAMP=865232129
  15. input archived log thread=1 sequence=54 RECID=7 STAMP=865232130
  16. input archived log thread=1 sequence=55 RECID=8 STAMP=865232199
  17. input archived log thread=1 sequence=56 RECID=9 STAMP=865232199
  18. input archived log thread=1 sequence=57 RECID=10 STAMP=865232203
  19. input archived log thread=1 sequence=58 RECID=11 STAMP=865232203
  20. input archived log thread=1 sequence=59 RECID=12 STAMP=865232203
  21. input archived log thread=1 sequence=60 RECID=13 STAMP=865232203
  22. input archived log thread=1 sequence=61 RECID=14 STAMP=865232209
  23. input archived log thread=1 sequence=62 RECID=15 STAMP=865232380
  24. channel ORA_DISK_1: starting piece 1 at 02-DEC-14
  25. channel ORA_DISK_1: finished piece 1 at 02-DEC-14
  26. piece handle=/DBBackup/Phycal/full_05pp4pfs_1_1.bak tag=TAG20141202T061940 comment=NONE
  27. channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
  28. channel ORA_DISK_1: deleting archived log(s)
  29. archived log file name=/DBData/fast_recovery_area/WOO12C/archivelog/2014_12_02/o1_mf_1_48_b7st3cbs_.arc RECID=1 STAMP=865232107
  30. archived log file name=/DBData/fast_recovery_area/WOO12C/archivelog/2014_12_02/o1_mf_1_49_b7st3d69_.arc RECID=2 STAMP=865232108
  31. archived log file name=/DBData/fast_recovery_area/WOO12C/archivelog/2014_12_02/o1_mf_1_50_b7st3fwr_.arc RECID=3 STAMP=865232110
  32. archived log file name=/DBData/fast_recovery_area/WOO12C/archivelog/2014_12_02/o1_mf_1_51_b7st3wto_.arc RECID=4 STAMP=865232124
  33. archived log file name=/DBData/fast_recovery_area/WOO12C/archivelog/2014_12_02/o1_mf_1_52_b7st3ydw_.arc RECID=5 STAMP=865232126
  34. archived log file name=/DBData/fast_recovery_area/WOO12C/archivelog/2014_12_02/o1_mf_1_53_b7st41h9_.arc RECID=6 STAMP=865232129
  35. archived log file name=/DBData/fast_recovery_area/WOO12C/archivelog/2014_12_02/o1_mf_1_54_b7st428n_.arc RECID=7 STAMP=865232130
  36. archived log file name=/DBData/fast_recovery_area/WOO12C/archivelog/2014_12_02/o1_mf_1_55_b7st66z1_.arc RECID=8 STAMP=865232199
  37. archived log file name=/DBData/fast_recovery_area/WOO12C/archivelog/2014_12_02/o1_mf_1_56_b7st67ox_.arc RECID=9 STAMP=865232199
  38. archived log file name=/DBData/fast_recovery_area/WOO12C/archivelog/2014_12_02/o1_mf_1_57_b7st6c1b_.arc RECID=10 STAMP=865232203
  39. archived log file name=/DBData/fast_recovery_area/WOO12C/archivelog/2014_12_02/o1_mf_1_58_b7st6c22_.arc RECID=11 STAMP=865232203
  40. archived log file name=/DBData/fast_recovery_area/WOO12C/archivelog/2014_12_02/o1_mf_1_59_b7st6c6y_.arc RECID=12 STAMP=865232203
  41. archived log file name=/DBData/fast_recovery_area/WOO12C/archivelog/2014_12_02/o1_mf_1_60_b7st6c7o_.arc RECID=13 STAMP=865232203
  42. archived log file name=/DBData/fast_recovery_area/WOO12C/archivelog/2014_12_02/o1_mf_1_61_b7st6kq8_.arc RECID=14 STAMP=865232209
  43. archived log file name=/DBData/fast_recovery_area/WOO12C/archivelog/2014_12_02/o1_mf_1_62_b7stcwmv_.arc RECID=15 STAMP=865232380
  44. Finished backup at 02-DEC-14
  46. Starting backup at 02-DEC-14
  47. using channel ORA_DISK_1
  48. channel ORA_DISK_1: starting full datafile backup set
  49. channel ORA_DISK_1: specifying datafile(s) in backup set
  50. input datafile file number=00004 name=/DBData/WOO12C/datafile/o1_mf_undotbs1_b7gh653v_.dbf
  51. input datafile file number=00001 name=/DBData/WOO12C/datafile/o1_mf_system_b7gh4dtv_.dbf
  52. input datafile file number=00003 name=/DBData/WOO12C/datafile/o1_mf_sysaux_b7gh21p2_.dbf
  53. input datafile file number=00006 name=/DBData/WOO12C/datafile/o1_mf_users_b7gh6409_.dbf
  54. channel ORA_DISK_1: starting piece 1 at 02-DEC-14
  55. channel ORA_DISK_1: finished piece 1 at 02-DEC-14
  56. piece handle=/DBData/fast_recovery_area/WOO12C/backupset/2014_12_02/o1_mf_nnndf_TAG20141202T061942_b7stcyyx_.bkp tag=TAG20141202T061942 comment=NONE
  57. channel ORA_DISK_1: backup set complete, elapsed time: 00:01:36
  58. channel ORA_DISK_1: starting full datafile backup set
  59. channel ORA_DISK_1: specifying datafile(s) in backup set
  60. input datafile file number=00014 name=/DBData/WOO12C/0847D2A3397B02B0E0533307A8C077E9/datafile/o1_mf_sysaux_b7gknfyd_.dbf
  61. input datafile file number=00013 name=/DBData/WOO12C/0847D2A3397B02B0E0533307A8C077E9/datafile/o1_mf_system_b7gknfmp_.dbf
  62. input datafile file number=00015 name=/DBData/WOO12C/0847D2A3397B02B0E0533307A8C077E9/datafile/o1_mf_users_b7gkngh6_.dbf
  63. channel ORA_DISK_1: starting piece 1 at 02-DEC-14
  64. channel ORA_DISK_1: finished piece 1 at 02-DEC-14
  65. piece handle=/DBData/fast_recovery_area/WOO12C/0847D2A3397B02B0E0533307A8C077E9/backupset/2014_12_02/o1_mf_nnndf_TAG20141202T061942_b7stgzdo_.bkp tag=TAG20141202T061942 comment=NONE
  66. channel ORA_DISK_1: backup set complete, elapsed time: 00:01:55
  67. channel ORA_DISK_1: starting full datafile backup set
  68. channel ORA_DISK_1: specifying datafile(s) in backup set
  69. input datafile file number=00009 name=/DBData/WOO12C/08D98EA3271835F9E0533307A8C068EE/datafile/o1_mf_sysaux_b7ghrvm2_.dbf
  70. input datafile file number=00008 name=/DBData/WOO12C/08D98EA3271835F9E0533307A8C068EE/datafile/o1_mf_system_b7ghrvnw_.dbf
  71. input datafile file number=00010 name=/DBData/WOO12C/08D98EA3271835F9E0533307A8C068EE/datafile/o1_mf_users_b7ght9rv_.dbf
  72. channel ORA_DISK_1: starting piece 1 at 02-DEC-14
  73. channel ORA_DISK_1: finished piece 1 at 02-DEC-14
  74. piece handle=/DBData/fast_recovery_area/WOO12C/08D98EA3271835F9E0533307A8C068EE/backupset/2014_12_02/o1_mf_nnndf_TAG20141202T061942_b7stlll8_.bkp tag=TAG20141202T061942 comment=NONE
  75. channel ORA_DISK_1: backup set complete, elapsed time: 00:00:55
  76. channel ORA_DISK_1: starting full datafile backup set
  77. channel ORA_DISK_1: specifying datafile(s) in backup set
  78. input datafile file number=00007 name=/DBData/WOO12C/datafile/o1_mf_sysaux_b7gh7gjq_.dbf
  79. input datafile file number=00005 name=/DBData/WOO12C/datafile/o1_mf_system_b7gh7gkl_.dbf
  80. channel ORA_DISK_1: starting piece 1 at 02-DEC-14
  81. channel ORA_DISK_1: finished piece 1 at 02-DEC-14
  82. piece handle=/DBData/fast_recovery_area/WOO12C/08D970F59616336FE0533307A8C03C35/backupset/2014_12_02/o1_mf_nnndf_TAG20141202T061942_b7stn9ly_.bkp tag=TAG20141202T061942 comment=NONE
  83. channel ORA_DISK_1: backup set complete, elapsed time: 00:01:05
  84. Finished backup at 02-DEC-14
  86. Starting backup at 02-DEC-14
  87. current log archived
  88. using channel ORA_DISK_1
  89. channel ORA_DISK_1: starting archived log backup set
  90. channel ORA_DISK_1: specifying archived log(s) in backup set
  91. input archived log thread=1 sequence=63 RECID=16 STAMP=865232715
  92. channel ORA_DISK_1: starting piece 1 at 02-DEC-14
  93. channel ORA_DISK_1: finished piece 1 at 02-DEC-14
  94. piece handle=/DBBackup/Phycal/full_0app4pqb_1_1.bak tag=TAG20141202T062515 comment=NONE
  95. channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
  96. channel ORA_DISK_1: deleting archived log(s)
  97. archived log file name=/DBData/fast_recovery_area/WOO12C/archivelog/2014_12_02/o1_mf_1_63_b7stpbxz_.arc RECID=16 STAMP=865232715
  98. Finished backup at 02-DEC-14
  100. Starting Control File and SPFILE Autobackup at 02-DEC-14
  101. piece handle=/DBData/fast_recovery_area/WOO12C/autobackup/2014_12_02/o1_mf_s_865232716_b7stpfto_.bkp comment=NONE
  102. Finished Control File and SPFILE Autobackup at 02-DEC-14
四、上傳解壓12.1.0.2安裝介質，並解壓縮
  1. [oracle@db01 ~]$ ll p17694377_121020*
  2. -rw-r--r-- 1 oracle oinstall 1673517582 Dec 2 05:38 p17694377_121020_Linux-x86-64_1of8.zip
  3. -rw-r--r-- 1 oracle oinstall 1014527110 Nov 28 02:44 p17694377_121020_Linux-x86-64_2of8.zip
  4. [oracle@db01 ~]$ unzip p17694377_121020_Linux-x86-64_1of8.zip
  5. [oracle@db01 ~]$ unzip p17694377_121020_Linux-x86-64_2of8.zip

五、建立使用者安裝12.1.0.2的軟體目錄

  1. [oracle@db01 ~]$ cd /DBSoft/Product/
  2. [oracle@db01 Product]$ ls
  3. 12.1.0
  4. [oracle@db01 Product]$ mkdir -p 12.1.0.2/db_1
  5. [oracle@db01 Product]$ ll
  6. total 8
  7. drwxr-xr-x 3 oracle oinstall 4096 Nov 20 05:39 12.1.0
  8. 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指令碼

  1. [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.12 彈出監聽配置，點選Next進入下一步                     

        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關閉升級視窗                                      


八、至此升級安裝已經完成。



九、完成之後檢查資料庫版本：


  1. SQL> set line 300
  2. SQL> set pagesize 1000
  3. SQL> r
  4.   1* select * from v$version

  6. BANNER CON_ID
  7. -------------------------------------------------------------------------------- ----------
  8. Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production 0
  9. PL/SQL Release 12.1.0.2.0 - Production 0
  10. CORE 12.1.0.2.0 Production 0
  11. TNS for Linux: Version 12.1.0.2.0 - Production 0
  12. NLSRTL Version 12.1.0.2.0 - Production 0

十、檢查各元件版本:

  1. SQL> select comp_name,version,control,status from dba_server_registry;

  3. COMP_NAME VERSION CONTROL STATUS
  4. ---------------------------------------- ------------- -------- ---------------
  5. Oracle Database Vault 12.1.0.2.0 SYS VALID
  6. Oracle Application Express 4.2.5.00.08 SYS VALID
  7. Oracle Label Security 12.1.0.2.0 SYS VALID
  8. Spatial 12.1.0.2.0 SYS VALID
  9. Oracle Multimedia 12.1.0.2.0 SYS VALID
  10. Oracle Text 12.1.0.2.0 SYS VALID
  11. Oracle Workspace Manager 12.1.0.2.0 SYS VALID
  12. Oracle XML Database 12.1.0.2.0 SYS VALID
  13. Oracle Database Catalog Views 12.1.0.2.0 SYS VALID
  14. Oracle Database Packages and Types 12.1.0.2.0 SYS VALID
  15. JServer JAVA Virtual Machine 12.1.0.2.0 SYS VALID
  16. Oracle XDK 12.1.0.2.0 SYS VALID
  17. Oracle Database Java Packages 12.1.0.2.0 SYS VALID
  18. OLAP Analytic Workspace 12.1.0.2.0 SYS VALID
  19. Oracle OLAP API 12.1.0.2.0 SYS VALID
  20. Oracle Real Application Clusters 12.1.0.2.0 SYS OPTION OFF

  22. 16 rows selected.
十一、檢查資料庫失效物件，是沒有失效的物件，如果有的話執行utlrcmp.sql重新編譯
  1. SQL> select owner, object_name, object_type, status from dba_objects where status=\'INVALID\' order by 1, 2,3;

  3. no rows selected

  5. SQL>

十一、open 所有PDBs，並檢視PDBs狀態

  1. SQL> show pdbs

  3.     CON_ID CON_NAME OPEN MODE RESTRICTED
  4. ---------- ------------------------------ ---------- ----------
  5.          2 PDB$SEED READ ONLY NO
  6.          3 PDB01 MOUNTED
  7.          4 WOO_ORA11G MOUNTED
  8. SQL> alter pluggable database all open;

  10. Pluggable database altered.

  12. SQL> show pdbs;

  14.     CON_ID CON_NAME OPEN MODE RESTRICTED
  15. ---------- ------------------------------ ---------- ----------
  16.          2 PDB$SEED READ ONLY NO
  17.          3 PDB01 READ WRITE NO
  18.          4 WOO_ORA11G READ WRITE NO










來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/20674423/viewspace-1379944/，如需轉載，請註明出處，否則將追究法律責任。

相關文章