ɨä ORACLE RACµÄ°Ù¿Æ½éÉÜ
Oracle RAC
¡¡¡¡RAC£¬È«³Æreal application clusters£¬ÒëΪ“ÕæÕýÓ¦Óü¯Èº”£¬ ÊÇOracleаæÊý¾Ý¿âÖвÉÓõÄÒ»Ïîм¼Êõ£¬Ò²ÊÇOracleÊý¾Ý¿âÖ§³ÖÍø¸ñ¼ÆËã»·¾³µÄºËÐļ¼Êõ¡£
¡¡¡¡Oracle RACÖ÷ÒªÖ§³ÖOracle9i¡¢10g¡¢11g°æ±¾£¬¿ÉÒÔ¿ÉÒÔÖ§³Ö24 x 7 ÓÐЧµÄÊý¾Ý¿âÓ¦Óà ϵͳ£¬Ôڵͳɱ¾·þÎñÆ÷ÉϹ¹½¨¸ß¿ÉÓÃÐÔÊý¾Ý¿âϵͳ£¬²¢ÇÒ×ÔÓɲ¿ÊðÓ¦Óã¬ÎÞÐèÐ޸ĴúÂë¡£
¡¡¡¡ÔÚOracle RAC»·¾³Ï£¬Oracle¼¯³ÉÌṩÁ˼¯ÈºÈí¼þºÍ´æ´¢¹ÜÀíÈí¼þ£¬ÎªÓû§½µµÍÁËÓ¦Óóɱ¾¡£µ±Ó¦ÓùæÄ£ÐèÒªÀ©³äʱ£¬Óû§¿ÉÒÔ°´ÐèÀ©Õ¹ÏµÍ³£¬ÒÔ±£Ö¤ÏµÍ³µÄÐÔÄÜ¡£
¡¡¡¡Oracle RACÒ»°ãÒ²¿É¹¹½¨ÓÚ´óÐÍSMPÖ÷»ú£¬IBMµÄAIXϵÁзþÎñÆ÷ÍùÍùÊÇÆäÖÐ¸ß¶ËÆ½Ì¨£¬Intel LinuxÍùÍù×÷ΪÆäµÍ¶Ëƽ̨¡£µ±AIX UNIXÓÃÀ´ÔËÐÐOracle RAC×÷Ϊ´óÐÍÊý¾Ý¿âϵͳƽ̨ʱ£¬Æä¼¯ÈºÏµÍ³¹¹½¨¡¢ÊµÊ©¡¢ÔËά¡¢¸ß¿ÉÓÃÉèÖã¬ÓÐÆäÆ½Ì¨ÌØµã¡£¿ÉÒÔ²ÎÕÕ¡¶Oracle´óÐÍÊý¾Ý¿âϵͳÔÚAIX/UNIXÉϵÄʵսÏê½â¡·£¬¸ÃÊéÒÔAIX UNIXƽ̨ΪÖ÷Ïߣ¬ÒÔÆäËûUNIXϵͳΪ²ÎÕÕ£¬ÃèÊöÁËÊý¾Ý¿âϵͳOracle 10g¡¢Oracle 11gµÄRACµÄ¹¹¼Ü·½·¨ºÍ¹ý³Ì¡£ÔÚLinuxƽ̨£¬Ôò¡¶´ó»°OracleRAC¼¯Èº¡¢¸ß¿ÉÓÃÐÔ¡¢±¸·ÝÓë»Ö¸´¡·ÓÐןܺõÄÂÛÊö¡£
PowerBuilder 11ÒÔºóµÄ°æ±¾,ÔÚÔÓлù´¡ÉÏÔö¼ÓÁ˶Ôoracle racµÄÖ§³Ö.ÁíÍ⻹Ôö¼ÓÁ˶Ômobilink(Ó¦¸ÃÊÇSQL anywhereµÄͬ²½¼¼Êõ°É?)µÄÖ§³Ö.
Ïà¹ØÎĵµ£º
ORACLE ·ÖÇø±í PARTITION table
http://blog.chinaunix.net/u/6889/showart_315897.html
1.1 ·ÖÇø±íPARTITION table
ÔÚORACLEÀïÈç¹ûÓöµ½Ìرð´óµÄ±í£¬¿ÉÒÔʹÓ÷ÖÇøµÄ±íÀ´¸Ä±äÆäÓ¦ÓóÌÐòµÄÐÔÄÜ¡£
1.1.1 ·ÖÇø±íµÄ½¨Á¢£º
ij¹«Ë¾µÄÿÄê²úÉú¾Þ´óµÄÏúÊۼǼ£¬DBAÏò¹«Ë¾½¨Òéÿ¼¾¶ÈµÄÊý¾Ý·ÅÔÚÒ»¸ö·ÖÇøÄÚ£¬ÒÔÏÂʾ·¶µÄÊǸù«Ë¾1 ......
1.sqlplus-----¿ªÆô·þÎñ
2.ÊäÈëÓû§ÃûºÍÃÜÂ루ĬÈÏ3¸öÓû§,×¢Ò⣬ÃÜÂëÊÇ¿ÉÒÔÐ޸ĵģºsystem/manager;scott/tiger;sys/change_on_install£©£¬Á¬½ÓÊý¿â¡£
3.´´½¨±í¿Õ¼ä£º
create tablespace ±í¿Õ¼äÂß¼Ãû datafile '±í¿Õ¼äÎļþµÄÎïÀíÂß¼'
size Îļþ´óС£¨È磺10m£© autoextend ÊÇ·ñ×Ô¶¯Ôö³¤Îļþ´óС£¨on/off ......
ºÜ¶àÈ˶¼ÖªµÀ£¬OracleµÄ¼àÌýÆ÷Ò»Ö±´æÔÚ×ÅÒ»¸ö°²È«Òþ»¼£¬¼ÙÈç²»ÉèÖð²È«´ëÊ©£¬ÄÇôÄܹ»·ÃÎʵÄÓû§¾Í¿ÉÒÔÔ¶³Ì¹Ø±Õ¼àÌýÆ÷¡£
Ïà¹ØÊ¾Àý£º
D:\>lsnrctl stop eygle
LSNRCTL for 32-bit Windows: Version 10.2.0.3.0 - Production on 28-11ÔÂ-2007 10:02:40
Copyright (c) 1991, 2006, Oracle. All rights reserved.
......
×î½ü×öÁ˸öÏîÄ¿£¬ÊµÏÖ¶Ô´æÔÚǧÍòÌõ¼Ç¼µÄ¿â±í½øÐвåÈë¡¢²éѯ²Ù×÷¡£ÔÒÔΪ¶ÔÊý¾Ý¿âµÄ²åÈë¡¢²éѯÊǼþºÜÈÝÒ×µÄÊ£¬¿É²»Öªµ±Êý¾Ý´ïµ½°ÙÍòÉõÖÁǧÍòÌõ¼¶±ðµÄʱºò£¬ÕâÒ»ÇÐËÆºõ±äµÃÏ൱À§ÄÑ¡£¼¸¾ÕÛÌÚ£¬×ÜËãÍê³ÉÁËÈÎÎñ¡£
¡¡¡¡1¡¢±ÜÃâʹÓÃHibernate¿ò¼Ü
¡¡¡¡HibernateÓÃÆðÀ´ËäÈ»·½±ã£¬µ«¶ÔÓÚº£Á¿Êý¾ÝµÄ²Ù×÷ÏÔµÃÁ¦²»´ÓÐÄ¡£ ......
2010-03-12 21:21:26
sqlplusµÇ½¶ÌÏûÏ¢oracleÊý¾Ý¿âʱÌáʾ“ORA-28000: Õʺű»Ëø¶¨”¡£
תÌù£ºhttp://blog.csdn.net/shongyu/archive/2009/06/01/4233260.aspx
È·¶¨ÊÇÓÉÓÚoracle11gÖÐĬÈÏÔÚdefault¸ÅÒªÎļþÖÐÉèÖÃÁË“FAILED_LOGIN_ATTEMPTS=10´Î”£¬µ±ÊäÈëÃÜÂë´íÎó´ÎÊý´ïµ½ÉèÖÃÖµ½«µ¼Ö´ËÎÊÌâ¡£
° ......