OAC: "ORA-01017: invalid username/password" Error when Using Remote Data Gateway
(Doc ID 2607419.1)
Last updated on JULY 11, 2022
Applies to:
Oracle Analytics Cloud - Version 105.3.0 and laterInformation in this document applies to any platform.
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
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
Symptoms |
Cause |
Solution |
References |