Forum Stats

  • 3,874,190 Users
  • 2,266,681 Discussions


Node JS - ORA-12650: No common encryption or data integrity algorithm

Cheslyn Dcruz
Cheslyn Dcruz Member Posts: 5 Blue Ribbon

Recently we are running into the following error when connecting to select instances 


[Error: ORA-12650: No common encryption or data integrity algorithm] {

 errorNum: 12650,

 offset: 0}

This could be linked to the SQLNET encrypting setting which is causing it. 

Based on what I have seen one suggested fix is to upgrade JDBC on the M/c running Node to 12.x+ 

However on our Non Prod instance the connectivity to the same DB goes through fine. 

Both instances have identical Node versions. 

Both Instances 

Node ver : 14.18.1 

Sqlnet.Ora on the server where Node is running 

$ cat sqlnet.ora

# sqlnet.ora Network Configuration File: /u01/orpppmp1/ppmapp/19.3/network/admin/sqlnet.ora

# Generated by Oracle configuration tools.


ADR_BASE = /u01/orpppmp1/ppmapp/19.3


  • Christopher Jones-Oracle
    Christopher Jones-Oracle Member Posts: 1,656 Employee

    The node-oracledb stack is C based, so playing with Java or JDBC is not going to have an effect.

    Yes it will be related to the sqlnet.ora configuration in some way. Check what encryption or check-summing protocols the DB sqlnet.ora has configured. Make sure you are using up to date client libraries (The current 19c client is 19.16) - or maybe you need an older insecure version if your database only supports older insecure algorithms - I don't know. Are you non-prod machines using the same OS as the prod machines?

  • Cheslyn Dcruz
    Cheslyn Dcruz Member Posts: 5 Blue Ribbon


    Thanks for your response.

    Earlier we were running on JDBC 12.x , we upgraded that to JDBC 19.x and this seems to have resolved the issue.

    However will check on what you said as well.



    Ps: Sorry for the double line spacing, cant find the setting which will set it to single line spacing.