·¢²©ÎÄ
huaihe0410

http://blog.chinaunix.net/space.php?uid=10597892

ŬÁ¦,¼á³Ö,³É°ÜÔÚ´Ë   
¸öÈË×ÊÁÏ
  • ²©¿Í·ÃÎÊ£º496294
  • ²©ÎÄÊýÁ¿£º255
  • ²©¿Í»ý·Ö£º10010
  • ²©¿ÍµÈ¼¶£ºÉϽ«
  • ×¢²áʱ¼ä£º2008-01-24 15:18:39
¶©ÔÄÎҵIJ©¿Í
  • ¶©ÔÄ
  • ¶©Ôĵ½Ïʹû
  • ¶©Ôĵ½×¥Ïº
  • ¶©Ôĵ½Google
×ÖÌå´óС£º´ó ÖРС²©ÎÄ
·ÖÀࣺ oracle

Îå¡¢×Ü½á £­ ¼°ÆäËû˵Ã÷/TIPS/ÎÄÖÐÌáµ½µÄÓÐÓýű¾£º

´ÓÉÏÃæµÄÅäÖü°²âÊÔÎÒÃÇ¿ÉÒÔ¿´µ½£¬Ö»ÒªÕÆÎÕÁËÓ¦ÓóÌÐòµÄÆô¶¯¡¢¹Ø±Õ¡¢¼ì²éµÄ·½·¨£¬ÎÒÃǾÍÍêÈ«¿ÉÒÔ
ÀûÓÃOracle CRSÀ´´î½¨Ò»°ãÓ¦ÓóÌÐòµÄ¸ß¿ÉÓü¯Èº£¬´Ó¶ø±£Ö¤ÁËÒµÎñµÄÁ¬ÐøÐÔ¡£

1.¼òµ¥´íÎó´¦Àí£ºÈç¹ûÔÚʵʩ»ò²âÊÔ¹ý³ÌÖÐÃüÁîʧ°Ü£¬»òÕßÓдíÎóÐèÒª»ØÍË״̬£¬
»òÕßɾ³ý×ÊÔ´¼°Ïà¹ØÐÅÏ¢£¬¿ÉÒÔʹÓÃÏÂÃæµÄ¼¸¸öÃüÁ
crs_stop -f db
crs_unregister db
crs_profile -delete db

´íÎó¶þ£ºÎÒÔÚÉÏÃæÆô¶¯ÐéÄâIP×ÊÔ´µÄʱºò±¨´í£º
root@rac01 # crs_start ¨Call
¡­.
Attempting to start `havip` on member `rac01`
`havip` on member `rac01` has experienced an unrecoverable failure.
Human intervention required to resume its availability.
¡­..
²é¿´crsÈÕÖ¾£º
2008-01-10 17:30:22.526: [ CRSRES][1580] startRunnable: setting CLI values 2008-01-10 17:30:22.527: [ CRSRES][1580] Attempting to start `dg` on member `rac01` 2008-01-10 17:30:22.589: [ CRSRES][1581] startRunnable: setting CLI values 2008-01-10 17:30:22.629: [ CRSRES][1581] Attempting to start `havip` on member `rac01` 2008-01-10 17:30:22.688: [ CRSAPP][1581] StartResource error for havip error code = 1 2008-01-10 17:30:22.749: [ CRSAPP][1581] StopResource error for havip error code = 1 2008-01-10 17:30:22.757: [ CRSRES][1581] X_OP_StopResourceFailed : Stop Resource failed (File: rti.cpp, line: 1796 2008-01-10 17:30:22.758: [ CRSRES][1581][ALERT] `havip` on member `rac01` has experienced an ... 2008-01-10 17:30:22.758: [ CRSRES][1581] Human intervention required to resume its availability. 2008-01-10 17:30:23.211: [ CRSRES][1580] Start of `dg` on member `rac01` succeeded.
Õâʱºò·¢ÏÖÔÚÊäÈëÍø¿¨Ê±ºò²»Ð¡ÐÄÊäÈëÁË´íÎóµÄÍø¿¨Ãû³Æ£¬¹«¹²Íø¿¨Ãû³ÆÓ¦¸ÃÊÇe1000g0£¬
½á¹ûʹÓõÄbge0£¬Ê¹ÓÃÏÂÃæÃüÁîÐÞ¸Ä
root@rac01 # crs_profile -update havip -o oi=e1000g0
ÔÙ´ÎÆô¶¯×ÊÔ´³É¹¦¡£

2.ÎÄÖеÄsysdbaÃüÁîÊÇÎÒϰ¹ßÓõÄalias£¬ÐèÒªÔÚoracleµÄ.bash_profile»òÕß.profileÖÐÌí¼Ó£º
alias sysdba="sqlplus '/as sysdba'"
ÎÄÖеÄÃüÁîcrs_start/crs_stop/crs_profile/crs_registerµÈÃüÁîλÓÚ$CRS_HOME/bin/Ŀ¼Ï£¬
ΪÁËʹÓ÷½Ã棬һ°ãÐèÒªÊÖ¹¤½«¸ÃPATHÌí¼Óµ½rootºÍoracleµÄPATH»·¾³±äÁ¿ÖÐÈ¥¡£

3.´ÅÅÌ×éµÄÆô¶¯¡¢¹Ø±Õ¡¢¼à²â½Å±¾db.sh
#!/bin/sh # ***************************************************************** # shahand 2008-1-3 SCRIPT=$0 ACTION=$1 # Action (start, stop or check) DG_NAME=oradata12 VOL_NAME=oradata case $1 in 'start') /
Ç×£¬Äú»¹Ã»ÓеǼ,Çë[µÇ¼]»ò[×¢²á]ºóÔÙ½øÐÐÆÀÂÛ