Java. SQL. sqlexception error code: 17002

When different IP segments are used, the IP address is often changed. Sometimes the restored IP address cannot access the local database orcle, and connection refused occurs.

 

Java. SQL. sqlexception: Io exception: Connection refused

An error occurred while establishing the connection:

Long Message:
Io exception: Connection refused (description = (TMP =) (vsnnum = 169869568) (ERR = 12505) (error_stack = (error = (code = 12505) (emfi = 4 ))))

Details:
Type: Java. SQL. sqlexception
Error code: 17002
SQL state: NULL

 

 

 

 

An error occurred while establishing a connection:
Long Message:
Io exception: Connection rejected (description = (TMP =) (vsnnum = 169869568) (ERR = 12505) (error_stack = (error = (code = 12505) (emfi = 4 ))))
Detailed description:
Type: Java. SQL. sqlexception
Error code: 17002
SQL status: NULL

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

------------------------------ Solution ---------------------------------

Try the following method:
1: Increase the processes parameter size
2: Add direct_handoff_ttc_listener = off to the header of listener. ora.