ORACLE PATCHSET Upgrade

 

*patch 순서 정리
1. shared_pool_size/java_pool_size=>150M요구
① SYS> show parameter sga_m <-확인
② SYS> shutdown immediate
③ SYS> create pfile from spfile
④ SYS> vi /u01/app/oracle/product/10.2.0/db_1/dbs/initdb01.ora
⑤ sga_max_size=293601280(280*1024*1024=293601280)
⑥ SYS> create spfile from pfile
⑦ SYS> startup
⑧ SYS> show parameter sga_m <-확인
⑨ SYS> alter system set shared_pool_size=100m;
⑩ SYS> alter system set java_pool_size=100m;

2. patch전 서비스 종료
① db shutdown -> SQL*PLUS 종료
② lsnrctl stop -> Listener 종료
③ emctl stop dbsonsole -> emctl 종료
④ root 계정에서
/u01/app/oracle/product/10.2.0/db_1/bin/crsctl stop crs
-> asm 설치할때 필요한 crs입니다.

3. patch 설치 -> ./runinstall
① next
② script 확인
③ y

4. startup upgrade
① export ORACLE_SID=db01 -> 접속
② sqlplus /as sysdba
③ startup upgrade

5. $ORACLE_HOME/rdbms/admin/catupgrd.sql
① @/u01/app/oracle/product/10.2.0/db_1/rdbms/admin/catupgrd.sql

6. shutdown immediate

7. startup

8. $ORACLE_HOME/rdbms/admin/utlrp.sql
-> dba_objects.status의 값이 invalid가 없을 때까지 재실행!!!
① @/u01/app/oracle/product/10.2.0/db_1/rdbms/admin/utlrp.sql
② select status from dba_objects;

[출처] Oracle 10.2.0.1.0 to 10.2.0.4.0 Upgrade (Oracle University (Korea)) |작성자 마이너스