26 06, 2009

¼òµ¥µÄ¼¸ÌõInsertÓï¾äÒýÆðµÄÂß¼­StandbyÓ¦ÓÃÑÓ³ÙµÄÕï¶Ï


Ò»¸öÂß¼­StandbyµÄ¿â£¬ÔËÐÐÔÚRedhat as4u4_x86_64µÄƽ̨ÉÏ£¬Êý¾Ý¿â°æ±¾10.2.0.2¡£Ö÷¿âÔËÐеIJÙ×÷ϵͳƽ̨ºÍÊý¾Ý¿â°æ±¾¸úStandby¿âÒ»Ö£¬ÔËÐÐÔÚ×î´óÐÔÄÜģʽ£¬Ê¹Óà LGWR ASYNC·½Ê½´«Redoµ½Âß¼­Standby¿â¡£Âß¼­Standby¿âʹÓÃApply Immedite·½Ê½½øÐÐʵʱӦÓá£ÒòΪÕâ¸ö¿âµÄѹÁ¦ºÜС£¬ËùÒÔStandby¿âºÍÖ÷¿âÖ®¼äµÄÊý¾Ýͬ²½Ê±¼ä·Ç³£Ð¡£¬Ò»°ã¶¼ÔÚ·ÖÖÓ¼¶±ðÒÔÄÚ£¬µ«Õâ´ÎÒòΪһ¸ö ÿ·ÖÖÓ²ÅÔËÐм¸´ÎµÄ¼òµ¥InsertÓï¾äÈ´ÄÜÒýÆðStandby ApplyµÄÑÓ³Ù£¬È·ÊµÓÐЩ²»Í¬Ñ°³££¬ÏÂÃæÀ´¿´¿´µ½µ×·¢ÉúÁËʲô¡£ ²é¿´È«ÎÄ

24 06, 2009

iostat -nÀ´Í³¼ÆNFS¶ÁдÐÅϢʱÅöµ½ÁËCannot open /proc/self/mountstats: No such file or directory


¸ãÁ˸öNFS»·¾³£¬È»ºóŪÁ˵ãѹÁ¦À´²âÊÔ϶ÁдÐÔÄÜÈçºÎ£¬ÆäʵÈç¹ûÍøÂçÉÏûÓÐÆäËûÁ÷Á¿£¬ÄÇ»ù±¾ÉÏÍøÂçÉϵõ½µÄÁ÷Á¿Ò²¾ÍÊÇNFS¶ÁдµÄÊý¾ÝµÄÁ÷Á¿ÁË£¬Ò²´ó¸Å Äܵõ½NFSµÄ¶ÁдÐÔÄÜ¡£µ«LINUXϵÄsysstat°üÖÐÌṩÁËÒ»¸öiostatÃüÁÆäÖÐÓÐÒ»¸ö-n²ÎÊý£¬¿ÉÒÔÖ±½Ó¿´µ½NFSÉϵÄÁ÷Á¿ÐŠϢ£¬BUT£¬Ê¹ÓÃÕâ¸ößËß˾ÍҪСÐÄÅöµ½¡°Cannot open /proc/self/mountstats: No such file or directory¡±ÁË¡£ ²é¿´È«ÎÄ

23 06, 2009

ÒªÃüµÄMERGE JOIN CARTESIAN


Ò»¸öÓ¦Óã¬Í»È»³öÏÖÏìÓ¦»ºÂý£¬²é¿´Ò»Ïµȴýʱ¼ä£¬·¢ÏÖÓкܶàµÄÊý¾Ý¶ÁÈ¡µÄµÈ´ý£¬¶øÇÒÿ´ÎÖ´ÐжÁÈ¡µÄBLOCKÊýÁ¿Ã÷ÏÔ±È֮ǰ¶à£¬¿´¿´SQLµÄÖ´Ðмƻ®£¬·¢ ÏÖ¸ú֮ǰµÄÖ´Ðмƻ®²»Ò»Ñù£¬¶àÁËÒ»¸öMERGE JOIN CARTESIAN µÄ¹ý³Ì£¬°ÑÕâЩ½ø³Ìɱµô£¬Ë¢ÐÂÏÂSHARED POOL£¬È»ºóµÈSQLÖØÐÂÇëÇó½øÀ´±»½âÎö£¬Ö´Ðмƻ®ÒѾ­ÕýÈ·ÁË£¬ÏÂÃæÀ´¿´¿´Õâ¸öMERGE JOIN CARTESIAN ÊǺη½ÉñÊ¥ ²é¿´È«ÎÄ

