Çó½â MyEclipseÖÐÉèÖÃÁ¬½ÓOracle 10g³öÏÖµÄÎÊÌâ
ÈçÌâ¡£
¸ÕÔÚ×Ô¼ºµÄµçÄÔÀï°²×°ÀïOracle 10g
ÓÃMyEclipseÉèÖÃÁ¬½Ó£¬³öÏÖÈçÏ´íÎóÌáʾ£¬ÇëÎʸ÷λ¸ßÊÖÄÄÀï³öÁËÎÊÌ⣺¶àлָ½Ì£¡
Error while performing database login with the Oracle driver:
Io exception: The Network Adapter could not establish the connection
---------------------
ÔÚEclipseµÄDB BrowserÖÐ×öµÄÉèÖÃÈçÏ£º
Driver name £ºOracle
Connection URL : jdbc:oracle:thin:@localhost:1521:test
User name : scott
Password : tiger
Driver JARs: D:\lib\ojdbc14.jar
Driver classname: oracle.jdbc.driver.Oracle
¶àлָ½Ì£¡
lsnrctl start
ÕâÊÇʲô¶«¶«°¡£¬²»ºÃÒâ˼£¬°³Ð¡°×£¬ÇëÖ¸½Ì~
Microsoft Windows XP [°æ±¾ 5.1.2600]
(C) °æÈ¨ËùÓÐ 1985-2001 Microsoft Corp.
C:\Documents and Settings\user.HQ-TEXT>lsnrctl start
LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 04-10ÔÂ-2009 17:4
3:58
Copyright (c) 1991, 2005, Oracle. All rights reserved.
TNS-01106: ʹÓÃÃû³ÆLISTENERµÄ¼àÌý³ÌÐòÒѾÆô¶¯
C:\Documents and Settings\user.HQ-TEXT>
Çý¶¯°ü²»ÊÇ*12.jarÂ𣿠ʲôʱºò±ä³É14ÁË...
Ïà¹ØÎÊ´ð£º
»·¾³£º1.win2003server+oracle9i
2.oracle9i×Ö·û¼¯ÎªAMERICAN_AMERICA.WE8ISO8859P1
3.oracle sql developer°æ±¾ 1.5.5
ÏÖÏóÃèÊö: 1.ÔÚsql developer ÖвéѯoracleÖеÄij¸ö±í£¬ÖÐÎÄÈ«²¿ÏÔʾΪÂÒÂë¡£
......
ÎÒ´óרѧÀú£¬ÔÚÒ»¼Ǫ̀×Ê ¼¯ÍÅµÄ ·Ö¹«Ë¾ ×öÀ²Ò»Äê´óÐÍERPÈí¼þ¿ª·¢&ά»¤£¬ÏëÔÚÖ麣ÕÒ·Ý.netµÄ¹¤×÷£¬Òª¶àÉÙ¹¤×ʺÏÊÊ£¿
¿ªÊ¼²»ÒªÌ«¸ß£¬3K×óÓÒÓ¦¸ÃÊDZê×¼
Ö麣ÄDZßËÆºõûÉîÛÚºÃ.
Èç¹ûÊÇÎҵϰ,Ê×ÏÈÊÇÒª±ÈÏ ......
ÎÒдµÄÒ»¸öJob
declare
job1 integer;
begin
dbms_job.submit(job1,
'Sale_FinanceUseFee(4,null,null,null);',
TRUNC(SYSDATE)+1.103, ......
±ðÈ˸øÁËÎÒÔ¶³ÌoracleÊý¾Ý¿âµÄÐÅÏ¢£º¹Ì¶¨IP£¬¶Ë¿ÚºÅºÍSID£¬»¹ÓÐÓû§ÃûºÍÃÜÂ룬ËûµÄÊý¾Ý¿âÊÇoracle9i,ÎÒµÄÒ²ÊÇ£¬ÎÒÈçºÎ²ÅÄÜÁ¬½Óµ½ËûµÄÊý¾Ý¿âµÃµ½Êý¾Ý£¬Çë¸ßÊÖ°ïæָµãһϣ¬²»Ê¤¸Ðл£¡
ÎÊÌâûÓнâ¾ö
wildwave£¬ ......
ÏÖÔÚÓжþÕÅ±í£¬±íÒ»ºÍ±í¶þ
ʹÓà plsqldeveloper
±íÒ»´ó¸ÅÓÐ15¸ö×ֶΣ¬Ô¼ 140 ÍòÐмǼ£¬Ê¹Óà count(1) ʱִÐÐÁË37Ã룬ʹÓà count(*) Ö´ÐÐʱ¼äÒ²ÔÚ37Ãë
±í¶þ´ó¸ÅÓÐ7,8¸ö×ֶΣ¬Ô¼ 500 ÍòÐмǼ£¬ ......