Question

java.sql.SQLException: Listener refused the connection with the following error: ORA-12505, TNS:

服务里面的OracleServiceORCL和OracleOraDb11g_home1TNSListener都打开了，LISTENER.ORA下面的（HOST=zhangyang）也改成计算机名了，没用localhost，还是报异常，求教！！
Class.forName("oracle.jdbc.driver.OracleDriver");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
try {
conn=DriverManager.getConnection("jdbc:oracle:thin:@zhangyang:1521:Admin","zhangpeng","zhangpeng");
System.out.println("数据库连接成功3");
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();

conn.close();
System.out.println("数据库关闭成功3");
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();

Answer 1

监听器确认lsnrctl status是否正常
Java代码里的连接字符串是否和服务器一致、尤其是数据库SID名