签到成功

知道了

CNDBA社区CNDBA社区

linux平台下oracle从10.2.0.1升级到10.2.0.4

2016-11-25 15:57 889 0 原创 Oracle 11g
作者: Dave

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.cndba.cn/Dave/article/1252

https://www.cndba.cn/Dave/article/1252
https://www.cndba.cn/Dave/article/1252
https://www.cndba.cn/Dave/article/1252https://www.cndba.cn/Dave/article/1252

 https://www.cndba.cn/Dave/article/1252https://www.cndba.cn/Dave/article/1252https://www.cndba.cn/Dave/article/1252https://www.cndba.cn/Dave/article/1252https://www.cndba.cn/Dave/article/1252

版权声明:本文为博主原创文章,未经博主允许不得转载。

oracle 11g

用户评论
* 以下用户言论只代表其个人观点,不代表CNDBA社区的观点或立场
Dave

Dave

关注

人的一生应该是这样度过的:当他回首往事的时候,他不会因为虚度年华而悔恨,也不会因为碌碌无为而羞耻;这样,在临死的时候,他就能够说:“我的整个生命和全部精力,都已经献给世界上最壮丽的事业....."

  • 1879
    原创
  • 2
    翻译
  • 437
    转载
  • 127
    评论
  • 访问:3440093次
  • 积分:3049
  • 等级:核心会员
  • 排名:第1名
精华文章
    最新问题
    查看更多+
    热门文章
      热门用户
      推荐用户
        Copyright © 2016 All Rights Reserved. Powered by ZhiXinTech · 皖ICP备19020168号·

        QQ交流群