10.1.0.X.0 TO 10.2.0.4.0 1. Install 10.2.0.1.0 software The software can be downloaded from the following link : http://www.oracle.com/technology/software/products/database/index.html https://metalink2.oracle.com/metalink/plsql/showdoc?db=NOT&id=169706.1&blackframe=1 : Oracle? Database Installation and Configuration Requirements Quick Reference (8.0.5 to 11.1) 2. Install the 10.2.0.4.0 patchset on top of 10.2.0.1.0 ORACLE_HOME Patchset number is : 6810189 http://updates.oracle.com/download/6810189.html 3. Upgrade the database to 10.2.0.4.0 https://metalink2.oracle.com/metalink/plsql/showdoc?db=NOT&id=419550.1&blackframe=1 : Different Upgrade Methods For Upgrading Your Database https://metalink2.oracle.com/metalink/plsql/showdoc?db=NOT&id=316889.1&blackframe=1 : Complete checklist for manual upgrades to 10gR2 REFERENCE: List of fixes included in 10.2.0.4 https://metalink2.oracle.com/metalink/plsql/showdoc?db=NOT&id=401436.1&blackframe=1 Known issues and alerts affecting 10.2.0.4 https://metalink2.oracle.com/metalink/plsql/showdoc?db=NOT&id=555579.1&blackframe=1 升级过程: 1.如果是全新安装的数据库,直接运行补丁包就可以了 p6810189_10204_Linux-x86.zip ./runInstaller 2.如果是已经创建了数据库,并且有应用在上面,则先停止相关应用 再按以下步骤执行: 0)shutdown 数据库,并停止所有oracle相关的服务和stop listener . $ isqlplusctl stop $ emctl stop dbconsole $ lsnrctl stop 注意： 需要停止Distributed Transaction Coordinator服务/iis服务/web publish(www)/; 1)冷备份数据库 2)运行安装补丁程序 3)startup upgrade; lsnrctl start 3.1)修改java_pool_size / large_pool_size=150M 4)运行脚本@rdbms/admin/catupgrd.sql 5)shutdown immediate 6)startup 7)运行脚本@rdbms/admin/utlrp.sql; # @rdbms/admin/catalog.sql; # @rdbms/admin/catproc.sql; 8)--察看数据库安装的组件、版本、状态: col comp_name format a30 col version format a30 col status format a10 SELECT comp_name, version, status FROM dba_registry; PS: Chmod -R 777 /u01 -->改变权限 Chmod oracle /u01 -->改变文档所有者 When I execute the runInstaller for the patchset it gives me: Checking operating system version: must be redhat-3, SuSE-9, SuSE-10, redhat-4, redhat-5, UnitedLinux-1.0, asianux-1, asianux-2 or asianux-3 Failed <<<< I already had set /etc/redhat-release to: redhat-5 What needs editing is these files: /etc/issue /etc/issue.net /etc/redhat-release In those files you will put this: Red Hat Enterprise Linux Server release 5 (Tikanga) Kernel /r on an /m "Tikanga" is for 5.0 only If your running 5.1 you need to substitute the name for it. The same applys to also CentOS version 4, you substitute the appropriate line. After your Oracle DB or Oracle App is installed change them back. an other way to resolve this is to use the switch -ignoreSysPrereqs when starting the installer
转载于:https://www.cnblogs.com/zlja/archive/2009/10/27/2450004.html
相关资源：oracle10.2.0.1升10.2.0.4.4