oracle wallet - connection to adb - Error pinging oracle: ORA-12154: TNS:could not resolve the connect identifier specified

[pvk1103]

I am trying to connect to adb through wallet in oracledb_exporter container and wallet is at /tmp/wallet location.

Below are the debug logs. Unable to understand the issue as first it says successfully connected and then throws the tns error.

time="2022-11-17T11:37:08Z" level=info msg="Starting oracledb_exporter master" source="main.go:543" time="2022-11-17T11:37:08Z" level=info msg="Successfully loaded default metrics from: default-metrics.toml" source="main.go:518" time="2022-11-17T11:37:08Z" level=info msg="No custom metrics defined." source="main.go:533" time="2022-11-17T11:37:08Z" level=debug msg="Launching connection: acdc/XXXXXXXXXXX@dvc2687adb324_high?ssl_server_dn_match=false&wallet_location=/tmp/wallet" source="main.go:105" time="2022-11-17T11:37:08Z" level=debug msg="set max idle connections to 0" source="main.go:111" time="2022-11-17T11:37:08Z" level=debug msg="set max open connections to 10" source="main.go:113" time="2022-11-17T11:37:08Z" level=debug msg="Successfully connected to: acdc/XXXXXXXXXXX@dvc2687adb324_high?ssl_server_dn_match=false&wallet_location=/tmp/wallet" source="main.go:115" time="2022-11-17T11:37:08Z" level=error msg="Error pinging oracle: ORA-12154: TNS:could not resolve the connect identifier specified\n" source="main.go:215" time="2022-11-17T11:37:08Z" level=info msg="Listening on :9161" source="main.go:579"

I tried with different DATA_SOURCE_NAME's but all seem to throw the same error. Below is one such data source name that I have tried. acdc/XXXXXXXXXXX@//vt1jqern.adb.us-phoenix-1.oraclecloud.com:1521/vphbtcf4stcojsp_dvc2687adb324_high.adb.oraclecloud.com?ssl_server_dn_match=false&wallet_location=/tmp/wallet

Any help on this would be much appreciated.

[npk1994]

@pvk1103 did you find any workaround. We are also facing similar issue