My Oracle Support Banner

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

Last updated on NOVEMBER 04, 2019

Applies to:

Oracle Analytics Cloud - Version 105.3.0 and later
Information 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


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