ORACLE RAC DOWN»úÎÊÌâ·ÖÎö
Author: Rainny
Date: 2010-3-5
Ò»£¬Ö¢×´ÃèÊö
2¸ö½ÚµãµÄORACLE 10G RAC£¬¸ôÒ»¶Îʱ¼äÆäÖеÄÒ»¸öNODE¾Í»áDOWN»ú¡£½Úµã´ÓCLUSTERÖб»ÇýÖð¡£
¶þ£¬Õï¶Ï¹ý³Ì
Rac1±»Öð³ö£¬RAC2´æ»î£¬RAC2½Ó¹ÜÁËRAC1µÄVIP£¬ÎÒÃÇÀ´²é¿´RAC2µÄÏà¹ØLOG¡£
Ê×ÏȲ鿴RAC2µÄ¸æ¾¯ÈÕÖ¾£º..\log\rac2\alertrac2.log:
2010-03-05 14:39:50.750
[cssd(7089)]CRS-1607:CSSD evicting node rac1. Details in /u01/crs/oracle/product/10/app/log/rac2/cssd/ocssd.log.
2010-03-05 14:39:51.893
[cssd(7089)]CRS-1601:CSSD Reconfiguration complete. Active nodes are rac2 .
2010-03-05 14:40:17.122
[crsd(8429)]CRS-1204:Recovering CRS resources for node rac1.
ÔÙ¼ì²éCSSµÄLOG£º/u01/crs/oracle/product/10/app/log/rac2/cssd/ocssd.log
[ CSSD]2010-03-05 14:38: 52.611 [3062369200] >TRACE: clssnmPollingThread: node rac1 (1) missed(4) checkin(s)
--ÖмäÊ¡ÂÔ50¶àÐÐ--
[ CSSD]2010-03-05 14:39:47.739 [3062369200] >TRACE: clssnmPollingThread: node rac1 (1) missed(59) checkin(s)
--´ÓÉÏÃæÎÒÃÇ·¢ÏÖ£¬CSSD´ÓVOTING DISK¶ÁÈ¡½ÚµãÐÅϢʱ£¬·¢ÏÖ½ÚµãRAC1 MISS£¬Ö±µ½¶ÁÁË60Ãëºó£¬ÅжÏRAC1¿ÉÄÜËÀµô£¬
--¿ªÊ¼·¢ÆðÇýÖ𣬽«RAC1´ÓCLUSTERÖÐÖð³ö
[ CSSD]2010-03-05 14:39:48.741 [3062369200] >TRACE: clssnmPollingThread: Eviction started for node rac1 (1), flags 0x000f, state 3, wt4c 0
[ CSSD]2010-03-05 14:39:48.741 [3041389488] >TRACE: clssnmDoSyncUpdate: Initiating sync 3
[ CSSD]2010-03-05 14:39:48.741 [3041389488] >TRACE: clssnmSetupAckWait: Ack message type (11)
[ CSSD]2010-03-05 14:39:48.741 [3041389488] >TRACE: clssnmSetupAckWait: node(1) is ALIVE
[ CSSD]2010-03-05 14:39:48.741 [3041389488] >TRACE: clssnmSetupAckWait: node(2) is ALIVE
[ CSSD]2010-03-05 14:39:48.741 [3041389488] >TRACE: clssnmSendSync: syncSeqNo(3)
[ CSSD]2010-03-05 14:39:48.742 [70884272] >TRACE: cls
Ïà¹ØÎĵµ£º
ÔÚSQL SERVER 20000ÖзÃÎÊOracleÊý¾Ý¿â·þÎñÆ÷µÄ¼¸ÖÖ·½·¨
1.ͨ¹ýÐм¯º¯Êýopendatasource
ÒªÇó:±¾µØ°²×°Oracle¿Í»§¶Ë
select * from opendatasource('MSDAORA', 'Data Source=XST4;User ID=manager;Password=sjpsjsjs')..MISD.PBCATCOL
ÆäÖУ¬MSDAORAÊÇOLEDB FOR OracleµÄÇý¶¯£¬
×¢Òâ:Óû§ÃûºÍ±íÃûÒ»¶¨Òª´óС£¬·þÎñÆ÷ºÍ ......
1.»ù±¾½á¹¹
CREATE OR REPLACE PROCEDURE ´æ´¢¹ý³ÌÃû×Ö
(
²ÎÊý1 IN NUMBER,
²ÎÊý2 IN NUMBER
) IS
±äÁ¿1 INTEGER :=0;
±äÁ¿2 DATE;
BEGIN
END ´æ´¢¹ý³ÌÃû×Ö
2.SELECT INTO STATEMENT
½«select²éѯµÄ½á¹û´æÈëµ½±äÁ¿ÖУ¬¿ÉÒÔͬʱ½«¶à¸öÁд洢¶à¸ö±äÁ¿ÖУ¬±ØÐëÓÐÒ»Ì ......
--´´½¨¶ÔÏóÀàÐÍ
create or replace type emp_typ as object (
id number,
name varchar2(30),
sal number,
comm number,
member procedure change_comm(new_comm number),
member function get_info return varchar2
) ;
--´´½¨¶ÔÏóÀàÐ͹¹Ô캯Êý¶¨Òå
create or replace type body emp_typ is
member proce ......
±³¾°£ºÔÚwindows2003serverÉÏ°²×°ÁËOracle9.2.0.1.0£¬ÏÖ´òË㽫ÆäÉý¼¶µ½9.2.0.8°æ±¾£¬²¢´òÉÏ×îÐµİ²È«²¹¶¡April2008°æ¡£
1.Éý¼¶oracle£¨administratorÓû§È¨ÏÞ£©
(1)µ½metalinkÏÂÔØÉý¼¶Ñ¹Ëõ°ü£¬patchºÅΪ4547809£¬Ñ¹Ëõ°üÃû³ÆΪ p4547809_92080_WINNT.zip£¬for windows 32bit¡£
(2)½âѹËõzip£¬Ï±߰üº¬Ò»¸ö ......