Oracle9201 upgrade to 9204(solaris)

Posted: 三月 4, 2011 in Uncategorized

首先,将下载的PATCH压缩文件解开:
$ unzip p3095277_9204_SOLARIS64.zip
$ cpio -idmv <p3095277_9204_SOLARIS64.cpio
SQL>startup upgrade
SQL> spool patch.log
SQL> @?/rdbms/admin/catpatch.sql
SQL> spo off
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 2635568784 bytes
Fixed Size 734864 bytes
Variable Size 486539264 bytes
Database Buffers 2147483648 bytes
Redo Buffers 811008 bytes
Database mounted.
Database opened.
检查patch.log文件,如果没有出现什么错误,则patch安装成功。
如果建立了多个数据库,则需要对每个数据库都执行catpatch.sql

发表评论

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