ÓÐûÓÐwindowsÏÂÃæµÄoracle 10g¿Í»§¶Ë£¿
ÏÖÔÚÔÚÎҵijÌÐòÀïÃæÍ¨¹ý ocilibÀ´·ÃÎÊÁËÁíһ̨·þÎñÆ÷ÉϵÄoracleÊý¾Ý¿â¡£ ÄÇÔÚÎÒ»ú×ÓÉÏÒª±àÒë²âÊÔÕâ¸ö³ÌÐòµÄ»°£¬ÎÒÖÁÉÙҪװЩʲô£¿ ÎÒ²»Ïë×°ÄǸö600¶àMµÄ¶«Î÷£¬Ì«´óÁË£¬¶øÇÒ¶ÔÎÒÀ´ËµºÃ¶à¶«Î÷¶¼Ã»Óã¬ÒòΪÎÒ²¢²»ÔÚ±¾µØ´´½¨Êý¾Ý¿â¡¡ ÓÐûÓбȽÏСµÄһЩ¶«Î÷£¬¶øÇÒÓÃocilib¿â¿ÉÒÔ·ÃÎÊ ÎÒÔõô²ÅÄÜÔÚ±¾µØ×°×îÉٵĶ«Î÷À´·ÃÎÊÔ¶µØµÄoracleÊý¾Ý¿â£º£¿£¿ лл£¡£¡£¡£¡
ÄǸöÖÁÉÙҪװsql net; Èç¹ûÓÃdelphiд´úÂ룬¿ÉÒÔʹÓÃodac¿Ø¼þ£¬²»ÐèÒª°²×°¿Í»§¶Ë Ö»ÐèÒªÌáÈ¡oralceÊý¾Ý¿âµÄ¼¸¸ö¶¯Ì¬¿â¾ÍÐÐÁË ¿Í»§¶Ë²»ÐèÒª°²×°oracleµÄ Ŷ£¿ ÍøÉÏÓÐûÓÐÒѾ´òºÃµÄ°üÌṩµÄ£¿ лл£¡ Ö±½Óplsqldevelop²»¾ÍÐÐÁË£¿ pl/sql¾ÍokÁË Å¶£¬Ð»Ð»~~~ Ã÷ÌìÈ¥¹«Ë¾ÊÔһϠ:-) ÎÒÊdzõѧÕßÒýÓà ֱ½Óplsqldevelop²»¾ÍÐÐÁË£¿ Õâ¸ö¾ÍºÜOKÁËÒýÓà ֱ½Óplsqldevelop²»¾ÍÐÐÁË£¿ ÄܺÍ10g¼æÈݵÄÓÃ8°æ±¾ÒÔÉϵÄplsqldevelop Èç¹û²»×°oracle¿Í»§¶ËµÄ»°£¬ÓÃpl/sqlû·¨Á¬½ÓÊý¾Ý¿âµÄѽ ÌáʾûÓÐ×°¿Í»§¶Ë£¬囧 ×°ÁËinstant clientºÍpl sql develop µ«ÏÖÔÚÓÃpl sqlÁ¬½ÓµÄʱºò×ÜÊÇÌáʾÎÞ·¨Ê¶±ðÃèÊö·ûÖеÄÇëÇó ÔÚÍøÉÏËÑÁËһϣ¬ËµÊÇtnsnames.oraµÄÎÊÌâ µ«ÓÖ²»ÖªµÀÓ¦¸ÃÔõô¸Ä¡¡ лл´ó¼ÒÁË£¬ÒѾ³É¹¦ÁË~~~ µ«ÎÒÔÚ³ÌÐòÀïÃæÓÃOCI_InitializeÀ´³õʼ»¯ocilib¿âµÄʱºò³ö´íÁË¡¡ ÕâÊÇΪʲô£¿ лл£¡
Ïà¹ØÎÊ´ð£º
ÇëÎÊÕâ¸ö»º³å³ØÊÇÔõô»ØÊ°¡£¿¿ÉÒÔÁ¬½Ó»º³å³ØÀûÓÃÆäÖеÄÊý¾Ý°É£¿ÔõôÓã¿ Õâ¸öÊÇoracle×Ô¶¯×öµÄ£¬Ò»°ãÓ¦ÓóÌÐòÊDzÙ×÷²»Á˵ġ£ ²»ÄÜÖ±½ÓÁ¬½ÓÂ𣿠ÒýÓà ²»ÄÜÖ±½ÓÁ¬½ÓÂ𣿠²»ÄÜ ÄÇ»º³å³ØÀïµÄÊý¾ÝÒ²²»Äܲéѯ ......
ÔÚÖ´ÐаüµÄʱºòÒýÓÃoracle spatial¿Õ¼äº¯Êý³ö´í£¬³ö´íÇé¿öÈçÏ Errors in file /user/oracle/app/oracle/admin/grid/udump/grid1_ora_143768.trc: ORA-29902: error in executing ODCIIndexStart() routine ORA-0 ......
СµÜ£¬×î½üҪתÐÐÈ¥×öoracle¿ª·¢ÁË£¬ÓÉÓÚ´óѧ±Ïҵʱ£¬×ßÁ˸öÍä·£¬ÏÖÔÚºÜСÐÄ£¬ÎÊÏ£¬×öPL/SQLÓÐûÓÐǰ;£¿£¿£¿ µ±È»ÎÒ˵µÄÕâ¸öǰ;ÊÇÖ¸ ÒÔºóÒªÌø²Û£¬Êг¡¶ÔÕâÑùµÄÈ˲ŵÄÐèÇóÁ¿´ó²»´ó£¿£¿ 3q ÄÇ¿´À´»¹Ö»ÄÜÏȽӴ ......
select sum£¨a.t)from ta a group by ta.a,ÕâÌõÓï¾ä½«±ítaÖеÄÊý¾Ý°´ÕÕa×ֶηÖ×é»ã×Üt×ֶΡ£ ½á¹û±ÈÈ磺 3 30 4 50 ÎÒÏëµÃµ½Õâ¸ö½á¹û£º 1 0 2 0 3 30 4 50 5 0 Õâ¸ö½á¹û£¬ÇëÎÊsqlÓï¾äÔõôд£¿¶àл nobody ......
oracle 11g °²×° 01092 ´íÎó, ÈÕÖ¾ÐÅÏ¢£º [oracle@linux trace]$ vi alert_orcl.log MMON started with pid=14, OS id=9089 RESETLOGS after incomplete recovery UNTIL CHANGE 522752 Errors in file / ......