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

¹ØÓÚoracle 10gµÄEMÆô¶¯ÎÊÌâ

oracle 10g°²×°Íê±ÏºóĬÈÏ»áÒÔÍøÒ³ÐÎʽÆô¶¯EM£¬µ«Îҹرպó¾ÍûÔÚ¿ªÊ¼²Ëµ¥ÀïÕÒµ½ÏàÓ¦µÄÍøҳģʽÆô¶¯EMºÍJAVA³ÌÐòÆô¶¯µÄEMÑ¡ÏÇëÎÊÕâÊÇÔõô»ØÊ£¿
emÊǸö·þÎñ£¬

°²×°ºÃÒÔºóÓ¦¸ÃÔÚÄãµÄ·þÎñÁбíÀïÕÒµ½ÀàËÆOraclDBConsoleXXXÕâÑùµÄÒ»¸ö·þÎñ£¬Æô¶¯¾Í¿ÉÒÔÁË¡£

»òÕßÓÃÃüÁîÐеķ½Ê½£¬ÃüÁîÐеķ½Ê½ÒªÏÈset Ò»ÏÂORacle_SID È»ºóemctl start dbconsole

Èç¹ûÊÇwindowsÏ°´ÕÕµÄoracle10gµÄ»¨£¬ÔÚcmd´°¿ÚģʽÏ ÓÃemctl start dbconsole ÃüÁî¿ÉÒÔÆô¶¯OEMµÄ¡£

ÒýÓÃ
emÊǸö·þÎñ£¬

°²×°ºÃÒÔºóÓ¦¸ÃÔÚÄãµÄ·þÎñÁбíÀïÕÒµ½ÀàËÆOraclDBConsoleXXXÕâÑùµÄÒ»¸ö·þÎñ£¬Æô¶¯¾Í¿ÉÒÔÁË¡£

»òÕßÓÃÃüÁîÐеķ½Ê½£¬ÃüÁîÐеķ½Ê½ÒªÏÈset Ò»ÏÂORacle_SID È»ºóemctl start dbconsole

ÇëÎÊÕâ¸öSETÓ¦¸ÃÔõôÉèÖÃ

ÒýÓÃ
emÊǸö·þÎñ£¬

°²×°ºÃÒÔºóÓ¦¸ÃÔÚÄãµÄ·þÎñÁбíÀïÕÒµ½ÀàËÆOraclDBConsoleXXXÕâÑùµÄÒ»¸ö·þÎñ£¬Æô¶¯¾Í¿ÉÒÔÁË¡£

»òÕßÓÃÃüÁîÐеķ½Ê½£¬ÃüÁîÐеķ½Ê½ÒªÏÈset Ò»ÏÂORacle_SID È»ºóemctl start dbconsole

Õâ¸öÒ»°ã²»ÔõôÓÃ

ÎÒÔÚѧϰoracle 9iÊǾÍÓÐÒ»¸öÆóÒµ¹ÜÀíÆ÷£¬ÊÇ»ùÓÚJAVA½çÃæµÄ£¬ÓÃÀ´ÉèÖÃʵÀý¡¢±í¿Õ¼ä¡¢Óû§µÈ²Ù×÷£¬ÎҼǵÃ10gÒ²Ó¦¸ÃÊÇÓеÄ

Êǵģ¬9iµÄʱºòÊÇoem£¬²»¹ý10gÊÇÌṩһ¸öweb applicationÀ´Ìæ´úoemÁË£¬Ãû×ÖÒ²¸ÄΪemÁË

set¾ÍÊÇÃüÁîÐеÄÒ»¸öÃüÁî¶øÒÑ

set oracle_sid=ÄãµÄÊý¾Ý¿âµÄsid

»òÕßÔÚµçÄÔÀï¼ÓÒ»¸öORACLE_SIDµÄ»·¾³±äÁ¿Ò²¿ÉÒÔ¡£

ÇëÎÊSID¸ÃÔõô¿´


ÖØÐÂÅäÖÃÏÂEM

¹Ø×¢


Ïà¹ØÎÊ´ð£º

ÇóÖúORACLEÅúÁ¿Çå³ý±íÊý¾ÝµÄÎÊÌâ - Oracle / ¿ª·¢

±ÈÈçÎÒÓÐtestA¡¢testB¡¢testCÈý¸ö±í
ÎÒÏÖÔÚÐèҪдһ¸öÅú´¦Àí»òÕ߽ű¾¸ø±ðÈË ×÷ÓþÍÊÇÖ´ÐÐÕâ¶ÎÓï¾ä¿ÉÒÔÇå³ýÕâÈý¸ö±íÀïÃæµÄÊý¾Ý ¾ÍÊÇÒ»¸ö³õʼ»¯µÄÒâ˼
ÄÄλ¸ßÈË°ïÖúÏ°¡ Ò»¸öÊý¾Ý¿âС°×ÔÚ´ËÇó¾ÈÀ²
SQL code:
......

Oracle Æô¶¯µÄÎÊÌâ

oracle not available
shared memory realm does not exist
ÇëÎʸßÊÖÕâ¸öÎÊÌâÈçºÎ½â¾ö£¿
http://www.inthirties.com/thread-109-2-1.html

Ö¸¶¨ÏÂORACLE_SID,ORACLE_HOME¿´¿´£¬²»ÐоÍÓÃ1Â¥µÃ·½·¨ÁË..

cm ......

oracleÈëÃÅÅäÖÃ

oracleÁ¬½ÓɶÕâô¸´ÔÓ°¡.
oracle 10g
ÓÃps/sql devÔõôҲÁ¬²»ÉÏ.
ÓÃsqlplus¿ÉÒԵǽ.net manager֮ǰ²âÊÔÁ¬½ÓÁ˳ɹ¦µÄ.ÏÖÔÚ¸ãµÃÒ²Á¬½Ó²»ÁË.
listener.ora:
SID_LIST_LISTENER =
  (SID_LIST =
  ......

ÊÇoracleµÄbugô£¿É¢·ÖÁË£¡ - Oracle / »ù´¡ºÍ¹ÜÀí

±¾À´ÒªÐ´¸öupdateÓï¾ä
update table_a A
  set A.flag=1
  where A.id in (select B.id from table_b B)
½á¹ûÎóд³É
update table_a A
  set A.flag=1
  where ......

OracleÊý¾Ý¿âÔ½À´Ô½Âý¸ÃÈçºÎ´¦Àí£¿

Êý¾Ý¿â£ºOracle10g(10.2)
Ó¦ÓãºÒ»¸öC#µÄ³ÌÐòдÊý¾Ý¿â£¬Ò»¸öJSP³ÌÐò¶ÁÊý¾Ý¿â
¸ºÔØ£ºÄ¿Ç°´¦ÓÚ¿ª·¢½×¶Î£¬»ù±¾ÉÏÖ»ÓÐ3-4¸öÓû§·ÃÎÊJSPÍøÕ¾¡£
ÏÖÏó£ºÖØÐÂÆô¶¯ºóµÄÊý¾Ý¿â²éѯ·Ç³£¿ì£¬µ«ÊÇÓÃ×ÅÓÃ×ÅÔ½À´Ô½Âý£¬ËùÓÐJSPÍøÒ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