oracle - Oracle / »ù´¡ºÍ¹ÜÀí
ÎҵĵçÄÔ°²×°ÁËoracle 10g£¬Ò»Ö±¿ÉÒÔÕý³£Ê¹Ó᣿ÉÊÇ£¬½ñÌìÎÒÔÚä¯ÀÀÆ÷ÊäÈëhttp://localhost:5500/em²»ÄÜ´ò¿ªÊý¾Ý¿âµÇ½¶ËÁË£¬ÒÔǰÄÜ´ò¿ªµÄ¡£ÎÒÓÖÔÚÃüÁîÌáʾ·ûÏ£¬ÊäÈësqlplus /nolog Äܵǽµ½Êý¾Ý¿â¡£½ñÌìÎҵĵçÄÔ°²×°ÁËSQL SEVER 2005£¬»¹°²×°ÁËiis5.1£¬»á²»»á¸úÕâ¸öÓйذ¡£¿»¹Çë¸ßÈËÖ¸½Ì£¬ÎÒÏëÈÃoracle 10gÓësql sever 2005ÔÚһ̨µçÄÔÉ϶¼Õý³£ÔËÐС£
emµÄĬÈ϶˿ÚÊÇ1158£¬ÄãûÓÐÓÃĬÈ϶˿ڣ¿ ÓÐÎÞ±¨´í£¬¿ÉÌùÉÏÀ´¿´Ò»¿´.ÒýÓà ¿ÉÄÜÊÇOEM ·þÎñûÓÐÆô¶¯£¬ Äã¼ì²éÏÂOracleDBconsole Õâ¸ö·þÎñ£¬¿´ÓÐûÓÐÆô¶¯¡£ Ò²¿ÉÒÔͨ¹ýÃüÁîÀ´¼ì²é£º C:>emctl status dbconsole C:>emctl start dbconsole sqlplus /nolog Äܵǽµ½Êý¾Ý¿â,ÊÇÒòΪÊý¾Ý¿â·þÎñÆô¶¯ÁË¡£ ËùÒÔÄÜÁ¬½Ó¡£ Oracle Æô¶¯ÐèÒªÈý¸ö·þÎñ£º OEMµÄOracleDBcons¡¡ up ллһ¥µÄ»Ø´ð£¬ÎҲ鿴¹ýÁË£¬Èý¸ö·þÎñ¶¼ÊÇÆô¶¯×´Ì¬£¬»¹ÊÇÎÞ·¨´ò¿ªµÇ½¶Ë¡£2¥˵µÄĬÈ϶˿Ú1158ÎÒÊÔ¹ýÁË£¬²»ÐС£²»¹ýÎÒÒѾÄÜ´ò¿ªµÇ½¶ËÁË£¬ÎÒÓÃä¯ÀÀÆ÷Àï±£´æµÄÒÔǰ³É¹¦µÇ½µÄµØÖ·£¬ºÜ³¤µÄÒ»´®ÄÜ´ò¿ª¡£¾ÍÊDz»ÖªµÀΪʲôֻÊäÈëhttp://localhost:5500/em²»ÄÜ´ò¿ª£¬ÒÔǰÄÜ´ò¿ªµÄ¡£ ÓÐЩ·þÎñÐèÒªÊÖ¶¯´ò¿ª£¬Ä㿴һϠлл¸÷λµÄ»Ø´ð£¬¸Ðл£¡ÎÊÌâ½â¾öÁË¡£ÊÇÓÐЩ·þÎñûÓдò¿ª£¬ÎÊÌâ½â¾öÁË£¬ÎÒҲѧ»áÁËһЩ·þÎñÏà¹ØµÄ֪ʶ£¬Õæ³ÏµÄ¸Ðл¸÷λµÄÖ¸½Ì£¡
Ïà¹ØÎÊ´ð£º
exp user/password@dbname file=c:\table.dmp tables=jbitaku,jbitakum grants=y È»áá°´»Ø車鍵 說Ã÷:¡¡ user/password@dbname ¡¡·Ö別±íʾÓÃ戶Ãû£¬ÃÜ碼ºÍ·þ務Ãû f ......
ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡ ORA-01034:ORACLE not available ORA-27101:shared memory realm does not exist ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡ 1. Oracle sid ÕýÈ ......
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 / ......
ÎÒ°²×°ÁËoracle 10g¾¹ýÒ»·¬Å¬Á¦Äܹ»Ë³ÀûµÄÁ¬½ÓÉÏÁË£¬ µ«ÊÇÎÒÒÔǰÓõÄÊÇsql server ËûµÄÆóÒµ¹ÜÀíÆ÷ÖÐÄÜ¶Ô±í½øÐпÉÊÓ»¯¹ÜÀí ÔÚoracleÖÐÎÒÒ²¿´µ½ÁËÓпÉÊÓ»¯µÄem µ«ÊÇÎÒ¾ÍÊÇ¿´²»µ½±íµÄÄÚÈÝÀ´ ÇëÎÊÓÐûÓдóϺÄܰï°ïà ......
¿´µ½ÓÐÒ»¸öSUNµÄÔªÀÏ´ÓOracle¹«Ë¾´ÇÖ°£¬¶øÇÒÊÇJava´´Ê¼ÈË——´óÃû¶¦¶¦µÄJames Gosling£¬ ÐÄÖÐÏ൱ÊÜ´ò»÷£¡ºÜ±¯Í´£¡ OrableÕâÊÇÔõôÁË£¬ÄѵÀÕâ¾ÍÊÇËùνµÄÈںϣ¨Ö«½â£¬·Ö»¯£¬Ïûʧ£©Â𣿠SUNµÄÒ»°ïÀÏÔ±¹¤¶ ......