Forum Stats

  • 3,874,190 Users
  • 2,266,681 Discussions
  • 7,911,766 Comments

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 

[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.

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

ADR_BASE = /u01/orpppmp1/ppmapp/19.3

Answers

  • 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

    Chris,

    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.

    Thanks

    Cheslyn

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