Error: The Network Adapter could not establish the connection

[camilo.martinez]

Hi,

We have had some problems in the generation of reports in our "Jasper report server", showing the following in the log server:

The problem is always solved by doing a sequential restart of the servers, would someone know what it is about?

2018-09-06 15:11:50,377 ERROR SystemErrorController,http-nio-8080-exec-26:86 - Internal server error
org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.JDBCConnectionException: Cannot open connection

Caused by: org.hibernate.exception.JDBCConnectionException: Cannot open connection

Caused by: java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection

Caused by: oracle.net.ns.NetException: The Network Adapter could not establish the connection

Caused by: java.net.ConnectException: Connection refused (Connection refused)

2018-09-06 15:11:50,370 ERROR JDBCExceptionReporter,pool-11-thread-113:101 - IO Error: The Network Adapter could not establish the connection

[hozawa]

Have you tried to restart oracle listener?

lsnrctl stop

lsnrctl start

[gonzalo.gatica]

@hozawa  I work with Camilo, and this problema is not constant.  It works correctly and suddenly the server sends this message and reports fail to generate.