linux平台下oracle从10.2.0.1升级到10.2.0.4
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
