ORA-01017 error message when remotely executing SQL statement by Oracle Probe

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

When remotely executing an SQL query by using Oracle probe (test query), you get the following Oracle's error message: "ORA-01017: invalid username/password; logon denied"

 

Environment

Release : 20.3

Component : UIM - ORACLE

Cause

The user does not have all the required permissions.

Resolution

1. Verify if you can authenticate your user, by creating a connection and testing it using "test" button

2. If the user can authenticate, but you get the aforementioned error message when testing the connection with remote SQL statement execution ("templates" tab -> new template -> enter the query and press "test") , verify if the user does have "remote SQL statement execution" privilege.