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博客

Linux 10G Upgrade from 10.2.0.1 to 10.2.0.5 briefly

最新文章