none
Unable to connect to Oracle database from ADF RRS feed

  • Question

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


    Tuesday, November 6, 2018 12:22 PM

All replies

  • Hi Manjiri,

    We are also stuck with the same problem, did you get any solution to it?



    Cheers,


    • Edited by Amit-Tomar Friday, November 23, 2018 8:48 AM
    Friday, November 23, 2018 8:48 AM