Is it possible to use Oracle Service Name instead of Oracle SID when connecting from ALM

  • KM00289101
  • 09-Jan-2013
  • 03-Mar-2014

Summary

This article clarifies if it is possible to use Oracle Service Name instead of SID when specifying database connection properties.

Question

Is it possible to use Oracle Service Name instead of Oracle SID when connecting from Application Lifecycle Management (ALM) server during the installation or when adding secondary DB server?

Answer

When connecting to a DB server from QC 10, ALM 11 and higher the SERVICE_NAME can be used instead of Oracle SID.

SERVICE_NAMES specifies one or more names for the database service to which this instance connects. You can specify multiple services names in order to distinguish among different uses of the same database. For example:

SERVICE_NAMES = sales.acme.com, widgetsales.acme.com