Unable to connect to Oracle database

Question

Hi,

I need to connect to the Oracle database which is installed on our internal server from Azure data factory. I  am using self hosted Integration runtime which is installed on local server and successfully connects to the oracle  database from here using same username & password; but is unable to establish connection to the oracle database from Azure data factory using this self hosted IR machine. 

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"}]

Please let me know if anyone has the solution to this issue.

---

Cheers,

Answer 1

Hi,

I need to connect to the Oracle database which is installed on our internal server from Azure data factory. I  am using self hosted Integration runtime which is installed on local server and successfully connects to the oracle  database from here using same username & password; but is unable to establish connection to the oracle database from Azure data factory using this self hosted IR machine. 

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"}]

Please let me know if anyone has the solution to this issue.

---

Cheers,

Please upgrade your self-hosted IR to latest version.  We have a recent fix for this issue.

Answer 2

Hi Amit,

Are you able to get rid of this error. I am also getting same error.

Any help will be highly appreciable.

---

-- Sumit Rastogi