Oracle Database - Service name

> Database > Oracle Database

1 - About

service name is an identifier of a database service.

A database can be presented as multiple services and
A service can be implemented as multiple database instances.

The service name is specified by the SERVICE_NAMES initialization parameter.

The sid, the global database name and the service name are different but often one refer to an other in article.


3 - SID or Service Name

If the destination service is:

  • an Oracle8i or later release database, then use Service Name
  • an Oracle release 8.0 database, then use the SID

db/oracle/service_name.txt · Last modified: 2017/09/06 19:30 by gerardnico