none
Unable to connect to Oracle database RRS feed

  • 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,


    • Edited by Amit-Tomar Friday, November 23, 2018 9:26 AM
    Friday, November 23, 2018 9:24 AM

Answers

  • 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.
    Friday, November 23, 2018 10:54 AM

All replies

  • 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.
    Friday, November 23, 2018 10:54 AM
  • 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

    Thursday, May 9, 2019 3:42 PM