How to Check the Service Name and SID in Oracle
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';
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>>