19 06, 2009

¿âÔÚ²»Í¬µÄ·¾¶RELINKºóµ¼ÖÂASMCMD²»ÄÜʹÓÃ

Ò»¸ö¿âǰÆÚÊDZðÈË×°ºÃµÄ£¬OSÊÇREDHAT AS4U6µÄ£¬ORACLEÊÇ10.2.0.3µÄ£¬ASMʵÀýÒ²ÒѾ­½¨ºÃÁË£¬¿ÉÊǵ±Ê¹ÓÃASMCMDÏëÀ´¿´¿´ÀïÃæ¶¼ÓÐЩʲôÄÚÈݵÄʱºòÈ´·¢ÏÖASMCMDÃüÁî²»ÄÜʹÓ㬱¨´íÈçÏ£º
install_driver(Oracle) failed: Can't load '/u01/oracle/product/10.2.0/db_1/perl/lib/site_perl/5.8.3/i686-linux-thread-multi/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle: /u01/oracle/product/10.2.0/db_1/lib32/libclntsh.so.10.1: undefined symbol: nnftboot at /u01/oracle/product/10.2.0/db_1/perl/lib/5.8.3/i686-linux-thread-multi/DynaLoader.pm line 229.
at (eval 2) line 3
Compilation failed in require at (eval 2) line 3.
Perhaps a required shared library or dll isn't installed where expected
at /u01/oracle/product/10.2.0/db_1/bin/asmcmdcore line 5953

 ²é¿´È«ÎÄ

19 06, 2009

ASM´ÅÅ̿ռä¼Ù×°ºÄ¾¡£¬ORA-15041: diskgroup space exhausted

Ò»¸öDATAGUARD£¬µ±Ö÷¿âRESIZEÀ©´óÒ»¸öÊý¾ÝÎļþºó£¬DGÉÏÃæÈ´²»ÄÜÓ¦ÓÃÕâ¸öRESIZEµÄ²Ù×÷£¬µ¼ÖÂMPR½ø³ÌÍ£µô£¬±¨´íÈçÏ£º
ORA-01237: cannot extend datafile 123
ORA-01110: data file 516: '+DG01/dg/datafile/aa.276.689185035'
ORA-17505: ksfdrsz:1 Failed to resize file to size 3053300 blocks
ORA-15041: diskgroup space exhausted
±¾À´ÏëÕâ¸ö´íÎóÌ«Ã÷ÏÔÁË£¬ÎÞ·ÇÊÇÒòΪDGÉÏÃæµÃASM×éûÓпÕÏпռäÁË£¬µ¼ÖÂÊý¾ÝÎļþ²»ÄÜÀ©Õ¹¡£ÓÚÊǵǽASMʵÀý£¬²éѯ¿ÕÏпռ䣬½á¹ûÈçÏ£º
SQL> select name,total_mb,free_mb from v$asm_diskgroup;

NAME TOTAL_MB FREE_MB
------------------------------ ---------- ----------
DG01 5209505 884073
DG02 1023994 988091
Ò²¾ÍÊÇ˵DG01ÃüÃû»¹Óн«½ü900GµÄ¿Õ¼ä£¬È´¸øÎÒ˵¿Õ¼ä²»¹»ÁË£¬ÕâÏÂץϹÀ²£¬¼û¹íµÄÎÊÌâÀ´ÁË

 ²é¿´È«ÎÄ

5 06, 2009

»ú·¿¾ª»ê¼Ç

Õâ²»ÊÇʲô¹íƬ£¬¶øÊÇ·¢ÉúÔÚ»ú·¿µÄÒ»´Îʹʡ£

