Striim 3.9.4 / 3.9.5 documentation

Configuring Oracle to host the metadata repository
  1. Copy the SQL script /opt/striim/conf/DefineMetadataReposOracle.sql to the Oracle host.

  2. Using sqlplus, log in to Oracle as an administrator and create the user Striim will use to create, write to, and read from the repository tables (replace ****** with a strong password):

    create user striimrepo identified by ******;
    grant connect, resource to striimrepo;
  3. Log out of sqlplus, log in again as the user you just created, and run the DefineMetadataReposOracle.sql script.