Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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

¹Ø×¢


Ïà¹ØÎÊ´ð£º

ÖªµÀÔõô°Ñsasµ¼ÈëoracleµÄ½øÀ´¿´¿´

ÎÒÏÖÔÚÓÐһЩsasÉÏÃæµÄÊý¾ÝÎļþ ÏÖÔÚÎÒÐèÒª°Ñsasµ¼Èëµ½oracle
ÏÖÔÚ°ÑÒ»¸ösasÎļþµ¼Èëµ½Ò»¸öoracleÖеÄÒ»¸ö±íÖÐÎÒÒѾ­ÖªµÀÔõôŪÁË
µ«ÊÇ ÎÒÏÖÔÚÐèÒª°ÑsasÖеÄÁíÒ»¸öÎļþ×·¼Óµ½oracleÖеÄÒ»¸öÓÐÊý¾ÝµÄÒ»¸ö±íÉÏà ......

Oracle¿Í»§¶Ë°²×°ºóODBCÎÞ·¨Ê¹ÓÃ

°²×°11gµÄ06,´ò²¹¶¡Éýµ½07£¬´ÓODBCÀïÃæ¿´£¬ÓÐ
Oracle in OraOdac11g_home1 11.01.00.07
´Ó×¢²á±í¿´HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ÏÂÃæµÄDriverºÍSetup¶¼ÊÇÎҵݲװ·¾¶
"D:\\app\\Ad ......

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

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

adoÁ¬½ÓoracleµÄ¹ÖÎÊÌâ

ÒÔÇ°³ÌÐòºÃºÃµÄ,ÄܽøÐÐÈκβÙ×÷
µ«´Ó×òÌ쿪ʼͻȻÁ¬½ÓÊý¾Ý¿âʧ°Ü,´úÂëÈçÏÂ:
try
{
        ::CoInitialize(NULL);
        hr=m_pConnection.Creat ......

´ÓORACLEµ½DB2µÄSQLÓï¾äÎÊÌâ

ÏÖÔÚÓÐÒ»ORACLEÖеÄSQLÓï¾ä£¬ÐèÒªÒÆÖ²µ½DB2ÖУ¬ÇëÎʸÃSQL¸ÄÈçºÎд
ORACLEÖУº
select floor(months_between(date1,date2)) from A  
date1,date2·Ö±ðΪ±íÖеÄÁ½¸ö×ֶΠ£¬¶¼ÎªÈÕÆÚÐÍ 
DB2ÖÐÈçºÎʹÓÃÐ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