오라클코리아

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.