How to configure an Oracle data source?
I want SQLMessenger to connect to an Oracle database. How should I configure it? Specifically, how should I fill in the Oracle TNS parameter?
You can fill in the Oracle TNS in one of the following formats:
Format 1: IP Address or Hostname:Port:Service Name. For example, 192.168.1.180:1521:orcl
Format 2: IP Address or Hostname:Port/Service Name. For example, 192.168.1.180:1521/orcl
After filling it out, click Test to verify the configuration. Once the test is successful, click OK to save the configuration.
Related documentation: SQLMessenger User Manual - Data Source Management