Azure Data Factory error connecting to Oracle ADW using Wallet

Question

Azure Data Factory error connecting to Oracle ADW using Wallet

Giulio Vellusi 20

I am configuring an Azure Data Factory Self-Hosted Integration Runtime to read data from Oracle Cloud ADW using a Wallet. I have installed the SHIR on a VM and extracted the wallet zip file in a local directory in the VM (C:\Oracle).

I followed what is described in the following resource but I am still unable to test the connection successfully. I get the following error:

ERROR [08001] [Microsoft][ODBC Oracle Wire Protocol driver]ORA-12203: unable to connect to destination

The SHIR version number is 5.35.8686.1 (Data Factory V2)

To verify that the error is not related to networking issues, I downloaded SQL Developer on the VM and set up a new connection using the wallet file being able to connect successfully.

I also tried to find an ODBC driver capable to connect to Oracle ADW in order to use it instead of the driver included in the SHIR as a workaround, but it seems that the Oracle Instant Client ODBC driver is not capable of using a wallet to connect to ADW.

Do anyone have any suggestion?

Giulio Vellusi 20 Reputation points

2023-12-11T17:26:38.0966667+00:00

For those who are interested, I used the workaround of setting up an ODBC source in the SHIR VM using the Oracle Intant Client 21.12 ODBC Driver. Still not able to use the SHIR integrated Oracle ODBC Driver though.
Harishga 6,000 Reputation points Microsoft External Staff

2023-12-12T11:01:47.7166667+00:00
Hi@Giulio Vellusi

Welcome to Microsoft Q&A platform and thanks for posting your question here.
It seems that the Oracle Instant Client ODBC driver is not capable of using a wallet to connect to ADW.

Here are some steps that you can follow to approach this issue:

Ensure that the Oracle Wallet Manager is installed on the VM where the SHIR is installed. The Oracle Wallet Manager is used to manage and maintain security credentials on Oracle databases.

Verify that the Oracle Wallet is configured correctly. The Oracle Wallet should contain the necessary credentials to connect to the Oracle ADW instance.

Check that the Oracle Wallet is accessible to the SHIR. The Oracle Wallet should be located in a directory that is accessible to the SHIR.

Ensure that the SHIR is configured correctly. The SHIR should be configured to use the Oracle ODBC driver to connect to the Oracle ADW instance.

Verify that the Oracle ODBC driver is installed on the VM where the SHIR is installed. The Oracle ODBC driver is required to connect to the Oracle ADW instance.

Check that the Oracle ODBC driver is configured correctly. The Oracle ODBC driver should be configured to use the Oracle Wallet to connect to the Oracle ADW instance.

check the firewall settings on the VM to ensure that the necessary ports are open for the SHIR to connect to the Oracle ADW instance.

I hope this information helps you. Let me know if you have any further questions or concerns.
Harishga 6,000 Reputation points Microsoft External Staff

2023-12-13T09:49:51.03+00:00

Hi@Giulio Vellusi
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution. please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Giulio Vellusi 20 Reputation points

2023-12-13T10:27:31.08+00:00

Hi, I have solved this as mentioned in my previous comment by using an ODBC source in the SHIR VM.

Thanks for your support.

Regards,

Giulio
Harishga 6,000 Reputation points Microsoft External Staff

2023-12-13T11:28:02.3233333+00:00

Hi@Giulio Vellusi
Glad to know your issue has been resolved. Since the Microsoft Q&A community has a policy that "The question author cannot accept their own answer. They can only accept answers by others "I'll repost your solution in case you'd like to accept the answer.

Accepted answer

0 additional answers

Your answer

Giulio Vellusi 20 Reputation points

2023-12-11T17:26:38.0966667+00:00

For those who are interested, I used the workaround of setting up an ODBC source in the SHIR VM using the Oracle Intant Client 21.12 ODBC Driver. Still not able to use the SHIR integrated Oracle ODBC Driver though.
Harishga 6,000 Reputation points Microsoft External Staff

2023-12-12T11:01:47.7166667+00:00

Hi@Giulio Vellusi

Welcome to Microsoft Q&A platform and thanks for posting your question here.
It seems that the Oracle Instant Client ODBC driver is not capable of using a wallet to connect to ADW.

Here are some steps that you can follow to approach this issue:

Ensure that the Oracle Wallet Manager is installed on the VM where the SHIR is installed. The Oracle Wallet Manager is used to manage and maintain security credentials on Oracle databases.

Verify that the Oracle Wallet is configured correctly. The Oracle Wallet should contain the necessary credentials to connect to the Oracle ADW instance.

Check that the Oracle Wallet is accessible to the SHIR. The Oracle Wallet should be located in a directory that is accessible to the SHIR.

Ensure that the SHIR is configured correctly. The SHIR should be configured to use the Oracle ODBC driver to connect to the Oracle ADW instance.

Verify that the Oracle ODBC driver is installed on the VM where the SHIR is installed. The Oracle ODBC driver is required to connect to the Oracle ADW instance.

Check that the Oracle ODBC driver is configured correctly. The Oracle ODBC driver should be configured to use the Oracle Wallet to connect to the Oracle ADW instance.

check the firewall settings on the VM to ensure that the necessary ports are open for the SHIR to connect to the Oracle ADW instance.

I hope this information helps you. Let me know if you have any further questions or concerns.
Harishga 6,000 Reputation points Microsoft External Staff

2023-12-13T09:49:51.03+00:00

Hi@Giulio Vellusi
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution. please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Giulio Vellusi 20 Reputation points

2023-12-13T10:27:31.08+00:00

Hi, I have solved this as mentioned in my previous comment by using an ODBC source in the SHIR VM.

Thanks for your support.

Regards,

Giulio
Harishga 6,000 Reputation points Microsoft External Staff

2023-12-13T11:28:02.3233333+00:00

Hi@Giulio Vellusi
Glad to know your issue has been resolved. Since the Microsoft Q&A community has a policy that "The question author cannot accept their own answer. They can only accept answers by others "I'll repost your solution in case you'd like to accept the answer.

Answer 1

Hi Giulio Vellusi,
I'm glad that you were able to resolve your issue and thank you for posting your solution so that others experiencing the same thing can easily reference this! Since the Microsoft Q&A community has a policy that ""The question author cannot accept their own answer. They can only accept answers by others ". They can only accept answers by others ", I'll repost your solution in case you'd like to accept the answer.

Ask: How to resolve the error "ORA-12203: unable to connect to destination" while configuring Azure Data Factory Self-Hosted Integration Runtime to read data from Oracle Cloud ADW using a Wallet? The customer has tried SQL Developer and finding an ODBC driver as a workaround but was unsuccessful.

Solution: The user was unable to use the SHIR integrated Oracle ODBC Driver to connect to Oracle Cloud ADW, so they set up an ODBC source in the SHIR VM using the Oracle Instant Client 21.12 ODBC Driver as a workaround. However, they still couldn't use the SHIR integrated Oracle ODBC Driver.

If I missed anything please let me know and I'd be happy to add it to my answer, or feel free to comment below with any additional information.
If you have any other questions, please let me know. Thank you again for your time and patience throughout this issue.
Please don’t forget to Accept Answer and Yes for "was this answer helpful" wherever the information provided helps you, this can be beneficial to other community members.

Hope this helps. Do let us know if you any further queries.

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Share via

Azure Data Factory error connecting to Oracle ADW using Wallet

0 additional answers

Your answer