Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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ºÍmysqlµÄÊé - Oracle / ·Ç¼¼ÊõÇø

ÎÒ¶ÔSQL SERVERºÍACCESS±È½ÏÊ죬ËùÒÔÊý¾Ý¿âµÄͨÓûù´¡¶«Î÷¿ÉÒÔ˵¶¼ÕÆÎյIJ¶àÁË£¬ÎÒÏÖÔÚÏëÒªµÄ¾ÍÊÇÒÔÉÏÁ½Êý¾Ý¿âµÄ¶ÀÌØÖ®´¦µÄ½éÉܺÍÓ¦ÓýéÉÜ¡£
ÁíÍâÊé×îºÃ¶ÔÓ¦×îа汾 oracleÊÇ11g°É 10µÄÒ²ÐУ»mysqlÊÇ5.1°É
л ......

½èˮԴÈËÆø£¡oracle jobÎÊÌ⣡ÔÚÏßµÈ

ÎÒдµÄÒ»¸öJob
declare
  job1 integer;
begin
  dbms_job.submit(job1,
    'Sale_FinanceUseFee(4,null,null,null);',
    TRUNC(SYSDATE)+1.103, ......

¹òÇó lomboz eclipse ÖмÓÈëoracleµÄÎÊÌâ

ÔÚlomboz eclipseÖеÄwindow->show view->others->ÖеÄÔõÑù¼ÓÈëconnectivityÖеÄdata sourceÖÐÁ¬½ÓoracleʱֻÓÐ8,9,10ÕâÈý¸ö°æ±¾£¬ÔõÑù²ÅÄÜÁ¬½Óoracle11Õâ¸ö°æ±¾ÄØ£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿
¸½Í¼Æ¬ ......

imp µ¼Èë oracle ÎÊÌâ

µ¼³ö¡¢µ¼Èë¶¼ÊÇ oracle 10g ¡£

ÔÚµ¼Èë¹ý³ÌÖгöÏÖÈçÏÂÇé¿ö£º

IMP-00017: ÓÉÓÚ ORACLE ´íÎó 6550, ÒÔÏÂÓï¾äʧ°Ü:
"DECLARE  SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '4E014E50 ......

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

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