oracle°²×°ÎÊÌâ
1.
ÔÚ°²×°µÄʱºò°²×°µÄoracle 9i release¡£¡£¡£ÊÇ·ñÓ¦¸Ã°²×°Õâ¸ö°æ±¾£¬ÔÙ°²×°¹ý³ÌÖгöÏÖoracle net configuration assistantÅäÖÃÄ£¿é£¬ÊäÈëÖ÷»úºÅºÍ¶Ë¿ÚºÅÒÔ¼°sll¶Ë¿ÚºÅ£¬²»ÖªµÀÊÇʲôÎÊÌâ¡£
2.
SQL*Plus: Release 9.2.0.1.0 - Production on ÐÇÆÚÁù 9ÔÂ 26 16:58:03 2009
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
ERROR:
ORA-12560: TNS: ÐÒéÊÊÅäÆ÷´íÎó
ÕâÊÇʲôÎÊÌ⣿³õѧ£¬Çë¶àÖ¸½Ì¡£
ÍøÉϵݲװͼ½â¸úÎÒ°²×°Ê±µÄ²»Ò»Ñù£¬¶àÁ˼¸¸ö»·½Ú£¬ÎÒÏÂÔØµÄºÃÏñÊÇOracle9i Database Release2 Client for Windows98_NT_2000_XP£¬Õâ¸ö°æ±¾ÓëOracle9i Database Release2 Enterprise/Standard/Personal Edition for Windows NT/2000/XP/2003ÓÐÇø±ðÂð£¿
ÄãϵÄÊDz»Ö»ÊÇOracleµÄ¿Í»§¶Ë£¿ÓзþÎñÆ÷µÄ»°£¬Åätnsnames.ora¡£
Ó¦¸Ã¾ÍÊǿͻ§¶ËÁË£¬»»¸ö°æ±¾µÄ£¬µ½ÄÄÀïÈ¥ÏÂÔØ±È½Ï·½±ã?
Â¥Ö÷ҪװµÄÓ¦¸ÃÊÇ·þÎñ¶Ë¡£
Oracle9i ¹Ù·½ÏÂÔØµØÖ·
http://www.oracle.com/technology/global/cn/software/products/oracle9i/index.html
10GºÍ11GµÄ
http://www.oracle.com/technology/software/products/database/index.html
11gµÄ²»ÊÇÊý¾Ý¿â°É£¬ºÃÏñÊÇʲôÉÌÒµÌ×¼þ£¬ÎÒÊdzõѧoracle£¬Ö÷ÒªÊÇÏȶÔÊý¾Ý¿âÓïÑÔÓиöºÜºÃµÄÁ˽⣬Äĸö°æ±¾¶¼¶ÔÎҴ´ÂÓÐÓàÁË£¬Èç¹ûÕÆÎÕÁË10gÄÇ9iÒ²²»³ÉÎÊÌâÁ˰ɣ¬ÎÒÏëÖªµÀÏÖÔÚÉç»áÉϵÄÖ÷Á÷ÊÇʹÓõÄÄǸö°æ±¾£¬¾Ý˵10gµÄbug±È½Ï¶à£¬²»ÖªµÀ»á²»»á¶ÔÒÔºóµÄǰ¾°ÓÐËùÓ°Ï죿
1¡£Ä¬ÈÏÅäÖðÉ
2.ÄãûÓÐÅ
Ïà¹ØÎÊ´ð£º
with adod_dict do
begin
close;
commandtext:='select bgqxcode,count(*) wjsl from wscl_wsda_file where wjnd=:tnd group by bgqxcode'; ......
°²×°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ÖеÄwindow->show view->others->ÖеÄÔõÑù¼ÓÈëconnectivityÖеÄdata sourceÖÐÁ¬½ÓoracleʱֻÓÐ8,9,10ÕâÈý¸ö°æ±¾£¬ÔõÑù²ÅÄÜÁ¬½Óoracle11Õâ¸ö°æ±¾ÄØ£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿
......
ÎÒ´óרѧÀú£¬ÔÚÒ»¼Ǫ̀×Ê ¼¯ÍÅµÄ ·Ö¹«Ë¾ ×öÀ²Ò»Äê´óÐÍERPÈí¼þ¿ª·¢&ά»¤£¬ÏëÔÚÖ麣ÕÒ·Ý.netµÄ¹¤×÷£¬Òª¶àÉÙ¹¤×ʺÏÊÊ£¿
¿ªÊ¼²»ÒªÌ«¸ß£¬3K×óÓÒÓ¦¸ÃÊDZê×¼
Ö麣ÄDZßËÆºõûÉîÛÚºÃ.
Èç¹ûÊÇÎҵϰ,Ê×ÏÈÊÇÒª±ÈÏ ......