Connection Manager – Oracle Configuration

 

If you installed Ephesoft Transact with ORACLE Database, you can connect to it using SID or Service Name.

Oracle SID is the unique name that uniquely identifies your instance/database whereas Service name is the TNS alias that you give when you remotely connect to your database. This Service name is recorded in the Tnsnames.ora file on your client, and it can be the same as SID or you can also give it any other name as needed.

Previously, the Connection Manager UI contained only SID option for the ORACLE Connection Type.

In Ephesoft Transact v.4.5.0.0, the Connection Manager UI for ORACLE Connection Type has been changed to include two radio buttons: SID and Service Name.

By Default, SID button is set to TRUE, and the value set in the text box will append with Connection URL to form a connection URL as “jdbc:oracle:thin:@<host-name>:1521:<sid>”

If Service Name button is selected, then the value set in the text box will append with Connection URL to form a connection URL as “jdbc:oracle:thin:@<host-name>:1521/<service-name>”

 

IMPORTANT: Due to Oracle restrictions, the following parameters should be in UPPER CASE and have the same value:
• Database Name
• User Name

The following parameter should be the same case as it was saved for Oracle during Ephesoft Transact installation:
• SID / Service Name