Before starting replication, the Oracle target database must be configured:
A user and schema must exist for each database from MySQL that you want to replicate. In addition, the schema used by the services within Tungsten Replicator must have an associated schema and user name.
For example, if you are replicating the database
sales to Oracle, the following
statements must be executed to create a suitable user. This can be
performed through any connection, including
sqlplus sys/oracle as sysdbaSQL>
passwordDEFAULT TABLESPACE DEMO QUOTA UNLIMITED ON DEMO;
The above assumes a suitable tablespace has been created
DEMO in this case).
A schema must also be created for each service replicating into
Oracle. For example, if the source schema is called
alpha, then the
must be created. The same command can be used:
CREATE USER tungsten_alpha IDENTIFIED BY password DEFAULT TABLESPACE DEMO QUOTA UNLIMITED ON DEMO;
One of the users used above must be configured so that it has the rights to connect to Oracle and has all rights so that it can execute statements on any schema:
GRANT CONNECT TO tungsten_alpha;SQL>
GRANT ALL PRIVILEGES TO tungsten_alpha;
The user/password combination selected will be required when configuring the slave replication service.