Home > Administration, Database Upgrade, Step by Step Documentation > Applying 11.1.0.7 PSU (Patch Set Update) to 11.1.0.6 Database

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

  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: