oracle 9204--->9208 升级小计

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