Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,631 questions
Unable to link Oracle Cloud Service to Azure Synapse
Pallav Kulkarni
1
Reputation point
I am trying to link Oracle Cloud Service to Azure Synapse Workspace. I have created Integration runtime, filled the hostname, but I am getting the error message while testing the connection:
ERROR [HY000] [Microsoft][OSvC] (100) Error parsing JSON: Invalid value. while parsing string <html> <head><title>302 Found</title></head> <body> <center><h1>302 Found</h1></center> <hr><center>nginx</center> </body> </html> . ERROR [HY000] [Microsoft][OSvC] (100) Error parsing JSON: Invalid value. while parsing string <html> <head><title>302 Found</title></head> <body> <center><h1>302 Found</h1></center> <hr><center>nginx</center> </body> </html> . Activity ID: a39c8ca9-c030-4cc6-ad75-f1983e54e215.
{count} votes
-
Pallav Kulkarni 1 Reputation point
2020-07-15T04:46:17.81+00:00 Now, when I put the port number along with Hostname, I got this error:
ERROR [HY000] [Microsoft][DriverSupport] (1160) Cannot enable SSL for the connection when connecting to a server that has not enabled SSL. If the server has SSL enabled, please check if it has been configured to use a SSL protocol version that is lower than what is allowed for the connection. The minimum SSL protocol version allowed for the connection is: TLS 1.2. ERROR [HY000] [Microsoft][DriverSupport] (1160) Cannot enable SSL for the connection when connecting to a server that has not enabled SSL. If the server has SSL enabled, please check if it has been configured to use a SSL protocol version that is lower than what is allowed for the connection. The minimum SSL protocol version allowed for the connection is: TLS 1.2. Activity ID: 2a20c362-9c3f-4346-8aaf-36d07f47f07f.
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(192, 26%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHM%3C/text%3E%3C/svg%3E)
HimanshuSinha-msft 19,376 Reputation points Microsoft Employee2020-07-15T21:22:43.48+00:00 Hello @PallaviKulkarni-5080 ,
Thanks for the question and using this forum,
I see that you have already reached out to the MS support team for help on this . With the error which you have pasted I think it looks to be an issue with the networ/certificate and I think they can work more closely with you and get this resolved .I have also reached out to the product group to see if they can help here . I will update the thread once I hear from you on this .
Just in case if you have an resolution , please update the thread .
Thanks
HImanshu -
Pallav Kulkarni 1 Reputation point
2020-07-16T06:17:04.597+00:00 Thank you @HimanshuSinha-MSFT for the response.
-
HimanshuSinha-msft 19,376 Reputation points Microsoft Employee
2020-07-16T23:23:16.653+00:00 Hello Pallav,
Just heard back from theteam and it this time , this is just a idea .
Azure supports Oracle 18.3 which supports TLS 1.0/1. Depending on Cipher suite.Take a look at Table 20.2 of https://docs.oracle.com/en/database/oracle/oracle-database/18/dbseg/configuring-secure-sockets-layer-authentication.html#GUID-EFF4B2C9-2D25-473D-B718-A42754252347
It could be simple TLS configuration on Azure Oracle Service.
Thanks
Himanshu
Sign in to comment