25 06, 2008
10G RACÖеÄCSS TIMEOUTÏà¹ØµÄÉèÖú͵÷Õû
ÕâÆªÎÄÕÂÊÇżÓðëÉú²»ÊìµÄEÎÄ·Òë¹ýÀ´µÄ£¬ËùÒԺܶà¿ÉÄÜ¿´×źܱðŤ£¬EÎĺõĽ¨ÒéÖ±½Ó¿´ÔÎÄ£¬ÔÚMETALINKÖеÄ294430.1£¬284752.1ºÍ309542.1ÈýƪÎÄÕÂÖС£
CSSµÄMISSCOUNT²ÎÊý¶¨ÒåÁ˼¯ÈºÖØÐÂÅäÖò¢ÇýÖðÒ»¸ö½Úµãǰ£¬Õâ¸ö½ÚµãµÄÐÄÌø¿ÉÒÔȱʧµÄʱ¼ä£¬µ¥Î»ÊÇÃë¡£ÆäÖи÷¸öƽ̨µÄȱʡµÄMISSCOUNTÈçÏ£º
LinuxÏÂ60Ã룬Unix¡¢VMSºÍWindows϶¼ÊÇ30Ã룬¶ÔÓÚÆäËû·ÇORACLEÌṩµÄCLUSTERÀ´Ëµ£¬È±Ê¡µÄMISSCOUNTÊÇ600Ã룬ÕâÊÇΪÁ˸øÆäËûµÄ¼¯ÈºÌṩÉÌÌṩ×ã¹»µÄʱ¼äÀ´½â¾öÈκγ¡¾°ÏµÄÄÔÁÑ¡£
CSSÐÄÌøµÄ»úÖÆºÍËûÃÇÖ®¼äµÄÏ໥¹ØÏµ:
²é¿´È«ÎÄ18 06, 2008
ϵͳÈÕÖ¾ÖгöÏÖ´óÁ¿µÄtruncating integer value to 32 bitsÐÅÏ¢
REDHAT AS4U4µÄX86_64ϵͳ£¬ÔÚϵͳµÄ/VAR/LOG/MESSAGEÈÕÖ¾ÖгöÏÖ´óÁ¿µÄtruncating integer value to 32 bitsÐÅÏ¢£¬ÍêÕûµÄÐÅÏ¢ÈçÏ£º
Jun 18 11:22:10 billdb1 snmpd[26994]: send response:
Jun 18 11:22:10 billdb1 snmpd[26994]: truncating integer value to 32 bits
Jun 18 11:22:10 billdb1 snmpd[26994]: truncating uinteger value to 32 bits
Jun 18 11:22:10 billdb1 snmpd[26994]: truncating uinteger value to 32 bits
Jun 18 11:22:13 billdb1 snmpd[26994]: truncating integer value to 32 bits
Jun 18 11:22:13 billdb1 snmpd[26994]: truncating uinteger value to 32 bits
Jun 18 11:22:13 billdb1 snmpd[26994]: truncating uinteger value to 32 bits
Jun 18 11:22:16 billdb1 snmpd[26994]: truncating integer value to 32 bits
Jun 18 11:22:16 billdb1 snmpd[26994]: truncating uinteger value to 32 bits
Jun 18 11:22:16 billdb1 snmpd[26994]: truncating uinteger value to 32 bits
ÒòΪϵͳÓÐʹÓÃSNMP½øÐв¿·Ö¼à¿Ø£¬µ¼ÖÂÉÏÃæÐÅÏ¢²»Í£µÄ³öÏÖÔÚMESSAGEÈÕÖ¾ÖУ¬µ¼ÖÂÓÐÓõÄϵͳÐÅÏ¢±»ÑÍûÆäÖС£GOOGLEÁ˰ëÌ죬Ӧ¸ÃÊÇREDHATƽ̨ÉϵÄNET-SNMP°üµÄÒ»¸öBUGµ¼Öµġ£
²é¿´È«ÎÄ16 06, 2008
Ö÷¿âǧÍò¼¶µÄÊý¾Ý¸üкó£¬STANDBYÈÕÖ¾Ó¦ÓôóÁ¿ÑÓ³ÙµÄÎÊÌâ´¦Àí
ÒòΪҵÎñÐèÒª£¬²»µÃ²»ÔÚÉú²úÉϸüÐÂÒ»¸öǧÍò¼¶µÄ´ó±í£¬¸üйý³ÌÖвúÉúÁË4¸öG×óÓÒµÄÈÕÖ¾ºó·¢Ïִ˸üлᵼÖÂÆäËûÎÊÌ⣬ȡÏû¸üУ¬È»ºó¸üÕý¸üеÄÂß¼ºó£¬ÖØÐ¶ÔÕâǧÍò¼¶µÄÊý¾Ý½øÐиüУ¬²úÉú6¸ö¶àGµÄÈÕÖ¾ºó£¬¸üÐÂÍê³É£¬µ«ÊÇÈ´Ôì³ÉÁËÆäËûÁ½¸öÂß¼STANDBYµÄ´óÁ¿ÑÓ³Ù¡£ÈçºÎ¼Ó¿ìÕâЩÈÕÖ¾µÄÓ¦Óã¬ÊÇÒ»¸ö±È½ÏÑÏÖØµÄÎÊÌâ¡£
²é¿´È«ÎÄ14 06, 2008
ORACLE CRSÈÕÖ¾ÖеÄClssnmPollingThread Missed Checkins Messages
×î½ü·¢ÏÖCRSÈÕÖ¾ÖеÄmissed checkinºÜ¶à£¬ÓÐʱºòÓÐÁ¬×Ž«½ü20´Î£¬Ö®Ç°ÓйýÒ»´ÎRACµÄå´»ú¼Ç¼£¬ËùÒÔ¶ÔÕâ¸ößËß˺ܾ¯¾õ¡£CRSÖУ¬»á¶¨ÆÚµÄÈ¥¶ÁÈ¡VOTING DISKÉϵÄÐÅÏ¢À´ÅжÏCLUSTERÖеÄÿ¸ö½ÚµãµÄ»î¶¯×´Ì¬£¬Èç¹û³öÏÖ¶à´ÎµÄ¶Áȡʧ°Ü£¬ÔòÈÏΪÕâ¸ö½ÚµãÒѾËÀµô£¬»ú»á°ÑËü¸Ï³öCLUSTERÁË¡£¶Áȡʧ°ÜµÄ²ÎÊýÊÇ¿ÉÒÔͨ¹ýCRSCTLÃüÁîÉèÖõģ¬Õâ¸öֵȱʡÊÇ60´Î¡£crsctl get css misscountÃüÁî¿ÉÒÔ·µ»Øµ±Ç°ÉèÖõÄÖµ£¬crsctl set css misscount 120ÔòÊǰÑʧ°Ü´ÎÊýÉèÖÃΪ120´Î¡£Ò»°ãÊDz»ÐèÒªµ÷ÕûÕâ¸öÖµµÄ£¬Èç¹ûµ÷ÕûÒ²²»Òªµ÷µÄÌ«´ó¡£»¹ÊÇÀ´¿´¿´metalinkÉÏÊÇÔõô˵µÄ°É¡£
²é¿´È«ÎÄ5 06, 2008
LINTENER.ORAÖеÄSID_NAMEºÍSERVICE_NAME´óдµ¼ÖÂORA-01031: insufficient privileges
´´½¨Ò»¸öRAC TO RACµÄSTANDBY£¬×ßµ½ÎªSTANDBY´´½¨¿ÚÁîÎļþ£¬È»ºóSTARTUP STANDBY¿âµ½NOMOUNT״̬£¬È»ºó´ÓÖ÷¿â¿ªÊ¼RMAN»Ö¸´À´´´½¨STANDBYµÄʱºò£¬±¨´í£ºORA-01031: insufficient privilege£¬ÓÚÊdz¢ÊÔÊÖ¹¤µÄͨ¹ýSQLPLUS SYS/PASSWORD@TNSNAME AS SYSDBA£¬±¨Í¬ÑùµÄ´íÎó£¬ÕâÑùµÄ´íÎóÅö¼û¼¸´ÎÁË£¬Î޷ǾÍÊÇ¿ÚÁîÎļþµÄÎÊÌ⣬»òÕß¾ÍÊÇremote_login_passwordfile²ÎÊýÉèÖõÄÎÊÌ⣬ÔÙÕß¾ÍÊÇSQLNET.ORAµÄÎÊÌâÁË£¬½á¹ûÕâÈýÕÐÓñéÁ˶¼²»ºÃʹ£¬¼û¹í¡£
²é¿´È«ÎÄ31 05, 2008
Åö¼ûÒ»¸öBLOCKING_SESSIONÏÔʾ²»ÕýÈ·µÄBUG
REDHAT LINUX AS4U4ÉÏÔËÐеÄ3¸ö½ÚµãµÄORACLE 10.2.0.2ϵͳ£¬ÒòΪǰ̨ӦÓõÄÔÒò£¬»áµ¼ÖÂijЩÊÂÎñÒ»Ö±²»Ìá½»Ò²²»»Ø¹ö£¬ËùÒÔÕâ¸öÊÂÎñÓ°ÏìµÄ¼Ç¼¾Í»á³öÓÚ¼ÓËø×´Ì¬£¬´Ó¶øµ¼ÖºóÀ´µÄÊÂÎñÐèÒª²Ù×÷Ïàͬ¼Ç¼µÄ¾Í»á³öÏÖÒ»¸öËøµÈ´ýʼþ£¬ÎªÁËÈ·¶¨ÊÇÄĸöSESSION BLOCKÆäËûÊÂÎñ£¬ÓÚÊǸù¾ÝËøµÈ´ýʱ¼ä×µÄSESSIONµÄSIDÈ¥V$SESSIONÊÓͼÖвéÕÒBLOCKING_SESSIONµÄÖµ£¬µÃµ½ÊÇËBLOCKÁËÕâ¸öSESSION£¬ÒÔ±ãÕÒµ½ÎÊÌâµÄ¸ùÔ´£¬È»ºóÆæ¹ÖµÄÎÊÌâ·¢ÉúÁË£¬ÕÒµ½µÄÕâ¸öBLOCKING_SESSIONµÄֵȥV$LOCKÖвéÕÒ£¬È´·¢ÏÖÕâ¸ösession¸ù±¾Ã»ÓÐLOCKÈκÎ×ÊÔ´£¬¶øÇÒ£¬°ÑÕâ¸öSESSIONɱµôÖ®ºó£¬ÔÏȱ»BLOCKµÄSESSION»¹ÊÇ´¦ÓÚBLOCKµÄ״̬£¬¿´À´ÊÇɱ´íSESSIONÁË¡£
¸Ð¾õ²»¿É˼Ò飬ORACLE BUGÅö¼ûµÄ¶à£¬Åö¼ûÕâÖÖ¹íÎÊÌâÊ×ÏÈÏëµ½µÄ¾ÍÊÇMETALINKÁË£¬²éÁËÏ£¬¹ûÈ»ÊǸöBUG£¬¿´¿´ÉÏÃæÊÇÔõô˵µÄ°É¡£
²é¿´È«ÎÄ29 05, 2008
£¨·Ò룩Õï¶ÏºÍ½â¾öORA-04031ÎÊÌâ
×î½üÔÚ¿´ORA-04031£¬½á¹ûÔÚMETALINKÉÏ¿´Ò»¸öÎĵµ£¬»áÒý³öÁíÍ⼸¸öÏà¹ØµÄÎĵµ£¬¿´ÁËÇ°ÃæÍüÁ˺óÃæ£¬¸É´à°ÑÕâЩÎĵµÒ»¸ö¸öµÄ¿´Í꣬Ȼºó·Òëһϣ¬Ï£Íû×îºóÄÜÓÐʱ¼äÔÙд¸ö´ó»ã×ÜÀ´°ÑÕâЩÎÊÌâ»ã×ÜÒ»±é£¬Ó¦¸Ã´ó¶àÊýµÄORA-04031ÎÊÌâ¾ÍÄܹ»±»½â¾öÁË¡£
´ËÎĵµÔÚMETALINKµÄID:146599.1
²é¿´È«ÎÄ27 05, 2008
ORACLE½¨¿â¹ý³ÌÖÐ×Ô¶¯Éú³ÉµÄ¸úËøÏà¹ØµÄVIEW
֮ǰһֱûÓÐ×¢Òâ¹ý£¬¶øÇÒ¶¼ÊÇʹÓÃÏֳɵÄÎĵµÀ´ÊÖ¹¤½¨¿â£¬½ñÌì²Å·¢ÏÖÎÒÃǵÄÊÖ²áûÓÐÖ´ÐÐcatblock.sqlÕâ¸ö½Å±¾£¬ËùÒÔ¾ÍûÓд´½¨ÕâЩÊÓͼ¡£ÕâЩÊÓͼ²»ÊDZØÐëµÄ£¬µ«ÊÇÓÐÁËÕâЩÊÓͼ¿ÉÄÜ»áʹÓÃÆðÀ´·½±ãµã¡£
ORACLE×Ô¶¯´´½¨ÁËÈçϼ¸¸öÊÓͼ£º
DBA_KGLLOCK
DBA_LOCK
DBA_LOCK_INTERNAL
DBA_DML_LOCKS
DBA_DDL_LOCKS
DBA_WAITERS
DBA_BLOCKERS
ËûÃǸ÷×Եĺ¬ÒåÆäʵֻҪ¿´catblock.sql½Å±¾ÖеÄ×¢Ê;ͿÉÒÔÁË£¬ÕâÀïÖ»ÊǰÑ×¢ÊͰá¹ýÀ´£¬¼Ç¼һÏ¡£
²é¿´È«ÎÄ27 05, 2008
£¨×ªÌù£©Out of Memory: Killed process
Èç¹û/VAR/LOG/MESSAGEÖгöÏÖÁËÉÏÃæµÄ´íÎó£¬ÄǾÍÊÇÒòΪijЩ½ø³ÌÒòΪÄÚ´æ²»¹»¶ø±»ÏµÍ³×Ô¶¯É±µôÁË£¬ÏµÍ³×Ô¶¯É±µôijЩ½ø³ÌÖ÷ÒªÊdzöÓÚ¶ÔϵͳÕûÌåµÄ±£»¤£¬±ÜÃâÕû¸öϵͳHANGµô¡£
ÏÂÃæ×ªÔØµÄÎÄÕÂÖÐÏêϸÃèÊöÁËÕâÖÖÎÊÌâ·¢ÉúµÄÔÒòºÍ±ÜÃâµÄ°ì·¨
²é¿´È«ÎÄ26 05, 2008
SHARED POOLÖÐKGH: NOACCESSÕ¼ÓôóÁ¿ÄÚ´æµÄÎÊÌâ·ÖÎö
½ÓÉÏÆªµÄORA-04031´íÎó£¬ÖªµÀÕû¸öSHARED POOLµÄ×é¼þÖУ¬ASM extent pointer arrayÕ¼ÓúܴóµÄÄÚ´æÊÇÏÔʾµÄÒ»¸öBUGºó£¬¼ÌÐø·ÖÎö¸÷¸ö×é¼þÕ¼ÓõÄÄÚ´æ´óС£¬½á¹û·¢ÏÖKGH: NO ACCESS×é¼þÒ²Õ¼ÓÃÁË400¶àM£¬Õâ¸öÓÖÊǸöʲô¹í¶«Î÷ÄØ£¿»¹ÊÇ¿´¿´METALINKÉÏÔõô˵µÄ°É¡£
²é¿´È«ÎÄ25 05, 2008
shared poolÖеÄASM extent pointer array×é¼þ´óСÏÔʾÒì³£µÄBUG
Êý¾Ý¿â±¨¸æ0RA-04031´íÎó£¬Õâ¸öÊǸöºÜ³£¼ûµÄ´íÎóÁË£¬Ê®Ö®°Ë¾ÅÊÇÒòΪSHARED POOL²»¹»´óÁË£¬µ¼ÖÂеĶÔSHARED POOLµÄÉêÇëÐèÇóʧ°Ü¶ø±¨´í¡£ÓÚÊǵǽÊý¾Ý¿â²é¿´V$SGA_STATÊÓͼ£¬¿´¿´Õû¸öshared pool·ÖÅäÖУ¬¸÷¸ö×é¼þÕ¼ÓöàÉÙÄڴ棬ÊÇ·ñÊÇÕæµÄshared pool²»¹»ÁË£¬»¹ÊÇijЩ×é¼þ·¢ÉúÒì³£µ¼Ö¡£½á¹û·¢ÏÖÒ»¸öºÜÆæ¹ÖµÄÏÖÏó£¬Õû¸öshared poolÉèÖÃΪ600M,µ«ÊÇASM extent pointer array×é¼þÕ¼ÓõÄÄÚ´æÈ´ÒѾÓÐ1500MÁË£¬¼û¹í£¬Õâ¸öÊǸöɶ¶«Î÷£¬¾ÓȻռÓÃ1500MµÄ¿Õ¼ä°¡£¿£¿
²é¿´È«ÎÄ23 05, 2008
£¨×ªÔØ£©É¾³ýÎļþºóÓ²Å̿ռ䲻ÊͷŵÄÎÊÌâ
×ªÔØ×Ô£ºhttp://www.linuxdiyf.com/viewarticle.php?id=89776
ºÜ¶àÈË»áÓöµ½ÔÚ²Ù×÷ϵͳÉÏrmµôÒ»¸ö´óµÄÎļþ£¬ÒÔ½â¾öÎļþϵͳ³¬±êµÄÎÊÌ⣬¿ÉÊÇÓеÄʱºîÎļþɾ³ýµôÁË£¬¶ø¿Õ¼äȴδÊͷųöÀ´¡£ÂÛ̳ÉÏÒ²³£³£¼ûÕâÑùÌù×Ó£¬ÎªÊ²Ã´»áÕâÑù£¬ÈçºÎ½â¾öÄØ£¿±¾ÎÄÖ»¾ÖÏÞÓÚHp unixµÄ²Ù×÷ϵͳ¡£
ÔÒòÆäʵºÜ¼òµ¥£¬Ö÷ÒªÊÇÒòΪ±»É¾³ýµÄÎļþÔÚɾ³ýµÄʱºî»¹Êǽø³ÌÔÚ²Ù×÷(´ò¿ª¡¢·ÃÎʵÈ)µÄÔµ¹Ê£¬rmÖ»Íê³ÉÁËÔÚ´ÅÅÌÉÏÎļþʵÌåµÄÊÍ·Å£¬¶øÀàËÆfree list½á¹¹ÖÐÏàÓ¦µÄÎļþϵͳÒò½ø³ÌµÄ²Ù×÷ÏàÓ¦µÄinode²¢Î´ÊÍ·Å¡£
²é¿´È«ÎÄ14 05, 2008
¼òµ¥Á˽âEXT4Îļþϵͳ
×î½ü¿´µ½ÁËÓÐEXT4µÄÎļþϵͳµÄ½éÉÜ£¬ÕÒÁËÒ»ÏÂÕâ¸öÉý¼¶°æµÄÎļþϵͳµÄNEW FEATURE£º
1 Multiblock Allocation
2 Delayed Allocation
3 Break 32000 subdirectory limit
4 directory Inodes reservation
5 nsec timestamps
6 inode version on disk
7 uninitialized groups
8 journal checksumming
9 persistent preallocation
10 Online Defragmentation
11 Undelete Feature for Ext4
12 Large file support
¼òµ¥¿´ÁË¿´£¬Æäʵ¶ÔÓÚ´ó¶àÊýϵͳÀ´Ëµ£¬×ÓĿ¼Êý¡¢µ¥¸öÎļþµÈµÈ¹À¼Æ¶¼ºÜÄÑ´ïµ½EXT3µÄÏÞÖÆµÄ£¬ËùÒÔÕâЩÎüÒýÁ¦¹À¼Æ²»´ó¡£
ÎұȽϹØÐĵÄÊÇUndelete FeatureºÍdirectory Inodes reservation,Ò»¸öÊÇÊý¾ÝµÄUNDELETE£¬ÁíÒ»¸öÊÇÒòΪÎÒÅö¼û¹ýÒòΪInodesÂúµ¼ÖÂlistener²»ÄÜÆô¶¯µÄ°¸Àý£¬µ±Ê±ÊÇÕÒµ½ÏµÍ³Éú³ÉºÜ¶àÁãËéµÄÈÕÖ¾£¬°ÑÕâЩÈÕ־ɾ³ýÁË¡£ÆäʵÈç¹ûInodesÒ²¿ÉÒÔºÍBlockÒ»ÑùÔ¤ÁôÒ»µã£¬ÄÇÉú²úϵͳ·¢ÉúÎÊÌâµÄʱºò£¬ÖÁÉÙ¿ÉÒÔÏÈʹÓÃÔ¤ÁôµÄ²¿·ÖÀ´¾È»ð£¬È»ºóÔÙÂýÂýµÄ½â¾öÎÊÌâÁË¡£
²»¹ý£¬¼òµ¥²éÁËЩ×ÊÁÏ£¬ÔÚĿǰµÄlinuxϵͳÖУ¬ºÃÏñÍêȫʵÏÖÉÏÃæ12¸ö¹¦Äܵķ¢²¼°æ»¹Ã»ÓУ¬ºÜ¶à¶¼Ö»ÊÇÌṩÁ˲¿·ÖµÄ¹¦ÄÜ£¬¶øÇÒ°ÑEXT3 MOUNTΪEXT4µÄʱºò£¬ÊÇMOUNT EXT4DEV¸ñʽµÄ£¬´ÓÕâÀïÒ²¿ÉÒÔ¿´³ö£¬Ä¿Ç°µÄEXT4Ó¦¸ÃÊÇ´¦ÓÚ¿ª·¢ÖеÄEXT4DEV£¬¶ø²»Êǰüº¬È«²¿FEATUREµÄ£¬ËùÒÔʹÓõÄʱºòÒª¿´×Ðϸ¡£
14 05, 2008
ÔÚÂß¼STANDBYÉÏʹÓÃEXPDP½øÐÐÊý¾Ýµ¼³ö±¸·ÝµÄÎÊÌ⣬ORA-39004£¬ORA-39091£¬ORA-16103
ÒòΪÔÚÂß¼STANDBYÉϽ¨ÁËÁíÍâµÄSCHEMAÀ´×ö±¨±í£¬¶øÇÒ±¨±í¿âºÜС£¬ËùÒÔ´òËãÿÌìʹÓÃEXPDP°Ñ±¨±í¿â±¸·Ýһϣ¬¿ÉÊÇʹÓÃEXPDP½øÐб¸·ÝµÄʱºò£¬È´³öÏÖ´íÎóÌáʾ£º
ORA-39004: invalid state
ORA-39091: unable to determine logical standby and streams status
ORA-16103: Logical Standby apply must be stopped to allow this operation
ÌáʾºÜÇå³þ£¬Ö´ÐÐÕâ¸ö²Ù×÷µÄʱºò£¬±ØÐëÍ£Ö¹STANDBY APPLY£¬ÓÚÊǰÑAPPLYÍ££¬¼û¹íµÄÊǾÓÈ»»¹ÊDz»ÐУ¬ÕâÕ¦»ØÊÂÄØ£¿
13 05, 2008
ÔâÓöORA-00600: internal error code, arguments: [kcrrrfswda.11], [4], [368], [], [], [], [], []
Errors in file /u01/app/oracle/admin/billdb/bdump/billdb1_lns1_28689.trc:
ORA-00272: error writing archive log
Thu May 8 22:23:26 2008
LGWR: I/O error 272 archiving log 2 to 'dgp'
DGPÊÇPHYSICAL DATAGUARD£¬¿´À´ÊÇÍùÎïÀíDATAGUARDÉÏдÈÕÖ¾µÄʱºò³öÏÖÎÊÌ⣬ÓÚÊǵǽÎïÀíDATAGUARD»úÆ÷¼ì²é£¬È´·¢ÏÖDATAGUARD»úÆ÷³öÏÖÈç±êÌâËùʾµÄ600´íÎ󣬲鿴TRACEÎļþ£¬Ò»¶Ñ¶þ½øÖƵÄÌìÊé¡£Õ¦°ìÄØ£¿ ²é¿´È«ÎÄ