...
- Basic Connection. Requires the name or IP of the host system for Oracle database, the port number and the service name. If the port number is 0, the default port 1521 will be is used.
- TNS Identifier. Requires a connect identifier that exists in the Oracle tnsnames.ora. You cannot use this type of connection to establish a connection to a remote Oracle database. The file tnsnames.ora must exist on the local system.
- Easy Connect. Requires an easy-connect string for the Oracle database. The format of the easy-connect string is
username/password@[//]host[:port][/service_name]. Because the username and password are already included in the easy-connect string, the credentials specified at the top section of the Add Connection form are ignored when the easy-connect option is selected. - Service Descriptor. Requires a connect descriptor in the format:
...
The Test Connection link allows you to verify whether the settings are correct and the connection to Oracle database can be established. You can add Oracle connection to the workspace by clicking OK.