oracle更新预计需要多久,Oracle 10g(10.2.0.4)升级到10.2.0.5.19

一、将数据库版本从10.2.0.4 升级到 10.2.0.5,再升级到10.2.0.5.19

(1) 备份等过程略过,一个老库的升级过程,记录之。

(2) 一致性关闭数据库及监听

sqlplus / as sysdba;

shutdown immediate

lsnrctl stop

二、升级数据库软件

1,解压p8202632_10205_Linux-x86-64.zip

2,直接采用安装方式安装,覆盖原安装目录

xhost+

su - oracle

cd Disk1/

./runInstaller

三、升级数据字典

1, 升级前检查

SQL> STARTUP UPGRADE

SQL> SPOOL upgrade_info.log

SQL> @?/rdbms/admin/utlu102i.sql

Oracle Database 10.2 Upgrade Information Utility    03-21-2016 10:27:05

.

**********************************************************************

Database:

**********************************************************************

--> name:       ORCL

--> version:    10.2.0.4.0

--> compatible: 10.2.0.3.0

--> blocksize:  8192

.

**********************************************************************

Tablespaces: [make adjustments in the current environment]

**********************************************************************

--> SYSTEM tablespace is adequate for the upgrade.

.... minimum required size: 488 MB

.... AUTOEXTEND additional space required: 8 MB

--> UNDOTBS1 tablespace is adequate for the upgrade.

.... minimum required size: 401 MB

.... AUTOEXTEND additional space required: 376 MB

--> SYSAUX tablespace is adequate for the upgrade.

.... minimum required size: 259 MB

.... AUTOEXTEND additional space required: 9 MB

--> TEMP tablespace is adequate for the upgrade.

.... minimum required size: 58 MB

.... AUTOEXTEND additional space required: 38 MB

.

**********************************************************************

Update Parameters: [Update Oracle Database 10.2 init.ora or spfile]

**********************************************************************

-- No update parameter changes are required.

.

**********************************************************************

Renamed Parameters: [Update Oracle Database 10.2 init.ora or spfile]

**********************************************************************

-- No renamed parameters found. No changes are required.

.

**********************************************************************

Obsolete/Deprecated Parameters: [Update Oracle Database 10.2 init.ora or spfile]

**********************************************************************

-- No obsolete parameters found. No changes are required

.

**********************************************************************

Components: [The following database components will be upgraded or installed]

**********************************************************************

--> Oracle Catalog Views         [upgrade]  VALID

--> Oracle Packages and Types    [upgrade]  VALID

--> JServer JAVA Virtual Machine [upgrade]  VALID

--> Oracle XDK for Java          [upgrade]  VALID

--> Oracle Java Packages         [upgrade]  VALID

--> Oracle Text                  [upgrade]  VALID

--> Oracle XML Database          [upgrade]  VALID

--> Oracle Workspace Manager     [upgrade]  VALID

--> Oracle Data Mining           [upgrade]  VALID

--> OLAP Analytic Workspace      [upgrade]  VALID

--> OLAP Catalog                 [upgrade]  VALID

--> Oracle OLAP API              [upgrade]  VALID

--> Oracle interMedia            [upgrade]  VALID

--> Spatial                      [upgrade]  VALID

--> Expression Filter            [upgrade]  VALID

--> EM Repository                [upgrade]  VALID

--> Rule Manager                 [upgrade]  VALID

PL/SQL procedure successfully completed.

SQL> SPOOL OFF

2. 开始升级数据库字典(大概需要30分钟)

SQL> STARTUP UPGRADE

SQL> SPOOL patch.log

SQL> @?/rdbms/admin/catupgrd.sql

SQL> SPOOL OFF

编译无译对象

SQL> SHUTDOWN IMMEDIATE

SQL> STARTUP

SQL> @?/rdbms/admin/utlrp.sql

SQL> SELECT COMP_NAME, VERSION, STATUS FROM SYS.DBA_REGISTRY;

升级后检查,升级成功。

set line 200

col ACTION_TIME for a30

col ACTION for a20

col NAMESPACE for a10

col VERSION for a10

col BUNDLE_SERIES for a5

col COMMENTS for a25

select * from dba_registry_history;

ACTION_TIME                    ACTION               NAMESPACE  VERSION            ID COMMENTS

------------------------------ -------------------- ---------- ---------- ---------- -------------------------

21-316 10.47.16.102814 VIEW RECOMPILE                                8289601 view recompilation

