9i to 10g automatic upgrade

9i to 10g Automatic UpGradation

Manual Upgrade
A manual upgrade consists of running SQL scripts and utilities from a command line to upgrade a database to
the new Oracle Database 10g release.

Pre-Requisites
• Backup the 9i database
• Install oracle 10g software

Backup the database

After cleanly shutting down the instance following the analysis of the database, you should perform a full backup of the database. Complete the following steps:

1. Sign on to RMAN:
rman "target / nocatalog"

2. Issue the following RMAN commands:

RUN
{
ALLOCATE CHANNEL chan_name TYPE DISK;
BACKUP DATABASE FORMAT 'some_backup_directory%U' TAG before_upgrade;
BACKUP CURRENT CONTROLFILE TO 'save_controlfile_location';
}
Install oracle 10g software
• An Oracle Database release must be installed in a new Oracle home that is separate from previous releases of Oracle.
• The following are the note required to install the oracle 10g software
1. Releasa notes
2. Installation update notes
3. Installation guide


Database Upgrade Assistant(DBUA)

The Database Upgrade Assistant (DBUA) interactively steps you through the upgrade process and configures the database for the new Oracle Database 10g release. The DBUA automates the upgrade process by performing all of the tasks normally performed manually. The DBUA makes appropriate recommendations for configuration options such as tablespaces and redo logs.

The DBUA provides support for Real Application Clusters (RAC) and Automatic Storage Management (ASM).

Upgrade the Data Base 9i to 10g

• To run the environment file i. e in the ORACLE_BASE of 10g directory.
• Before running environment file to unsure that ORACLE_HOME and
ORACLE_SID is correct.

Using the Database Upgrade Assistant Graphical User Interface

If you installed the new Oracle Database 10g release and specified that you are upgrading an existing database, then the Database Upgrade Assistant is started automatically. However, if you did not specify that you are upgrading an existing database, then you can start the Database Upgrade Assistant independently after
Installation is complete.

In the environment of the new Oracle Database 10g release, start the Database Upgrade Assistant as follows:


Enter the following command at a system prompt:
$dbua

=======================================================
Note: The dbua executable is usually located in ORACLE_HOME/bin.
=======================================================



When the Database Upgrade Assistant starts, its Welcome screen appears. Before the upgrade, the DBUA performs the following steps:


i. Check for any invalid user accounts or roles

ii. Check for any invalid datatypes or invalid objects

iii. Check for any desupported character sets
iv. Check for adequate resources, including rollback segments, tablespaces, and free disk space
v. Check for any missing SQL scripts needed for the upgrade
vi. Optionally, DBUA backs up all necessary files

The DBUA does not begin the upgrade until all of these pre-upgrade steps are completed.


Welcome Screen of the Database Upgrade Assistant





Clike the next

and follow the screen