Skip to content

Wrong path in LD_LIBRARY_PATH and ORACLE_HOME #136

Closed
@AOzhogin

Description

@AOzhogin

Hi,
Image: amd64 container-registry.oracle.com/database/observability-exporter:1.5.0 id: 7a38e0ddd3e6
Registry: container-registry.oracle.com
DB: Oracle 19.0.0.0.0

Problem:
I noticed errors in the container log and decided to take a look, as a result I came across a problem with the paths, but i dont fix my problem.

1. caller=collector.go:346 level=error msg="Error scraping metric" Context=activity MetricsDesc="map[value:Generic counter metric from v$sysstat view in Oracle.]" time=44.085579ms error="**driver: bad connection**"
2. caller=collector.go:346 level=error msg="Error scraping metric" Context=db_platform MetricsDesc="map[value:Database platform]" time=48.104538ms error="driver: bad connection"
3. caller=collector.go:346 level=error msg="Error scraping metric" Context=db_system MetricsDesc="map[value:Database system resources metric]" time=1.375944ms error="driver: bad connection"

Other database queries are working.

bash-4.4$ env
>	LD_LIBRARY_PATH=/usr/lib/oracle/21/client64/lib
	CUSTOM_METRICS=/exporter/custom_metrics.toml
>	ORACLE_HOME=/usr/lib/oracle/21/client64
	HOSTNAME=f4fa135a9694
	VERSION=1.0.0
	PWD=/
	HOME=/
	DB_PASSWORD=any_pwd
	DEBIAN_FRONTEND=noninteractive
	DB_CONNECT_STRING=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=any_host)(PORT=1521))(CONNECT_DATA=(SID=any_sid)))
	TERM=xterm
	DB_USERNAME=any_user
	SHLVL=1
>	PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/lib/oracle/21/client64/bin
	_=/usr/bin/env

bash-4.4$ cd /usr/lib/oracle/
bash-4.4$ ls -la
	total 12
	drwxr-xr-x 3 root root 4096 Sep 30 17:51 .
	dr-xr-xr-x 1 root root 4096 Sep 30 17:51 ..
	drwxr-xr-x 3 root root 4096 Sep 30 17:51 19.23

bash-4.4$ ls 19.23/
	client64

bash-4.4$ ls 19.23/client64/
	bin  lib

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions