oracle - Oracle / »ù´¡ºÍ¹ÜÀí
ÎҵĵçÄÔ°²×°ÁËoracle 10g£¬Ò»Ö±¿ÉÒÔÕý³£Ê¹Ó᣿ÉÊÇ£¬½ñÌìÎÒÔÚä¯ÀÀÆ÷ÊäÈëhttp://localhost:5500/em²»ÄÜ´ò¿ªÊý¾Ý¿âµÇ½¶ËÁË£¬ÒÔǰÄÜ´ò¿ªµÄ¡£ÎÒÓÖÔÚÃüÁîÌáʾ·ûÏ£¬ÊäÈësqlplus /nolog Äܵǽµ½Êý¾Ý¿â¡£½ñÌìÎҵĵçÄÔ°²×°ÁËSQL SEVER 2005£¬»¹°²×°ÁËiis5.1£¬»á²»»á¸úÕâ¸öÓйذ¡£¿»¹Çë¸ßÈËÖ¸½Ì£¬ÎÒÏëÈÃoracle 10gÓësql sever 2005ÔÚһ̨µçÄÔÉ϶¼Õý³£ÔËÐС£
emµÄĬÈ϶˿ÚÊÇ1158£¬ÄãûÓÐÓÃĬÈ϶˿ڣ¿
ÓÐÎÞ±¨´í£¬¿ÉÌùÉÏÀ´¿´Ò»¿´.
up
ллһ¥µÄ»Ø´ð£¬ÎҲ鿴¹ýÁË£¬Èý¸ö·þÎñ¶¼ÊÇÆô¶¯×´Ì¬£¬»¹ÊÇÎÞ·¨´ò¿ªµÇ½¶Ë¡£2¥˵µÄĬÈ϶˿Ú1158ÎÒÊÔ¹ýÁË£¬²»ÐС£²»¹ýÎÒÒѾÄÜ´ò¿ªµÇ½¶ËÁË£¬ÎÒÓÃä¯ÀÀÆ÷Àï±£´æµÄÒÔǰ³É¹¦µÇ½µÄµØÖ·£¬ºÜ³¤µÄÒ»´®ÄÜ´ò¿ª¡£¾ÍÊDz»ÖªµÀΪʲôֻÊäÈëhttp://localhost:5500/em²»ÄÜ´ò¿ª£¬ÒÔǰÄÜ´ò¿ªµÄ¡£
ÓÐЩ·þÎñÐèÒªÊÖ¶¯´ò¿ª£¬Äã¿´Ò»ÏÂ
лл¸÷λµÄ»Ø´ð£¬¸Ðл£¡ÎÊÌâ½â¾öÁË¡£ÊÇÓÐЩ·þÎñûÓдò¿ª£¬ÎÊÌâ½â¾öÁË£¬ÎÒҲѧ»áÁËһЩ·þÎñÏà¹ØµÄ֪ʶ£¬Õæ³ÏµÄ¸Ðл¸÷λµÄÖ¸½Ì£¡
Ïà¹ØÎÊ´ð£º
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñ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 ......
ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó
#topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬
Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7
Êý¾ÝÎļþ¹ÒÔØµÄ½Úµã£º/oradata/pcs/ Âß¼¾íºÅlv04
#lslv -l lv04
......
ÎÒÊÇÔÚtoadÖÐÊäÈë϶Îsql
declare
TYPE test_rec IS record(
code varchar(10),
name varchar(30)
);
v_book test_rec;
......
oracleµÄ°²×°ºÍʹÓö¼ºÜÄÑÂð£¿ÔÀ´Ê²Ã´¶¼²»»áʱѧÁËMySQL£¬Ò²Ã»Ôõôѧ¹ý£¬¾Í×Ô¼º×°¼¸´Î£¬Óü¸Ï£¬¾Í´ïµ½ÁË´óÌåÄÜʹÓõij̶ÈÁË£¬¿ÉÊÇoracleµ½ÏÖÔÚ²»»á×°²»»áÓ㬲»»áÅ䣬ÎÒ¾ÍÏë×°¸öoracle£¬È»ºó½¨¸öÊý¾Ý¿â£¬ÀïÃæÓм¸Õ ......