Linux 10G Upgrade from 10.2.0.1 to 10.2.0.5 briefly

Upgrade Linux 10g from 10.2.0.1 to 10.2.0.5

1 Pre-Check 
-Get OS bit and version
#getconf LONG_BIT    
#uname -a

-Check DB component verision
sqlplus / as sysdba
set linesize 200
col comp_name for a50
select comp_name,version,status from dba_registry;

--Stop service
lsnrctl stop
emctl stop dbconsole
shutdown immediate

2 Pre-upgrade Backup

-DB backup
rman full backup or cold backup

-Binary backup
$cd $ORACLE_HOME
$cd ../

$tar -cvf  10.2.0.1.tar db_1

-Related file backup

$cp -p /etc/oraInst.loc /etc/oraInst.loc.10.2.0.1

#cd /usr/local/bin
#cp -p coraenv coraenv.10.2.0.1
#cp -p dbhome dbhome.10.2.0.1
#cp -p oraenv oraenv.10.2.0.1

3 Upgrade process

--Binary upgrade
./runInstaller


--DB upgrade

-Comand upgrade
sqlplus / as sysdba
startup upgrade
spool patch.log
@?/rdbms/admin/catupgrd.sql
spool off

shutdown immediate
startup
spool recompile.log
@?/rdbms/admin/utlrp.sql
spool off

-DBUA upgrade

4 Verification

set linesize 200
col comp_name for a50
select comp_name,version,status from dba_registry;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/27064837/viewspace-746042/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/27064837/viewspace-746042/