Striim 4.0.4 documentation

... when hosted on Oracle

Set the following properties:

MetadataDb=oracle
MetaDataRepositoryLocation=<connection URL>
MetaDataRepositoryDBname=striimrepo
MetaDataRepositoryUname=striimrepo

If you use an SID, the connection URL has the format jdbc:oracle:thin:@<IP address>:<port>:<SID>, for example, jdbc:oracle:thin:@192.0.2.0:1521:orcl. If you use a service name, it has the format jdbc:oracle:thin:@<IP address>:<port>/<service name>, for example, jdbc:oracle:thin:@192.0.2.01521:/orcl. I

In a high availability active-standby or RAC environment, specify all servers, for example, MetaDataRepositoryLocation=jdbc:oracle:thin:@(DESCRIPTION_LIST=(LOAD_BALANCE=off)(FAILOVER=on)(DESCRIPTION= (CONNECT_TIMEOUT=5)(TRANSPORT_CONNECT_TIMEOUT=3)(RETRY_COUNT=3)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST= 192.0.2.100)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=racdb.localdomain)))(DESCRIPTION= (CONNECT_TIMEOUT=5)(TRANSPORT_CONNECT_TIMEOUT=3)(RETRY_COUNT=3)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST= 192.0.2.101)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=racdb.localdomain)))) (see Features Specific to JDBC Thin for more information.)

When the connection uses SSL, the connection URL has the format:

MetaDataRepositoryLocation=jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)
(HOST=<IP address>)(PORT=<port>))(CONNECT_DATA=(SERVICE_NAME=<service name>)))
  • For SSL with a PKCS12 keystore, copy the ewallet.p12 file to the Striim server's local environment and set the following properties:

    OracleMDRTrustStoreType=PKCS12
    OracleMDRTrustStore=<path>/ewallet.p12
  • For SSL with an SSO keystore, copy the cwallet.ss0 file to the Striim server's local environment and set the following properties:

    OracleMDRTrustStoreType=SSO
    OracleMDRTrustStore=<path>/cwallet.sso