오라클코리아

1.Restart Version (Standalone)

1) grid 중단 (by grid)

$ crsctl stop has

2) grid unlock (by root)

# $GRID_HOME/crs/install/roothas.pl -unlock

 <- 11g

# $GRID_HOME/crs/install/roothas.has -unlock

 <- 12.1 ~

3) config.o file rename (bygrid)

$ ls -l $GRID_HOME/rdbms/lib/config.o

$ mv $GRID_HOME/rdbms/lib/config.o $GRID_HOME/rdbms/lib/config.o_bak

$ ls -l $GRID_HOME/rdbms/lib/config.o*

4) elink 작업

$ relink all

 <- grid

$ relink all

 <- database

5) grid unlock 작업 (by root)

# $GRID_HOME/rdbms/install/rootadd_rdbms.sh

# $GRID_HOME/crs/install/roothas.pl -patch

 <- 11g

# $GRID_HOME/crs/install/roothas.sh -postpatch

 <- 12.1 ~

2.RAC (Rolling 으로 가능)

1) grid 중단 (by grid)

$ crsctl stop crs

 <- 11g 기준이며, 12c 이후에는 unlock 만 해도 Grid 중단이 같이 됨

2) grid unlock (by root)

# cd $GRID_HOME/crs/install

# perl rootcrs.pl -unlock

 <- 11g

# $GRID_HOME/crs/install/rootcrs.sh -unlock

 <- 12c ~

# $GRID_HOME/crs/install/rootcrs.sh -prepatch

 <- 12c ~ , 그리고 Grid가 기동되어 있는 상태에서 사용해야 함. 또한 둘다 동시에 하려면 -nonrolling 옵션을 사용 해야 함.

3)  relink 작업

$ relink all

 <- grid

$ relink all

 <- database

4) grid unlock 작업 (by root)

# $GRID_HOME/rdbms/install/rootadd_rdbms.sh

# $GRID_HOME/crs/install/rootcrs.pl -patch

 <- 11g

# $GRID_HOME/crs/install/roothas.sh -patch

 <- 12.1

# $GRID_HOME/crs/install/roothas.sh -lock

# $GRID_HOME/bin/crsctl start crs

 <- 12.2 ~

# $GRID_HOME/crs/install/roothas.sh -postpatch

 <- 12c ~ , 그리고 Grid를 자동으로 기동 하게 됨 unlock 할때 -nonrolling 옵션을 사용 했으면 동일하게 옵션 필요.

0. Patch 충돌 여부 체크

- For Grid Infrastructure Home, as home user:
% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/%BUGNO%/%OCW TRACKING BUG%
% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/%BUGNO%/%ACFS TRACKING BUG%
% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/%BUGNO%/%DB WLM TRACKING BUG%
% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/%BUGNO%/%DB RU TRACKING BUG%
% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/%BUGNO%/%TOMCAT RU TRACKING BUG%

- For Database home, as home user:
% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/%BUGNO%/%OCW TRACKING BUG%
% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/%BUGNO%/%DB RU TRACKING BUG%

1. Stop the CRS managed resources running from DB homes.

 - GI HOME 환경이면, DB HOME 계정으로 아래 수행 한다. (ORACLE)

  $ <ORACLE_HOME>/bin/srvctl stop home -o <ORACLE_HOME> -s <status file location> -n <node name>

 - Oracle Restart Home 환경이면, DB HOME 계정으로 아래 수행 한다. (ORACLE)

  $ <ORACLE_HOME>/bin/srvctl stop home -o <ORACLE_HOME> -s <status file location>

2. Run the pre root script.

 - GI HOME 환경이면, DB HOME 계정으로 아래 수행 한다. (root)

  # <GI_HOME>/crs/install/rootcrs.sh -prepatch

 - Oracle Restart Home 환경이면, DB HOME 계정으로 아래 수행 한다. (root)

  # <GI_HOME>/crs/install/roothas.sh -prepatch

3. Patch GI home.

 - GI HOME OWNER 로 수행 한다 (grid)

  $ <GI_HOME>/OPatch/opatch apply -oh <GI_HOME> -local <UNZIPPED_PATCH_LOCATION>/%BUGNO%/%OCW TRACKING BUG%

  $ <GI_HOME>/OPatch/opatch apply -oh <GI_HOME> -local <UNZIPPED_PATCH_LOCATION>/%BUGNO%/%ACFS TRACKING BUG%

  $ <GI_HOME>/OPatch/opatch apply -oh <GI_HOME> -local <UNZIPPED_PATCH_LOCATION>/%BUGNO%/%DB WLM TRACKING BUG%

  $ <GI_HOME>/OPatch/opatch apply -oh <GI_HOME> -local <UNZIPPED_PATCH_LOCATION>/%BUGNO%/%DB RU TRACKING BUG%

  $ <GI_HOME>/OPatch/opatch apply -oh <GI_HOME> -local <UNZIPPED_PATCH_LOCATION>/%BUGNO%/%TOMCAT RU TRACKING BUG% 

