Oracle10.2.0.1 upgrade to 10.2.0.2(solaris)

Posted: 三月 4, 2011 in Uncategorized

1. unzip p4547817_10202_SOLARIS64.zip
2. sqlplus / as sysdba
sql>shutdown immediate;
sql> exit;
3. lsnrctl stop listener
4.ps -ef |grep ora_
5.$cd DISK1; ./runInstaller
6.# $ORACLE_HOME/root.sh
7.lsnrctl start linstener
8.$sqlplus / as s sysdba; sql>startup upgrade; sql>spool patch.log; sql>@?/rdbms/admin/catupgrd.sql
sql>spool off;
sql>shutdown immediate;
sql>startup;
sql>@?/rdbms/admin/utlrp.sql

note:不过Oracle10.2.0.2有一个严重的bug,就是将libserver10.a错误的安装到了$ORACLE_HOME/rdbms/lib目录下,因此,Oracle强制安装Oracle10.2.0.2后,在安装任何的patch之前,必须安装Patch 5117016,否则会造成严重的错误

$ unzip p5117016_10202_SOLARIS64.zip
$ cd  5117016
$ $ORACLE_HOME/OPatch/opatch apply

然后启动数据库,至此,10.2.0.2补丁安装完毕。

发表评论

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / 更改 )

Twitter picture

You are commenting using your Twitter account. Log Out / 更改 )

Facebook photo

You are commenting using your Facebook account. Log Out / 更改 )

Google+ photo

You are commenting using your Google+ account. Log Out / 更改 )

Connecting to %s