# Oracle Modules **URL:** \ **Category:** Beats\ **Tags:** metricbeat\ **Created:** [April 29, 2020, 9:26am UTC](https://discuss.elastic.co/t/oracle-modules/230345 "2020-04-29T09:26:12Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![Mario\_Fimiani](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/mario_fimiani/32/51039_2.png) [@Mario\_Fimiani](https://discuss.elastic.co/u/Mario_Fimiani)\ **Post date:** [April 29, 2020, 9:26am UTC](https://discuss.elastic.co/t/oracle-modules/230345/1 "2020-04-29T09:26:12Z")
Hi we are testing this module for metricbeat (v7.5.0) that work with standard OCI driver. We installed/tested the following : - enable the module - instant client (as per doc) - modify the systemd script to load the ENV var - tested manual connection with oracle tool but we receive the same errors on data ingested : oracle://\<..user..\>:\<..pwd..\>@\<..host..\>:1521/\<..sid..\>?sysdba=1 error creating connection to Oracle: error doing ping to database: username="xxxxxxxx" sid="xxxxxx" params={authMode:2 connectionClass:0x7f42740a9240 connectionClassLength:7 purity:0 newPassword: newPasswordLength:0 appContext: numAppContext:0 externalAuth:0 externalHandle: pool: tag: tagLength:0 matchAnyTag:0 outTag: outTagLength:0 outTagFound:0 shardingKeyColumns: numShardingKeyColumns:0 superShardingKeyColumns: numSuperShardingKeyColumns:0 outNewSession:0}: ORA-01017: invalid username/password; logon denied Some suggestions ? ---
**Author:** ![kvch](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/kvch/32/72058_2.png) [@kvch](https://discuss.elastic.co/u/kvch)\ **Post date:** [April 29, 2020, 2:29pm UTC](https://discuss.elastic.co/t/oracle-modules/230345/2 "2020-04-29T14:29:39Z")
Could you please share your configuration formatted using ``? Also, please share the debug logs (`./metricbeat -e -d "*"`)? ---
**Author:** ![Mario\_Fimiani](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/mario_fimiani/32/51039_2.png) [@Mario\_Fimiani](https://discuss.elastic.co/u/Mario_Fimiani)\ **Post date:** [April 29, 2020, 2:58pm UTC](https://discuss.elastic.co/t/oracle-modules/230345/3 "2020-04-29T14:58:37Z")
> [@kvch](#): > > ./metricbeat -e -d "\*" [root@server metricbeat]# metricbeat modules list Enabled: oracle system - module: oracle metricsets: ["tablespace","performance"] enabled: true period: 30s hosts: ["oracle://:@:1521/sid?sysdba=1"] 2020-04-29T14:44:23.096Z INFO instance/beat.go:610 Home path: [/usr/share/metricbeat] Config path: [ /etc/metricbeat] Data path: [/var/lib/metricbeat] Logs path: [/var/log/metricbeat] 2020-04-29T14:44:23.096Z DEBUG [beat] instance/beat.go:662 Beat metadata path: /var/lib/metricbeat/m eta.json 2020-04-29T14:44:23.096Z INFO instance/beat.go:618 Beat ID: 9d3da00d-7665-4db3-a423-9501a5e16afd 2020-04-29T14:44:23.099Z DEBUG [filters] add\_cloud\_metadata/providers.go:126 add\_cloud\_metadat a: starting to fetch metadata, timeout=3s 2020-04-29T14:44:26.099Z DEBUG [filters] add\_cloud\_metadata/providers.go:162 add\_cloud\_metadat a: received disposition for az after 3.000442219s. result=[provider:az, error=failed requesting az metadata: Get [http://169.254.169.254/metadata/instance/compute?api-version=2017-04-02:](http://169.254.169.254/metadata/instance/compute?api-version=2017-04-02:) dial tcp 169.254.169.254:80: i/o timeout , metadata={}] 2020-04-29T14:44:26.099Z DEBUG [filters] add\_cloud\_metadata/providers.go:169 add\_cloud\_metadat a: timed-out waiting for all responses 2020-04-29T14:44:26.099Z DEBUG [filters] add\_cloud\_metadata/providers.go:129 add\_cloud\_metadat a: fetchMetadata ran for 3.000700115s 2020-04-29T14:44:26.099Z INFO add\_cloud\_metadata/add\_cloud\_metadata.go:89 add\_cloud\_metadata: hosti ng provider type not detected. 2020-04-29T14:44:26.099Z DEBUG [processors] processors/processor.go:101 Generated new processors: add\_host\_metadata=[netinfo.enabled=[false], cache.ttl=[5m0s]], add\_cloud\_metadata=null The log that I pushed before was inside the event.dataset in kibana dashboard. BR ---
**Author:** ![Mario\_Fimiani](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/mario_fimiani/32/51039_2.png) [@Mario\_Fimiani](https://discuss.elastic.co/u/Mario_Fimiani)\ **Post date:** [April 30, 2020, 10:56am UTC](https://discuss.elastic.co/t/oracle-modules/230345/4 "2020-04-30T10:56:02Z")
In the environment we set Environment="ORACLE\_BASE="/orabin/app/oracle" Environment="ORA\_RDBMS\_HOME="/orabin/app/oracle/product/18.0.0/dbhome\_1" Environment="ORA\_GRID\_HOME="/orabin/app/18.0.0/grid" Environment="ORA\_AG\_HOME="/orabin/app/oracle/agent/agent\_13.4.0.0.0" Environment="ORACLE\_SID=name1" Environment="ORA\_DB\_NAME=name" Environment="ORACLE\_HOME=/orabin/app/oracle/product/18.0.0/dbhome\_1" Environment="TNS\_ADMIN=/orabin/app/oracle/product/18.0.0/dbhome\_1/network/admin" Environment="PATH=/etc/metricbeat/instantclient/instantclient\_18\_5:/orabin/app/oracle/product/18.0.0/dbhome\_1/bin:/orabin/app/oracle/product/18.0.0/dbhome\_1/OPatch:/orabin/app/18.0.0/grid/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/opt/puppetlabs/bin:/orabin/app/oracle/product/18.0.0/dbhome\_1/network/admin" Environment="LD\_LIBRARY\_PATH=/etc/metricbeat/instantclient/instantclient\_18\_5:/orabin/app/oracle/product/18.0.0/dbhome\_1/bin:/orabin/app/oracle/product/18.0.0/dbhome\_1/OPatch:/orabin/app/18.0.0/grid/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/opt/puppetlabs/bin:/orabin/app/oracle/product/18.0.0/dbhome\_1/network/admin" and test also via sqlplus the auth. BR ---
**Author:** ![Mario\_Fimiani](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/mario_fimiani/32/51039_2.png) [@Mario\_Fimiani](https://discuss.elastic.co/u/Mario_Fimiani)\ **Post date:** [May 5, 2020, 9:22am UTC](https://discuss.elastic.co/t/oracle-modules/230345/5 "2020-05-05T09:22:24Z")
Seems that in the field sid on kibana side there is sid="db\_host:dp\_port/service" and not only the sid. ---
**Author:** ![Mario\_Fimiani](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/mario_fimiani/32/51039_2.png) [@Mario\_Fimiani](https://discuss.elastic.co/u/Mario_Fimiani)\ **Post date:** [May 8, 2020, 10:00am UTC](https://discuss.elastic.co/t/oracle-modules/230345/6 "2020-05-08T10:00:10Z")
Any idea ? ---
**Author:** ![Mario\_Fimiani](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/mario_fimiani/32/51039_2.png) [@Mario\_Fimiani](https://discuss.elastic.co/u/Mario_Fimiani)\ **Post date:** [June 4, 2020, 8:44am UTC](https://discuss.elastic.co/t/oracle-modules/230345/7 "2020-06-04T08:44:19Z")
Seems that the problem was on sysdba user. ---
**Author:** ![Mario\_Castro](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/mario_castro/32/35107_2.png) [@Mario\_Castro](https://discuss.elastic.co/u/Mario_Castro)\ **Post date:** [June 4, 2020, 3:39pm UTC](https://discuss.elastic.co/t/oracle-modules/230345/8 "2020-06-04T15:39:18Z")
We have removed the hard requirement to connect as sysdba in 7.8. However, you'll still need proper permissions to access the system tables. > ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [July 2, 2020, 5:39pm UTC](https://discuss.elastic.co/t/oracle-modules/230345/9 "2020-07-02T17:39:19Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.