ÒòΪÀ©ÈÝÐèÒª£¬È¥»ú·¿Ìí¼ÓÒ»¸öÅ̹ñ£¬È»ºó°ÑÕâЩ¿Õ¼äÌí¼Óµ½Ö÷»ú£¬ÒòΪÖ÷»ú²»Äܶ¯Ì¬Ê¶±ðÕâЩÐÂÌí¼ÓµÄ¿Õ¼ä£¬ËùÒÔÖØÆôÖ÷»ú¡£Ö÷»úÉÏÅܵÄÒµÎñ²»ÄÜÍ£»úºÜ¾Ã£¬ÓÚÊÇÖØÆôÃüÁîÇÃÍ꣬׼±¸½Ó¸öÏÔʾÆ÷ÉÏÈ¥¿´¿´Æô¶¯µÄ¹ý³Ì£¬ÍòÒ»ÐèÒª°´¸öF1»òÕßÅö¼ûʲô¹ÊÕÏÔÝÍ£ÁË£¬Ò²ºÃ¼°Ê±´¦Àí¡£Ã»Ïëµ½¾ªÏÕÒ»¿ÌºÜ¿ì¾ÍÀ´ÁË¡£

 ²é¿´È«ÎÄ

30 05, 2009

ORACLEµÄµ¥»úÒÔ¼°RACÔÚ¸÷ÖÖOSƽ̨ÏÂʹÓÃNFSʱµÄMOUNT²ÎÊý

ÕâÆªÎÄÕÂÊÇ·­METALINKʱÕÒµ½µÄ£¬×ªÔØÒ»Ï¹©²Î¿¼¡£MLID:359515.1

ÊÊÓð汾£º
Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 11.1.0.6 Information in this document applies to any platform.
Oracle Clusterware, Oracle Real Application Clusters, NAS Purpose
The purpose of this bulletin is to document the options with which the NAS systems should be mounted. This note does not cover the new dNFS feature that was introduced in 11g.

 ²é¿´È«ÎÄ

21 05, 2009

ÎÒҲΪ¹úÄÚDNS·þÎñÆ÷̱»¾¹±Ï×ÁËÒ»·ÝÁ¦Á¿£¿£¿

×òÌìÍíÉÏÏÂÁ˸öƬ×Ó£¬Ó°Òô·ç±©´ò¿ª£¬ÌáʾÎÒ˵ȱÉÙÒ»¸ö±àÂëÆ÷£¬È»ºó×Ô¶¯Á¬µ½ÁËÓ°Òô·ç±©µÄ·þÎñÆ÷È¥ÏÂÔØ±àÂëÆ÷£¬½ÓÏÂÀ´¾ÍÊÇÌáʾ˵Á¬²»ÉÏ£¬¶øÇÒ¸øÁËÒ»¸öÊÖ¶¯°²×°µÄÁ´½Ó¡£¼ÈÈ»Á¬²»ÉÏ£¬ÄǾÍÊÖ¶¯µÄÊÔÊÔ°É£¬½á¹ûÄǸöÁ´½Ó»¹ÊÇ´ò²»¿ª£¬·´¸´³¢ÊÔ¶à´ÎÒ²¶¼Ò»Ñù¡£¸É´àµ½±©·çµÄÖ÷Ò³¿´¿´°É£¬·¢ÏÖÖ÷Ò³Ò²´ò²»¿ªÁË£¬Õâ¾Í¸ã²»Ã÷°×ÁË£¬µ½×îºóƬҲû¿´³É¡£

½ñÌì²Å·¢ÏÖÊÇÒòΪ±©·çÖ¸ÏòµçÐŵÄÓòÃû·þÎñÆ÷¹ÒÁË£¬¶øºÜ¶àÓû§¶¼×°Óб©·ç£¨±©·çºÅ³ÆÓÐ1.5ÒÚÓû§£©£¬µ±È»°üÀ¨ÎÒ£¬ÎÒ»¹×°ÁËÈý·Ý£¬¹«Ë¾Ì¨Ê½»úÒ»·Ý£¬±Ê¼Ç±¾Ò»·Ý£¬¼ÒÀï±Ê¼Ç±¾Ò»·Ý¡£¶ø±©·çÒ²»áÓÐЩºǫ́µÄ³ÌÐòÔÚÔËÐУ¬·¢ÏÖ×Ô¼ºµÄÓòÃû·þÎñÆ÷å´»úºó»á²»Í£µØÖØÊÔ£¬Òò´Ë³öÏÖÁË´óÁ¿µÄDNS²éѯ£¬ÇÒÁ¿´ó¼ä¸ô¶Ì£¬µ¼ÖÂDNSϵͳ×ÊÔ´ºÄ¾¡¶øå´»ú¡£Õâ²»¾ÍÊÇÒ»´ÎDDOS¹¥»÷Âð£¿ÎÒÊDz»ÊÇÒ²¹±Ï×ÁËÒ»·ÝÁ¦Á¿ÄØ£¿

