Oracle configuration in Connection Manager
If you install Transact with an Oracle database, you can connect to it using SID or Service Name.
Oracle SID is the unique name that 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 according to your requirements.
In Transact, the Connection Manager UI for Oracle Connection Type includes two radio buttons: SID and Service Name.
By default, SID button is set to TRUE, and the value set in the text box is appended to the Connection URL to form a connection URL as jdbc:oracle:thin:@<host-name>:1521:<sid>.
If the Service Name button is selected, then the value set in the text box is appended to the Connection URL to form a connection URL as jdbc:oracle:thin:@<host-name>:1521/<service-name>.
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 Transact installation:
- SID
- Service Name