Thursday, April 7, 2011

Upgrade Oracle 10.2.0.1 to 10.2.0.2

1. Stop all Oracle processes
2. Get Oracle patch, extract and install
3. Do as follow to upgrade: 
cd $ORACLE_HOME/rdbms/admin
sqlplus "/as sysdba"
SQL>startup upgrade;
SQL>@catupgrd.sql
SQL>shutdown immediate;
SQL>startup;
SQL>@utlrp.sql

No comments:

Post a Comment