CentOS下Oracle 10g 升级至10.2.0.4

2014-11-24 17:55:49 · 作者: · 浏览: 0

单实例环境


1,停进程


2,安装补丁


3,升级数据库


1>停止所有Oracle相关进程


[oracle@node2 Disk1]$ emctl stop dbconsole


[oracle@node2 Disk1]$ lsnrctl stop


SQL>shutdown immediate


2>安装补丁步骤


升级至10.2.0.4


下载包:p6810189_10204_Linux-x86


使用DBUA升级。


[oracle@linux Disk1~]$ ./runInstaller




安装图像界面。


运行root.sh 脚本


[root@node2 db]# sh root.sh


Running Oracle10 root.sh script...


The following environment variables are set as:


ORACLE_OWNER= oracle


ORACLE_HOME= /u01/app/oracle/product/10.2.0/db


Enter the full pathname of the local bin directory: [/usr/local/bin]: y


The file "dbhome" already exists in y. Overwrite it (y/n)


[n]: y


Copying dbhome to y ...


The file "oraenv" already exists in y. Overwrite it (y/n)


[n]: y


Copying oraenv to y ...


The file "coraenv" already exists in y. Overwrite it (y/n)


[n]: y


Copying coraenv to y ...


Entries will be added to the /etc/oratab file as needed by


Database Configuration Assistant when a database is created


Finished running generic part of root.sh script.


Now product-specific root actions will be performed.


3>升级数据库