关于10g RAC的升级(10.2.0.1 –> 10.2.0.5):DBUA and Manual
这里需要说明的是,我的初始版本为:10.2.0.1;我需要升级到的版本是:10.2.0.5。
你需要在Oracle的Support网站MOS上下载补丁包:p8202632_10205_Linux-x86-64.zip。
集群件和数据库的补丁包都是同一介质。
在我的环境中,集群件与数据库软件是分别用两个用户配置的,分别为:grid与oracle。
一、集群件
集群件的升级很容易。
通过grid登录系统,运行补丁包中的”./runInstaller”。
有可能直接运行无法开启OUI,可以忽略OUI的运行前检查:./runInstaller -ignoreSysPrereqs
然后是图形化中傻瓜式的下一步,最后分别在两个节点上按照OUI的提示,执行对应的脚本即可。
二、数据库软件
通过oracle登录系统,以忽略预检查的方式运行OUI程序。
需要注意的是,你需要彻底停掉RAC环境,否则安装过程中会提示你一些后台进程需要关闭。
如下:
1. sqlplus –> shutdown immediate
2. crsctl stop crs (Each Node)
三、数据库实例
如果你的数据库实例是通过10201的版本创建的,那么在成功升级到10205之后,是无法直接拉起数据库的。
你会遇到如下错误:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 |
[root@smmis1 ~]# su - oracle [oracle@smmis1 ~]$ sqlplus -v SQL*Plus: Release 10.2.0.5.0 - Production [oracle@smmis1 ~]$ sqlplus / as sysdba SQL*Plus: Release 10.2.0.5.0 - Production on Thu May 15 18:19:39 2014 Copyright (c) 1982, 2010, Oracle. All Rights Reserved. Connected to an idle instance. SQL> startup ORACLE instance started. Total System Global Area 536870912 bytes Fixed Size 2097592 bytes Variable Size 155192904 bytes Database Buffers 369098752 bytes Redo Buffers 10481664 bytes Database mounted. ORA-01092: ORACLE instance terminated. Disconnection forced SQL> exit Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production With the Partitioning, Real Application Clusters, OLAP, Data Mining and Real Application Testing options [oracle@smmis1 ~]$ |
关于这个异常更详细的日志内容如下:
alert日志:
1 2 3 4 5 6 7 8 9 |
Thu May 15 18:19:54 CST 2014 Errors in file /u01/app/oracle/admin/smmisdb/udump/smmisdb1_ora_4618.trc: ORA-00704: bootstrap process failure ORA-39700: database must be opened with UPGRADE option Thu May 15 18:19:54 CST 2014 Error 704 happened during db open, shutting down database USER: terminating instance due to error 704 Instance terminated by USER, pid = 4618 ORA-1092 signalled during: ALTER DATABASE OPEN... |
通过如上日志信息可以看到:数据库实例需要升级。
数据库实例的升级:
有两种方式:DBUA或者手动升级
一、DBUA
Oracle用户,执行:dbua
查看下数据库的当前状态:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 |
[oracle@smmis1 ~]$ ps -ef | grep ora_ oracle 755 1 0 19:14 ? 00:00:00 ora_pmon_smmisdb1 oracle 757 1 0 19:14 ? 00:00:00 ora_diag_smmisdb1 oracle 759 1 0 19:14 ? 00:00:00 ora_psp0_smmisdb1 oracle 763 1 0 19:14 ? 00:00:00 ora_lmon_smmisdb1 oracle 766 1 0 19:14 ? 00:00:05 ora_lmd0_smmisdb1 oracle 768 1 0 19:14 ? 00:00:00 ora_lms0_smmisdb1 oracle 772 1 0 19:14 ? 00:00:00 ora_lms1_smmisdb1 oracle 776 1 0 19:14 ? 00:00:00 ora_lms2_smmisdb1 oracle 780 1 0 19:14 ? 00:00:00 ora_lms3_smmisdb1 oracle 786 1 0 19:14 ? 00:00:00 ora_lms4_smmisdb1 oracle 791 1 0 19:14 ? 00:00:00 ora_lms5_smmisdb1 oracle 795 1 0 19:14 ? 00:00:00 ora_mman_smmisdb1 oracle 797 1 0 19:14 ? 00:00:00 ora_dbw0_smmisdb1 oracle 799 1 0 19:14 ? 00:00:00 ora_dbw1_smmisdb1 oracle 801 1 0 19:14 ? 00:00:00 ora_dbw2_smmisdb1 oracle 805 1 0 19:14 ? 00:00:00 ora_lgwr_smmisdb1 oracle 808 1 0 19:14 ? 00:00:00 ora_ckpt_smmisdb1 oracle 815 1 0 19:14 ? 00:00:01 ora_smon_smmisdb1 oracle 817 1 0 19:14 ? 00:00:00 ora_reco_smmisdb1 oracle 819 1 0 19:14 ? 00:00:05 ora_cjq0_smmisdb1 oracle 821 1 0 19:14 ? 00:00:00 ora_mmon_smmisdb1 oracle 823 1 0 19:14 ? 00:00:00 ora_mmnl_smmisdb1 oracle 827 1 0 19:14 ? 00:00:00 ora_d000_smmisdb1 oracle 859 1 0 19:14 ? 00:00:00 ora_s000_smmisdb1 oracle 867 1 0 19:14 ? 00:00:06 ora_lck0_smmisdb1 oracle 889 1 0 19:14 ? 00:00:00 ora_asmb_smmisdb1 oracle 894 1 0 19:14 ? 00:00:00 ora_rbal_smmisdb1 oracle 972 1 0 19:14 ? 00:00:00 ora_o000_smmisdb1 oracle 1181 1 0 19:14 ? 00:00:00 ora_qmnc_smmisdb1 oracle 1227 1 0 19:14 ? 00:00:03 ora_pz99_smmisdb1 oracle 1252 1 0 19:15 ? 00:00:00 ora_o001_smmisdb1 oracle 1492 1 0 19:15 ? 00:00:00 ora_q000_smmisdb1 oracle 1494 1 0 19:15 ? 00:00:00 ora_q001_smmisdb1 oracle 19366 1 0 19:26 ? 00:00:00 ora_j000_smmisdb1 oracle 19769 4345 0 19:26 pts/3 00:00:00 grep ora_ [oracle@smmis1 ~]$ [oracle@smmis1 ~]$ sqlplus / as sysdba SQL*Plus: Release 10.2.0.5.0 - Production on Thu May 15 19:26:21 2014 Copyright (c) 1982, 2010, Oracle. All Rights Reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production With the Partitioning, Real Application Clusters, OLAP, Data Mining and Real Application Testing options SQL> select * from v$version 2 ; BANNER ---------------------------------------------------------------- Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bi PL/SQL Release 10.2.0.5.0 - Production CORE 10.2.0.5.0 Production TNS for Linux: Version 10.2.0.5.0 - Production NLSRTL Version 10.2.0.5.0 - Production SQL> select instance_name,status from v$instance; INSTANCE_NAME STATUS ---------------- ------------ smmisdb1 OPEN SQL> exit Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production With the Partitioning, Real Application Clusters, OLAP, Data Mining and Real Application Testing options [oracle@smmis1 ~]$ |
这样就升级完成了。
注意:在RAC中,数据库的实例升级,可以在其中一个节点上操作,另一个节点关闭,升级成功后,再按照正常的方式打开另一个节点的库即可。
二、手动升级
以Upgrade方式启动数据库:
1 2 3 4 5 6 7 8 9 10 11 |
SQL> startup upgrade; ORACLE instance started. Total System Global Area 536870912 bytes Fixed Size 2097624 bytes Variable Size 163581480 bytes Database Buffers 364904448 bytes Redo Buffers 6287360 bytes Database mounted. Database opened. SQL> |
alert日志:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 |
Fri May 15 19:19:19 CST 2015 Starting ORACLE instance (normal) LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 Picked latch-free SCN scheme 3 Using LOG_ARCHIVE_DEST_1 parameter default value as /u01/app/oracle/product/10g/dbhome_1/dbs/arch IMODE=BR ILAT =73 LICENSE_MAX_USERS = 0 SYS auditing is disabled ksdpec: called for event 13740 prior to event group initialization Starting up ORACLE RDBMS Version: 10.2.0.5.0. System parameters with non-default values: processes = 600 sessions = 665 __shared_pool_size = 155189248 __large_pool_size = 4194304 __java_pool_size = 4194304 __streams_pool_size = 0 sga_target = 536870912 control_files = /u01/app/oracle/oradata/smposdb/control01.ctl, /u01/app/oracle/oradata/smposdb/control02.ctl, /u01/app/oracle/oradata/smposdb/control03.ctl db_block_size = 8192 __db_cache_size = 364904448 compatible = 10.2.0.1.0 db_file_multiblock_read_count= 16 undo_management = AUTO undo_tablespace = UNDOTBS1 remote_login_passwordfile= EXCLUSIVE db_domain = dispatchers = (PROTOCOL=TCP) (SERVICE=smposdbXDB) job_queue_processes = 10 background_dump_dest = /u01/app/oracle/admin/smposdb/bdump user_dump_dest = /u01/app/oracle/admin/smposdb/udump core_dump_dest = /u01/app/oracle/admin/smposdb/cdump audit_file_dest = /u01/app/oracle/admin/smposdb/adump db_name = smposdb open_cursors = 300 pga_aggregate_target = 1245708288 PMON started with pid=2, OS id=4260 PSP0 started with pid=3, OS id=4262 MMAN started with pid=4, OS id=4264 DBW0 started with pid=5, OS id=4266 DBW1 started with pid=6, OS id=4268 LGWR started with pid=7, OS id=4270 CKPT started with pid=8, OS id=4272 SMON started with pid=9, OS id=4274 RECO started with pid=10, OS id=4276 CJQ0 started with pid=11, OS id=4278 MMON started with pid=12, OS id=4280 Fri May 15 19:19:19 CST 2015 starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'... MMNL started with pid=13, OS id=4282 Fri May 15 19:19:19 CST 2015 starting up 1 shared server(s) ... Fri May 15 19:19:20 CST 2015 ALTER DATABASE MOUNT Fri May 15 19:19:24 CST 2015 Setting recovery target incarnation to 2 Fri May 15 19:19:24 CST 2015 Successful mount of redo thread 1, with mount id 731500600 Fri May 15 19:19:24 CST 2015 Database mounted in Exclusive Mode Completed: ALTER DATABASE MOUNT Fri May 15 19:19:24 CST 2015 ALTER DATABASE OPEN MIGRATE Fri May 15 19:19:24 CST 2015 Thread 1 opened at log sequence 6 Current log# 2 seq# 6 mem# 0: /u01/app/oracle/oradata/smposdb/redo02.log Successful open of redo thread 1 Fri May 15 19:19:24 CST 2015 MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set Fri May 15 19:19:24 CST 2015 SMON: enabling cache recovery Fri May 15 19:19:24 CST 2015 Successfully onlined Undo Tablespace 1. Fri May 15 19:19:24 CST 2015 SMON: enabling tx recovery Fri May 15 19:19:24 CST 2015 Database Characterset is ZHS16GBK Fri May 15 19:19:25 CST 2015 Stopping background process MMNL Fri May 15 19:19:26 CST 2015 Stopping background process MMON Starting background process MMON Starting background process MMNL MMON started with pid=12, OS id=4291 Fri May 15 19:19:27 CST 2015 ALTER SYSTEM enable restricted session; MMNL started with pid=13, OS id=4293 Fri May 15 19:19:27 CST 2015 ALTER SYSTEM SET _system_trig_enabled=FALSE SCOPE=MEMORY; Autotune of undo retention is turned off. Fri May 15 19:19:27 CST 2015 ALTER SYSTEM SET _undo_autotune=FALSE SCOPE=MEMORY; Fri May 15 19:19:27 CST 2015 ALTER SYSTEM SET undo_retention=900 SCOPE=MEMORY; Fri May 15 19:19:27 CST 2015 ALTER SYSTEM SET aq_tm_processes=0 SCOPE=MEMORY; Resource Manager disabled during database migration: plan '' not set Fri May 15 19:19:27 CST 2015 ALTER SYSTEM SET resource_manager_plan='' SCOPE=MEMORY; replication_dependency_tracking turned off (no async multimaster replication found) Completed: ALTER DATABASE OPEN MIGRATE |
重建数据字典:$ORACLE_HOME/rdbms/admin/catupgrd.sql
1 2 3 4 5 6 7 8 |
SQL> spool /home/oracle/update.log SQL> !ls $ORACLE_HOME/rdbms/admin/ | grep catupgrd.sql catupgrd.sql SQL> !echo $ORACLE_HOME /u01/app/oracle/product/10g/dbhome_1 SQL> @/u01/app/oracle/product/10g/dbhome_1/rdbms/admin/catupgrd.sql |
该脚本的执行时间较长。
最后执行完的时候的呈现如下:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 |
Submitting DBMS jobs. old 5: IF NOT ('&EM_REPOS_MODE' = 'CENTRAL') THEN new 5: IF NOT ('SYSAUX' = 'CENTRAL') THEN TIMESTAMP -------------------------------------------------------------------------------- COMP_TIMESTAMP EM 2015-05-15 19:44:37 DBUA_TIMESTAMP EM VALID 2015-05-15 19:44:37 .. loading the Expression Filter/BRM Java library .. creating Rule Manager catalog views .. creating Rule Manager package/type implementations No errors. No errors. No errors. No errors. No errors. No errors. No errors. No errors. No errors. No errors. No errors. No errors. No errors. No errors. No errors. No errors. No errors. No errors. No errors. No errors. TIMESTAMP -------------------------------------------------------------------------------- COMP_TIMESTAMP RUL 2015-05-15 19:44:44 DBUA_TIMESTAMP RUL VALID 2015-05-15 19:44:44 TIMESTAMP -------------------------------------------------------------------------------- COMP_TIMESTAMP UPGRD_END 2015-05-15 19:45:29 . Oracle Database 10.2 Upgrade Status Utility 05-15-2015 19:45:29 . Component Status Version HH:MM:SS Oracle Database Server VALID 10.2.0.5.0 00:08:33 JServer JAVA Virtual Machine VALID 10.2.0.5.0 00:02:43 Oracle XDK VALID 10.2.0.5.0 00:00:21 Oracle Database Java Packages VALID 10.2.0.5.0 00:00:18 Oracle Text VALID 10.2.0.5.0 00:00:30 Oracle XML Database VALID 10.2.0.5.0 00:01:14 Oracle Workspace Manager VALID 10.2.0.5.0 00:00:25 Oracle Data Mining VALID 10.2.0.5.0 00:00:13 OLAP Analytic Workspace VALID 10.2.0.5.0 00:00:17 OLAP Catalog VALID 10.2.0.5.0 00:00:34 Oracle OLAP API VALID 10.2.0.5.0 00:00:30 Oracle interMedia VALID 10.2.0.5.0 00:02:02 Spatial VALID 10.2.0.5.0 00:01:33 Oracle Expression Filter VALID 10.2.0.5.0 00:00:12 Oracle Enterprise Manager VALID 10.2.0.5.0 00:00:55 Oracle Rule Manager VALID 10.2.0.5.0 00:00:06 . Total Upgrade Time: 00:21:19 DOC>####################################################################### DOC>####################################################################### DOC> DOC> The above PL/SQL lists the SERVER components in the upgraded DOC> database, along with their current version and status. DOC> DOC> Please review the status and version columns and look for DOC> any errors in the spool log file. If there are errors in the spool DOC> file, or any components are not VALID or not the current version, DOC> consult the Oracle Database Upgrade Guide for troubleshooting DOC> recommendations. DOC> DOC> Next shutdown immediate, restart for normal operation, and then DOC> run utlrp.sql to recompile any invalid application objects. DOC> DOC>####################################################################### DOC>####################################################################### DOC># SQL> SQL> spool off SQL> SQL> |
在该过程中的alert日志的情况:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309 310 |
Fri May 15 19:24:12 CST 2015 SERVER COMPONENT id=PATCH_BGN: timestamp=2015-05-15 19:24:12 Fri May 15 19:25:29 CST 2015 Thread 1 advanced to log sequence 7 (LGWR switch) Current log# 3 seq# 7 mem# 0: /u01/app/oracle/oradata/smposdb/redo03.log Fri May 15 19:26:29 CST 2015 Thread 1 advanced to log sequence 8 (LGWR switch) Current log# 1 seq# 8 mem# 0: /u01/app/oracle/oradata/smposdb/redo01.log Fri May 15 19:27:02 CST 2015 Thread 1 cannot allocate new log, sequence 9 Checkpoint not complete Current log# 1 seq# 8 mem# 0: /u01/app/oracle/oradata/smposdb/redo01.log Fri May 15 19:27:04 CST 2015 Thread 1 advanced to log sequence 9 (LGWR switch) Current log# 2 seq# 9 mem# 0: /u01/app/oracle/oradata/smposdb/redo02.log Fri May 15 19:27:46 CST 2015 Thread 1 cannot allocate new log, sequence 10 Checkpoint not complete Current log# 2 seq# 9 mem# 0: /u01/app/oracle/oradata/smposdb/redo02.log Fri May 15 19:27:52 CST 2015 Thread 1 advanced to log sequence 10 (LGWR switch) Current log# 3 seq# 10 mem# 0: /u01/app/oracle/oradata/smposdb/redo03.log Fri May 15 19:28:41 CST 2015 Thread 1 cannot allocate new log, sequence 11 Checkpoint not complete Current log# 3 seq# 10 mem# 0: /u01/app/oracle/oradata/smposdb/redo03.log Fri May 15 19:28:43 CST 2015 Thread 1 advanced to log sequence 11 (LGWR switch) Current log# 1 seq# 11 mem# 0: /u01/app/oracle/oradata/smposdb/redo01.log Fri May 15 19:29:26 CST 2015 Thread 1 cannot allocate new log, sequence 12 Checkpoint not complete Current log# 1 seq# 11 mem# 0: /u01/app/oracle/oradata/smposdb/redo01.log Fri May 15 19:29:30 CST 2015 Thread 1 advanced to log sequence 12 (LGWR switch) Current log# 2 seq# 12 mem# 0: /u01/app/oracle/oradata/smposdb/redo02.log Fri May 15 19:30:14 CST 2015 Thread 1 cannot allocate new log, sequence 13 Checkpoint not complete Current log# 2 seq# 12 mem# 0: /u01/app/oracle/oradata/smposdb/redo02.log Fri May 15 19:30:19 CST 2015 Thread 1 advanced to log sequence 13 (LGWR switch) Current log# 3 seq# 13 mem# 0: /u01/app/oracle/oradata/smposdb/redo03.log Fri May 15 19:31:10 CST 2015 Thread 1 cannot allocate new log, sequence 14 Checkpoint not complete Current log# 3 seq# 13 mem# 0: /u01/app/oracle/oradata/smposdb/redo03.log Fri May 15 19:31:16 CST 2015 Thread 1 advanced to log sequence 14 (LGWR switch) Current log# 1 seq# 14 mem# 0: /u01/app/oracle/oradata/smposdb/redo01.log Fri May 15 19:31:44 CST 2015 Thread 1 cannot allocate new log, sequence 15 Checkpoint not complete Current log# 1 seq# 14 mem# 0: /u01/app/oracle/oradata/smposdb/redo01.log Fri May 15 19:31:46 CST 2015 Thread 1 advanced to log sequence 15 (LGWR switch) Current log# 2 seq# 15 mem# 0: /u01/app/oracle/oradata/smposdb/redo02.log Fri May 15 19:32:43 CST 2015 SERVER COMPONENT id=CATPROC: timestamp=2015-05-15 19:32:43 SERVER COMPONENT id=RDBMS: status=VALID, version=10.2.0.5.0, timestamp=2015-05-15 19:32:43 Fri May 15 19:33:19 CST 2015 Thread 1 cannot allocate new log, sequence 16 Checkpoint not complete Current log# 2 seq# 15 mem# 0: /u01/app/oracle/oradata/smposdb/redo02.log Fri May 15 19:33:20 CST 2015 Thread 1 advanced to log sequence 16 (LGWR switch) Current log# 3 seq# 16 mem# 0: /u01/app/oracle/oradata/smposdb/redo03.log Fri May 15 19:33:31 CST 2015 Thread 1 cannot allocate new log, sequence 17 Checkpoint not complete Current log# 3 seq# 16 mem# 0: /u01/app/oracle/oradata/smposdb/redo03.log Fri May 15 19:33:35 CST 2015 Thread 1 advanced to log sequence 17 (LGWR switch) Current log# 1 seq# 17 mem# 0: /u01/app/oracle/oradata/smposdb/redo01.log Fri May 15 19:33:47 CST 2015 Thread 1 cannot allocate new log, sequence 18 Checkpoint not complete Current log# 1 seq# 17 mem# 0: /u01/app/oracle/oradata/smposdb/redo01.log Fri May 15 19:33:54 CST 2015 Thread 1 advanced to log sequence 18 (LGWR switch) Current log# 2 seq# 18 mem# 0: /u01/app/oracle/oradata/smposdb/redo02.log Thread 1 cannot allocate new log, sequence 19 Checkpoint not complete Current log# 2 seq# 18 mem# 0: /u01/app/oracle/oradata/smposdb/redo02.log Fri May 15 19:34:20 CST 2015 Thread 1 advanced to log sequence 19 (LGWR switch) Current log# 3 seq# 19 mem# 0: /u01/app/oracle/oradata/smposdb/redo03.log Thread 1 cannot allocate new log, sequence 20 Checkpoint not complete Current log# 3 seq# 19 mem# 0: /u01/app/oracle/oradata/smposdb/redo03.log Fri May 15 19:34:52 CST 2015 Thread 1 advanced to log sequence 20 (LGWR switch) Current log# 1 seq# 20 mem# 0: /u01/app/oracle/oradata/smposdb/redo01.log Fri May 15 19:35:27 CST 2015 SERVER COMPONENT id=JAVAVM: status=VALID, version=10.2.0.5.0, timestamp=2015-05-15 19:35:27 Fri May 15 19:35:37 CST 2015 Thread 1 cannot allocate new log, sequence 21 Checkpoint not complete Current log# 1 seq# 20 mem# 0: /u01/app/oracle/oradata/smposdb/redo01.log Fri May 15 19:35:41 CST 2015 Thread 1 advanced to log sequence 21 (LGWR switch) Current log# 2 seq# 21 mem# 0: /u01/app/oracle/oradata/smposdb/redo02.log Fri May 15 19:35:48 CST 2015 SERVER COMPONENT id=XML: status=VALID, version=10.2.0.5.0, timestamp=2015-05-15 19:35:48 Fri May 15 19:36:01 CST 2015 Thread 1 cannot allocate new log, sequence 22 Checkpoint not complete Current log# 2 seq# 21 mem# 0: /u01/app/oracle/oradata/smposdb/redo02.log Fri May 15 19:36:04 CST 2015 Thread 1 advanced to log sequence 22 (LGWR switch) Current log# 3 seq# 22 mem# 0: /u01/app/oracle/oradata/smposdb/redo03.log Fri May 15 19:36:07 CST 2015 SERVER COMPONENT id=CATJAVA: status=VALID, version=10.2.0.5.0, timestamp=2015-05-15 19:36:07 Fri May 15 19:36:37 CST 2015 SERVER COMPONENT id=CONTEXT: status=VALID, version=10.2.0.5.0, timestamp=2015-05-15 19:36:37 Fri May 15 19:36:44 CST 2015 Thread 1 cannot allocate new log, sequence 23 Checkpoint not complete Current log# 3 seq# 22 mem# 0: /u01/app/oracle/oradata/smposdb/redo03.log Fri May 15 19:36:47 CST 2015 Thread 1 advanced to log sequence 23 (LGWR switch) Current log# 1 seq# 23 mem# 0: /u01/app/oracle/oradata/smposdb/redo01.log Fri May 15 19:37:48 CST 2015 Thread 1 cannot allocate new log, sequence 24 Checkpoint not complete Current log# 1 seq# 23 mem# 0: /u01/app/oracle/oradata/smposdb/redo01.log Fri May 15 19:37:50 CST 2015 Thread 1 advanced to log sequence 24 (LGWR switch) Current log# 2 seq# 24 mem# 0: /u01/app/oracle/oradata/smposdb/redo02.log Fri May 15 19:37:51 CST 2015 SERVER COMPONENT id=XDB: status=VALID, version=10.2.0.5.0, timestamp=2015-05-15 19:37:51 Fri May 15 19:38:17 CST 2015 SERVER COMPONENT id=OWM: status=VALID, version=10.2.0.5.0, timestamp=2015-05-15 19:38:17 Fri May 15 19:38:25 CST 2015 Thread 1 cannot allocate new log, sequence 25 Checkpoint not complete Current log# 2 seq# 24 mem# 0: /u01/app/oracle/oradata/smposdb/redo02.log Fri May 15 19:38:27 CST 2015 Thread 1 advanced to log sequence 25 (LGWR switch) Current log# 3 seq# 25 mem# 0: /u01/app/oracle/oradata/smposdb/redo03.log Fri May 15 19:38:30 CST 2015 SERVER COMPONENT id=ODM: status=VALID, version=10.2.0.5.0, timestamp=2015-05-15 19:38:30 Fri May 15 19:38:48 CST 2015 SERVER COMPONENT id=APS: status=VALID, version=10.2.0.5.0, timestamp=2015-05-15 19:38:48 Fri May 15 19:38:57 CST 2015 Thread 1 cannot allocate new log, sequence 26 Checkpoint not complete Current log# 3 seq# 25 mem# 0: /u01/app/oracle/oradata/smposdb/redo03.log Fri May 15 19:38:58 CST 2015 Thread 1 advanced to log sequence 26 (LGWR switch) Current log# 1 seq# 26 mem# 0: /u01/app/oracle/oradata/smposdb/redo01.log Fri May 15 19:39:23 CST 2015 SERVER COMPONENT id=AMD: status=VALID, version=10.2.0.5.0, timestamp=2015-05-15 19:39:23 Fri May 15 19:39:43 CST 2015 Thread 1 cannot allocate new log, sequence 27 Checkpoint not complete Current log# 1 seq# 26 mem# 0: /u01/app/oracle/oradata/smposdb/redo01.log Fri May 15 19:39:45 CST 2015 Thread 1 advanced to log sequence 27 (LGWR switch) Current log# 2 seq# 27 mem# 0: /u01/app/oracle/oradata/smposdb/redo02.log Fri May 15 19:39:53 CST 2015 SERVER COMPONENT id=XOQ: status=VALID, version=10.2.0.5.0, timestamp=2015-05-15 19:39:53 Fri May 15 19:40:07 CST 2015 Thread 1 cannot allocate new log, sequence 28 Checkpoint not complete Current log# 2 seq# 27 mem# 0: /u01/app/oracle/oradata/smposdb/redo02.log Fri May 15 19:40:15 CST 2015 Thread 1 advanced to log sequence 28 (LGWR switch) Current log# 3 seq# 28 mem# 0: /u01/app/oracle/oradata/smposdb/redo03.log Fri May 15 19:40:34 CST 2015 Thread 1 cannot allocate new log, sequence 29 Checkpoint not complete Current log# 3 seq# 28 mem# 0: /u01/app/oracle/oradata/smposdb/redo03.log Fri May 15 19:40:39 CST 2015 Thread 1 advanced to log sequence 29 (LGWR switch) Current log# 1 seq# 29 mem# 0: /u01/app/oracle/oradata/smposdb/redo01.log Fri May 15 19:40:55 CST 2015 Thread 1 cannot allocate new log, sequence 30 Checkpoint not complete Current log# 1 seq# 29 mem# 0: /u01/app/oracle/oradata/smposdb/redo01.log Fri May 15 19:41:00 CST 2015 Thread 1 advanced to log sequence 30 (LGWR switch) Current log# 2 seq# 30 mem# 0: /u01/app/oracle/oradata/smposdb/redo02.log Fri May 15 19:41:27 CST 2015 Thread 1 cannot allocate new log, sequence 31 Checkpoint not complete Current log# 2 seq# 30 mem# 0: /u01/app/oracle/oradata/smposdb/redo02.log Fri May 15 19:41:28 CST 2015 Thread 1 advanced to log sequence 31 (LGWR switch) Current log# 3 seq# 31 mem# 0: /u01/app/oracle/oradata/smposdb/redo03.log Fri May 15 19:41:55 CST 2015 SERVER COMPONENT id=ORDIM: status=VALID, version=10.2.0.5.0, timestamp=2015-05-15 19:41:55 Fri May 15 19:42:05 CST 2015 Thread 1 cannot allocate new log, sequence 32 Checkpoint not complete Current log# 3 seq# 31 mem# 0: /u01/app/oracle/oradata/smposdb/redo03.log Fri May 15 19:42:08 CST 2015 Thread 1 advanced to log sequence 32 (LGWR switch) Current log# 1 seq# 32 mem# 0: /u01/app/oracle/oradata/smposdb/redo01.log Fri May 15 19:42:38 CST 2015 Thread 1 cannot allocate new log, sequence 33 Checkpoint not complete Current log# 1 seq# 32 mem# 0: /u01/app/oracle/oradata/smposdb/redo01.log Fri May 15 19:42:42 CST 2015 Thread 1 advanced to log sequence 33 (LGWR switch) Current log# 2 seq# 33 mem# 0: /u01/app/oracle/oradata/smposdb/redo02.log Fri May 15 19:43:07 CST 2015 Thread 1 cannot allocate new log, sequence 34 Checkpoint not complete Current log# 2 seq# 33 mem# 0: /u01/app/oracle/oradata/smposdb/redo02.log Fri May 15 19:43:09 CST 2015 Thread 1 advanced to log sequence 34 (LGWR switch) Current log# 3 seq# 34 mem# 0: /u01/app/oracle/oradata/smposdb/redo03.log Fri May 15 19:43:29 CST 2015 SERVER COMPONENT id=SDO: status=VALID, version=10.2.0.5.0, timestamp=2015-05-15 19:43:29 Fri May 15 19:43:34 CST 2015 Thread 1 cannot allocate new log, sequence 35 Checkpoint not complete Current log# 3 seq# 34 mem# 0: /u01/app/oracle/oradata/smposdb/redo03.log Fri May 15 19:43:37 CST 2015 Thread 1 advanced to log sequence 35 (LGWR switch) Current log# 1 seq# 35 mem# 0: /u01/app/oracle/oradata/smposdb/redo01.log Fri May 15 19:43:42 CST 2015 SERVER COMPONENT id=EXF: status=VALID, version=10.2.0.5.0, timestamp=2015-05-15 19:43:42 Fri May 15 19:44:00 CST 2015 Thread 1 cannot allocate new log, sequence 36 Checkpoint not complete Current log# 1 seq# 35 mem# 0: /u01/app/oracle/oradata/smposdb/redo01.log Fri May 15 19:44:01 CST 2015 Thread 1 advanced to log sequence 36 (LGWR switch) Current log# 2 seq# 36 mem# 0: /u01/app/oracle/oradata/smposdb/redo02.log Fri May 15 19:44:17 CST 2015 Thread 1 cannot allocate new log, sequence 37 Checkpoint not complete Current log# 2 seq# 36 mem# 0: /u01/app/oracle/oradata/smposdb/redo02.log Fri May 15 19:44:20 CST 2015 Thread 1 advanced to log sequence 37 (LGWR switch) Current log# 3 seq# 37 mem# 0: /u01/app/oracle/oradata/smposdb/redo03.log Fri May 15 19:44:37 CST 2015 SERVER COMPONENT id=EM: status=VALID, version=10.2.0.5.0, timestamp=2015-05-15 19:44:37 SERVER COMPONENT id=RUL: status=VALID, version=10.2.0.5.0, timestamp=2015-05-15 19:44:44 Fri May 15 19:44:50 CST 2015 Thread 1 cannot allocate new log, sequence 38 Checkpoint not complete Current log# 3 seq# 37 mem# 0: /u01/app/oracle/oradata/smposdb/redo03.log Fri May 15 19:44:52 CST 2015 Thread 1 advanced to log sequence 38 (LGWR switch) Current log# 1 seq# 38 mem# 0: /u01/app/oracle/oradata/smposdb/redo01.log Fri May 15 19:45:19 CST 2015 Thread 1 cannot allocate new log, sequence 39 Checkpoint not complete Current log# 1 seq# 38 mem# 0: /u01/app/oracle/oradata/smposdb/redo01.log Fri May 15 19:45:21 CST 2015 Thread 1 advanced to log sequence 39 (LGWR switch) Current log# 2 seq# 39 mem# 0: /u01/app/oracle/oradata/smposdb/redo02.log Fri May 15 19:45:29 CST 2015 SERVER ACTION=UPGRADE id=: Upgraded from 10.2.0.1.0 SERVER COMPONENT id=UPGRD_END: timestamp=2015-05-15 19:45:29 |
重启数据库:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 |
SQL> shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. SQL> SQL> startup ORACLE instance started. Total System Global Area 536870912 bytes Fixed Size 2097624 bytes Variable Size 260050472 bytes Database Buffers 268435456 bytes Redo Buffers 6287360 bytes Database mounted. Database opened. SQL> |
重新编译无效的PL/SQL程序包:
1 |
SQL> @?/rdbms/admin/utlrp.sql |
这样,数据库实例的升级就完成了。
查看一下当前的数据库组件的状态:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 |
SQL> set linesize 900 SQL> set pagesize 900 SQL> col comp_name for a40 SQL> col version for a12 SQL> col status for a6 SQL> SQL> select comp_name,version,status from sys.dba_registry; COMP_NAME VERSION STATUS ---------------------------------------- ------------ ------ Oracle Database Catalog Views 10.2.0.5.0 VALID Oracle Database Packages and Types 10.2.0.5.0 VALID Oracle Workspace Manager 10.2.0.5.0 VALID JServer JAVA Virtual Machine 10.2.0.5.0 VALID Oracle XDK 10.2.0.5.0 VALID Oracle Database Java Packages 10.2.0.5.0 VALID Oracle Expression Filter 10.2.0.5.0 VALID Oracle Data Mining 10.2.0.5.0 VALID Oracle Text 10.2.0.5.0 VALID Oracle XML Database 10.2.0.5.0 VALID Oracle Rule Manager 10.2.0.5.0 VALID Oracle interMedia 10.2.0.5.0 VALID OLAP Analytic Workspace 10.2.0.5.0 VALID Oracle OLAP API 10.2.0.5.0 VALID OLAP Catalog 10.2.0.5.0 VALID Spatial 10.2.0.5.0 VALID Oracle Enterprise Manager 10.2.0.5.0 VALID SQL> |
查看数据库版本:
1 2 3 4 5 6 7 8 9 10 |
SQL> select * from v$version; BANNER ---------------------------------------------------------------- Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bi PL/SQL Release 10.2.0.5.0 - Production CORE 10.2.0.5.0 Production TNS for Linux: Version 10.2.0.5.0 - Production NLSRTL Version 10.2.0.5.0 - Production SQL> |
确认是否有无效对象:
1 2 3 4 5 |
SQL> select object_name,status from dba_objects where status='INVALID'; no rows selected SQL> |
注:关于Oracle RAC数据库实例的手动升级部分也可以参考往期日志,得到更详细的描述:d-prototype.com/archives/2319
——————————————————
Done。
其实,昨天在写这边文档的时候,是没有意识到过去在本站也写过同样的文章的,…
这说明人的记忆力真的很难靠得住。
其次,这次写的升级方案和过去的那篇升级方案里,有一些细节是没有估计到的。
这也说明了很多的事情,一段时间没有做了,就真的和初见一般,…
人,应该看清自己,不该仰仗过去的得到而恃才傲物,因为记忆与自我认知都不是以为的那么可靠,你自认为的那种才华与成就又凭什么就一定可靠?
对于真正的能者来说,谦卑与客观是必备的品格。
除却这两点,很难相信一个人的作为是靠谱的,因为他们的实现与他们自己的所想的偏差,有时候都是自己难以容忍的。更何况超脱个人之外的更高水准的要求?
所以,… 我需要努力的,还很多很多。