ºÜ¾Ã֮ǰ¿´¹ýÒ»¸öµçÓ°£¬½²Ò»¸öɱÊÖҪɱһ¸öÈË£¬¶øÕâ¸öÈËÊÇÂýÂý±»É±ËÀµÄ£¬¶øÉ±ËÀËûµÄÕû¸ö¹ý³Ì¶¼ÊÇÔÚÍøÂçÉÏÖ±²¥µÄ¡£ÄÇô£¬ËûËÀµÄ¿ìÂýÊǸúÍøÂç·ÃÎÊÁ¿ÓйØÏµµÄ£¬·ÃÎʵÄÈËÔ½¶à£¬ËÀµÄÔ½¿ì£»Èç¹ûûÈË·ÃÎÊ£¬ÔòËû²»»á±»É±ËÀµÄ¡£ÄÇô´ó¼Ò´¦ÓÚºÃÆæÐÄ£¬×Ü»áµãÉÏÀ´¿´¿´£¬¶øÇҺܿì¾Í»áÔÚÍøÂçÉÏ·è¿ñ´«²¥£¬×îÖÕµ¼ÖÂÕâ¸öÈ˱»É±ËÀ¡£ÄÇô£¬´ó¼ÒÊDz»ÊÇÿ¸öÈ˶¼ÊǰïÐ×ÄØ£¿

¿ÉÊÇ£¬ÄÜÓм¸¸öÈË»áÏëµ½×Ô¼ºÊǰïÐ×¶øÄâÖÆ×Ô¼ºµÄºÃÆæÐIJ»È¥¿´ÄØ£¿


11 05, 2009

ͨ¹ýVPDÀ´ÊµÏÖ¶ÔÌØ¶¨Óû§ÆÁ±ÎijЩÁеķÃÎÊ

ºÜ¶àʱºò±íµÄ·ÃÎÊ¿ØÖƶ¼ÊÇͨ¹ýȨÏÞ»òÕßÊÓͼÀ´¿ØÖƵ쬵«ÊÇÕâÑùµÄʵÏÖ·½Ê½Á£¶È²»¹»Ï¸¡£±ÈÈçÎÒÓÐ100¸öÓû§£¬Ã¿¸öÓû§¶¼Ö»ÈÃËûÃÇ·ÃÎʱíÖÐÌØ¶¨ÐеÄÊý¾Ý£¬µ«ÊÇÆäËûÐеÄÊý¾Ý¶ÔËûÃÇÀ´Ëµ²»¿É¼û£¬VIEW¿ÉÒÔʵÏÖ£¬µ«²»ÖÁÓÚΪÿ¸öÓû§½¨Ò»¸öVIEW°É¡£ÁíÍ⣬¶ÔÓÚÁеķÃÎÊ¿ØÖÆÒ²ÓÐÏàͬµÄÎÊÌâ¡£µ«Èç¹ûÊÇÎÒÏë¸øÓû§SELECT ANY TABLEµÄȨÏÞ£¬µ«ÊÇÆäÖÐÓÖÓÐijЩÐлòÕßijЩÁв»ÏëÈÃÓû§¿´µ½£¬ÄDz»Í¬µÄȨÏÞ»òÕßÊÓͼ¾ÍÎÞÄÜΪÁ¦ÁË¡£ºÃ°É£¬VPD³ö³¡ÁË¡£ ²é¿´È«ÎÄ

11 05, 2009

ORACLE 10.2ÖиöÈ˰桢±ê×¼°æ¡¢ÆóÒµ°æÖ®¼äµÄÇø±ð

