ת:ÀûÓÃOracle CRS´î½¨Ó¦Óõĸ߿ÉÓü¯Èº-5
(2008-02-20 11:35)
·ÖÀࣺ 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ÈÕÖ¾£º
Õâʱºò·¢ÏÖÔÚÊäÈëÍø¿¨Ê±ºò²»Ð¡ÐÄÊäÈëÁË´íÎóµÄÍø¿¨Ãû³Æ£¬¹«¹²Íø¿¨Ãû³ÆÓ¦¸ÃÊÇ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
´ÓÉÏÃæµÄÅäÖü°²âÊÔÎÒÃÇ¿ÉÒÔ¿´µ½£¬Ö»ÒªÕÆÎÕÁËÓ¦ÓóÌÐòµÄÆô¶¯¡¢¹Ø±Õ¡¢¼ì²éµÄ·½·¨£¬ÎÒÃǾÍÍêÈ«¿ÉÒÔ
ÀûÓÃ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.
![]()
½á¹ûʹÓõÄ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')
/
²©¿ÍÍÆ¼öÎÄÕÂ
- [Oracle] ORA-03113´íÎó·ÖÎöÓë½â¾ö (11Сʱǰ)
- ·Ö²¼Ê½ÄÜÔ´·¢µç²¢ÍøÎÊÌâµÃµ½½â¾ö (12Сʱǰ)
- Çå½àÄÜÔ´ÔÚµçÁ¦Ïû·ÑÖÐÓдýÌá¸ß (12Сʱǰ)
- ÂãÉ豸RAC»·¾³£¬Ôö¼Óredo log groupºÍmember (14Сʱǰ)
- (Steven Adms)oracle8i internal services for waits, latches, locks (14Сʱǰ)



