Error while testing the “Oracle Database Credentials account” credential

Questions
1

Describe the problem/error/question

I am getting an error when testing the connection to my ORACLE database.

For your information, I have the same problem with a Node.js script when I don’t specify this line:
oracledb.initOracleClient()

What is the error message (if any)?

image
image967×127 12.2 KB

Please share your workflow

No workflow

Information on your n8n setup

  • **n8n version:**2.6.3
  • Database (default: SQLite):SQLite
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app):npm
  • Operating system:Windows 11
2

Hi @TheoB

Wlcome back to the n8n community!

can you share how you’re filling the connection fields (especially connection string / service name format)? it would help narrow this down further.

error usually means the TCP connection was opened but then closed by the server or interrupted on the network side.

Since you mentioned your Node.js script only works when explicitly calling initOracleClient(), that may still be needed depending on how Oracle libraries are installed, but the current error suggests the connection is reaching the server and then being closed, which points more to configuration or network rather than the client library itself.