Configuring Oracle for Streaming Components

If you intend to use Oracle to store the metadata for Streams Messaging Manager or Schema Registry, you must configure the Oracle database.

After you install Oracle, configure the database to store:

Schema Registry data such as the schemas and their metadata, all the versions and branches.
SMM data such as Kafka metadata, stores metrics, and alert definitions.

For setting the relevant tablespaces for the SMM and Schema Registry, see Creating the relevant schema DBs.

The new user needs to have permissions to create or drop tables and other database structures because when the Schema Registry or SMM service starts, it automatically creates the database structure. If the database structure already exists, then the service alters it as necessary.