About DATABASE

오라클

srvctl stop home -o $ORACLE_HOME -s /app/oracle/state_file.state -n rac1

root로
cd /app/11g/grid/crs/install
./rootcrs.pl -unlock

oracle로

/app/11g/grid/OPatch/opatch napply -oh /app/11g/grid/ -local /home/oracle/16459322/

/app/11g/grid/OPatch/opatch apply -oh /app/11g/grid/ -local /home/oracle/16056267

/home/oracle/16459322/custom/server/16459322/custom/scripts/prepatch.sh -dbhome /app/oracle/11g/db

DB패치 oracle로
opatch napply -oh /app/oracle/11g/db -local /home/oracle/16459322/custom/server/16459322

opatch apply -oh /app/oracle/11g/db -local /home/oracle/16056267

/home/oracle/16459322/custom/server/16459322/custom/scripts/postpatch.sh -dbhome /app/oracle/11g/db

root로

cd /app/11g/grid/rdbms/install/

./rootadd_rdbms.sh

cd /app/11g/grid/crs/install

./rootcrs.pl -patch

oracle로

srvctl start home -o $ORACLE_HOME -s /app/oracle/state_file.state -n rac1

###########################################################################################################################

###########################################################################################################################

2번 노드에서

oracle유저로
srvctl stop home -o $ORACLE_HOME -s /app/oracle/state_file.state -n rac2

root로
cd /app/11g/grid/crs/install
./rootcrs.pl -unlock

oracle로

/app/11g/grid/OPatch/opatch napply -oh /app/11g/grid/ -local /home/oracle/16459322/

/app/11g/grid/OPatch/opatch apply -oh /app/11g/grid/ -local /home/oracle/16056267

/home/oracle/16459322/custom/server/16459322/custom/scripts/prepatch.sh -dbhome /app/oracle/11g/db

DB패치 oracle로
opatch napply -oh /app/oracle/11g/db -local /home/oracle/16459322/custom/server/16459322

opatch apply -oh /app/oracle/11g/db -local /home/oracle/16056267

/home/oracle/16459322/custom/server/16459322/custom/scripts/postpatch.sh -dbhome /app/oracle/11g/db

root로

cd /app/11g/grid/rdbms/install/

./rootadd_rdbms.sh

cd /app/11g/grid/crs/install

./rootcrs.pl -patch

oracle로

srvctl start home -o $ORACLE_HOME -s /app/oracle/state_file.state -n rac2

Problems

- 11gR2 GI PSU 설치 작업 시 $GI_HOME의 가용 디스크 공간이 22GB 이하인 상황 (AIX환경)

- PSU 적용 사전 단계에서 Fail 발생 (Prerequisite check “CheckSystemSpace” failed.

   The details are: Required amount of space(22288172004) is not available.)

- $GI_HOME의 가용 디스크 공간이 부족하여 발생함

- 실제로 PSU Patch시 필요한 공간보다 과도하게 가용 디스크 요구

- $GI_HOME Filesystem에 가용한 디스크 공간을 확보

- .patch_storage 디렉토리용 Filesystem을 $GI_HOME용 Filesystem과 분리하고 Symbolic Link 생성하여 가용 디스크 확보

- PSU 적용시 DiskSpace 점검 단계 생략하는 방법

   $ opatch apply OPatch.SKIP_VERIFY_SPACE=true         #auto 옵션에서는 적용 안됨

- .patch_storage 정리하는 방법

   $ opatch util cleanup

- 관련문서

   · opatch CheckSystemSpace Fails With Error Code 73 While Applying GI PSU [ID 1088455.1]

   · How To Avoid Disk Full Issues Because OPatch Backups Take Big Amount Of Disk Space. [ID 550522.1]

- 관련버그

   · Bug 9780505: 11.2_GIPSU2_AIX: REQUIRED SYSTEM SPACE (22G) IS TOO LARGE FOR GI PSU 2 PATCH