Hi,
I'm trying to configure Metricbeat Oracle Module on my system but getting logon denied error upon starting Metricbeat.
Error Message:
2020-05-05T16:45:30.988Z INFO module/wrapper.go:259 Error fetching data for metricset oracle.performance: error creating connection to Oracle: error doing ping to database: username="sys" sid="ipaddress:1521/XE" params={authMode:2 connectionClass:0x7fd1480008c0 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
====================================================================
Below is configuration for oracle.yml file
- module: oracle
metricsets: ["tablespace", "performance"]
enabled: true
period: 10s
hosts: ["oracle://sys:oracle@ipaddress:1521/XE?sysdba=1"]
===============================================================
The oracle version installed is Oracle 18c and able to logon using the above credential using sqlplus.
Elastic Version : 7.5.1
Can someone please let me know if I'm missing anything while configuring the same.
Thanks
Rakesh Chhabria