oracle database upgrade from 10.2.0.3 to 10.2.0.5

Upgrade From 10.2.0.3 to 10.2.0.5

On Standalone Machine (Non RAC):

 Step1. Take full backup.(You can choose your own way to take full backup, below script will take full backup through RMAN)

Export ORACLE_SID=kpdb

Oracle@ /u01/rman_bak/kpdb>rman target /

run{

sql 'alter system archive log current';

CONFIGURE DEFAULT DEVICE TYPE TO DISK;

CONFIGURE RETENTION POLICY TO REDUNDANCY 2;

CONFIGURE BACKUP OPTIMIZATION ON;

CONFIGURE CONTROLFILE AUTOBACKUP ON;

CONFIGURE DEVICE TYPE DISK PARALLELISM 2;

CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/u01/rman_bak/kpdb/ora_df%t_s%s_s%p';

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/u01/rman_bak/kpdb/ora_cf%F';

backup as compressed backupset incremental level 0 database tag 'RMAN_FULL_BACKUP' format '/u01/rman_bak/kpdb/ora_df_%d_%s_%p';

backup as compressed backupset archivelog all not backed up 1 times FORMAT '/u01/rman_bak/kpdb/ora_arch_%d_%s_%p';

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO  '/u01/rman_bak/kpdb/ora_cf_%F';

}

STEP2: Take 10.2.0.3 Home and Inventory backup:

cd $ORACLE_HOME

Make below command as per your need:

tar cvf – .|gzip -c >  /u01/oracle10_Home_bak/Oracle_Home10g_`hostname`_`date +%Y%m%d`.tar.gz

cd $ORACLE_BASE/oraInventory

tar cvf – .|gzip -c >  /u01/oracle10_inv_bak/Oracle_OraInventory10g_`hostname`_`date +%Y%m%d`.tar.gz

The above two commands will create a file named “Oracle*” along with its hostname followed by the current time stamp and the binaries and inventory gets tarred and gzipped.

STEP3: Install 10g software and upgrade to 10.2.0.5 in another home.

++Now Upgrade database to new Oracle home.++

STEP4A:

  Shutdown all database instance.

· Stop listener(s)

  Change the entries in oratab

· Copy and modify init.ora for relevant database.

 ·Copy password file to New Home

· Copy tnsnames and sqlnet.ora to new ORACLE_HOME location

STEP4B: 

Startup  database in the UPGRADE mode from new installed home:

SQL> STARTUP UPGRADE

Spool all to a log file:

SQL> SPOOL preupgrade_info.log

Run the Pre-Upgrade Tool to check any prerequisites if left:

SQL> @/rdbms/admin/utlu102i.sql

SQL> SPOOL OFF

Enter the following SQL*Plus commands:

SQL> SPOOL patch_upgrade.log

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

SQL> SPOOL OFF

Restart the database:

SQL> Shu immediate

SQL> startup

Startup listener.

lsnrctl start

lsnrctl status

Run the utlrp.sql script to recompile all invalid PL/SQL packages.

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

 Run the following command to check the status of all the components after the upgrade:

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

COMP_NAME                                VERSION                        STATUS

—————————————-           ——————————          ———–

Oracle Enterprise Manager                10.2.0.5.0                     VALID

Spatial                                            10.2.0.5.0                     VALID

Oracle interMedia                            10.2.0.5.0                     VALID

OLAP Catalog                                 10.2.0.5.0                     VALID

Oracle XML Database                      10.2.0.5.0                     VALID

Oracle Text                                     10.2.0.5.0                     VALID

Oracle Expression Filter                   10.2.0.5.0                     VALID

Oracle Rule Manager                       10.2.0.5.0                     VALID

Oracle Workspace Manager             10.2.0.5.0                     VALID

Oracle Data Mining                          10.2.0.5.0                     VALID

Oracle Database Catalog Views        10.2.0.5.0                     VALID

 

COMP_NAME                                VERSION                        STATUS

—————————————- —————————— ———–

Oracle Database Packages and Types       10.2.0.5.0                     VALID

JServer JAVA Virtual Machine             10.2.0.5.0                     VALID

Oracle XDK                               10.2.0.5.0                     VALID

Oracle Database Java Packages            10.2.0.5.0                     VALID

OLAP Analytic Workspace                  10.2.0.5.0                     VALID

Oracle OLAP API                          10.2.0.5.0                     VALID

 

NOTE: Must follow README doc for installation.

Request you all to put your valuable comments on  posts of  this blog, will motivate me to write more good post. smiley

You can skip to the end and leave a response. Pinging is currently not allowed.

Leave a Reply