Windows»·¾³ÏÂjavaÁ¬½ÓLinux»·¾³OracleÊý¾Ý¿â³ö´í
Çë½ÌΪʲô±¾»úWindows»·¾³ÏÂjavaÁ¬½ÓLinux»·¾³ÏÂOracleÊý¾Ý¿â³ö´í£¿£¨×¢£ºÒ»Ï´úÂëÁ¬½Ó±¾»úOracleÊý¾Ý¿âÕý³££¬Çý¶¯°üΪojdbc14.jar£©
ÒÔÏÂΪjavaÁ¬½ÓOracleÊý¾Ý¿â´úÂ룬ÔÚÁ¬½Ó±¾»úOracleÊý¾Ý¿âÕý³£
Connection con = null;
PreparedStatement pst = null;
ResultSet rs = null;
public Connection getConnection() {
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
if(con == null || con.isClosed()){
con = DriverManager.getConnection("jdbc:oracle:thin:@10.216.8.212:1521:NXDC","mw_sys","sys");
}
} catch (Exception e) {
e.printStackTrace();
System.out.print("Á¬½Ó³öÒì³££¡");
}
return con;
}
Á¬½Ó·þÎñÆ÷OracleÒì³£ÐÅÏ¢£¨·þÎñÆ÷ϵͳ£ºLinux£©
java.sql.SQLException: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
The Connection descriptor used by the client was:
10.216.8.212:1521:NXDC
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:260)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:386)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:413)
at oracle.jdbc.driver.T4CConnection.<init>
Ïà¹ØÎÊ´ð£º
ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó
#topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬
Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7
Êý¾ÝÎļþ¹ÒÔØµÄ½Úµã£º/oradata/pcs/ Âß¼¾íºÅlv04
#lslv -l lv04
......
ÎÒJSPµÄÒ³ÃæÊÇ£º
<%@ page language="java" contentType="text/html; charset=gb2312"
%>
<script>
function Save(){
xmlHttp=GetXmlHttpObject()
if(xmlHttp==nul ......
¸÷·´óÏÀ¸ø¸ö˼·£¬²»ÊÇÔÚÏßµÄÄÇÖÖ£¬¾ÍÊÇÒ»¸ö×öÆÕͨµÄÓ¦ÓóÌÐò¡£
´Ê¿âÔõôÉú³ÉÄØ£¿
²»»á¡£
ÒýÓÃ
´Ê¿âÔõôÉú³ÉÄØ£¿
ÕÒ±¾×Öµä
ÒýÓÃ
´Ê¿âÔõôÉú³ÉÄØ£¿
Êý¾Ý¿â ºÇºÇ
ÓÃmap ¼üÖµ¶ÔÓ¦
Èç¹ûÓÃÊý¾Ý¿ ......
´úÂëÈçÏ £¬ÎÒÏëͨ¹ý´úÀí·ÃÎÊÒ»Ð©ÍøÖ·£¬µ«ÊDz»ÖªµÀÈçºÎ²âÊÔ´úÀí³É¹¦£¬ÎÒÏëͨ¹ý·ÃÎÊ¡°http://www.blogger.com/¡±À´¿´¿´ÊÇ·ñ´úÀí³É¹¦£¬µ«ÊÇÒ²²»ÄÜ·ÃÎÊ£¬³öÏÖÒì³£¡°Unexpected end of file from server¡±£¬µ«ÊÇÈç¹û²»Õâ ......
ÈçÌ⣬ÔÚWINDOWSµ×ϵÄCODE»á£¬µ«ÔÚLINUXϲ»ÖªµÀÈçºÎʵÏÖ£¬JSµÄ´úÂëÓ¦¸ÃÊDz»Ò»ÑùµÄ¡£ Çó½Ì¡£
·Ö²»¹»ÔÙ¼Ó¡£
http://topic.csdn.net/u/20100113/08/17ba1e71-4c33-43f6-91a5-0e031c86e5ed.html
linux ......