linux平臺下oracle從10.2.0.1升級到10.2.0.4

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 --&gt改變許可權
Chmod oracle /u01 --&gt改變文件所有者
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

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/16978544/viewspace-691833/，如需轉載，請註明出處，否則將追究法律責任。