Install metabase dialog (Oracle) - Connect_CDC - aws_mainframe_modernization_service - connect_cdc_mimix_share - 6.x

Connect CDC Getting Started Guide

Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect CDC (MIMIX Share)
Version
6.x
Language
English
Product name
Connect CDC
Title
Connect CDC Getting Started Guide
Copyright
2024
First publish date
2003
Last updated
2024-10-15
Published on
2024-10-15T20:38:41.117981

The Install Metabase program prompts you for information to connect to your Oracle instance and, depending on the status of the metabase that it detects, lets you create or re-initialize or upgrade the metabase.

To install the metabase:

  1. Right-click the Oracle server, then, select Install Source Metabase or Install Target-only Metabase in the menu that displays, depending on your server’s intended usage.

    The Install Metabase wizard prompts you for user and tablespace information to prepare the metabase installation scripts.

  2. Provide the administrator and user ID password.
    Note: You must install an Oracle metabase using the sys user ID, which must have privileges to create a database. Using any user ID other than sys is not allowed.

    Use the Connect CDC Installation Guide for instructions on how to setup Oracle.

    The user ID value is used at the server to execute scripts that create, update, or remove the Connect CDC metabase. Some of the scripts are executed as a system administrator and some as the replication user (the user that is created to be the owner of the Connect CDC metabase objects).

  3. Click OK.

  4. Specify a tablespace in which to store the metabase. Based on how Oracle Database Storage is configured, File System or ASM, one of the following dialogs will display.

    File System

    • Specify a tablespace in which to store the metabase. Specify an existing tablespace, not the SYSTEM tablespace, or enter the name of a new tablespace to be created for you.

    • If you select a new tablespace, specify its size (default 20 MB) and the name of the data file (path optional) in which the metabase objects are to be stored.

    • If you select an existing tablespace, the displayed size and data file values are ignored.

    • You can specify a file path ASM

    • Specify an existing ASM Storage Group.

    • Enter the name of the tablespace and size.

    • Enter the name of the temporary tablespace and size.

  5. Click OK. The User ID and Password dialog displays for the replication user.

  6. Provide a user ID and password for the replication user. The replication user schema will contain the metabase objects.

    After the metabase is installed, the replication user and password are the database login ID and database password values associated with the updating statements that Connect CDC applies to a target table during data replication.

  7. Review the text displayed in the Install Source Metabase dialog to determine if you need to make any adjustments.

    The text in the dialog indicates:

    • Current status of the metabase at the server, if any, as detected by the Connect CDC Director

    • Sequence of operations about to be performed

    • ID under which the actions are performed.

  8. Review Metabase status and creation options for Oracle.

  9. Click OK to install the metabase.

    An output window displays a log of the SQL statements sent and any errors that occur. The contents of this window can be printed, saved, or copied.

    Upon successful installation, a confirmation message is displayed.

  10. Click OK.

    If the database login ID connection used to access this source was not the replication user, you are asked to select to have Install Source Metabase change the database login ID to the replication user.

  11. If this message displays, click Yes to complete the install.

  12. When complete, go to After the metabase is installed.