Connection tab

On the Connection tab, you specify the information for the connection to the Oracle database server:

  • Use existing TNS: Select the alias (Transparent Network Substrate) to access the repository database from the drop-down list. The alias points to a net service name of the configuration file tnsnames.ora that maps net service names to connect descriptors (destination for the network connection). If you configure the database connection manually, select the option Define manually.
  • Define manually: Select this option, if you configure the connection to the Oracle database server manually.
  • Server name: Specify the name of the computer, on which the Oracle service is running (only for TCP/IP connections).
  • Port number: Specify the port number that is used to access the Oracle service. The standard port number for TCP/IP connections is 1521.
  • Connection type: Select, whether the database works as a Dedicated Server or as a Shared Server. This setting relates to the administration of processes in which database queries are processed. Select Database default value to use the default setting for the database.
  • Protocol: Select the protocol that is used to establish the connection. By default TCP/IP is selected.
  • Service name: Specify the name of the Oracle service on your computer.
  • Service ID: Specify the service ID of the database. The service ID can be used instead of the Oracle service name.
Parent topic: Connection Settings for Oracle