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

ÇóÖú£¬Oracle¼àÌýµÄÎÊÌâ

RTÎÒÓõÄÊÇOracle9iµÄÊý¾Ý¿â£¬Á¬½Ó±¾µØµÄOracleûÓÐÈκÎÎÊÌ⣬µ«ÊÇÎÒÁ¬½ÓÆäËû»úÆ÷µÄOracleµÄʱºò×ÜÊDZ¨³öûÓÐûÓмàÌýÆ÷ÕâÊÂÔõô»ØÊ£¬¼àÌýÄÇЩ¶«Î÷¶¼ÊÇÆô¶¯Á˵ġ£¡£¡£

¼àÌý¶Ë¿Ú¶ÔÉÏû£¿

ÓÃeasy connect³¢ÊÔһϣº
SQL code:

sqlplus /nolog
conn user/password@'target_host_or_ip:port_number/instance_name'




¼àÌý¶Ë¿ÚÄÇЩÊǶԵģ¬¸ÃºË¶ÔµÄµØ·½¶¼ºË¶ÔÁË£¬¾ÍÊÇÕÒ²»µ½ÎÊÌâËùÔÚ¡£¡£¡£


ÄãÊÇÓÃʲôÁ¬½ÓµÄ£¿

¹Ø±Õwindows·À»ðǽ

»òÐí\NETWORK\ADMIN\tnsnames.oraµÄÅäÖÃÓÐÎÊÌâ°É¡£¡£¡£

ÒýÓÃ
RTÎÒÓõÄÊÇOracle9iµÄÊý¾Ý¿â£¬Á¬½Ó±¾µØµÄOracleûÓÐÈκÎÎÊÌ⣬µ«ÊÇÎÒÁ¬½ÓÆäËû»úÆ÷µÄOracleµÄʱºò×ÜÊDZ¨³öûÓÐûÓмàÌýÆ÷ÕâÊÂÔõô»ØÊ£¬¼àÌýÄÇЩ¶«Î÷¶¼ÊÇÆô¶¯Á˵ġ£¡£¡£


Á¬½ÓÆäËû»úÆ÷µÄOracle ÐèÒªÅäÖÃtnsnames µÄ..

ÎļþÔÚ$ORACLE_HOME\NETWORK\ADMIN\tnsnames.ora
¼ÓÉÏÏÂÃæÕâ¶Î£º
SQL code:

OracleSID =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = YourIpAddress)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = SIDName)
)
)



ÅäÍêºóÖØÆô¼àÌý¾Í¿ÉÒÔÁË:
lsnrctl restart


ÒýÓÃ
ÄãÊÇÓÃʲôÁ¬½ÓµÄ£¿


Ïà¹ØÎÊ´ð£º

ÇóʹÓÃt-sqlÓï¾ä½«paradoxÊý¾Ýµ¼ÈëoracleµÄ°ì·¨

ʹÓÃt-sqlÓï¾ä½«sqlserver2kÊý¾Ýµ¼ÈëparadoxµÄ¹¦ÄÜÎÒÒÑʵÏÖ£¬ÓõÄÊÇinsert into ... from table in [ODBC][ODBC;Driver=SQL Server...]µÄ°ì·¨£¬µ±ÎÒ×¼±¸Èç·¨ÅÚÖÆÍê³Éparadoxµ¼Èëoracleʱȴ²»ÐУ¬²»±¨´íµ«ÊÇÖ´ÐкóÃ»Ó ......

lomboz eclipse ÖмÓÈëoracleµÄÎÊÌâ

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


......

½èˮԴÈËÆø£¡oracle jobÎÊÌ⣡ÔÚÏßµÈ

ÎÒдµÄÒ»¸öJob
declare
  job1 integer;
begin
  dbms_job.submit(job1,
    'Sale_FinanceUseFee(4,null,null,null);',
    TRUNC(SYSDATE)+1.103, ......

Çó½â MyEclipseÖÐÉèÖÃÁ¬½ÓOracle 10g³öÏÖµÄÎÊÌâ

ÈçÌâ¡£
¸ÕÔÚ×Ô¼ºµÄµçÄÔÀï°²×°ÀïOracle 10g
ÓÃMyEclipseÉèÖÃÁ¬½Ó£¬³öÏÖÈçÏ´íÎóÌáʾ£¬ÇëÎʸ÷λ¸ßÊÖÄÄÀï³öÁËÎÊÌ⣺¶àлָ½Ì£¡

Error while performing database login with the Oracle driver:
Io exc ......

oracle Á¬½ÓµÄÎÊÌâ

Óö¼ûÁËÒ»¸öÕâÖÖÇé¿ö    A  ÔÚÄÚÍø  B ÓÐÄÚÍøºÍÍâÍøµÄÍø¿¨  C  ΪÍâÍø 

Oracle Server ×°ÔÚAÀï    ÏÖÔÚÖ»Äܱ»B·ÃÎÊ 

ÏëÇëÎʸ÷·¸ßÊÖ  Ä ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