search

iamseth / oracledb_exporter

Prometheus Oracle database exporter.
MIT License
472 stars 242 forks source link

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

Open asalieu opened 2 months ago

asalieu commented 2 months ago

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"