Forum Discussion

WilliamSca's avatar
WilliamSca
Copper Contributor
Mar 15, 2024

Error: ORA-12650: No common encryption or data integrity

hi guys,

 

I started getting this weird error in the copy activity, have you seen this error before ? any idea ?

 

Oracle 11.2

 

 

Failure happened on 'Source' side. ErrorCode=UserErrorFailedToConnectOdbcSource,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=ERROR [HY000] [Microsoft][ODBC Oracle Wire Protocol driver][Oracle]ORA-12650: No common encryption or data integrity algorithm
ERROR [HY000] [Microsoft][ODBC Oracle Wire Protocol driver][Oracle]ORA-12650: No common encryption or data integrity algorithm,Source=Microsoft.DataTransfer.ClientLibrary.Odbc.OdbcConnector,''Type=System.Data.Odbc.OdbcException,Message=ERROR [HY000] [Microsoft][ODBC Oracle Wire Protocol driver][Oracle]ORA-12650: No common encryption or data integrity algorithm
ERROR [HY000] [Microsoft][ODBC Oracle Wire Protocol driver][Oracle]ORA-12650: No common encryption or data integrity algorithm,Source=,'

 

 

thank you 

13 Replies

  • DexterV's avatar
    DexterV
    Copper Contributor
    Jul 09, 2024
    We encountered the same error around June 9 , 2024. I managed to fix this by going to the Oracle Database server and update the following:
    Existing : on DB Node sqlnet.ora file ...

    SQLNET.CRYPTO_CHECKSUM_TYPES_SERVER=(SHA1)
    SQLNET.CRYPTO_CHECKSUM_TYPES_CLIENT=(SHA1)

    TO


    SQLNET.CRYPTO_CHECKSUM_TYPES_SERVER=(SHA256,SHA384,SHA512,SHA1)
    SQLNET.CRYPTO_CHECKSUM_TYPES_CLIENT=(SHA256,SHA384,SHA512,SHA1)
  • athuljcde's avatar
    athuljcde
    Copper Contributor
    Jun 12, 2024

    We have been facing the same issue from yesteday, there has been no changes in the source, this started happening after the outage yesterday and it's revival. 

  • Kjetil_Andenas's avatar
    Kjetil_Andenas
    Copper Contributor
    Jun 10, 2024
    Hi William, did you get to solve this error? I just started to see this on our server last Thursday - 6th of June - no changes logged of course ..
    • andrewmoon's avatar
      andrewmoon
      Copper Contributor
      Jun 11, 2024

      Kjetil_Andenas 

      Did you figure this out? We're also experiencing this when testing the connection on the Azure portal through our Self-Hosted Integration Runtime.

       

      • Kjetil_Andenas's avatar
        Kjetil_Andenas
        Copper Contributor
        Jun 12, 2024
        We actually made it work by having our DB Admin insert the following into the .ora file on the Oracle server: SQLNET.ENCRYPTION_SERVER=REQUESTED. Seems this made the trick - having Oracle server allowing what ever encryption thta Azure is asking for.

Resources