N8n-nodes-oracle-database-parameterization don't show file tnsname.ora

Questions
1

Hi,

I can’t connect the node Oracle to database. The credential oracle account don’t show the file tnsname.ora.

I have install the Oracle InstantClient 23 and I have add variables

export N8N_LOG_LEVEL=debug
export N8N_LOG_OUTPUT=console,file
export N8N_LOG_FILE_LOCATION=/home/exploit/n8n/logs/n8n.log
export N8N_LOG_FILE_MAXSIZE=50
export N8N_LOG_FILE_MAXCOUNT=60

export N8N_SECURE_COOKIE=false
export VUE_APP_URL_BASE_API=https://aci-ia01/
export N8N_HOST=aci-ia01
export N8N_RUNNERS_ENABLED=true
export N8N_CUSTOM_EXTENSIONS=$(pwd)/node_modules/n8n-nodes-oracle-database-parameterization
export N8N_ENFORCE_SETTINGS_FILE_PERMISSIONS=true

export PATH=$PATH:/app/oracle/instantclient_23_8
export ORACLE_BASE=/app/oracle/instantclient_23_8
export ORACLE_HOME=/app/oracle/instantclient_23_8
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/app/oracle/instantclient_23_8

When I test connect database with tool “sqlplus”, the connection is OK

When I configure the credentials in interface n8n and I want execute query sql I have this error

error NJS-518: cannot connect to Oracle Database. Service “PAYREC” is not registered with the listener at host 192.168.0.39 port 1521. (CONNECTION_ID=fyL4NVWMnEUgZBl0aDTj+A==) { “file”: “error-reporter.js”, “function”: “defaultReport” }

Information on your n8n setup

  • **n8n version: 1.100.1
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • **Running n8n via (npm):npm
  • **Operating system:Ubuntu 24.04

Can you help me ?

Thank a lot.

Jacques A.

2

Hi,

It’s OK for me, in interface credential, I had a error because I put the complete link database with Server/Instance instead on just Instance.

Thank you.