My Oracle Support Banner

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

Last updated on NOVEMBER 03, 2023

Applies to:

Oracle Analytics Cloud
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

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