How to solve the problem of jam when connecting to the oracle server on Sqlserver?

Today, I will talk to you about how to solve the jam when connecting to the oracle server on Sqlserver. Many people may not know much about it. In order to make you understand better, the editor summarized the following content for you. I hope you can get something according to this article.

It is sometimes encountered that the linked server to oracle established on the sqlserver server cannot be connected.

You will get stuck during the test.

This will directly cause the sqlserver service to shutdown directly, and the sqlserver service needs to be restarted.

Solution:

1. Delete the linked server of the original oracle on sqlserver and reset it.

With graphical settings, regardless of whether you select "allow in-process" here or not, you will get stuck when selecting a provider until the sqlserver service stops.

2. Manually create a linked server with a script, which can be tested successfully, but if "allow in-process" is checked, the test connection will still get stuck.

3. Finally, the client side of oracle on the sqlserver server is uninstalled, and the oracle client side is reinstalled. However, the first time you set up the provider, it still gets stuck, and the second time it succeeds.

After reading the above, do you have any further understanding of how to solve the problem of jam when connecting to the oracle server on Sqlserver? If you want to know more knowledge or related content, please follow the industry information channel, thank you for your support.