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

Á½¸ö¹ØÓÚoracleµÄÎÊÌ⣬·Ç³£¼òµ¥£¬µ«ÊÇÎÒÊDzËÄñ

µÚÒ»¸ö£ºÎÒµçÄÔû»»IPǰ°²×°Á˸öoracle10G  µ«ÊÇ×î½üijЩԭÒò ÎÒ»»ÁËIP£¬ÏÖÔÚoracleÊý¾Ý¿âºÍ·þÎñ¶¼Æô¶¯²»Õý³££¬Õâ¸öÔõô½â¾ö£¿

µÚ¶þ¸ö£ºoracle10G  Äö·þÎñÆô¶¯Á˾ͿÉÒÔ½øÐÐÊý¾Ý¿âµÄ²Ù×÷£¿Ò²¾ÍÊÇÕý³£ÔË×÷¡££¨ÒòΪÎÒÓõÄÊDZʼDZ¾£¬ÎÒ·¢ÏÖoracleÓÐЩ·þÎñµ÷³É×Ô¶¯ÁË£¬µçÄÔÆô¶¯N+NÂý£¡£©


Á½¸öÎÊÌ⣬Íû¸ßÊÖ½â¾ö£¡ÔÚϲ»Éõ¸Ð¼¤~~
1£¬ip ²»Ó°ÏìÄãoracleµÄÆô¶¯£¬Èç¹ûÆô¶¯²»ÆðÀ´ÁË£¬Ò»¶¨²»ÊÇipµÄÔ­Òò£¬¶øÊDZðµÄ·½ÃæÒýÆðµÄ¡£

2£¬Ö»ÒªOracleServiceOrcl¡¢OracleOraDb10g_home1TNSListener·þÎñÆô¶¯ÁË£¬¾Í¿ÉÒÔÕý³£·ÃÎÊÊý¾Ý¿âÁË¡£


1. Ò»°ãÀ´Ëµ£¬¶ÔÓÚ±¾»ú£¬¸ü»»IPµØÖ·ÊDz»Ó°Ïì

2. OracleServeicesSID
  OracleOraDb10g_home1TNSListener
  OracleOraDb10g_home1iSQL*Plus
  Æô¶¯ÕâÈý¸ö¾Í¿ÉÒÔÁË

Â¥Ö÷Æô¶¯²»ÁË£¬¿ÉÄÜÊÇ·þÎñû¿ª¡£

ÒýÓÃ
1£¬ip ²»Ó°ÏìÄãoracleµÄÆô¶¯£¬Èç¹ûÆô¶¯²»ÆðÀ´ÁË£¬Ò»¶¨²»ÊÇipµÄÔ­Òò£¬¶øÊDZðµÄ·½ÃæÒýÆðµÄ¡£

2£¬Ö»ÒªOracleServiceOrcl¡¢OracleOraDb10g_home1TNSListener·þÎñÆô¶¯ÁË£¬¾Í¿ÉÒÔÕý³£·ÃÎÊÊý¾Ý¿âÁË¡£



¶¥£¡

ÒýÓÃ
µÚÒ»¸ö£ºÎÒµçÄÔû»»IPǰ°²×°Á˸öoracle10G  µ«ÊÇ×î½üijЩԭÒò ÎÒ»»ÁËIP£¬ÏÖÔÚoracleÊý¾Ý¿âºÍ·þÎñ¶¼Æô¶¯²»Õý³££¬Õâ¸öÔõô½â¾ö£¿

µÚ¶þ¸ö£ºoracle10G  Äö·þÎñÆô¶¯Á˾ͿÉÒÔ½øÐÐÊý¾Ý¿âµÄ²Ù×÷£¿Ò²¾ÍÊÇÕý³£ÔË×÷¡££¨ÒòΪÎÒÓõÄÊDZʼDZ¾£¬ÎÒ·¢ÏÖoracleÓÐЩ·þÎñµ÷³É×Ô¶¯ÁË£¬µçÄÔÆô¶¯N+NÂý£¡£©


Á½¸öÎÊÌ⣬Íû¸ßÊÖ½â¾ö£¡ÔÚϲ»É


Ïà¹ØÎÊ´ð£º

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 ......

¼±ÎÊÒ»¸öoracle×Ö¶ÎÉèÖõÄÎÊÌâ - Oracle / »ù´¡ºÍ¹ÜÀí

¸÷´óÀÏʦºÃ£¬Çë½ÌÒ»¸öÎÊÌ⣮
ÎÒÉèÖÃÁËÒ»¸öoracle×ֶΣ¬varchar(3000),È»ºó²åÈëÒ»ÌõÊý¾Ý³¤¶È²Å1000,¾Í±¨´íÁË£®È磺net.sf.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
Caused ......

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

ÏÖÔÚÓÐÒ»ORACLEÖеÄSQLÓï¾ä£¬ÐèÒªÒÆÖ²µ½DB2ÖУ¬ÇëÎʸÃSQL¸ÄÈçºÎд
ORACLEÖУº
select floor(months_between(date1,date2)) from A  
date1,date2·Ö±ðΪ±íÖеÄÁ½¸ö×Ö¶Î £¬¶¼ÎªÈÕÆÚÐÍ 
DB2ÖÐÈçºÎʹÓÃÐ ......

ÇóÖúÒ»¸ö¶¨Ê±Ö´ÐÐoracle´æ´¢¹ý³ÌµÄÎÊÌ⣬Çë´óÏÀ°ïæ

ÎÒÐèÒªÓö¨Ê±Ö´Ðд洢¹ý³Ì£¬µ«ÊÇÎҵĴ洢¹ý³ÌÀïÓõ½µÄ±íÊÇÓÐÁ´½ÓµÄ£¬¾ÍÏñÕâÑù£º
.....from table_name@cxdb_link
Ò²¾ÍÊÇÎÒ½¨Á¢¶¨Ê±Æ÷µÄÊý¾Ý¿âÓë±íËùÔÚµÄÊý¾Ý¿â²»ÊÇÒ»¸ö¿â£¬£¨ÒòΪ±íËùÔÚµÄÊý¾Ý¿âÎÒûÓÐȨÏÞ½¨Á¢¶¨Ê ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