21-316 10.47.16.167852 UPGRADE              SERVER     10.2.0.5.0            Upgraded from 10.2.0.4.0

SQL>

四、打PSU19,更新OPatch版本,必须要更新OPatch版本

说明:分别在两个节点更新OPatch版本。

1. 更新OPatch版本,需要更新到10.2.0.5.19,OPatch直接压缩替换就可以了。

(1) 上传p6880880_102000_Linux-x86-64.zip到/u01/software目录下, /u01/software给777权限,也可以采用/tmp目录。

(2) root用户下将原OPatch目录改名。

mv /u01/app/oracle/product/10.2.0/db_1/OPatch /u01/app/oracle/product/10.2.0/db_1/OPatchBK

2. oracle目录OPatch替换

(1) root用户

cd /u01/software/

chown oracle:oinstall p6880880_102000_Linux-x86-64.zip

chown oracle:oinstall p20299014_10205_Linux-x86-64.zip

(2) oracle用户

su - oracle

cd /u01/software/

unzip p6880880_102000_Linux-x86-64.zip

unzip p20299014_10205_Linux-x86-64.zip

(3) root用户

cd /u01/software/

mv OPatch /u01/app/oracle/product/10.2.0/db_1/

(4) oracle用户测试

su - oracle

/u01/app/oracle/product/10.2.0/db_1/OPatch/opatch version

Invoking OPatch 10.2.0.5.1

OPatch Version: 10.2.0.5.1

OPatch succeeded

3. 测试兼容性

su - oracle

$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/software/20299014 -oh $ORACLE_HOME

----------------------------------------------------

Invoking OPatch 10.2.0.5.1

Oracle Interim Patch Installer version 10.2.0.5.1

Copyright (c) 2010, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /u01/app/oracle/product/10.2.0/db_1

Central Inventory : /u01/app/oracle/oraInventory

from           : /etc/oraInst.loc

OPatch version    : 10.2.0.5.1

OUI version       : 10.2.0.5.0

OUI location      : /u01/app/oracle/product/10.2.0/db_1/oui

Log file location : /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/opatch/opatch2016-03-15_12-33-56PM.log

Patch history file: /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/opatch/opatch_history.txt

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

五、实施打补丁PSU

1. 关闭数据库

1)关闭数据库

sqlplus / as sysdba;

shutdown immediate;

2)关闭监听

$ lsnrctl stop

3. oracle database打补丁,还是用同一个补丁包

su - oracle

/u01/app/oracle/product/10.2.0/db_1/OPatch/opatch napply -oh $ORACLE_HOME -local /u01/software/20299014

***************************************************************

Do you want to proceed? [y|n]

y

User Responded with: Y

Email address/User Name:

You have not provided an email address for notification of security issues.

Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]:  y

...

Is the local system ready for patching? [y|n]

y

User Responded with: Y

Verifying the update...

Inventory check OK: Patch ID 20299014 is registered in Oracle Home inventory with proper meta-data.

Files check OK: Files from Patch ID 20299014 are present in Oracle Home.

Running make for target client_sharedlib

Running make for target ikfod

Running make for target ioracle

Running make for target iwrap

Running make for target client_sharedlib

Running make for target proc

Running make for target irman

Running make for target itnslsnr

Execution of 'sh /u01/software/20299014/custom/scripts/post -apply 20299014 ':

Return Code = 0

The local system has been patched and can be restarted.

UtilSession: N-Apply done.

OPatch succeeded.

过程略。

***************************************************************

4. 查看升级状态

[oracle@test ~]$ /u01/app/oracle/product/10.2.0/db_1/OPatch/opatch lsinv

Invoking OPatch 10.2.0.5.1

Oracle Interim Patch Installer version 10.2.0.5.1

Copyright (c) 2010, Oracle Corporation.  All rights reserved.

Oracle Home       : /u01/app/oracle/product/10.2.0/db_1

Central Inventory : /u01/app/oracle/oraInventory

from           : /etc/oraInst.loc

OPatch version    : 10.2.0.5.1

OUI version       : 10.2.0.5.0

OUI location      : /u01/app/oracle/product/10.2.0/db_1/oui

Log file location : /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/opatch/opatch2016-03-21_11-30-15AM.log

Patch history file: /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/opatch/opatch_history.txt

Lsinventory Output file location : /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2016-03-21_11-30-15AM.txt