¿ÉÄÜ»áÓÐÈ˾­³£Åöµ½Õâ¸öÎÊÌ⣬¸ÕºÃÔÚMLÉÏ¿´¼ûÁËÕâ¸öÎÄÕ£¬×ªÌûһϰɣ¬Ï£ÍûÄܰﵽһÁ½¸öÈË¡£¸ñʽÓÐЩÂÒ£¬Ô­ÎÄÖÐÊÇÓÐÒ»¸ö±í¸ñÐÎʽµÄ¡£ÓÐÕ˺ŵϹÊÇÖ±½ÓÈ¥ML¿´°É¡£ML:465465.1

 ²é¿´È«ÎÄ

8 05, 2009

PLS-00123:³ÌÐòÌ«´ó£¬ÊÇ·ñÊÇORACLEDZ·ü¶àÄêµÄСBUGÄØ£¿

Ò»¸çÃǸøÎÒÌáÁ˸öÎÊÌ⣬˵һ¸öPACKAGE£¬Í¨¹ýPL/SQL DEVELOPER½øÐбàдºÍµ÷ÊԵ쬴ó¸Å³¬¹ý5000ÐÐ×óÓÒ£¬±àÒëµÄʱºò»á±¨´í£¬±¨´íµÄÐÅÏ¢ÊÇ¡°PLS-00123:³ÌÐòÌ«´ó¡±£¬²Å5000ÐоÍÌ«´ó£¬ORACLE²»ÖÁÓÚÕâôÈõ°É£¿Ê×ÏÈÏëµ½µÄ¾ÍÊÇPL/SQL DEVELOPERÉÏÓÐʲôÏÞÖÆ£¬°Ñ²Ëµ¥À¸=¡·TOOLS=>PERFERENCESÖÐËùÓÐÑ¡ÏîÍÚµØÈý³ß£¬Ã»µØ·½ÏÞÖÆ°¡¡£GOOGLEÁËһϣ¬½â¾öµÄ°ì·¨ºÜ¼òµ¥£ºÔÚTOOLS=>PERFERENCES=>ORACLE=>DEBUGGER=>ADD DEBUG INFORMAION WHEN COMPILING£¬ÔÚÕâ¸öµØ·½°ÑÕâ¸ö¹´È¡Ïû£¬È»ºó¾Í¿ÉÒÔ±àÒëͨ¹ýÁË¡£ÄÇôÏÂÃæÀ´×Ðϸ¿´¿´Õâ¸ö¶«¶«ÊǸÉɶµÄÄØ£¿

 ²é¿´È«ÎÄ

7 04, 2009

ÈçºÎÕÒµ½Ä³¸ö¼üÖµÔÚË÷ÒýÖдæÔÚÓÚÄĸöBLOCKÖÐ

±ÈÈçÎÒÏëÖªµÀÎÒµÄEMAILÔÚ²âÊÔϵͳÖдæÔÚÁËʲôλÖã¬ÄǾÍÐèÒªDUMP BLOCKÀ´²é¿´ÁË£¬¿ÉÊÇË÷Òý²»ÏñÊý¾Ý£¬Êý¾ÝµÄ»°ÎÒÖ»ÒªÖªµÀROWID£¬È»ºó¸ù¾ÝROWIDµÃµ½Êý¾Ý´æÔÚÓÚÄĸöÊý¾ÝÎļþµÄÄĸö¿éÖУ¬È»ºóÖ±½ÓDUMPÕâ¸öBLOCK¾Í¿ÉÒÔÁË¡£¿ÉÊÇË÷Òý´æÁËROWID£¬µ«ÊÇÄãÈ´SELECT²»³öÀ´£¬ÏÂÃæÀ´ÑÝʾÏÂÔõôÕÒµ½Ò»¸öÖµÔÚË÷ÒýÖдæÔÚÓÚʲôµØ·½ ²é¿´È«ÎÄ

17 03, 2009

LINUXϵÄÓû§ºÍ×éµÄ¸ÅÄîºÍ¹ÜÀí

