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Êý¾Ý¿â½ÏºÃµÄÊ®ÖÖÖØÐÂÆô¶¯²½Öè¡£
¡¡¡¡1. Í£Ó¦ÓòãµÄ¸÷ÖÖ³ÌÐò¡£
¡¡¡¡2. Í£oralceµÄ¼àÌý½ø³Ì:
¡¡¡¡$lsnrctl stop
¡¡¡¡3. ÔÚ¶ÀÕ¼µÄϵͳÓû§Ï£¬±¸·Ý¿ØÖÆÎļþ:
¡¡¡¡SQL>alter database backup controlfile to trace;
¡¡¡¡4. ÔÚ¶ÀÕ¼µÄϵͳÓû§Ï£¬ÊÖ¹¤Çл»ÖØ×÷ÈÕÖ¾Îļþ£¬È·±£µ±Ç°ÒÑÐ޸Ĺýµ ......
1¡¢¶à¹¤Áª»úÖØ×÷ÈÕÖ¾Îļþ
¡¡¡¡Ã¿¸öÊý¾Ý¿âʵÀý¶¼ÓÐÆä×Ô¼ºµÄÁª»úÖØ×÷ÈÕÖ¾×飬ÔÚ²Ù×÷Êý¾Ý¿âʱ£¬OracleÊ×ÏȽ«Êý¾Ý¿âµÄÈ«²¿¸Ä±ä±£´æÔÚÖØ×÷ÈÕÖ¾»º³åÇøÖУ¬ËæºóÈÕÖ¾¼Ç¼Æ÷½ø³Ì£¨LGWR£©½«Êý¾Ý´Óϵͳ¹²ÓÃÇøSGA£¨System Global Area£©µÄÖØ×÷ÈÕÖ¾»º³åÇøдÈëÁª»úÖØ×÷ÈÕÖ¾Îļþ£¬ÔÚ´ÅÅ̱ÀÀ£»òʵÀýʧ°Üʱ£¬¿ÉÒÔͨ¹ýÓëÖ®Ïà¹ØµÄÁª»úÖØ×÷ÈÕÖ¾ ......
Àý£º
create user his identified by his default tablespace users temporary tablespace temp;
grant connect,resource,dba to his;
create tablespace his
logging
datafile 'd:\oracle\product\10.2.0\oradata\zjxsh\his.ora' size 100M extent
management local segment space management auto;
exp his/ny@ny ......
µ¥Ðк¯Êý ·µ»ØÖµÖ»ÓÐÒ»¸ö
·Ö×麯Êý ·µ»ØÖµÊǶàÌõ¼Ç¼
group by
sum
avg   ......
½¨Á¢±íÈçÏÂ:
ѧÉú»ù±¾ÐÅÏ¢±í
CREATE Student(
[Studentid][Int]IDENTITY(1,1)NOT NULL primary key,--Ö÷¼ü
[StudentName][char]NOT NULL
)
¿Î³ÌÐÅÏ¢±í
CREATE Subject(
[SubjectID][char]NOT NULL primary key, --Ö÷¼ü
[SubjectName][char]NOT NULL
)
³ ......