OracleÆô¶¯ÎÊÌâ
¸÷λºÃ£¡×Éѯһ¸öÎÊÌ⣬ÍûÖ¸½Ì¡£
ÈçÏ£º
×ÊÁÏÉÏ˵Æô¶¯OracleÊý¾Ý¿âÐèÒª¼¸¸ö²ÎÊýÎļþ£¬SPFILEORCL.ORA»òÕßinit.ora.162010112236.µ«ÊÇÎÒɾµôÕâÁ½¸ö²ÎÊýÎļþʱ£¬·¢ÏÖOracleServiceORCLÕâ¸ö·þÎñÈÔÈ»¿ÉÒÔÆô¶¯£¬Ã»ÓÐÈκÎÎÊÌ⣬Õâ¸öµ½µ×ÊÇÔõô»ØÊ°¡£¿¶øÇÒÎÒ·´¸´ÊÔÑéÁ˺ܶà´Î¶¼ÊÇÕâÑù£¬·Ç³£ÓôÃÆ¡£
ÇëÇó¸ßÊÖÖ¸µã¡¡
ÊDz»ÊÇ»¹ÓиöPFILEORCL.ORA£¿
°Ñinit.oraҲɾµô ÊÔÊÔ
¶¼ÊÔ¹ýÁË »¹ÊÇ¿ÉÒÔÕý³£Æô¶¯£¬µ«ÊÇÁ¬½Ó²»ÉÏÊý¾Ý¿â
ÕâÑù¾Í¿ÉÒÔÁË oracleÎÞ·¨´´½¨ºÍÆô¶¯instance
ȱÉÙÄǼ¸¸öÎļþ²¢²»ÊÇoracle·þÎñ²»ÄÜÆô¶¯
¿´À´Ä㻹ûÓи㶮·þÎñ¡¢Àý³ÌÒÔ¼°Êý¾Ý¿âµÄ¹ØÏµ
·þÎñÖ»ÒªÄãÄãµÄÍøÂç·þÎñÃûÅäÖÃÕýÈ·£¬¾ÍÄܹ»Æô¶¯ÆðÀ´
Ëû²¢²»Éæ¼°Êý¾Ý¿âµÄÎïÀí½á¹¹µÄÏà¹ØÎļþ
¶øÊý¾Ý¿âµÄÆô¶¯¹ý³ÌÊÇ£º
ÏÈÆô¶¯Àý³Ì£¬¼´·ÖÅäÒ»¶¨µÄÄÚ´æ¿Õ¼äÒÔ¼°Æô¶¯ºǫ́½ø³Ì
È»ºó¼ÓÔØÊý¾Ý¿â£¬¼´Í¨¹ý²ÎÊýÎļþ£¨Ò²¾ÍÊÇpfileºÍspfileÁË£©´ò¿ª¿ØÖÆÎļþ£¬´Ó¶ø»ñÈ¡Êý¾Ý¿âµÄÏà¹ØÐÅÏ¢¡£
×îºóͨ¹ý¿ØÖÆÎļþ´ò¿ªÊý¾ÝÎļþÒÔ¼°ÖØ×öÈÕÖ¾Îļþ£¬Ò²¾ÍÊÇ´ò¿ªÊý¾Ý¿âÁË¡£
Õâ¸ö¹ý³ÌºÃºÃÀí½âһϰÉ
Ïà¹ØÎÊ´ð£º
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæµÄÔʼÎļþ,ÏÂÔØµ½±¾»úÁË.ÎÒÏëÔÚ±¾»ú·ÃÎÊÊý¾Ý¿âÔõôÉèÖð¡.ÊDz»ÊÇÀàËÆ¿ÉÒÔ½¨Á¢Ò»¸öʲôÐéÄâ·þÎñÆ÷À´ÊµÏÖ.Çë´ó¼Ò³ö³öÖ÷Òâ
ÒýÓÃ
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæ ......
ÔÚÖ´ÐаüµÄʱºòÒýÓÃ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 ......
ÎÒÓÐÒ»¸öserver 2000ÀïµÄÊý¾Ý,ÏÖÔÚÏëתµ½oracleÊý¾Ý¿âÉÏÓÃ,²»ÖªµÀÓÐûÓиßÊÖÓмòµ¥ÓÖ¿ì½ÝµÄ·½·¨,ǰÌáÊDz»ÄܸÄÔÀ´oracleÀïµÄÔÓеÄÊý¾Ý¿â,Ö»ÄÜн¨
ÒýÓÃ
°²×°£Ï£Ò£Á£Ã£Ì£ÅµÄ£Ï£Ä£Â£Ã£¬È»ºóÓãӣѣ̡¡£Ó£Å£Ò£Ö£Å£ ......
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 ......