探索Oracle之数据库升级九 12.1.0.1 Update 12.1.0.2

探索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
   
9. 
   
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
    
16. 
    
17. SQL> select * from v$version;
    
18. 
    
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
    
26. 
    
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;
    
34. 
    
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
    
53. 
    
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')
   
5. 
   
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关闭升级窗口                                      


八、至此升级安装已经完成。

九、完成之后检查数据库版本：

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.

十一、检查数据库失效对象，是没有失效的对象，如果有的话执行utlrcmp.sql重新编译

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/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/20674423/viewspace-1379944/