Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

Oracleʱ¼äÀàÐÍÊý¾ÝΪ0µÄbug

Ó¦ÓÃÊý¾Ý¿âÖмǼÖÐdateÁÐĪÃûÆäÃîµÄ³öÏÖÁ˼¸¸öֵΪ0000-00-00µÄÊý¾Ý¡£
¸ü¿ÉŵÄÊÇÈç¹û½«ÕâÑùµÄ¼Ç¼½øÐжÁÈ¡³ÉΪvarchar2ºóÔÙto_dateת»»»ØÈ¥¾Í»á±¨´í¡£
ÎÊÌâÎÞ´Ó²éÆð£¬Ö»ËµÒ»ÏÂ×îÖÕͬÊÂËÑË÷µ½µÄÁ¬½Ó½á¹û£ºhttp://www.hellodba.com/Doc/oracle_date_zero_bug.htm
¿´À´µÄÈ·ÊÇoracleµÄÒ»¸öbug¡£
ÁíÍâÐèҪעÒâµÄÊÇ£¬ÔÚʹÓÃjava.sql.DateµÄvalueOf()·½·¨µÄʱºò£¬Ò²ÊDz»»á½øÐÐÈκμìÑéµÄ¡£Ö±½Ó½«ÏàÓ¦µÄֵת»»ÎªDate£¬Òò´Ë
Èç¹ûÖ´ÐÐÁËjava.sql.Date.valueOf("0000-01-03");ÕâÑùµÄ·½·¨£¬ÔÚ²åÈëµ½oracleÖкó¾Í»á±ä³É0000-00-00µÄÊý¾Ý
ÍÛ¹þ¹þ£¬²»´í²»´í£¬¼ÌitpubÖ®ºóÓÖ·¢ÏÖÒ»¸ödbaµÄÍøÕ¾¡£


Ïà¹ØÎĵµ£º

oracle¹ÜÀí±í¿Õ¼äºÍÊý¾ÝÎļþ

'
ALTER TABLESPACE app_data
      ADD DATAFILE 'u01/oradata/userdata03.dbf'
SIZE 200M;
'´´½¨±í¿Õ¼ä
CREATE TABLESPACE userdata
DATAFILE 'u01/oradata/userdata03.dbf' SIZE 100M
AUTOEXTEND ON NEXT 5M MAXSIZE 200M;
'´´½¨»Ø¹ö±í¿Õ¼ä
CREATE UNDO TABLESPACE undo1
DATAFILE ' ......

AIX Oracle RAC Éý¼¶µ½10.2.0.4.0ÒªÌØ±ð×¢ÒâµÄÎÊÌâ

AIX Oracle RAC Éý¼¶µ½10.2.0.4.0¹ý³ÌÓÐÈçϱ¨´í(Ö±½ÓÉý¼¶µ½10.2.0.4²»ÐèÒªÓ¦ÓÃPatch:6160398)£º
 root@bwgl_db2:/u01/app/oracle/crs_1/bin# /u01/app/oracle/crs_1/install/root102.sh
Error : Please change the CRS_ORACLE_USER id <oracle> to have the following OS capabilities :
  <CAP_BYP ......

Oracle RAC 10.2.0.1 Éý¼¶ 10.2.0.4 ¼òµ¥ÃèÊö

ÍÆ¼öcrs°æ±¾¸ßÓÚdb°æ±¾
If you also plan to apply this patch to Oracle Clusterware,
ensure that you apply the patch to Oracle Clusterware before
applying it to Oracle Database. This is because Oracle Clusterware
hould always be at the same or later version as the database.
Éæ¼°µ½Êý¾Ý¿â¶ø²»ÊÇʵÀýµ ......

ORACLE ѧϰ

Ò»¡¢°²×°(ÂÔ)
      ·þÎñÆ÷¶Ë
      1¡¢windows:£¨ÂÔ£©
      2¡¢linux:´ýÐø...
      ¿Í»§¶Ë
         ´ýÐø...
     --°üÀ¨ÅäÖÃ--
¶þ¡¢µÇ½
......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