OraOLEDB.Oracle.1' is not registered on local machine SSIS

Palesa Mokoena 1 Reputation point
2021-03-15T22:59:18.38+00:00

![77860-image.png]1

I have uninstalled and reinstalled oracle client,

I installed both 32 & 64 bit drivers to local machine,
made sure the ODBC test connection is working but I still get the error

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,450 questions
0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Yitzhak Khabinsky 24,936 Reputation points
    2021-03-15T23:23:17.043+00:00

    @Palesa Mokoena ,

    If you are trying to use Oracle OLEDB provider, what is the point to test ODBC connection?
    They have nothing to do with each other.

    I would suggest to create a udl flle, and check there what OLEDB provider is installed.
    And upon selection a proper Oracle OLEDB provider, you can test the connection.

    You should see something like below. I don't have Oracle OLEDB provider installed on my machine, but you should see and select Oracle's provider, and proceed to the Connection tab to test the connection.

    UPDATE
    Upon testing your connections successfully via udl file, you can open that udl file in notepad. It will reveal for you the entire connection string that is working. You can go now to SSIS, and compare its Oracle connection properties vs. connection in the udl file. Specially the provider attribute of the connection in SSIS. If there is a discrepancy, you can adjust it to match what is in the udl file.

    77800-udl-oracle.jpg

    0 comments
  2. Palesa Mokoena 1 Reputation point
    2021-03-15T23:43:59.477+00:00

    I created a udl-oracle file as you suggested and the test connection was successful for oracle procider for OLE DB
    77982-image.png

    However when I try to test connection on SSIS it still fails with the error "
    Test connection failed because of an error in initializing provider. The 'OraOLEDB.Oracle.1' provider is not registered on the local machine."

  3. Monalv-MSFT 5,891 Reputation points
    2021-03-16T09:51:36.69+00:00

    Hi @Palesa Mokoena ,

    1.Please share the version of your SQL Server.

    2.Please check if you download proper version of Microsoft Connector for Oracle.

    3.Then we can create Oracle Connection Manager and test the connection.
    78196-oracle-cm.png

    Best regards,
    Mona

    If the answer is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.