How to check the service name / SID in Oracle

Revision 1 — March 18, 2020

Issue

The following error may occur in the logs when Ephesoft Transact is configured with Oracle:

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

This error states that the mentioned service name cannot be found in the database. You may be using an incorrect Service Name or SID, and you will need to configure the correct SID/ Service Name in the server.xml connection string.

Query to Find Service Name

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

image002

Figure 1. Query to Find Service Name

The service name will display in the Query Result section. In the example above, the SID and service name are both “testdb”.

Update the server.xml

Update the connection string as below:

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