ITPub博客

首页 > Linux操作系统 > Linux操作系统 > oracle 9204--->9208 升级小计

oracle 9204--->9208 升级小计

原创 Linux操作系统 作者:mhaoy 时间:2009-10-10 16:12:58 0 删除 编辑
oracle 9204--->9208 升级小计
 
/usr/sbin/slibclean

./runInstaller
When prompted $ORACLE_HOME/root.sh
STARTUP
ALTER SYSTEM SET SHARED_POOL_SIZE='150M' SCOPE=spfile;
ALTER SYSTEM SET JAVA_POOL_SIZE='150M' SCOPE=spfile;
 SHARED_POOL_SIZE and the JAVA_POOL_SIZE  set 150M
 
SQL> SHUTDOWN

STARTUP MIGRATE
SQL> STARTUP MIGRATE
SQL> SPOOL patch.log
SQL> @?/rdbms/admin/catpatch.sql
SQL> SPOOL OFF
check patch.log
If necessary, rerun the catpatch.sql script. after correcting any problems.
Restart the database:
SQL> SHUTDOWN
SQL> STARTUP
SQL> @?/rdbms/admin/utlrp.sql
cd $ORACLE_HOME/install
changePerm.sh
_____________________________________________________________________
remove patch set
$ sqlplus /nolog
SQL> CONNECT SYS/SYS_password AS SYSDBA
SQL> SHUTDOWN (Required only for Single Instance)
SQL> STARTUP MIGRATE
SQL> SPOOL catbkout.out
SQL> @?/rdbms/admin/catbkout.sql
SQL> SPOOL OFF
SQL> SHUTDOWN IMMEDIATE
______________________________________________________________________
reinstall patch set
$ sqlplus /nolog
SQL> CONNECT SYS/SYS_password AS SYSDBA
SQL> STARTUP MIGRATE
SQL> SPOOL catpatch.out
SQL> @?/rdbms/admin/catpatch.sql
SQL> SPOOL OFF

SQL> alter session set current_schema = mdsys;
SQL> @?/md/admin/prvtmd.plb
SQL> @?/md/admin/prvtmd2.plb
SQL> @?/md/admin/sdopidx.sql
SQL> @?/md/admin/prvtpidx.plb
SQL> @?/md/admin/prvtsidx.plb
SQL> @?/md/admin/sdogeom.sql
SQL> @?/md/admin/prvt3glh.plb
SQL> @?/md/admin/prvtgeom.plb
SQL> @?/md/admin/prvt3gl.plb
SQL> alter session set current_schema = sys;
SQL> SHUTDOWN IMMEDIATE
SQL> STARTUP
SQL> @?/rdbms/admin/utlrp.sql

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/15149581/viewspace-616231/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2009-05-13

  • 博文量
    54
  • 访问量
    94844