"advanced negotiation error: during receive service header: network excpetion: ora-12269"

[asalieu]

Hi,

Thanks for the good work on the oracle exporter for go, but i have an issue while attempting to connect to a tcps only enabled database and details as followed:

OS Linux
Database oracle 19c

Exporter Error code:
ts=2024-05-03T08:58:53.136Z caller=collector.go:263 level=error errorpingingoracle:="advanced negotiation error: during receive service header: network excpetion: ora-12269"

Oracle Trace LogFile:

Fatal NI connect error 12269, connecting to:
(ADDRESS=(PROTOCOL=tcps)(HOST=x.x.x.x)(PORT=24553))

VERSION INFORMATION:
TNS for Linux: Version 19.0.0.0.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 19.0.0.0.0 - Production
sdp
Version 19.18.0.0.0
Time: 03-MAY-2024 11:12:08
Tracing not turned on.
Tns error struct:
ns main err code: 12269

TNS-12269: Message 12269 not found; product=network; facility=TNS

ns secondary err code: 0
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0

opiodr aborting process unknown ospid (896886) as a result of ORA-609

Good to know that i packaged and built this exporter to run in a container in kubernetes and and container is running Linux OS , i have also installed oracle client oracle-instantclient-basic-21.11.0.0.0-1.x86_64.rpm and oracle-instantclient-sqlplus-21.11.0.0.0-1.x86_64.rpm and with these i am able to test and make an sqlplus connection towards the tcps enabled database but the exporter fails on collector.go:263 level=error errorpingingoracle:="advanced negotiation error: during receive service header: network excpetion: ora-12269"