hpux+slvm+mc/sg+oracle 10g racʵʩÊÖ²á
Ó²¼þ»·¾³:hp rx2660*2+hp eva4400
Èí¼þ»·¾³:hpux 11.23,oracle 10g for hpux,oracle clusterware,mc/serviguard 11.18
1.°²×°HPUX
2.´ò²¹¶¡,²ÎÕÕÎĵµ¼´¿É,»ò´òµ½magepatch dec.12.07ÒÔºóÒ²¿ÉÒÔ
3.°²×°mc/sg+SGeRAC(hp MC/ServiceguardΪÅäºÏoracle racËùʹÓõÄÄ£¿é)
4.¹æ»®´æ´¢
lock vg:1G
rac:100G
5.ÐÞ¸ÄÄں˲ÎÊý
kctune -h nproc="4096"
kctune -h ksi_alloc_max="(nproc*8)"
kctune -h max_thread_proc="1024"
kctune -h maxdsiz="1073741824"
kctune -h maxdsiz_64bit="2147483648"
kctune -h maxssiz="134217728"
kctune -h maxssiz_64bit="1073741824"
ÂÔ¹ý500×Ö
6.´´½¨ORACLEÓû§ºÍ×é
groupadd -g 201 dba
groupadd -g 200 oinstall
useradd -u 200 -g oinstall -G dba,oinstall oracle
7.µ÷ÕûhostsÎļþ
# vi /etc/hosts
127.0.0.1 localhost
192.168.10.7 his1
192.168.10.8 his2
192.168.10.3 his1-vip
192.168.10.4 his2-vip
10.0.0.1 his1_priv
10.0.0.2 his2_priv
8.ÅäÖÃmc/sg
# cmquerycl -v -C /etc/cmcluster/cluster.ascii -n his1 -n his2
# vi cmcluster.ascii
CLUSTER_NAME rac-test
FIRST_CLUSTER_LOCK_VG /dev/vglock
NODE_NAME his1
NETWORK_INTERFACE lan0
HEARTBEAT_IP 192.168.10.7
NETWORK_INTERFACE lan1
HEARTBEAT_IP 10.0.0.1
FIRST_CLUSTER_LOCK_PV /dev/dsk/c2t0d1
NODE_NAME his2
NETWORK_INTERFACE lan0
HEARTBEAT_IP 192.168.10.8
NETWORK_INTERFACE lan1
HEARTBEAT_IP 10.0.0.2
FIRST_CLUSTER_LOCK_PV /dev/dsk/c2t0d1
HEARTBEAT_INTERVAL 1000000
NODE_TIMEOUT 6000000
AUTO_START_TIMEOUT 600000000
NETWORK_POLLING_INTERVAL 2000000
NETWO
Ïà¹ØÎĵµ£º
ÎÒÏÖÔÚÔÚ×öÒ»¸öOracleÊý¾Ýµ¼È룬Ҫ½«EXCELÊý¾Ýµ¼Èëµ½OracleÊý¾Ý¿âÖУ¬ÏȶÁÈ¡Êý¾Ý£¬½«Êý¾Ý±£´æÔÚÒ»ÕÅÁÙʱ±íÖУ¬È»ºóµ¼Èë֮ǰ¶ÔÁÙʱ±íÖÐÊý¾ÝµÄÿ¸ö×Ö¶Î×öУÑ飬±ÈÈçÊý¾ÝÊÇ·ñΪÕûÊý£¬ÕûÊýµÄ×î´óλÊý£¬¼°µ¼ÈëµÄÊý¾ÝÔÚÔÊý¾Ý¿âÖÐÊÇ·ñÒѾ´æÔڵȣ¬ÎÒдÁËÒ»¸ö´æ´¢¹ý³Ì£¬¶ÔÒì³£µÄÊý¾Ý£¬½«×ֶΓis_checked”ÉèΪÒì³ ......
1¡¢ÅäÖÃhibernate£º
1.1¡¢ÅäÖÃhibernateµÄ³Ö¾ÃÀàÎļþÖжÔÓ¦µÄ×Ö¶ÎΪbyte[]ÀàÐÍ
2.2¡¢ÅäÖÃhibernateµÄÀàÓ³ÉäÎļþÖжÔÓ¦µÄ×Ö¶ÎtypeΪ
org.springframework.orm.hibernate3.support.BlobByteArray ......
rownum ÕæµÄÊǺܺõĶ«Î÷£¬ÏÖÔÚ´ó¶àÊýÓÃÓÚ´æ´¢¹ý³Ì·ÖÒ³. µ«ÔõôÓÃÄØ£¿Õâ¾ÍÀ´Ñо¿Ò»Ï¡£ ºÙºÙ
--- ÒÔÏÂÎª×ªÔØÖ®´¦£¬½ö¹©Ñ§Ï°
¶ÔÓÚrownumÀ´ËµËüÊÇoracleϵͳ˳Ðò·ÖÅäΪ´Ó²éѯ·µ»ØµÄÐеıàºÅ£¬·µ»ØµÄµÚÒ»ÐзÖÅäµÄÊÇ1£¬µÚ¶þÐÐÊÇ2£¬ÒÀ´ËÀàÍÆ£¬Õâ¸öα×ֶοÉÒÔÓÃÓÚÏÞÖÆ²éѯ·µ»ØµÄ×ÜÐÐÊý£¬¶øÇÒrownum²»ÄÜÒÔÈκαíµÄà ......
µ¥Ðк¯Êý ·µ»ØÖµÖ»ÓÐÒ»¸ö
·Ö×麯Êý ·µ»ØÖµÊǶàÌõ¼Ç¼
group by
sum
avg   ......
a)Êý¾Ý¿â±¾ÉíµÄÓÅ»¯
³õʼ»¯Îļþ init.ora
open_cursors = 150 ´ò¿ªµÄÓαêµÄ¸öÊý
ºÜ¶àµÄ´æ´¢¹ý³ÌµÄʱºò ¿ÉÒÔ°ÑËüµ÷´óЩ
......