Technical data

Unable to alter a replication scheme
6-2 Oracle TimesTen In-Memory Database Troubleshooting Procedures Guide
Unable to alter a replication scheme
This section describes what to check if you are unable to use ALTER REPLICATION to
alter a replication scheme.
Unable to start or stop replication agent
This section describes what to check if you are unable to start or stop a replication
agent.
Replication tables defined in
the CREATE
REPLICATION statement
do not exist.
The name, owner, and column definitions of the tables
participating in the replication scheme must be identical on both
the master and subscriber data stores. Use CREATE TABLE to
create tables on the data store, or use the ttRepAdmin
-duplicate utility or the ttRepDuplicateEx C function to
duplicate the entire data store to be replicated.
Other problems Review the procedures and requirements described in "Defining
Replication Schemes" in the Oracle TimesTen In-Memory Database
TimesTen to TimesTen Replication Guide.
Possible cause What to do
You do not have ADMIN privilege You must have ADMIN privilege to use the ALTER
REPLICATION statement.
Replication agent in Start state Most ALTER REPLICATION operations are
supported only when the replication agent is
stopped (ttAdmin -repStop). Stop the replication
agents on both master and subscriber data stores,
alter the replication scheme on both master and
subscriber data stores, then restart both replication
agents.
Incorrect data store name, host name, or
element name
■ Check ALTER REPLICATION statement for
typographical errors.
■ See "Check host names" on page 6-7.
Replication table defined in the ALTER
REPLICATION statement does not exist
Use CREATE TABLE to create a table on the data
store.
Other problems Review the procedures and requirements described
in "Altering Replication" in the Oracle TimesTen
In-Memory Database TimesTen to TimesTen Replication
Guide.
Possible cause What to do
You do not have ADMIN privileges You must have ADMIN privileges to use the
ttAdmin utility or the ttRepStart or ttRepStop
procedures to start or stop a replication agent.
TimesTen daemon not started Check the state of the TimesTen daemon, as described
in "Check the TimesTen user error log" on page 2-2. If
necessary, start the TimesTen daemon as described in
"Working with the Oracle TimesTen Data Manager
Daemon" in the Oracle TimesTen In-Memory Database
Operations Guide.
Possible cause What to do