Monday, January 5, 2009

Oracle Upgrade after Script

SQL> STARTUP UPGRADE

SQL> SPOOL patch.log

SQL> @$ORACLE_HOME/rdbms/admin/catupgrd.sql

SQL> SPOOL OFF

SQL> SHUTDOWN

SQL> STARTUP

SQL> @ORACLE_HOME/rdbms/admin/utlrp.sql


/orahome/oracle/product/10.2.0/rdbms/admin/utlrp.sql

No comments:

Post a Comment

Followers

About Me

My photo
N.Delhi, Delhi, India
I am an Oracle Certified Professional, Oracle 9i/10G DBA, having 4+ years of core DBA experience.