Hellom PRTG
I have added the sensor for the Oracle database. When I set In the host the database credentials for database user SYS, then it works. When I want to use SYS AS SYSDBA as database user, I get this error in the PRTG sensor:
ORA-01017: invalid username/password; logon denied
How can I connect as user SYS AS SYSDBA to the database ? It's essential in case of the Oracle Data Guard disaster recvovery setup to connect as the highest privileged user. Because on the standby side, database user SYSTEM does not have these permissions.
Regards, Martin
Article Comments
Hello Martin,
Please enable "Write result to disk" in the sensor's "Settings" tab. With the next scan it will write one or several result-files into "C:\ProgramData\Paessler\PRTG Network Monitor\Logs (Sensors)" of your PRTG server (or on the Remote Probe if applicable). All files have the sensor's numeric ID in their filenames. The sensor ID can be found on the sensor's "Overview" tab. Please send us those result-files.
Note: In case you've configured a different data-path in PRTG Administration Tool, you need to look there for subfolder "Logs (Sensors)".
Kind regards,
Erhard
Nov, 2017 - Permalink
Hello Martin,
Please enable "Write result to disk" in the sensor's "Settings" tab. With the next scan it will write one or several result-files into "C:\ProgramData\Paessler\PRTG Network Monitor\Logs (Sensors)" of your PRTG server (or on the Remote Probe if applicable). All files have the sensor's numeric ID in their filenames. The sensor ID can be found on the sensor's "Overview" tab. Please send us those result-files. Note: In case you've configured a different data-path in PRTG Administration Tool, you need to look there for subfolder "Logs (Sensors)".
Kind regards,
Erhard
Nov, 2017 - Permalink