Hi,
We need to connect to Oracle database which is installed on our internal server from Azure data factory. I have installed the "Microsoft Integration Runtime" service which successfully connects to the local database; but is unable to establish
connection to the oracle database hosted on a server (it is part of the same network).
When establishing the connection via Linkedservice we receive error as:
Connection failed
[{"code":9603,"message":"ERROR [28000] [Microsoft][ODBC Oracle Wire Protocol driver][Oracle]ORA-01017: invalid username/password; logon denied\r\nERROR [28000] [Microsoft][ODBC Oracle Wire Protocol driver][Oracle]ORA-01017: invalid
username/password; logon denied"}]
Kindly let us know any possible workarounds or options.