Specifying a custom URL for an Oracle JDBC connection v7

Note

This option applies only to the publication server.

By default, Replication Server supports the basic thin-client URL pattern for an Oracle JDBC connection. If you need to specify custom connectivity credentials, specify the advanced URL using the following option.

oraJDBCCustomURL=customURL_string

The following is an example of custom connectivity to an Oracle database.

oraJDBCCustomURL=jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=$HOST)(PORT=$PORT))(CONNECT_DATA=(SERVICE_NAME =$SERVICE_NAME)(SERVER=DEDICATED)))

The parameters prefixed with a dollar sign ($) are dynamically replaced based on the actual connection values specified when adding the Oracle publication database (see Adding a publication database). Alternatively, you can replace the parameters prefixed with a dollar sign with hardcoded values in the URL string, in which case these hardcoded values override what is specified when adding the publication database.