Migration

Overview:

---------
- We need a migration from 10.2.0.4 to 10.2.0.5

- We need to install

- Patch set (8202632)

- OPatch (6880880_102000)

- PSU (12419392)

Softwares are located at -

zpadt241:/interfaces/oracle_software

(we have unzipped it for Patch set and PSU)



Preparation:

------------

- Shutdown the databases, listeners



Installation and migration:

---------------------------

Patch set Installation

- Open NXclient

- root zpadt241

- sux - oracle

- cd Disk1 and invoke ./runInstaller (follow the steps)

OPatch Installation

- Open putty

- su - oracle

- cd $ORACLE_HOME

- cp -r OPatch OPatch.bkp.07.08.11

- ls -ltr |grep -i OPatch

- mv /interfaces/oracle_software/p6880880_102000_SOLARIS64.zip .

- unzip p6880880_111000_Linux-x86-64.zip

- ls -ltr |grep -i OPatch

- opatch lsinventory

Database migration

- @$ORACLE_HOME/rdbms/admin/utlu102i.sql

- select owner,count(*) from dba_objects where status !='VALID' group by owner;

- startup upgrade

- spool upgrade_07082011.log

- @$ORACLE_HOME/rdbms/admin/catupgrd.sql

- spool off

- shutdown immediate ; startup ( make sure db has to run with spfile, if not, then create spfile and restart db)

- select comp_name,status,version from dba_registry;

- select * from v$version;

- @$ORACLE_HOME/rdbms/admin/utlrp.sql

- select owner,count(*) from dba_objects where status !='VALID' group by owner;

- exec dbms_stats.gather_database_stats(degree=>6,cascade=>true ,estimate_percent=>dbms_stats.auto_sample_size);

- Shutdown databases

PSU Installation

- cd /interfaces/oracle_software/12419392

- follow the README.html

- Apply patch

- Follow the post steps on each databases



Post migration:

---------------

- Startup the databases, listeners

- Make sure that all files and database are in available status

- tnsping and listener are working fine