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