java.sql.SQLException: Listener refused the connection with the following error

標籤：

      jdbc串連ORACLE資料庫時出現如題錯誤的一種可能： 

//oracle串連標識
        String url = "jdbc:oracle:thin:@192.168.0.200:1521:orcl";

必須與

檔案：oracle\product\10.2.0\db_1\network\admin\tnsnames.ora中：

RHORCL =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.200)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = orcl)
    )
  )

對應：@後面接相對應的HOST,PORT,SERVICE_NAME的值

java.sql.SQLException: Listener refused the connection with the following error