Configuration Service: Considerations

Consider the following guidelines before choosing to use the Configuration Service (ConfigService) in OGGCA:

• ConfigService is configured when adding deployments using OGGCA. See Select Service Manager Options.

• The Database and Fileset options both provide high availability with Oracle GoldenGate.

• If you choose to use the ConfigService, then you cannot revert to using conventional File Management system.

• If you select the Database option, then use the following guidelines:

  • The database used by the ConfigService can be in a Real Application Cluster and/or a primary database in a Data Guard environment.

  • The database backend only supports Oracle database.

  • You can query the backend table of the ConfigService, but you cannot modify it’s content.

  • The tablespace that contains the backend table must use a locally managed tablespace.

  • The backend table can be at a remote database.

  • As many Configuration Services from different deployments can use one and the same backend table, the configuration data can be centralized.