Oracle 10g upgrade from 10.2.0.1 to 10.2.0.4-优快云博客

本文详细介绍了如何使用DBUA工具将数据库版本从10.2.0.1升级到10.2.0.4的过程。包括下载patchset、关闭数据库、安装patchset、执行升级脚本、检查确认升级状态等关键步骤。同时，提供了升级后的检查和配置步骤，确保数据库正常运行。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

新安装了一台数据库服务器，版本是10.2.0.1的，因为现在最新的是10.2.0.4的。版本低了，bug多。所以就对数据库做了一个升级。

服务器是windows2003的系统，都是可视话操作。下一步的问题。10.2.0.4的patchset里面也有详细的安装说明。之做个总结，是因为这次用了DBUA工具，以前做升级，都是用脚本来的。这次常个新鲜。基本步骤还是差不多。

升级步骤如下：

1.从metalink上下载10.2.0.4的patchset，编号是：p6810189

2.关闭数据库，做个冷备份，防止安装失败。

3.安装patchset软件,这里要注意，ORACLE_HOME要和以前的一样。

4.执行脚本或者用DBUA工具

5.检查确认升级是否成功。

下面是readme上面的说明：

UpgradingaRelease10.2Database

Afteryouinstallthepatchset,youmustperformthefollowingstepsoneverydatabaseassociatedwiththeupgradedOraclehome:

Note:

Ifyoudonotrunthecatupgrd.sqlscriptasdescribedinthissectionandyoustartupadatabasefornormaloperation,thenORA-01092:ORACLEinstanceterminated.DisconnectionforcederrorswilloccurandtheerrorORA-39700:databasemustbeopenedwithUPGRADEoptionwillbeinthealertlog.

1.Loginwithadministratorprivileges.

2.ForOracleRACinstallations,startlisteneroneachnodeoftheclusterasfollows:

C:/>ORACLE_BASE/ORACLE_HOME/bin/srvctlstartlistener-nnode

3.IfyouareusingAutomaticStorageManagement,starttheAutomaticStorageManagementinstance.

4.Forsingle-instanceinstallations,startthelistenerasfollows:

C:/>lsnrctlstart

5.Forsingle-instanceinstallations,useSQL*PlustologintothedatabaseastheSYSuserwithSYSDBAprivileges:

C:/>sqlplus/NOLOG

SQL>CONNECTSYSASSYSDBA

Enterpassword:SYS_password

Usersofsingle-instanceinstallationsnowproceedtostep7.

6.ForOracleRACinstallations:

A.UseSQL*PlustologintothedatabaseastheSYSuserwithSYSDBAprivileges:

C:/>sqlplus/NOLOG

SQL>CONNECTSYSASSYSDBA

Enterpassword:SYS_password

SQL>STARTUPNOMOUNT

B.SettheCLUSTER_DATABASEinitializationparametertoFALSE:

SQL>ALTERSYSTEMSETCLUSTER_DATABASE=FALSESCOPE=spfile;

C.Shutdownthedatabase:

SQL>SHUTDOWN

7.EnterthefollowingSQL*Pluscommands:

SQL>STARTUPUPGRADE

SQL>SPOOLpatch.log

SQL>@ORACLE_BASE/ORACLE_HOME/rdbms/admin/catupgrd.sql

SQL>SPOOLOFF

8.Reviewthepatch.logfileforerrorsandinspectthelistofcomponentsthatisdisplayedattheendofcatupgrd.sqlscript.

ThislistprovidestheversionandstatusofeachSERVERcomponentinthedatabase.

9.Ifnecessary,rerunthecatupgrd.sqlscriptaftercorrectinganyproblems.

10.Restartthedatabase:

SQL>SHUTDOWNIMMEDIATE

SQL>STARTUP

11.Runtheutlrp.sqlscripttorecompileallinvalidPL/SQLpackagesnowinsteadofwhenthepackagesareaccessedforthefirsttime.Thisstepisoptionalbutrecommended.

SQL>@ORACLE_BASE/ORACLE_HOME/rdbms/admin/utlrp.sql

Note:

Whenthe10.2.0.4patchsetisappliedtoanOracleDatabase10gStandardEditiondatabase,theremaybe54invalidobjectsaftertheutlrp.sqlscriptruns.Theseobjectsbelongtotheunsupportedcomponentsanddonotaffectthedatabaseoperation.

Ignoreanymessagesindicatingthatthedatabasecontainsinvalidrecyclebinobjectssimilartothefollowing:

BIN$4lzljWIt9gfgMFeM2hVSoA==$0

12.Runthefollowingcommandtocheckthestatusofallthecomponentsaftertheupgrade:

SQL>SELECTCOMP_NAME,VERSION,STATUSFROMSYS.DBA_REGISTRY;

Intheoutputoftheprecedingcommand,thestatusofallthecomponentsshouldbeVALIDforasuccessfulupgrade.

13.IfyouareusingtheOracleRecoveryManagercatalog,enterthefollowingcommand:

C:/>rmancatalogusername/password@alias

RMAN>UPGRADECATALOG;

14.ForOracleRACinstallations:

A.SettheCLUSTER_DATABASEinitializationparametertoTRUE:

SQL>ALTERSYSTEMSETCLUSTER_DATABASE=TRUESCOPE=spfile;

B.Restartthedatabase: