连接方案:
public class Conn {
public static String DRIVER="oracle.jdbc.driver.OracleDriver";
public static String URL="jdbc:oracle:thin:@127.0.0.1:1521:orcl";
public static String NAME="system";
public static String PWD="ly";
public static Connection getConn() throws Exception
{
Class.forName(DRIVER);
Connection conn=DriverManager.getConnection(URL, NAME, PWD);
return conn;
}
public static void main(String[] args) throws Exception {
Conn conn=new Conn();
if(conn.getConn()!=null)System.out.println("OK!");
}
}
报错:Exception in thread "main" 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
错误原因:给的sid不对
已做过的处理:1.select instance_name from v$instance---------------结果为orcl
2.怀疑监听不稳定,重新配置监听服务
[color=#FF0000]
但是仍然报上面错误,郁闷,求助!!!!!!!!!!![/
color]