Re: 오늘의 마지막 문제. grid 환경에서 패치

[22기_정민수]

-- 오늘의 마지막 문제.  위의 패치 작업이 성공적으로 완료되는지 확인하시오
-- ASM확경에서의 OPath 작업

-- 1. 사전 점검
[sql]
-- 버전 체크
SELECT * FROM v$version;


-- TEMP 테이블 스페이스 경로 체크.
SELECT tablespace_name, file_name FROM dba_temp_files;
/*
TABLESPACE_NAME                 FILE_NAME
------------------------------ ------------------------------------------------
TEMP                            +DATA/ORCL/TEMPFILE/temp.268.1227121675
*/
-- 작업을 위한 TEMP 테이블 스페이스 공간 확보.
ALTER DATABASE TEMPFILE '+DATA/ORCL/TEMPFILE/temp.268.1227121675' RESIZE 2048M;

[shell]
df -h # 여유공간 확인.

-- 2. 패치 작업을 위한 디렉토리 구축 & 패치파일 업로드 및 압축해제
[shell]
# 작업계정: oracle
# 1) 작업 폴더 생성
mkdir -p /home/oracle/patch_1926
cd /home/oracle/patch_1926

# 2) 'Oracle_Patch_19.26.zip' 업로드 후 1차 압축 해제
unzip Oracle_Patch_19.26.zip

# 3) RU 본체(대용량) 2차 압축 해제
cd /home/oracle/patch_1926/Oracle_Patch_19.26/RU
unzip p37257886_190000_Linux-x86-64.zip


-- 3. OPatch 업데이트
[shell]
# DB_HOME OPatch 업데이트
mv $ORACLE_HOME/OPatch $ORACLE_HOME/OPatch_old 

unzip /home/oracle/patch_1926/Oracle_Patch_19.26/Opatch/*.zip -d $ORACLE_HOME
$ORACLE_HOME/OPatch/opatch version


# Grid_HOME OPatch 업데이트
sudo mv $GRID_HOME/OPatch $GRID_HOME/OPatch_old
sudo unzip /home/oracle/patch_1926/Oracle_Patch_19.26/Opatch/*.zip -d $GRID_HOME

sudo chown -R oracle:oinstall $GRID_HOME/OPatch
sudo chmod -R 755 $GRID_HOME/OPatch

$GRID_HOME/OPatch/opatch version

-- 4. 통합 바이너리 패치 적용 (opatchauto)
# 작업 계정: root
export PATH=$PATH:/app/grid/OPatch

cd /home/oracle/patch_1926
unset ORACLE_HOME

# 1) 패치 충돌 사전 검사(시뮬레이션)
opatchauto apply /home/oracle/patch_1926/Oracle_Patch_19.26/RU/37257886/37260974 -analyze

# 2) 실제 패치 적용 (시간 소요)
opatchauto apply /home/oracle/patch_1926/Oracle_Patch_19.26/RU/37257886/37260974

# 완료 시 터미널 마지막에 아래 문구 확인
# OPatchauto session completed successfully


-- 5.딕셔너리 업데이트(Datapatch)
[shell]
# 작업 계정: oracle
$ORACLE_HOME/OPatch/datapatch -verbose

-- 로그 확인
tail -f /app/oracle/cfgtoollogs/sqlpatch/sqlpatch_27241_2026_03_06_10_01_51/sqlpatch_invocation.log

-- 6. 검수
[sql]
SELECT * FROM v$version;


-- OPactch_old 삭제
[shell]
# 작업 계정: oracle
rm -rf $ORACLE_HOME/OPatch_old
sudo rm -rf $GRID_HOME/OPatch_old