1. Shut down the database
SQL> shut immediate
2. Stop the listener
$ lsnrctl stop
3. Unzip the patchset and run OUI
$ ./runinstaller
4. Start the listener
$ lsnrctl start
5. Run the following commnads
SQL> STARTUP UPGRADE
SQL> SPOOL patch.log
SQL> @?/rdbms/admin/catupgrd.sql
SQL> SPOOL OFF
6. Restart the database
SQL> SHUT IMMEDIATE
SQL> STARTUP
7. Run the utlrp.sql script to recompile all invalid PL/SQL packages
SQL> @?/rdbms/admin/utlrp.sql
No comments:
Post a Comment