--------------------------------------------------------------------------------

Installed Top-level Products (3):

Oracle Database 10g                                                  10.2.0.1.0

Oracle Database 10g Release 2 Patch Set 3                            10.2.0.4.0

Oracle Database 10g Release 2 Patch Set 4                            10.2.0.5.0

There are 3 products installed in this Oracle Home.

Interim patches (1) :

Patch  20299014     : applied on Mon Mar 21 11:05:03 CST 2016

Unique Patch ID:  19074368

Created on 24 Jun 2015, 02:35:37 hrs PST8PDT

Bugs fixed:

20074391, 13596521, 17088068, 8865718, 17201047, 13489660, 9020537

8664189, 10091698, 14275629, 19909862, 17832122, 17832123, 17832124

17832125, 16619894, 8822531, 10139235, 20299014, 8350262, 7119382

19274521, 13632738, 11724962, 20331945, 19274523, 9320130, 16961614

16961615, 13775862, 16961616, 16961617, 19006757, 16961618, 16961619

18221699, 9399589, 14841459, 9672816, 9499302, 20299021, 9659614, 13632743

9949948, 14220725, 8882576, 7612454, 7111619, 9711859, 9714832, 12780098

13561951, 14665116, 11066597, 16703112, 19231857, 17721717, 9713537

14459552, 19458377, 13737773, 13737775, 16212405, 18096714, 16338983

14390396, 10249537, 19006849, 7115910, 8354642, 7602341, 14076510

12565867, 15987029, 16462834, 18641419, 11693109, 14023636, 9024850

8394351, 8224558, 17082365, 14149782, 9109487, 14841558, 9171933

10173237, 16817117, 10068982, 10306945, 8666117, 11725006, 10214450

14205448, 17082371, 9767674, 16306019, 9323583, 9726739, 16279211

8412426, 10326338, 10165083, 6651220, 9145204, 13554409, 11076894

19854436, 11893577, 17865671, 16746190, 14492313, 14492314, 11814891

14492315, 14492316, 16742123, 21048089, 16864562, 14546638, 12419258

16056270, 10010310, 18139709, 9689310, 9390484, 21048090, 21048091

9963497, 12551700, 16362358, 12551701, 17465584, 12551702, 12551703

12551704, 10076669, 12551705, 16270946, 12551706, 12551707, 6076890

9308296, 12551708, 14258925, 12880299, 17381900, 18641451, 17381901

17381902, 11790175, 12796518, 9772888, 8650138, 17056813, 14469008

12551710, 10092858, 7519406, 9821321, 8771916, 13349665, 7509714

10159846, 13257247, 18031728, 18641461, 16372203, 11792865, 19007266

19309466, 16309604, 16309605, 16309606, 18522511, 8966823, 11674645

17551414, 15877957, 15877958, 7026523, 15877959, 17716305, 13503598

18767250, 9150282, 9448311, 10327179, 14774730, 19153980, 9735237

9952230, 15877960, 15877961, 15877962, 15877963, 8660422, 18221700

18221701, 16279401, 14546673, 14105702, 14105703, 14105704, 13483152

14269955, 17285560, 12925532, 12748240, 9694101, 12862186, 12862187

14727319, 8211733, 9586877, 9548269, 6694396, 7710224, 9337325, 11856395

10157402, 15950541, 19699191, 6402302, 10327190, 10269717, 13015379

10017048, 8546356, 13561750, 8821114, 9770451, 9360157, 8488233, 10132870

4180770, 9532911, 7361418, 6157713, 9184754, 8544696, 17850678, 8277300

13343467, 16382448, 13791364, 12419392, 10208905, 20236416, 20236417

20236418, 20236419, 7450366, 8970313, 6690853, 6011045, 10162036, 10248542

9469117, 13359623, 9952270, 13343471, 9842573, 17381899, 12710774

20558005, 10324526, 9322219, 8636407, 12828105, 19289642, 13736501

9824435, 13736502, 18681879, 13736503, 13736504, 13736505, 13736506

9032322, 13736507, 14035825, 19769505, 11858315, 14040433, 13916709

12827745, 14038805, 19567242, 16721594, 13923855, 19567243, 8528171

9072105, 19567244, 11737047

--------------------------------------------------------------------------------

OPatch succeeded.

[oracle@test ~]$ $ORACLE_HOME/OPatch/opatch lsinv -bugs_fixed  |grep SPU

