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Óï¾ä½«sqlserver2kÊý¾Ýµ¼ÈëparadoxµÄ¹¦ÄÜÎÒÒÑʵÏÖ£¬ÓõÄÊÇinsert into ... from table in [ODBC][ODBC;Driver=SQL Server...]µÄ°ì·¨£¬µ±ÎÒ×¼±¸Èç·¨ÅÚÖÆÍê³Éparadoxµ¼Èëoracleʱȴ²»ÐУ¬²»±¨´íµ«ÊÇÖ´ÐкóÃ»Ó ......
ÔÚlomboz eclipseÖеÄwindow->show view->others->ÖеÄÔõÑù¼ÓÈëconnectivityÖеÄdata sourceÖÐÁ¬½ÓoracleʱֻÓÐ8,9,10ÕâÈý¸ö°æ±¾£¬ÔõÑù²ÅÄÜÁ¬½Óoracle11Õâ¸ö°æ±¾ÄØ£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿ ......
ÎÒдµÄÒ»¸öJob declare job1 integer; begin dbms_job.submit(job1, 'Sale_FinanceUseFee(4,null,null,null);', TRUNC(SYSDATE)+1.103, ......
ÈçÌâ¡£ ¸ÕÔÚ×Ô¼ºµÄµçÄÔÀï°²×°ÀïOracle 10g ÓÃMyEclipseÉèÖÃÁ¬½Ó£¬³öÏÖÈçÏ´íÎóÌáʾ£¬ÇëÎʸ÷λ¸ßÊÖÄÄÀï³öÁËÎÊÌ⣺¶àлָ½Ì£¡ Error while performing database login with the Oracle driver: Io exc ......
Óö¼ûÁËÒ»¸öÕâÖÖÇé¿ö A ÔÚÄÚÍø B ÓÐÄÚÍøºÍÍâÍøµÄÍø¿¨ C ΪÍâÍø Oracle Server ×°ÔÚAÀï ÏÖÔÚÖ»Äܱ»B·ÃÎÊ ÏëÇëÎʸ÷·¸ßÊÖ Ä ......