Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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²»ÄÜ´ò¿ª£¬ÒÔǰÄÜ´ò¿ªµÄ¡£

ÓÐЩ·þÎñÐèÒªÊÖ¶¯´ò¿ª£¬Äã¿´Ò»ÏÂ

лл¸÷λµÄ»Ø´ð£¬¸Ðл£¡ÎÊÌâ½â¾öÁË¡£ÊÇÓÐЩ·þÎñûÓдò¿ª£¬ÎÊÌâ½â¾öÁË£¬ÎÒҲѧ»áÁËһЩ·þÎñÏà¹ØµÄ֪ʶ£¬Õæ³ÏµÄ¸Ðл¸÷λµÄÖ¸½Ì£¡


Ïà¹ØÎÊ´ð£º

OracleÀëÏß·ÃÎÊ---ÇóÖú - Oracle / »ù´¡ºÍ¹ÜÀí

´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæµÄԭʼÎļþ,ÏÂÔØµ½±¾»úÁË.ÎÒÏëÔÚ±¾»ú·ÃÎÊÊý¾Ý¿âÔõôÉèÖð¡.ÊDz»ÊÇÀàËÆ¿ÉÒÔ½¨Á¢Ò»¸öʲôÐéÄâ·þÎñÆ÷À´ÊµÏÖ.Çë´ó¼Ò³ö³öÖ÷Òâ
ÒýÓÃ
    ´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæ ......

javaÔõôÁ¬½ÓOracle£¬¼±°¡ - Java / JavaÏà¹Ø

private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "s ......

oracleÓëaix - Oracle / ¸ß¼¶¼¼Êõ

ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó
#topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬
Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7 
Êý¾ÝÎļþ¹ÒÔØµÄ½Úµã£º/oradata/pcs/ Âß¼­¾íºÅlv04 
#lslv -l lv04 ......

Ò»¸öpl/sqlÎÊÌâ - Oracle / ¿ª·¢

ÎÒÊÇÔÚtoadÖÐÊäÈë϶Îsql
  declare
  TYPE test_rec IS record(
  code varchar(10),
  name varchar(30)
  );
  v_book test_rec;
    ......

oracleµÄ°²×°ºÍʹÓúÃÄѰ¡ - Java / Java EE

oracleµÄ°²×°ºÍʹÓö¼ºÜÄÑÂð£¿Ô­À´Ê²Ã´¶¼²»»áʱѧÁËMySQL£¬Ò²Ã»Ôõôѧ¹ý£¬¾Í×Ô¼º×°¼¸´Î£¬Óü¸Ï£¬¾Í´ïµ½ÁË´óÌåÄÜʹÓõij̶ÈÁË£¬¿ÉÊÇoracleµ½ÏÖÔÚ²»»á×°²»»áÓ㬲»»áÅ䣬ÎÒ¾ÍÏë×°¸öoracle£¬È»ºó½¨¸öÊý¾Ý¿â£¬ÀïÃæÓм¸Õ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