For more details visit>>
The steps for a manual upgrade to the Oracle database 10g database version are briefly listed here, and they are discussed in more detail in the following sections:
1) Create a spool file
SQL > SPOOL upgrade.log
2) Log in as a user with the SYSDBA privilege, and run the Pre-Upgrade Information tool.
SQL>@$ORACLE_HOME/rdbms/admin/utlu102i.sql
To check the results of pre-upgrade check turn spooling off
SQL> spool off
Check the upgrade.log spool file to see if we meet all upgrade requirements. Mkae all the changes pointed out by the Pre-Upgrade information tool before proceeding with the upgrade.
3) Backup the database we are going to upgrade using RMAN or user-managed backup techniques
4) Copy the current init.ora file to its default location in the new Oracle database 10gR2 home($ORACLE_HOME/dba). We should make changes that the pre-upgrade information tool recommended. Remove all the obsolete and deprecated parameters and add new parameters such as SGA_TARGET,which automates shared memory management.
5) Shut down the database and restart it under the new Oracle 10g home in the STARTUP UPGRADE mode
SQL> connect sys/
SQL> STARTUP UPGRADE
6) Create the required SYSAUX tablespace
SQL > CREATE TABLESPACE sysaux DATAFILE '/u10/oradata/prod/sysaux01.dbf'
SIZE 500M REUSE EXTENT MANAGEMENT LOCAL SEGMENT SPACE
MANAGEMENT AUTO;
The database is now technically converted into an Oracle database 10g version, as shown by the following query:
SQL > select * from V$VERSION;
7) Run the catupgrd.sql upgrade script
8) Check to see if any objects became invalidated during the database upgrade process
SQL> select count(*) from dba_objects where status='INALID';
9) Run the utlrp.sql script to recompile any objects that became invalid during the database upgrade
SQL> @$ORACLE_HOME/rdbms/admin/utlrp.sql
To check that there aren't any invalid objects left,we should run the check again:
SQL> select count(*) dba_objects where status='INVALID';
The query should return 0 rows.
Once it has validated all the invalid objects the utlrp.sql script validates each individual component in the database and updates the DBMS_SERVER_REGISTRY view.
10) Run the Post-Upgrade Status tool
SQL>@$ORACLE_HOME/rdbms/admin/utlu102s.sql
the tool determines the upgrade status of each database component by querying the DBA_SERVER_REGISTRY view. It tells us how upgrade went. If we don't clrly upgrade a component the tool will tell what we have to do to fix the problem.
11) End the spool file
SQL > spool OFF
12) Shutdown and startup the new database
SQL > SHUTDOWN IMMEDIATE
SQL> STARTUP
For more details visit>>
Upgrading Manually
