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
¹Ø×¢
Ïà¹ØÎÊ´ð£º
ÎÒ¶ÔSQL SERVERºÍACCESS±È½ÏÊ죬ËùÒÔÊý¾Ý¿âµÄͨÓûù´¡¶«Î÷¿ÉÒÔ˵¶¼ÕÆÎյIJ¶àÁË£¬ÎÒÏÖÔÚÏëÒªµÄ¾ÍÊÇÒÔÉÏÁ½Êý¾Ý¿âµÄ¶ÀÌØÖ®´¦µÄ½éÉܺÍÓ¦ÓýéÉÜ¡£
ÁíÍâÊé×îºÃ¶ÔÓ¦×îа汾 oracleÊÇ11g°É 10µÄÒ²ÐУ»mysqlÊÇ5.1°É
л ......
ÎÒдµÄÒ»¸öJob
declare
job1 integer;
begin
dbms_job.submit(job1,
'Sale_FinanceUseFee(4,null,null,null);',
TRUNC(SYSDATE)+1.103, ......
ÔÚlomboz eclipseÖеÄwindow->show view->others->ÖеÄÔõÑù¼ÓÈëconnectivityÖеÄdata sourceÖÐÁ¬½ÓoracleʱֻÓÐ8,9,10ÕâÈý¸ö°æ±¾£¬ÔõÑù²ÅÄÜÁ¬½Óoracle11Õâ¸ö°æ±¾ÄØ£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿
¸½Í¼Æ¬ ......
µ¼³ö¡¢µ¼Èë¶¼ÊÇ oracle 10g ¡£
ÔÚµ¼Èë¹ý³ÌÖгöÏÖÈçÏÂÇé¿ö£º
IMP-00017: ÓÉÓÚ ORACLE ´íÎó 6550, ÒÔÏÂÓï¾äʧ°Ü:
"DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '4E014E50 ......
Êý¾Ý¿â£ºOracle10g(10.2)
Ó¦ÓãºÒ»¸öC#µÄ³ÌÐòдÊý¾Ý¿â£¬Ò»¸öJSP³ÌÐò¶ÁÊý¾Ý¿â
¸ºÔØ£ºÄ¿Ç°´¦ÓÚ¿ª·¢½×¶Î£¬»ù±¾ÉÏÖ»ÓÐ3-4¸öÓû§·ÃÎÊJSPÍøÕ¾¡£
ÏÖÏó£ºÖØÐÂÆô¶¯ºóµÄÊý¾Ý¿â²éѯ·Ç³£¿ì£¬µ«ÊÇÓÃ×ÅÓÃ×ÅÔ½À´Ô½Âý£¬ËùÓÐJSPÍøÒ ......