'RAC patch'에 해당되는 글 2건

  1. 2015.11.04 RAC Patch 작업
  2. 2008.04.16 Oracle RAC patch 후 startup 안될때.

2015. 11. 4. 16:12 오라클

RAC Patch 작업


패치작업 11.2.0.4.8 (2015.10)

 

BUG 21523375- GRID INFRASTRUCTURE SYSTEM PATCH 11.2.0.4.8 contains

 

BUG 21352635  -DATABASE PATCH SET UPDATE 11.2.0.4.8 (INCLUDES CPUOct2015)
BUG 21352649 - OCW PATCH SET UPDATE 11.2.0.4.8
BUG 21352642 - ACFS PATCH SET UPDATE 11.2.0.4.8

 

DB Patch Number : 21352635
OCW PATCH       : 21352649
ACFS PATCH      : 21352642

Oracle Grid Infrastructure Patch Set Update 11.2.0.4.8 (Includes Database PSU 11.2.0.4.8)
-------------------------------------

GRID_HOME, ORACLE_HOME 을 개별로 각각 할때

 

작업전 slibclean

(root 유저)
# /oragrid/product/11.2.0.4/crs/install/rootcrs.pl -unlock (CRS 가 떠 있으면 script로 자동으로 내려버림)


(grid 유저)
/oragrid/product/11.2.0.4/OPatch/opatch napply -oh /oragrid/product/11.2.0.4 -local /arch/21523375/21352649
/oragrid/product/11.2.0.4/OPatch/opatch napply -oh /oragrid/product/11.2.0.4 -local /arch/21523375/21352642
/oragrid/product/11.2.0.4/OPatch/opatch apply -oh /oragrid/product/11.2.0.4 -local /arch/21523375/21352635

 

(oracle 유저)
/arch/21523375/20831122/custom/server/20831122/custom/scripts/prepatch.sh -dbhome /oracle/product/11.2.0.4 (권한체크)
/oracle/product/11.2.0.4/OPatch/opatch napply -oh /oracle/product/11.2.0.4 -local /arch/21523375/21352649/custom/server/21352649
/oracle/product/11.2.0.4/OPatch/opatch apply -oh /oracle/product/11.2.0.4 -local /arch/21523375/21352635
/arch/21523375/20831122/custom/server/20831122/custom/scripts/postpatch.sh -dbhome /oracle/product/11.2.0.4 (권한체크)

 

(root 유저)
# /oragrid/product/11.2.0.4/rdbms/install/rootadd_rdbms.sh
# /oragrid/product/11.2.0.4/crs/install/rootcrs.pl -patch (script로 자동으로 CRS를 올려 버림)


[롤백하는 경우]


GI Home
(root로)
# /oragrid/product/11.2.0.4/crs/install/rootcrs.pl -unlock

 

(grid 유저로)
/oragrid/product/11.2.0.4/OPatch/opatch rollback -local -id 21352649 -oh /oragrid/product/11.2.0.4
/oragrid/product/11.2.0.4/OPatch/opatch rollback -local -id 21352642 -oh /oragrid/product/11.2.0.4 
/oragrid/product/11.2.0.4/OPatch/opatch rollback -local -id 21352635  -oh /oragrid/product/11.2.0.4

 

(oracle 유저로)
/arch/21523375/20831122/custom/server/20831122/custom/scripts/prepatch.sh -dbhome /oracle/product/11.2.0.4
/oracle/product/11.2.0.4/OPatch/opatch rollback -local -id 21352649 -oh /oracle/product/11.2.0.4
/oracle/product/11.2.0.4/OPatch/opatch rollback -local -id 21352635  -oh /oracle/product/11.2.0.4
/arch/21523375/20831122/custom/server/20831122/custom/scripts/postpatch.sh -dbhome /oracle/product/11.2.0.4

 

Run post script
(root로)
# /oragrid/product/11.2.0.4/rdbms/install/rootadd_rdbms.sh
# /oragrid/product/11.2.0.4/crs/install/rootcrs.pl -patch

 

사후작업

 

cd $ORACLE_HOME/rdbms/admin
sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> STARTUP
SQL> @catbundle.sql psu apply
SQL> QUIT

저작자표시 비영리 변경금지
Posted by pat98

2008. 4. 16. 09:53 오라클

Oracle RAC patch 후 startup 안될때.




RAC 환경에서 patch 후 한쪽 노드가 올라오지 않을때.
alert.log 나 udump, cdump 등에도 특별한 로그는 남지 않음. 올리면 아래와 같이 나오기만 하고 난감함.

ORA-00469: CKPT process terminated with error
ORA-07445: exception encountered: core dump [] [] [] [] [] []

9i or 10g 상관없이 에러 발생함.

잘 찾아보면 1번 노드에는 $ORACLE_HOME/rdbms/lib/libknlopt.a 화일이 있으나 2번에는 없음.

수동으로 동일한 위치에 copy 해주고 (DB 내리고 할것) 다시 relink 해주면 한방에 올라옴.

요로코롬 해결하면 됨. 자세한 방법은 아래의 metalink 문서 참조.

==================================================================================================

Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 10.2.0.2
This problem can occur on any platform.
After installing any One-off patch in RAC nodes, one of those nodes may fail to start the instance.


NOTE: We did observe the similar problem on 10.2.0.2 RAC installations where certain libraries are not copied from the installing node to other RAC nodes. For such type of problem while performing installation, please refer to the following note.

Note 363840.1 - 10.2.0.2 RAC: ORA-7445 in KKXSYN or KKXCMS ON ALL NODES BUT INSTALL NODE

Symptoms

Oracle Instance does not startup on one of RAC the nodes after installing any One-off Patch.

If you see the alert and trace log files, you may see the following errors:

ORA-00469: CKPT process terminated with error

ORA-07445: exception encountered: core dump [] [] [] [] [] []

Cause

It was noted that the resulting 'Oracle' binaries on different nodes were not the same. Running a cksum on all involved libraries in lib/ and rdbms/lib/, it was evident that libknlopt.a was different across nodes. The object modules that get into libknlopt.a however are identical, so it clearly appears that libknlopt.a isn't relinked on nodes other than the installation one.

Solution

Copy the good library in the faulty node and manually re-link the Oracle again.

Ensure all instances are shut down !

Manually copy good $ORACLE_HOME/rdbms/lib/libknlopt.a from the local node to all remote faulty nodes and relink Oracle again on all faulty nodes.

eg: cd $ORACLE_HOME/rdbms/lib
make -f ins_rdbms.mk ioracle

Posted by pat98
이전버튼 1 이전버튼
05-09 04:31
Flag Counter
Yesterday
Today
Total

글 보관함

최근에 올라온 글

달력

 « |  » 2024.5
일 월 화 수 목 금 토
1 2 3 4
5 6 7 8 9 10 11
12 13 14 15 16 17 18
19 20 21 22 23 24 25
26 27 28 29 30 31

최근에 달린 댓글

티스토리툴바