Applying 11.1.0.7 PSU (Patch Set Update) to 11.1.0.6 Database

11.1.0.7 PSU (Patch Set Update) to 11.1.0.6 Database
Pre – Applying checks
1- Take backup your Oracle Home directory
$ tar -cf ora11g.tar ora11g
2- Take full database backup
3- Download p6890831_111070_Linux-x86-64.zip file over Metalink
Applying PSU (patch set update)
1- The time_zone check is very important check. it needs to be made and you can check it with this query;
SQL>SELECT version FROM v$timezone_file;

If you are running anything other than version 4, check MetaLink document 568125.1

2- Shutdown the database
SQL>shutdown database
3- Stop the services
$ emctl stop dbconsole
$ lsnrctl stop
4- Unzip p6890831_111070_Linux-x86-64.zip installation file. Run OUI (Oracle Universal Installer) in terminal

$ unzip p6890831_111070_Linux-x86-64.zip
$ cd Disk1
$ ./runInstaller
On the welcome screen click “Next” button

5- Choose the name of oracle home and click “Next” button.

6- Uncheck “I wish to receive security updates via MetaLink” check box. If you want, you can configure this option after installation.

If you unchecked the check box, you will warned. Click “Yes” to continue.

7- After prerequisite checks you can start the installation.

8- After installation of rdbms PSU you must check permissions of newly created folders on operating system.
Now it is time of database upgrade

9- Pre-upgrade checks

SQL> STARTUP UPGRADE
SQL> SPOOL pre_upgrade_check.log
SQL> @?/rdbms/admin/utlu111i.sql
SQL> SPOOL OFF
Examine the pre_upgrade_check.log file. Examine tablespace sizes and database components status

10- Start database in upgrade mode and run the script catupgrd.sql

$ lsnrctl start
$ sqlplus / as sysdba
SQL> STARTUP UPGRADE
SQL> SPOOL patch.log
SQL> @?/rdbms/admin/catupgrd.sql
SQL> SPOOL OFF
Examine the patch.log file. If there is error then you must solve the problem and rerun catupgrd.sql script.

11- If there is no error, shutdown database and startup normal.

SQL> SHUTDOWN IMMEDIATE
SQL> STARTUP

12- Post-Upgrade checks

SQL> SPOOL post_upgrade_check.log
SQL> @?/rdbms/admin/utlu111s.sql
SQL> SPOOL OFF
Examine post_upgrade_check.log file.

13- After upgrading database, some objects will be invalid. For recompiling run the following script.

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

14- Check the status of database components.

SQL> SELECT COMP_NAME, VERSION, STATUS FROM SYS.DBA_REGISTRY;

Talip Hakan ÖZTÜRK