cd $ORACLE_HOME/rdbms/admin
sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> STARTUP
SQL> @catbundle.sql psu apply
SQL> -- Execute the next statement only if this is the first PSU applied for 10.2.0.5 or this is the first PSU applied since 10.2.0.5.3.
SQL> @utlrp.sql
升级后检查
SQL> set line 200
SQL> col ACTION_TIME for a30
SQL> col ACTION for a20
SQL> col NAMESPACE for a10
SQL> col VERSION for a20
SQL> col BUNDLE_SERIES for a5
SQL> col COMMENTS for a25
SQL> select * from dba_registry_history;
ACTION_TIME ACTION NAMESPACE VERSION ID BUNDL COMMENTS
------------------------------ -------------------- ---------- -------------------- ---------- ----- -------------------------
21-316 10.47.16.102814 VIEW RECOMPILE 8289601 view recompilation
21-316 10.47.16.167852 UPGRADE SERVER 10.2.0.5.0 Upgraded from 10.2.0.4.0
21-316 11.09.17.948626 jvmpsu.sql SERVER 10.2.0.5.2OJVMBP 0 RAN jvmpsu.sql
21-316 11.09.52.682715 jvmpsu.sql SERVER 10.2.0.5.2OJVMBP 0 RAN jvmpsu.sql
21-316 11.15.00.366608 APPLY SERVER 10.2.0.5 19 PSU PSU 10.2.0.5.19