question

PalesaMokoena-8457 avatar image
0 Votes"
PalesaMokoena-8457 asked Monalv-msft edited

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

![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
image.png (30.8 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

YitzhakKhabinsky-0887 avatar image
0 Votes"
YitzhakKhabinsky-0887 answered YitzhakKhabinsky-0887 edited

@PalesaMokoena-8457,

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







udl-oracle.jpg (68.1 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

PalesaMokoena-8457 avatar image
0 Votes"
PalesaMokoena-8457 answered YitzhakKhabinsky-0887 commented

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




image.png (97.1 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@PalesaMokoena-8457,

I updated the answer with the steps what to do next.
Check it out its UPDATE section.

0 Votes 0 ·
Monalv-msft avatar image
0 Votes"
Monalv-msft answered Monalv-msft edited

Hi @PalesaMokoena-8457 ,

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.




oracle-cm.png (40.3 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @PalesaMokoena-8457 ,

May I know if you have anything to update?

Best regards,
Mona

0 Votes 0 ·