4. Patch DB home.

 - DB HOME OWNER 로 수행 한다 (oracle)

  $ <UNZIPPED_PATCH_LOCATION>/%BUGNO%/%OCW TRACKING BUG%/custom/scripts/prepatch.sh -dbhome <ORACLE_HOME>

  $ <ORACLE_HOME>/OPatch/opatch apply -oh <ORACLE_HOME> -local <UNZIPPED_PATCH_LOCATION>/%BUGNO%/%OCW TRACKING BUG%

  $ <ORACLE_HOME>/OPatch/opatch apply -oh <ORACLE_HOME> -local <UNZIPPED_PATCH_LOCATION>/%BUGNO%/%DB RU TRACKING BUG%

  $ <UNZIPPED_PATCH_LOCATION>/%BUGNO%/%OCW TRACKING BUG%/custom/scripts/postpatch.sh -dbhome <ORACLE_HOME> 

5. Run the post script.

 - root 계정으로 수행한다.
  # <GI_HOME>/rdbms/install/rootadd_rdbms.sh

 - GI HOME 환경이면, DB HOME 계정으로 아래 수행 한다. (root)
  # <GI_HOME>/crs/install/rootcrs.sh -postpatch
 - Oracle Restart Home 환경이면, DB HOME 계정으로 아래 수행 한다. (root)
  # <GI_HOME>/crs/install/roothas.sh -postpatch

6. If the message, A system reboot is recommended before using ACFS is shown, then a reboot must be issued before continuing. Failure to do so will result in running with an unpatched ACFS\ADVM\OKS driver.

7.    Start the CRS managed resources that were earlier running from DB homes.
 - GI HOME 환경이면, DB HOME 계정으로 아래 수행 한다. (ORACLE)
  $ <ORACLE_HOME>/bin/srvctl start home -o <ORACLE_HOME> -s <status file location> -n <node name>
 - Oracle Restart Home 환경이면, DB HOME 계정으로 아래 수행 한다. (ORACLE)
  $ <ORACLE_HOME>/bin/srvctl start home -o <ORACLE_HOME> -s <status file location>

8. For each database instance running on the Oracle home being patched, run the datapatch utility as described in next table.

1.  /etc/oraInst.loc (AIX and Linux) or /var/opt/oracle/oraInst.loc (Platform specific) 생성

inventory_loc=<location_for_oraInventory>
inst_group=<name_of_group_for_installtion>
Example:
inventory_loc=/u01/oracle/oraInventory
inst_group=oinstall
 
2. 기존 OraInventory 삭제 
% mv oraInventory oraInventory_orig
 
3. OUI 디렉토리로 이동
% cd $ORACLE_HOME/oui/bin
 
4. OraInventory 생성 
% ./runInstaller -silent -ignoreSysPrereqs -attachHome ORACLE_HOME="<Oracle_Home_Location>" ORACLE_HOME_NAME="<Name_Of _Oracle_Home>"
For Example:
ORACLE_HOME=/u01/app/oracle/product/10.2.0.3
ORACLE_HOME_NAME=OraDb10g_home1
% ./runInstaller -silent -ignoreSysPrereqs -attachHome ORACLE_HOME="/u01/app/oracle/product/10.2.0.3" ORACLE_HOME_NAME="OraDb10g_home1"
 
■ 참조문헌
Steps To Recreate Central Inventory(oraInventory) In RDBMS Homes (Doc ID 556834.1)
Steps to Recreate Central Inventory in Real Applications Clusters (Doc ID 413939.1)

해당 기능을 이용시 Patch 가 적용 되어 있는 Image File 생성이 가능 합니다. 
아래 명령어는 19c 에서 RU10 을 적용한 환경에서 만들었습니다.

■ 사용방법 

Grid 계정에서 수행

$GRID_HOME/gridSetup.sh -silent -createGoldImage -exclFiles $ORACLE_HOME/log -destinationLocation /backup/grid_gold_image

Oracle 계정에서 수행
$ORACLE_HOME/runInstaller -silent -createGoldImage -exclFiles $ORACLE_HOME/log  -destinationLocation /backup/db_gold_image

■  option 

■ 참조문서

docs.oracle.com/en/database/oracle/oracle-database/19/ladbi/setup-wizard-installation-options.html#GUID-30C45B5F-58A3-4D4C-8475-40093C51650B