Issues in connection with Oracle DB

Article Overview:

This article will cover how you can achieve the following:

This article will describe various ways of troubleshooting the issue with Oracle DB 

Problem Statement:

Getting the below error response in Swagger when connecting the Oracle DB
{"error": "A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)","data":""}

Solution:

1. Check if the config file is as below-

{
 "Logging": {
   "LogLevel": {
     "Default": "Information",
     "Microsoft.AspNetCore": "Warning"
   }
 },

 "Urls": "http://10.18.0.5:5001",
 "AllowedHosts": "*",
 "SQLAPIConfig": {
   "Connector": "ORACLE",
   "ConnectionString": "Data Source=192.168.1.157:1521/XE;User Id=system;Password=awesome123;"
 }
}

2. Additionally, check the tnsnames.ora file from the path $ORACLE_HOME/database/network/admin/tnsnames.ora?

If neither solution works, please contact support.