oracle 10g°²×°Íê±ÏºóĬÈÏ»áÒÔÍøÒ³ÐÎʽÆô¶¯EM£¬µ«Îҹرպó¾ÍûÔÚ¿ªÊ¼²Ëµ¥ÀïÕÒµ½ÏàÓ¦µÄÍøҳģʽÆô¶¯EMºÍJAVA³ÌÐòÆô¶¯µÄEMÑ¡ÏÇëÎÊÕâÊÇÔõô»ØÊ£¿
emÊǸö·þÎñ£¬
°²×°ºÃÒÔºóÓ¦¸ÃÔÚÄãµÄ·þÎñÁбíÀïÕÒµ½ÀàËÆOraclDBConsoleXXXÕâÑùµÄÒ»¸ö·þÎñ£¬Æô¶¯¾Í¿ÉÒÔÁË¡£
»òÕßÓÃÃüÁîÐеķ½Ê½£¬ÃüÁîÐеķ½Ê½ÒªÏÈset Ò»ÏÂORacle_SID È»ºóemctl start dbconsole
Èç¹ûÊÇwindowsÏ°´ÕÕµÄoracle10gµÄ»¨£¬ÔÚcmd´°¿ÚģʽÏ ÓÃemctl start dbconsole ÃüÁî¿ÉÒÔÆô¶¯OEMµÄ¡£
ÇëÎÊÕâ¸öSETÓ¦¸ÃÔõôÉèÖÃ
Õâ¸öÒ»°ã²»ÔõôÓÃ
ÎÒÔÚѧϰoracle 9iÊǾÍÓÐÒ»¸öÆóÒµ¹ÜÀíÆ÷£¬ÊÇ»ùÓÚJAVA½çÃæµÄ£¬ÓÃÀ´ÉèÖÃʵÀý¡¢±í¿Õ¼ä¡¢Óû§µÈ²Ù×÷£¬ÎҼǵÃ10gÒ²Ó¦¸ÃÊÇÓеÄ
Êǵģ¬9iµÄʱºòÊÇoem£¬²»¹ý10gÊÇÌṩһ¸öweb applicationÀ´Ìæ´úoemÁË£¬Ãû×ÖÒ²¸ÄΪemÁË
set¾ÍÊÇÃüÁîÐеÄÒ»¸öÃüÁî¶øÒÑ
set oracle_sid=ÄãµÄÊý¾Ý¿âµÄsid
»òÕßÔÚµçÄÔÀï¼ÓÒ»¸öORACLE_SIDµÄ»·¾³±äÁ¿Ò²¿ÉÒÔ¡£
ÇëÎÊSID¸ÃÔõô¿´
ÖØÐÂÅäÖÃÏÂEM
¹Ø×¢
Ïà¹ØÎÊ´ð£º
±ÈÈçÎÒÓÐtestA¡¢testB¡¢testCÈý¸ö±í
ÎÒÏÖÔÚÐèҪдһ¸öÅú´¦Àí»òÕ߽ű¾¸ø±ðÈË ×÷ÓþÍÊÇÖ´ÐÐÕâ¶ÎÓï¾ä¿ÉÒÔÇå³ýÕâÈý¸ö±íÀïÃæµÄÊý¾Ý ¾ÍÊÇÒ»¸ö³õʼ»¯µÄÒâ˼
ÄÄλ¸ßÈË°ïÖúÏ°¡ Ò»¸öÊý¾Ý¿âС°×ÔÚ´ËÇó¾ÈÀ²
SQL code:
......
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 10g
ÓÃps/sql devÔõôҲÁ¬²»ÉÏ.
ÓÃsqlplus¿ÉÒԵǽ.net manager֮ǰ²âÊÔÁ¬½ÓÁ˳ɹ¦µÄ.ÏÖÔÚ¸ãµÃÒ²Á¬½Ó²»ÁË.
listener.ora:
SID_LIST_LISTENER =
(SID_LIST =
......
±¾À´ÒªÐ´¸ö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 ......
Êý¾Ý¿â£ºOracle10g(10.2)
Ó¦ÓãºÒ»¸öC#µÄ³ÌÐòдÊý¾Ý¿â£¬Ò»¸öJSP³ÌÐò¶ÁÊý¾Ý¿â
¸ºÔØ£ºÄ¿Ç°´¦ÓÚ¿ª·¢½×¶Î£¬»ù±¾ÉÏÖ»ÓÐ3-4¸öÓû§·ÃÎÊJSPÍøÕ¾¡£
ÏÖÏó£ºÖØÐÂÆô¶¯ºóµÄÊý¾Ý¿â²éѯ·Ç³£¿ì£¬µ«ÊÇÓÃ×ÅÓÃ×ÅÔ½À´Ô½Âý£¬ËùÓÐJSPÍøÒ ......