OAC: "ORA-01017: invalid username/password" Error when Using Remote Data Gateway
(Doc ID 2607419.1)
Last updated on APRIL 05, 2021
Applies to:Oracle Analytics Cloud - Version 105.3.0 and later
Information in this document applies to any platform.
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)
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document