Error pinging oracle: ORA-12537: TNS:connection closed

[kelein]

Excuse me, I met a question after the oracledb_exporter be running after more hours, the output occurs this:

ERRO[1942] Error pinging oracle: ORA-12537: TNS:connection closed source=main.go:136
ERRO[1947] Error pinging oracle: ORA-12537: TNS:connection closed source=main.go:136
ERRO[1952] Error pinging oracle: ORA-12537: TNS:connection closed source=main.go:136

Due to this, the path http://localhost:9161/metrics couldn't return any metric.

I use a image of webdizz/oracle-xe-11g-sa:latest up for oracle db.
After some research I login into the oracle container to tail the tnslnr listener.log:

tail -f /u01/app/oracle/diag/tnslsnr/cb2abd620214/listener/trace/listener.log

Thu Jun 29 03:45:31 2017
29-JUN-2017 03:45:31 * service_update * XE * 0
29-JUN-2017 03:45:34 * service_update * XE * 0
Thu Jun 29 03:46:15 2017
WARNING: Subscription for node down event still pending
29-JUN-2017 03:46:15 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=cb2abd620214)(USER=root))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=1866470
40)) * status * 0
WARNING: Subscription for node down event still pending
29-JUN-2017 03:46:18 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=cb2abd620214)(USER=root))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=1866470
40)) * status * 0
Thu Jun 29 03:47:17 2017
No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=cb2abd620214)(PORT=1521)))
No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=cb2abd620214)(PORT=8080))(Presentation=HTTP)(Session=RAW))

[iamseth]

@Keleir I'm having trouble reproducing the issue. I was not able to make the container image you used but I used another and so far after 2 hours no problems.

BTW, I create a Docker image for this exporter as well.

docker run --name oracle -d -p 8080:8080 -p 1521:1521 sath89/oracle-12c
docker run -d --link=oracle -p 9161:9161 -e DATA_SOURCE_NAME=system/oracle@oracle/xe.oracle.docker iamseth/oracledb_exporter:0.0.1