Thursday, November 17, 2016

RDBMS --- Upgrading a Single Instance Oracle Database from to using DBUA /Linux

In this post, I will give you a quick example about upgrading an Oracle Database from to in Linux 64 bit platform.
This blog post is written to show you the upgrade work required for upgrading a single instance Oracle Database, which is running on a cooked filesystem(non ASM) , to

In this blog post , we 'll go through an out of place upgrade process, because; Oracle strongly recommends that we should not upgrade Oracle Database to release or using an existing Oracle home.

Note that, the upgrade method demostrated here is for an example TEST environment, this method may change (at least minor changes may be required) according to your env. However, this blog post is useful for taking a look at the upgrade process, which is actually pretty straightforward and easy once we know what we are doing.

We download " PATCH SET FOR ORACLE DATABASE SERVER" using Patch 13390677 from Oracle Support.
Note that, this patch includes Oracle Database, ASM, Grid, Oracle RAC and so on.

We download 7 zip files and their descriptions are as follows; Oracle Database (includes Oracle Database and Oracle RAC) Oracle Database (includes Oracle Database and Oracle RAC) Oracle Grid Infrastructure (includes Oracle ASM, Oracle Clusterware, and Oracle Restart) Oracle Database Client Oracle Gateways Oracle Examples Deinstall

We create a directory for installing our Oracle home and configure its privileges accordingly(i.e chown -R oracle:dba)

we unzip the zip files, and execute the runInstaller from the <unzipped_directory>/database via a X windows session.

We follow the installer screens and install Oracle RDBMS as Software Only.

We run utlu112i.sql in the database which needs to be upgraded. (we run the utlu112i.sql located in new Oracle Home, but we run it when our environment is set to the old Oracle Home.)

We take corrective action by analyzing the output/spool file of utlu112i.sql.


Corrective Actions reported in a demo environment:
exec dbms_stats.gather_dictionary_stats;

We backup our source database . (only db backup, oracle home backup is not required as wer are doing an out-of-place upgrade)
Note that, DBUA provides backup options as well.

Next, we run dbua from the new Oracle Home and upgrade our database following the screens, as shown in the following example screenshots..
Note that, we shutdown our source database before executing dbua, but dbua can handle thse stop/start things as well.

Lastly, we check the difference between newly created spfile and the old spfile. We ensure nothing important is changed there.
--Note that, DBUA creates the new spfile according to the old spfile, but still checking is a good thing to do.

Lastly, we review te Post Upgrade section of the following document and take necessary action if our environment requires us to do so.

Oracle Database Upgrade Guide

No comments :

Post a Comment