17832122   20299014  Mon Mar 21 11:05:03 CST 2016   DB-10.2.0.5-MOLECULE-058-SPUJAN2014

17832123   20299014  Mon Mar 21 11:05:03 CST 2016   DB-10.2.0.5-MOLECULE-059-SPUJAN2014

17832124   20299014  Mon Mar 21 11:05:03 CST 2016   DB-10.2.0.5-MOLECULE-060-SPUJAN2014

17832125   20299014  Mon Mar 21 11:05:03 CST 2016   DB-10.2.0.5-MOLECULE-061-SPUJAN2014

17850678   20299014  Mon Mar 21 11:05:03 CST 2016   DB-10.2.0.5-MOLECULE-062-SPUJAN2014

18221699   20299014  Mon Mar 21 11:05:03 CST 2016   DB-10.2.0.5-MOLECULE-063-SPUAPR2014

18221700   20299014  Mon Mar 21 11:05:03 CST 2016   DB-10.2.0.5-MOLECULE-064-SPUAPR2014

18221701   20299014  Mon Mar 21 11:05:03 CST 2016   DB-10.2.0.5-MOLECULE-065-SPUAPR2014

18767250   20299014  Mon Mar 21 11:05:03 CST 2016   DB-10.2.0.5-MOLECULE-066-SPUJUL2014

19567242   20299014  Mon Mar 21 11:05:03 CST 2016   DB-10.2.0.5-MOLECULE-067-SPUOCT2014

19567243   20299014  Mon Mar 21 11:05:03 CST 2016   DB-10.2.0.5-MOLECULE-068-SPUOCT2014

19567244   20299014  Mon Mar 21 11:05:03 CST 2016   DB-10.2.0.5-MOLECULE-069-SPUOCT2014

20236416   20299014  Mon Mar 21 11:05:03 CST 2016   DB-10.2.0.5-MOLECULE-070-SPUJAN2015

20236417   20299014  Mon Mar 21 11:05:03 CST 2016   DB-10.2.0.5-MOLECULE-071-SPUJAN2015

20236418   20299014  Mon Mar 21 11:05:03 CST 2016   DB-10.2.0.5-MOLECULE-072-SPUJAN2015

20236419   20299014  Mon Mar 21 11:05:03 CST 2016   DB-10.2.0.5-MOLECULE-073-SPUJAN2015

21048089   20299014  Mon Mar 21 11:05:03 CST 2016   DB-10.2.0.5-MOLECULE-074-SPUJUL2015

21048090   20299014  Mon Mar 21 11:05:03 CST 2016   DB-10.2.0.5-MOLECULE-075-SPUJUL2015

21048091   20299014  Mon Mar 21 11:05:03 CST 2016   DB-10.2.0.5-MOLECULE-076-SPUJUL2015

5. 升级数据库字典

cd $ORACLE_HOME/rdbms/admin

sqlplus /nolog

SQL> CONNECT / AS SYSDBA

SQL> STARTUP

SQL> @catbundle.sql psu apply

SQL> -- Execute the next statement only if this is the first PSU applied for 10.2.0.5 or this is the first PSU applied since 10.2.0.5.3.

SQL> @utlrp.sql

升级后检查

SQL> set line 200

SQL> col ACTION_TIME for a30

SQL> col ACTION for a20

SQL> col NAMESPACE for a10

SQL> col VERSION for a20

SQL> col BUNDLE_SERIES for a5

SQL> col COMMENTS for a25

SQL> select * from dba_registry_history;

ACTION_TIME                    ACTION               NAMESPACE  VERSION                      ID BUNDL COMMENTS

------------------------------ -------------------- ---------- -------------------- ---------- ----- -------------------------

21-316 10.47.16.102814 VIEW RECOMPILE                                          8289601       view recompilation

21-316 10.47.16.167852 UPGRADE              SERVER     10.2.0.5.0                            Upgraded from 10.2.0.4.0

21-316 11.09.17.948626 jvmpsu.sql           SERVER     10.2.0.5.2OJVMBP              0       RAN jvmpsu.sql

21-316 11.09.52.682715 jvmpsu.sql           SERVER     10.2.0.5.2OJVMBP              0       RAN jvmpsu.sql

21-316 11.15.00.366608 APPLY                SERVER     10.2.0.5                     19 PSU   PSU 10.2.0.5.19

5 rows selected.

SQL>

升级成功。

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值