ºìÆìDC Server 5.0ÉÏ°²×°Oracle 10g R2
Ç°ÃæдÁ˶à·ÝºìÆìDC 4.1ºÍ5.0ÉÏ°²×°Oracle 9i/10gµÄÎĵµ£¬µ«Ò»Ö±Ã»ÓÐÕûÀíDC 5.0ÉÏ°²×°Oracle 10gµ¥»ú·þÎñÆ÷µÄ×ÊÁÏ£¬ÔÒòÊǸùý³Ì·Ç³£¼òµ¥¡£µ«×î½üÏîÄ¿ÖУ¬»¹ÊÇÓÐÓû§Óöµ½Ð©ÎÊÌ⣬½ñÌì¾Í°ÑһЩÐèҪעÒâµÄµØ·½ÕûÀíһϣ¬ÏêϸµÄ¹ý³Ì¾Í²»ÃèÊöÁË¡£
Ò»¡¢ÏµÍ³»·¾³
²Ù×÷ϵͳ£ººìÆì DC 5.0 for x86 »ò x86_64
Ó²¼þ»·¾³£ºXeon 3.0 DP£¬1GÄÚ´æ
Ó¦ÓóÉѵ£ºOracle 10g R2
¶þ¡¢°²×°¹ý³Ì
ºìÆìDC Server´øÓа²×°OracleÓõݲװÏòµ¼oranavi£¬µ«ÔÚDC 5.0°æ±¾ÉÏÖ»Ö§³ÖOracle 10gµÄ°²×°£¬9iµÄ°²×°¿É²Î¿¼[Ô]ºìÆìDC Server 5.0ÉÏ°²×°Oracle9i¡£
¡òÓÐЩÅäÖÃÔÚ°²×°Ç°ÊÇÐèÒªÔ¤ÏÈÅäÖúõģº
1¡¢²é¿´swapÊÇ·ñ×ã¹»£¿
ÒýÓÃ
# free
total used free shared buffers cached
Mem: 1034332 50752 983580 0 7288 21052
-/+ buffers/cache: 22412 1011920
Swap: 1992012 0 1992012
swap×îÉÙ1.5GÒÔÉÏ£¬·ñÔòOracle°²×°µ½×îºó»á±¨´í¡£
2¡¢²é¿´¿Õ¼äÊÇ·ñ×ã¹»£¿
ÒýÓÃ
# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/sda1 7.4G 3.3G 3.8G 47% /
none 506M 0 506M 0% /dev/shm
/dev/sdb2 6.5G 47M 6.2G 1% /opt
Oracle°²×°×îÉÙÐèÒª5G¿Õ¼ä¡£
3¡¢ÅäÖù̶¨IPºÍÖ÷»úÃû£¬²¢ÉèÖöÔÓ¦
ÉèÖù̶¨IP£º
ÒýÓÃ
# cat /etc/sysconfig/network-scripts/ifcfg-eth0
DEVICE=eth0
ONBOOT=yes
BOOTPROTO=static
IPADDR=192.168.228.220
NETMASK=255.255.255.0
ÉèÖÃÖ÷»úÃû£º
# echo "kernel.hostname=ora01" >> /etc/sysctl.conf
¶ÔÓÚ¶àÍø¿¨µÄ·þÎñÆ÷£¬²»½¨ÒéÐÞ¸Ä/etc/sysconfig/networkÀ´ÉèÖÃÖ÷»úÃû£¬ÒòΪһµ©ÐÞ¸ÄÍøÂçÅäÖ㬿ÉÄܻᵼÖÂÖ÷»úÃûҲһͬÐ޸ģ¬ËùÒÔ½¨ÒéÖ±½ÓÉèÖÃkern
Ïà¹ØÎĵµ£º
oracle±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
1.¸ÅÊö
Ë÷ÒýÊÇÓ¦ÓÃÉè¼ÆºÍ¿ª·¢µÄÒ»¸öÖØÒª·½Ãæ¡£Èç¹ûÓÐÌ«¶àµÄË÷Òý£¬DML µÄÐÔÄܾͻáÊܵ½Ó°Ïì¡£Èç¹ûË÷ÒýÌ«
ÉÙ£¬ÓÖ»áÓ°Ïì²éѯ£¨°üÀ¨²åÈë¡¢¸üкÍɾ³ý£©µÄÐÔÄÜ¡£ÒªÕÒµ½Ò»¸öºÏÊʵÄƽºâµã£¬Õâ¶ÔÓÚÓ¦ÓõÄÐÔÄÜÖÁ¹Ø
ÖØÒª¡£
ÎÒ³£³£·¢ÏÖ£¬ÈËÃÇÔÚÓ¦Óÿª·¢ÖÐ×ÜÊÇʺó²ÅÏëÆðË÷Òý¡£ÎÒ¼á³ÖÈÏΪÕâÊÇÒ»ÖÖ´íÎóµÄ×ö·¨¡£Èç¹ûÄãÖª
µÀÊý¾Ý½«ÈçºÎ ......
ʹÓÃÄ£ºý²éѯ£º
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-mm-dd");
Date startdate = sdf.parse(start_date);
Date enddate = sdf.parse(end_date);
List list = sess.createCriteria(MyTabel.class)
.add( ......
ÔÎÄ´«ËÍÃÅ£ºhttp://blog.csdn.net/wh62592855/archive/2009/11/06/4776631.aspx
¼ÇµÃÒÔÇ°ÔÚÂÛ̳Àï¿´µ½inthirtiesÓõ½¹ýWITH ASÕâ¸ö×ÖÑÛ£¬µ±Ê±Ã»ÌرðÔÚÒâ¡£½ñÌìÔÚÒ»¸öÌû×ÓÀïÓÖ¿´µ½ÓÐÈËÓÃÕâ¸ö£¬ËùÒÔ¾ÍÈ¥ÍøÉÏËÑÁËËÑÏà¹ØÄÚÈÝ£¬×Ô¼ºÐ¡ÊÔÁËÒ»°Ñ£¬Ð´ÏÂÀ´£¬·½±ãÒÔºóÍüÁ˵Ļ°Ñ§Ï°¡£
============================================ ......
Ò»¸ö±íÖÐÓм¸°ÙÍòÌõÊý¾Ý£¬¶Ôij¸ö×ֶμÓÁËË÷Òý£¬µ«ÊDzéѯʱÐÔÄܲ¢Ã»ÓÐʲôÌá¸ß£¬ÕâÖ÷Òª¿ÉÄÜÊÇoracleµÄË÷ÒýÏÞÖÆÔì³ÉµÄ¡£
¡¡¡¡oracleµÄË÷ÒýÓÐһЩË÷ÒýÏÞÖÆ£¬ÔÚÕâЩË÷ÒýÏÞÖÆ·¢ÉúµÄÇé¿öÏ£¬¼´Ê¹ÒѾ¼ÓÁËË÷Òý£¬oracle»¹ÊÇ»áÖ´ÐÐÒ»´ÎÈ«±íɨÃ裬²éѯµÄÐÔÄܲ»»á±È²»¼ÓË÷ÒýÓÐËùÌá¸ß£¬·´¶ø¿ÉÄÜÓÉÓÚÊý¾Ý¿âά»¤Ë÷ÒýµÄϵͳ¿ªÏúÔì³ÉÐÔÄܸ ......