oracle µÇ²»ÉÏ
ÎÒ°²×°µÄÊÇOracle10G£¬°²×°Ë³ÀûûÎÊÌ⣡·þÎñÒ²ÄÜÕý³£Æô¶¯£¡
µÇ½ʱ³öÏÖ£º"ora-12514: TNS:¼àÌý³ÌÐòµ±Ç°ÎÞ·¨Ê¶±ðÁ¬½ÓÃèÊö·ûÖÐÇëÇóµÄ·þÎñ£¡
¼´Ê¹ÖØ×°Ò²»¹ÊÇÕâ¸öÎÊÌ⣡
ÇëÎÊ´óÏÀÃÇÕâÊÇʲôÔÒòÒýÆðµÄ°¡£¿Ð»Ð»£¡
SQL code:
--¼àÌýûÓÐÅäÖúã¬ÖØÐÂÅäÖÃһϼàÌý
¼àÌýÔõôÅäÖ𡣿ËÑË÷ÁËһϣ¬ºÃÏñû¼ûµ½Ê²Ã´ÓÐÓõģ¡
ÇëÂ¥Éϸø¾ßÌåÖ¸µ¼Ò»ÏÂлл£¡
F:\oracle\db_1\NETWORK\ADMINÏÂlistener.oraÎļþÎÒÐÞ¸ÄÈçÏ£º
# listener.ora Network Configuration File: f:\oracle\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = f:\oracle\db_1)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
)
F:\oracle\db_1\NETWORK\ADMINÏÂtnsnames.oraÐÞ¸ÄÈçÏ£º
# tnsnames.ora Network Configuration File: f:\oracle\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration to
Ïà¹ØÎÊ´ð£º
with adod_dict do
begin
close;
commandtext:='select bgqxcode,count(*) wjsl from wscl_wsda_file where wjnd=:tnd group by bgqxcode'; ......
ʹÓÃt-sqlÓï¾ä½«sqlserver2kÊý¾Ýµ¼ÈëparadoxµÄ¹¦ÄÜÎÒÒÑʵÏÖ£¬ÓõÄÊÇinsert into ... from table in [ODBC][ODBC;Driver=SQL Server...]µÄ°ì·¨£¬µ±ÎÒ×¼±¸Èç·¨ÅÚÖÆÍê³Éparadoxµ¼Èëoracleʱȴ²»ÐУ¬²»±¨´íµ«ÊÇÖ´ÐкóÃ»Ó ......
ÎÒÏÖÔÚÓÐһЩsasÉÏÃæµÄÊý¾ÝÎļþ ÏÖÔÚÎÒÐèÒª°Ñsasµ¼Èëµ½oracle
ÏÖÔÚ°ÑÒ»¸ösasÎļþµ¼Èëµ½Ò»¸öoracleÖеÄÒ»¸ö±íÖÐÎÒÒѾ֪µÀÔõôŪÁË
µ«ÊÇ ÎÒÏÖÔÚÐèÒª°ÑsasÖеÄÁíÒ»¸öÎļþ×·¼Óµ½oracleÖеÄÒ»¸öÓÐÊý¾ÝµÄÒ»¸ö±íÉÏà ......
ÔÚlomboz eclipseÖеÄwindow->show view->others->ÖеÄÔõÑù¼ÓÈëconnectivityÖеÄdata sourceÖÐÁ¬½ÓoracleʱֻÓÐ8,9,10ÕâÈý¸ö°æ±¾£¬ÔõÑù²ÅÄÜÁ¬½Óoracle11Õâ¸ö°æ±¾ÄØ£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿
......