Red Hat Cluster Suite¼¯Èº OracleÊý¾Ý¿â
Ŀ¼
Ò»¡¢¸ÅÊö
¶þ¡¢Ó²¼þƽ̨´î½¨
Èý¡¢Redhat As4 update2°²×°ÅäÖÃ
ËÄ¡¢Oracle 10g°²×°ÅäÖÃ
Îå¡¢Red Hat Cluster Suite°²×°ÅäÖÃ
Áù¡¢ÏµÍ³Çл»²âÊÔ
Æß¡¢³£ÓÃÃüÁî
Ò»¡¢¸ÅÊö
»ÆµºÊпª·¢Çø²ÆÕþ¾Ö±¾´Î²ÉÓÃÁ½Ì¨IBM X3850£8664·þÎñÆ÷¡¢Ò»Ì¨DS4300ÅÌÕ󣬯½Ì¨²ÉÓÃRedhat As4 update2
½áºÏcluster suite£¬²¿ÊðOracle 10gÊý¾Ý¿â£¬Ðγɸ߿ÉÓÃÐÔÊý¾Ý¼¯ÈºÏµÍ³¡£
²Ù×÷ϵͳ£ºRedhat As4 update2_emt64
¼¯ÈºÈí¼þ£ºrhel-4-u2-rhcs-emt64
Êý¾Ý¿âÈí¼þ£ºOracle 10g for linux64
·þÎñÆ÷£ºIBM X3850£8664
ÅÌÕó£ºDS4300
¶þ¡¢Ó²¼þƽ̨
IBM X3850£8664·þÎñÆ÷ÎªË«Íø¿¨£¬Intelligent Platform Management Interface
(IPMI)ʹÓõÚÒ»¿éÍø¿¨µÄ¶Ë¿Ú£¬RSA IIÔ¶³Ì¹ÜÀí¿¨µ¥¶ÀÒ»¸öÍøÂç¶Ë¿Ú¡£
ÿ¸ö½Úµãͨ¹ý¹âÏËÁ¬½ÓDS4300ÅÌÕó¡£°²×°¹ý³ÌÖÐ×îºÃ°ÑÁ¬½Ó½ÚµãºÍÅÌÕóµÄ¹âÏ˰ÎÏ£»»òÕßÐνçÃæ (X)
o½ÓÊÜĬÈÏÖµ
19.ÅäÖüàÊÓÆ÷
oÐÎÅäÖÃ
o½ÓÊÜĬÈÏÖµ¡£
21.¹§Ï²
o´ÓϵͳÖÐÈ¡³ö°²×°½éÖÊ£¬È»ºóµ¥»÷ ÏÂÒ»²½¡£
22.ϵͳ×Ô¶¯ÖØÐÂÆô¶¯²¢ÏÔʾһ¸öÐµĻ¶ÓÆÁÄ»¡£
oµ¥»÷ÏÂÒ»²½¡£
o¸ù¾ÝÌáʾ¸ü»»¹âÅÌ¡£µÚÎåÕŹâÅ̰²×°Íê³ÉºóÌáʾ²åÈëµØÒ»ÕŹâÅÌ£¬°²×°Íê³ÉºóÖØÐÂÆô¶¯»úÆ÷¡£
23.Ðí¿ÉÐÒé
oÔĶÁÐí¿ÉÐÒé¡£ÐεǼÆÁÄ»¡£
30.¹§Ï²£¡ÄúµÄ Linux Èí¼þÏÖÒѰ²×°Íê±Ï¡£
£¨ËÄ£©¡¢ÅäÖÃÍøÂç(ÔÚÁ½Ì¨»úÆ÷ÉÏ·Ö±ðÖ´ÐÐ)
££rpm -ivh tg3-3.62b-1.src.rpm
££cd /usr/src/redhat
££rpmbuild -bb SPECS/tg3.spec
££rpm -ivh RPMS/<arch>/tg3-<version>.<arch>.rpm
££cd /lib/modules/<kernel_version>/kernel/drivers/net/
££modprobe tg3
££system-config-network
ͨ¹ýͼÐνçÃæÌí¼Óа²×°µÄÍø¿¨£¬²¢ÅäÖõØÖ·Îª192.168.7.21
µÚ¶þ̨»úÆ÷ÅäÖÃÐÂÌí¼ÓÍø¿¨µØÖ·Îª192.168.7.22
ÅäÖÃ/etc/hostsÎļþ£º
#vi /etc/hosts
127.0.0.1 localhost.localdomain localhost
10.28.36.11 kfqcz1
10.28.36.12 kfqcz2
10.28.36.13 share-kfqcz
192.168.7.11 fence-kfqcz1
192.168.7.12 fence-kfqcz2
ÆäÖÐ10.28.36.13Ϊcluster¸¡¶¯ipµØÖ·£¬192.168.7.11¡¢192.168.7.12ΪfenceµØÖ·
£¨Î壩¡¢ÅäÖôÅÅÌÕóÁÐ
1¡¢£¨ÔÚkfqcz1ÉÏÖ´ÐУ©´ÅÅÌÕóÁл®·ÖΪËĸö·ÖÇø£¬Á½¸ö500M·ÖÇø×öΪclusterͶƱ·ÖÇø£¬Ê£Óà´ÅÅ̿ռä·ÖΪÁ½¸ö·ÖÇø£¬Ò»¸öÓÃÀ´´æ·Å
oracleÊý¾Ý¿â£¬ÁíÒ»¸öÓÃÀ´±¸·ÝÊý¾ÝÎļþ£¬ÆäÖÐÖ»°ÑµÚÈý·ÖÇø¸ñʽ»¯Îªext3¸ñʽ£¬1¡¢2·ÖÇø×öΪÂãÉ豸δ¸ñʽ»¯£¬4·ÖÇøÓÉÓÚδ±¸·ÝÊý¾Ý£¬Ò²Î´¸ñʽ
»¯¡£
²½Ö
Ïà¹ØÎĵµ£º
ORACLEÊý¾Ý¿âµÄ»ù±¾Óï·¨¼¯½õ
-- ±í
create table test (names varchar2(12),
dates date,
&nb ......
select v.spid spid,v.appid appid,v.version version,v.newversion newversion,v.status status,v.createtime createtime from adc_spversionchangeapply v inner join adc_application a on a.id=v.appid
where a.create_by = 'a' and v.appid = '12000000005' and (v ......
1. °²×°Ç°µÄϵͳÅäÖÃ
1.1. ÅäÖÃϵͳsystemÎļþ
ʹÓÃrootÓû§µÇ½Ö÷»ú£¬ÐÞ¸Ä/etc/systemÎļþ£¬Ìí¼ÓÈçÏÂ×ֶΣº
set noexec_user_stack=1
set semsys:seminfo_semmni = 100
set semsys:seminfo_semmns = 1024
set semsys:seminfo_semmsl = 256
set semsys:seminfo_semvmx = 32767
set shmsys ......
Windows 7ÕæÊÇÈÃÈËÓÖ°®ÓÖºÞ°¡£¡±¾È˵çÄÔ֮ǰÒѰ²×° SQL Server 2005£¬°²×°¹ý³Ì¶¼Ã»Ê²Ã´ÎÊÌ⣬ºÜ¿ì¸ã¶¨£¬¿ÉÊÇ×°Ò»¸öOracle 10gÈ´»¨ÁËÎÒÒ»¸öÍíÉϵÄʱ¼ä£¡²»¹ý×ÜËã°²×°³É¹¦ÁË£¡ËäÈ»»¹Ã»ÓÐÕýʽ¿ªÊ¼Ê¹Ó㬵«ÊÇÐË·ÜÖ®ÓàÆÈ²»¼°´ýÒªºÍ´ó¼Ò·ÖÏíһϾÑ飡
Ê×ÏÈÒªÏÂÔØÖ§³ÖVista°æ±¾µÄOracle 10g£¨ÒÔÏÂÁ´½ÓµØÖ·ÔÚä¯ÀÀÆ÷Öдò¿ªÃ»Ó㬸´ ......
ÓÐÁ½¸öÈÕÆÚÊý¾ÝSTART_DATE£¬END_DATE£¬ÓûµÃµ½ÕâÁ½¸öÈÕÆÚµÄʱ¼ä²î£¨ÒÔÌ죬Сʱ£¬·ÖÖÓ£¬Ã룬ºÁÃ룩£º
Ì죺
ROUND(TO_NUMBER(END_DATE - START_DATE))
Сʱ£º
ROUND(TO_NUMBER(END_DATE - START_DATE) * 24)
ᅅ
ROUND(TO_NUMBER(END_DATE - START_DATE) * 24 * 60)
Ã룺
ROUND(TO_NUMBER(END_DATE - START ......