怎么没人回答我的这个问题！！！！！！！！！！111

If you are on server , You need to check listener.ora instead of tnsnames.ora .verify your client tnsname.ora ->oracle8 setting.
don't worry , it's a very small issue:-)

解决方案 »

免费领取超大流量手机卡，每月29元包185G流量+100分钟通话, 中国电信官方发货

上面的兄弟：这是我的listener.ora.
# LISTENER.ORA Network Configuration File: C:\oracle\ora81\network\admin\listener.ora
# Generated by Oracle configuration tools.LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = 0-100hr)(PORT = 1521))
      )
    )
  )SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = C:\oracle\ora81)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = oracle8)
      (ORACLE_HOME = C:\oracle\ora81)
      (SID_NAME = oracle8)
    )
  )
下面是我的程序，总是说编译错误
<%@ page import="oracle.jdbc.driver.*" %>
<%@ page import="java.sql.*" %>
<%@ page contentType="text/html;charset=gb2312"%>
<HTML>
<HEAD>
  <TITLE>
SimpleQuery JSP
  </TITLE>
</HEAD>
<BODY BGCOLOR=EOFFFO>
<H1> Hello !  ÕâÊÇÎÒµÚÒ»¸öjspÒ³Ãæ£¡
</H1>
<HR>
<B> I will do a basic JDBC query to get member data from table member
</B> <P>
<%
//JDBC-ODBCÁ¬½Ó·½Ê½
/*try {
  DriverManager.registerDriver(new sun.jdbc.odbc.JdbcOdbcDriver());
        Connection conn = DriverManager.getConnection("jdbc:odbc:test","system","manager");
    Statement stmt = conn.createStatement ();
    ResultSet rset = stmt.executeQuery ("SELECT * from test");
    if (rset.next()) {
*/
//JDBC
try {
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@0-100hr:1521:oracle8","system","manager");
    Statement stmt = conn.createStatement ();
    ResultSet rset = stmt.executeQuery ("SELECT * from test");
    if (rset.next()) {
%><TABLE BORDER=1 BGCOLOR="C0C0C0">
<TH WIDTH=200 BGCOLOR="white"> <I>userId</I> </TH>
<TH WIDTH=100 BGCOLOR="white"> <I>password</I> </TH>
<TR> <TD ALIGN=CENTER> <%= rset.getString(1) %> </TD>
   <TD ALIGN=CENTER> <%= rset.getString(2) %></TD>
</TR> <%while (rset.next()) {
%> <TR>
  <TD ALIGN=CENTER> <%= rset.getString(1) %> </TD>
   <TD ALIGN=CENTER> <%= rset.getString(2) %> </TD>
</TR> <% }
%>
    </TABLE>
<%  }
    else {
%> <P> Sorry, the query returned no rows! </P> <%
    }
    rset.close();
    stmt.close();
  } catch (SQLException e) {
    out.println("<P>" + "There was an error doing the query:");
    out.println ("<PRE>" + e + "</PRE> \n <P>");
  }
%> </BODY>
</HTML>
你的LISTENER中没有对HOST luobutou的TCP协议监听器,在LISTENER.ORA中加入:
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = luobutou)(PORT = 1521))
      )
    )
  )然后重新启动监听服务.