Óõ½ÁËÓû§ºÍ×éµÄ¹ÜÀíµÄµØ·½£¬ÓÐЩ¸ã²»Çå³þ£¬ÍøÉÏËÑÁËЩ×ÊÁÏ£¬Ò²ÀÁµÄÕûÀíÁË£¬Ö±½Ó¶«Æ´Î÷´ÕµÄÌùÔÚÕâÀï°É¡£

Æäʵ×îÖ÷ÒªµÄ¾ÍÊÇ/etc/groupºÍ/etc/passwdÁ½¸öÎļþ£¬¸ãÇå³ýÁËÀïÃæµÄÄÚÈÝ¡¢º¬Ò塢ȨÏÞ£¬È»ºóÔٸ㼸¸öÃüÁһ°ãµÄÓû§¹ÜÀíÒ²¾Í¶¼¸ã¶¨ÁË¡£

 ²é¿´È«ÎÄ

16 03, 2009

Ö÷¼ü³åÍ»Òý·¢µÄËÀËø

ÓÐÈ˵ĵط½¾ÍÓн­ºþ£¬ÓÐ×ÊÔ´µÈ´ýµÄµØ·½¾ÍÓÐËÀËø¡£Ð´ÍêÖ÷¼üµÄËÀËø£¬»ù±¾ÉÏORACLEµÄËÀËøÒ²¾Í¶¼ÔÚÕâÀïÁË--Ö÷Íâ¼üËÀËø¡¢BITMAPË÷ÒýËÀËø¡¢ITLËÀËø£¬»¹ÓÐ×î³£¼ûµÄÊÂÎñËøµÄÒý·¢µÄËÀËø¡£Ö÷¼üµÄËÀËøºÜÈÝÒ×Ä£Äâ³öÀ´µÄ£¬½¨Ò»¸ö±í£¬²åÈëÒ»¸öÖµ£¬È»ºó²»ÒªCOMMIT£¬ÁíÒ»¸ö»á»°²åÈëÁíÒ»¸öÖµ£¬Ò²²»ÒªCOMMIT£¬È»ºóÔÙ°ÑÕâÁ½¸ö²åÈëµÄÖµ»¥Ïཻ»»Ò»Ï£¬ÔÚÁ½¸ö»á»°Öзֱð²åÈ룬ËÀËø²úÉú¡£¸üÉîÈëµÄ·ÖÎöÒ²²»ÏëдÁË£¬¼Ç¼һÏÂTRACEÎļþ°É¡£

 ²é¿´È«ÎÄ

10 03, 2009

REDHATÖÐÈçºÎÅжÏÖ÷»úµÄCPUÊÇ32λ»¹ÊÇ64λµÄ

¿ÉÒÔÖ±½Ó²é¿´/proc/cpuinfoÎļþ£¬ÆäÖÐÓйØÓÚCPUµÄÏêϸÐÅÏ¢£¬°üÀ¨Ðͺš¢CACHE¡¢ÆµÂʵȵȣ¬µ«ÊÇûÓеط½Ã÷È·µÄдÃ÷ÊÇ32λ»¹ÊÇ64λµÄ£¬²»¹ýÔÚFLAGÄÇÒ»ÐÐÓкܶàµÄ±êÖ¾ÐÅÏ¢£¬Èç¹ûÆäÖÐÓÐLM±êÖ¾£¬ËµÃ÷Õâ¸öÊÇ64λµÄCPU£¬Èç¹ûûÓУ¬Ôò˵Ã÷ÊÇ32λµÄ¡£

FLAGµÄÏêϸµÄ½âÊÍÊǶ¨ÒåÔÚcpufeature.hÍ·ÎļþÖеģ¬ÀïÃæ¹ØÓÚLMµÄ½âÊÍÊÇLong Mode (x86-64)£¬Õâ¸öÎļþÔÚ64λϵͳÉÏλÓÚ/usr/include/asm-x86_64Ŀ¼Ï£¬ÔÚ32λϵͳÖÐλÓÚ/usr/include/asmĿ¼Ï£¬ÏÂÃæÁÐÒ»¸ö64λµÄcpufeatureµÄÍ·Îļþ×ö¸ö¼Ç¼°É

 ²é¿´È«ÎÄ