Patch and Upgrade DB 11.1.0.6 to 11.1.0.7

Manual patch dan upgrade tanpa dbua 11g:
1. set ORACLE_BASE, ORACLE_HOME, ORACLE_SID
2. matikan
listener (lsnrctl stop),
console (emctl stop dbconsole),
database (shutdown immediate)
3. ./runInstaller
4. check opatch
$ORACLE_HOME/Opatch/opatch lsinventory -detail
5.
SQL> STARTUP UPGRADE
SQL> SPOOL upgrade_info.log
SQL> @?/rdbms/admin/utlu111i.sql
SQL> SPOOL OFF

6.
SQL> STARTUP UPGRADE
SQL> SPOOL patch.log
SQL> @?/rdbms/admin/catupgrd.sql
SQL> SPOOL OFF

7. check error di file patch.log
8.
SQL> SHUTDOWN IMMEDIATE
SQL> STARTUP
9. recompile
SQL> @?/rdbms/admin/utlrp.sql
10. check status registry (harus valid semua)
SQL> SELECT COMP_NAME, VERSION, STATUS FROM SYS.DBA_REGISTRY;