OAC: "ORA-01017: invalid username/password" Error when Using Remote Data Gateway (Doc ID 2607419.1)

Last updated on JULY 11, 2022

Applies to:

Symptoms

You have configured the Remote Data Gateway to connect to an On Premises database as per the instructions on Configure and Register Data Gateway for Reporting.

However, when you try to open an analysis accessing the remote source either one of these two errors is displayed:

DatasourceService. Details: [JDSError : 102] Cannot create a connection since there are some errors. Please fix them and try again. Failed creating a data source connection for jdbc:oracle:thin:@//<hostname>:<port>/<service_name> - Cause: ORA-01017: invalid username/password; logon denied Action: Invalid connection details. (HY000)

Or

State: HY000. Code: 46008. [nQSError: 46008] Internal error: File server/Query/Optimizer/ServiceInterfaceMgr/Src/SQOIServiceInterfaceMgr.cpp, line 3507. (HY000)

You have confirmed that the username and password are correct.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.