2.5 Initializing Metadata Store

Only Oracle user-managed services This topic applies only to Oracle user-managed services.

After installing GGSA, you need to configure the metadata store with the database admin credential details and the version of GGSA as required.
To initialize the metadata store, you need database admin credentials with sysdba privileges:
  1. Change directory to OSA-26.1.0.0.*/osa-base/bin.
  2. To set the proxy for the OSA, run the start script. For example, /start-osa.sh dbroot="SYS AS SYSDBA" dbroot_password="oracle" --proxy=http://<proxy-host>:<proxy-port>
  3. Enter password:
  4. Re-enter password:
  5. Run ./stop-osa.sh to complete schema creation and metadata initialization.
  6. If you don’t see the above messages, check the OSA-26.1.0.0.*/osa-base/logs folder to identify the cause and potential solution.

    Note:

    If you do not have the database admin credentials, ask your database administrator to create a GoldenGate Stream Analytics database user by using the SQL scripts available in the OSA-26.1.0.0.*/osa-base/sql folder. The GoldenGate Stream Analytics database username must match the one configured in osa-datasource.xml.