I'm trying to connect an Oracle database with node.js using javaScript.
Requirements - I am using webdriverIo to automate the UI, which uses node.js and JS. In one process, I need to connect to Oracle DB and run a query through automation to get the values. I tried everything but the reaction was the same every time. I'm trying to connect oracle db using Nodejs and JS. I'm using VScode for coding.
1
0
0
For Oracle Database 11gR2 or earlier:
Add a call to initOracleClient() to enable node-oracledb Thick mode
Alternatively, you can upgrade the database.
For Oracle Database 12c or later:
To use Lite Mode: See Find and reset user passwords using the 10G password version. in conclusion:
Ensure that the database initialization parameter sec_case_sensitive_logon is not FALSE. In SQL*Plus, run showparameter sec_case_sensitive_logon as SYSDBA to check the value.
(Note that sec_case_sensitive_logonhas been deleted in DB 21c).
If the error still occurs, regenerate the password, such as running ALTER USER x IDENTIFIED BY y if necessary.
Alternatively, you can use thick mode.
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
