Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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Êý¾Ý¿âµÄ»ù±¾Óï·¨¼¯½õ

ORACLEÊý¾Ý¿âµÄ»ù±¾Óï·¨¼¯½õ
 
-- ±í
create table test (names varchar2(12),
                   dates date,
               &nb ......

µ±oracle³öÏÖ ¸ñʽÓë×Ö·û´®¸ñʽ²»Æ¥Åä½â¾ö°ì·¨

    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 ......

Soloris 10ÏÂoracle 10gµÄ°²×°ÓëÅäÖÃ

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Éϳɹ¦°²×°Oracle 10gµÄÒ»µã¾­Ñé

Windows 7ÕæÊÇÈÃÈËÓÖ°®ÓÖºÞ°¡£¡±¾È˵çÄÔ֮ǰÒѰ²×° SQL Server 2005£¬°²×°¹ý³Ì¶¼Ã»Ê²Ã´ÎÊÌ⣬ºÜ¿ì¸ã¶¨£¬¿ÉÊÇ×°Ò»¸öOracle 10gÈ´»¨ÁËÎÒÒ»¸öÍíÉϵÄʱ¼ä£¡²»¹ý×ÜËã°²×°³É¹¦ÁË£¡ËäÈ»»¹Ã»ÓÐÕýʽ¿ªÊ¼Ê¹Ó㬵«ÊÇÐË·ÜÖ®ÓàÆÈ²»¼°´ýÒªºÍ´ó¼Ò·ÖÏíһϾ­Ñ飡
Ê×ÏÈÒªÏÂÔØÖ§³ÖVista°æ±¾µÄOracle 10g£¨ÒÔÏÂÁ´½ÓµØÖ·ÔÚä¯ÀÀÆ÷Öдò¿ªÃ»Ó㬸´ ......

Oracle¼ÆËãʱ¼ä²î±í´ïʽ

 
ÓÐÁ½¸öÈÕÆÚÊý¾Ý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 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