Issue Description:

If you are seeing the below error in the logs when Ephesoft is configured with Oracle database :

Caused by: java.sql.SQLException: Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor

 

What does above log suggest:

This error states that mentioned service name should be a valid service name in the database.It may be possible that you are using an incorrect Service Name or SID and the correct SID/ Service Name needs to be configured in the server.xml connection string as well.

 

Query to find service Name:

select value from v$parameter where name=’service_names’;

image002

 

In the above SID and service name are same as “testdb”

 

Update the server.xml

Update the connection string as below:

jdbc:oracle:thin:@//<<IP>>:<<PORT>>/<<ServiceName / SID>>

 

 

 

Was this article helpful to you?

Abhishek Jain