1,到oracle metalink下载oracle 1204 patch for oracle 1201 x86介质包
2,ftp上述包到安装有oracle 1201的节点(注:请以oracle用户上传,之后unzip it)
3,在patch节点查看oracle 1201实例是否运行,监听器是否运行,asm实例是否运行,css进程是否运行,若运行,依次关闭它们
ps -ef|grep ora_
sqlplus '/as sysdba'
shutdown immediate
exit
ps -ef|grep +ASM
sqlplus '/as sysdba'
shutdown immediate
exit
lsnrctl status --如开启,lsnrctl stop
以root用户关闭ocssd进程
/etc/init.d/init.cssd stop
Stopping CSSD.
Shutting down CSS daemon.
Shutdown request successfully issued.
Shutdown has begun. The daemons should exit soon.
-bash-3.00# ps -ef|grep ocss --查看是否关闭
root 3891 3852 0 00:48:54 pts/4 0:00 grep ocss
4,cd 解压后的Disk1下,运行./runinstaller
5,升级结束,会提示运行一个root.sh(脚本作用,配置相关信息用于dbca,启动用于asm的ocssd进程),运行一切完事
6,启库(注:asm也同时升级到了1204)
相关小结:
1,在最后打完patch,打开数据库时,请加上upgrade选项,操作如下:
sqlplus '/as sysdba'
startup upgrade
2,startup upgrade启库后,运行如下出错
SQL> select count(*) from dba_objects where status='INVALID';
select count(*) from dba_objects where status='INVALID'
*
ERROR at line 1:
ORA-04030: out of process memory when trying to allocate 123404 bytes (QERHJ
hash-joi,kllcqas:kllsltba)
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/9240380/viewspace-621099/
,如需转载,请注明出处,否则将追究法律责任。