ORA-12650: No common encryption or data integrity algorithm - connectivity error in Synapse.

Jayachandran, Athul 21 Reputation points
2024-06-12T09:18:51.3+00:00

Hi Team,

We are using an Azure Self Hosted Integration Runtime to connect to an on-premise Oracle SQL Database, we had pipeline running everyday till yesterday before the west europe outage ( Ticket ID - RN9S-39Z ).

Post the outage fix we have been facing the error 'ORA-12650: No common encryption or data integrity algorithm' while trying to connect to the oracle SQL database and our pipelines have been failing since the outage.

Is this a known issue at Microsoft end ?

Regards,

Athul

Azure Synapse Analytics
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,916 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Amira Bedhiafi 24,451 Reputation points
    2024-06-12T09:31:55.6266667+00:00

    To resolve this issue, get correct values of ASO related parameters and provide them in the JDBC connection string (You can get the exact values of these parameters from sqlnet.ora file, which is present in Oracle server machine).

    Example: Below are the contents of sqlnet.ora file:

    SQLNET.ENCRYPTION_CLIENT = REQUIRED    

    SQLNET.ENCRYPTION_TYPES_CLIENT = (RC4_256) SQLNET.CRYPTO_CHECKSUM_CLIENT = REQUIRED SQLNET.CRYPTO_CHECKSUM_TYPES_CLIENT = (MD5)​

    Since you mentioned a specific ticket ID related to the outage, it would be beneficial to follow up with Microsoft support. Provide them with the error details and the timeline of when the issue started to see if there are any known issues or fixes from their end.

    https://knowledge.informatica.com/s/article/498384?language=en_US

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.