ż±È½Ï²Ë£¬ÏëÎÊÏÂOracleÆóÒµ¹ÜÀíÆ÷ÖÐÔõÑù²éѯÊý¾Ý°¡£¿
ÎÒÔõôֻÄÜ¿´µ½±íµÄÐÅÏ¢£¬¿´²»µ½¾ßÌåÊý¾ÝÄÇ£¿×¢£ºÅ¼ÖªµÀÔõôÓÃSQLÓï¾ä²é£¬ËùÒÔÇëÖ±½Ó¸æËßÎÒÔõôÔÚÆóÒµ¹ÜÀíÆ÷Öп´µ½Êý¾Ý¡£Ð»Ð»¸÷λ°ïæ¡£
ÆóÒµ¹ÜÀíÆ÷ûÓвéѯÊý¾ÝµÄµØ·½ ½¨Òé×°Ò»¸öPL/SQL DEVELOPER»òÕßTOAD£¬ºÜºÃÓà µ±È»,sqlplusÒ²²»´í ÔÚEMÀïÑ¡ÖÐÄ¿±ê±í£¬ÓҲࡰ²Ù×÷¡±À¸µÄÏÂÀ¿òÀÓС°²é¿´Êý¾Ý¡±Ñ¡ÏѡÔñÖ®£¬È»ºóµ¥»÷¡°¿ªÊ¼¡±°´Å¥£¬¼´¿É¿´¼û±íÄÚ¾ßÌåÊý¾Ý¡£ ѧϰÁË Ôڲ鿴Êý¾ÝµÄͬʱ£¬Ò²¿ÉÊÇÉè¼Æ²éѯϸ½Ú£¬¼´¹ýÂËÌõ¼þ¡£°´ÕÕÒ³ÃæÌáʾÀ´×ö¡£ÒýÓà ÎÒÔõôֻÄÜ¿´µ½±íµÄÐÅÏ¢£¬¿´²»µ½¾ßÌåÊý¾ÝÄÇ£¿×¢£ºÅ¼ÖªµÀÔõôÓÃSQLÓï¾ä²é£¬ËùÒÔÇëÖ±½Ó¸æËßÎÒÔõôÔÚÆóÒµ¹ÜÀíÆ÷Öп´µ½Êý¾Ý¡£Ð»Ð»¸÷λ°ïæ¡£ oracleÀïÃæÃ»ÓÐÆóÒµ¹ÜÀíÆ÷°É£¬ÄãÔÚplsqlÀïÃæ¿ÉÒÔÓÃsql²éѯÓï¾ä¿´µ½µÄ¡£ »òÕßÔÙsqlplusÒ²¿ÉÒÔ¿´µ½µÄ¡£ 2Â¥µÄ£¬Ê×ÏȸÐлÄãµÄ»Ø´ð¡£²»¹ýÎÒûÕÒµ½Å¶¡£ÎÒÓõÄÊÇ9I¡£ ¶÷£¬ÎÒÒÔΪÄãÖ¸µÄÊÇ10g¡£ 9iÔÚ±íÉϵãÓÒ¼ü£¬ºÃÏóÓиöʲô¡°ä¯ÀÀĿ¼ÄÚÈÝ¡±Ê²Ã´µÄÑ¡Ïî¡£ºÜ¾Ã²»ÓÃ9iÒÔ¼°ORACLEÆóÒµ¹ÜÀíÆ÷ÁË£¬Ó¡ÏóÄ£ºý¡£Äã×ÐϸÕÒÕÒÓÒ¼ü²Ëµ¥¡£ 9iµÄÕâ¸öÕæÃ»ÓС£¡£¡£ ÎÞÂÛ9i»¹ÊÇ10g£¬ÆóÒµ¹ÜÀíÆ÷Àï¶¼¿ÉÒÔÖ±½Óä¯ÀÀ±íÊý¾Ý¡£ ²»ÖªµÀÊDz»ÊÇÎÒÌ«±¿ÁË£¬Ã»ÓÐÕÒµ½¡£ Ī·ÇÕæµÄûÓÐÂ𣿠ºÇºÇ£¬ÎÒÔø¾ÓÃËü²é¿´¹ý±íÊý¾Ý¡£¸æËßÎÒQ£¬Ô¶³ÌÐÖú£¬³ý·ÇÄã½øµÄ²»ÊÇÆóÒµ¹ÜÀíÆ÷¡£ 9iÔÚÆóÒµ¹ÜÀíÖÐÓÒ¼ü±íÃû³Æ£¬Óиö¡°±íÊý¾Ý±à¼Æ÷¡±ÀïÃæÓжÔÓ¦µÄÊý¾Ý~~~ ллsuiziguo£¬tianyihuyidao30£¬ÔÚÄãÃǵİïÖúÏÂÎÒÖÕÓÚÕÒµ½ÁË£¬ÔÚ9IÀïÓ¦¸ÃÊÇÓÒ¼ü²é¿´¡¢±à¼Ä¿Â¼¡£
Ïà¹ØÎÊ´ð£º
°²×°ÁËOracle 10g£¬Ä¬Èϰ²×°ÁËorclÊý¾Ý¿â£¬Õâ¸öÊý¾Ý¿âÄܲ»ÄÜɾ³ý°¡£¬»¹ÓÐÎÒÈç¹ûн¨ÁËÆäËûÊý¾Ý¿â£¬Ôõô֪µÀÔÚwebÖеǽ²»Í¬Êý¾Ý¿âµÄµØÖ·°¡£¿ 1 ¿ÉÒÔɾ³ý 2 ÔÚWEBµØÖ·À¸ÖÐÊäÈëµØÖ·µÄʱºòÖ¸¶¨Ð´´½¨µÄÊý¾Ý¿âµÄIP ......
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæµÄÔʼÎļþ,ÏÂÔØµ½±¾»úÁË.ÎÒÏëÔÚ±¾»ú·ÃÎÊÊý¾Ý¿âÔõôÉèÖð¡.ÊDz»ÊÇÀàËÆ¿ÉÒÔ½¨Á¢Ò»¸öʲôÐéÄâ·þÎñÆ÷À´ÊµÏÖ.Çë´ó¼Ò³ö³öÖ÷Òâ ÒýÓà ´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæ ......
private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl"; private static final String USERNAME = "sys"; private static final String PASSWORD = "s ......
СµÜ£¬×î½üҪתÐÐÈ¥×öoracle¿ª·¢ÁË£¬ÓÉÓÚ´óѧ±Ïҵʱ£¬×ßÁ˸öÍä·£¬ÏÖÔÚºÜСÐÄ£¬ÎÊÏ£¬×öPL/SQLÓÐûÓÐǰ;£¿£¿£¿ µ±È»ÎÒ˵µÄÕâ¸öǰ;ÊÇÖ¸ ÒÔºóÒªÌø²Û£¬Êг¡¶ÔÕâÑùµÄÈ˲ŵÄÐèÇóÁ¿´ó²»´ó£¿£¿ 3q ÄÇ¿´À´»¹Ö»ÄÜÏȽӴ ......
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 / ......