Download TimesTen Troubleshooting Guide

Transcript
Replication does not work
Daemon pid 3396 port 15000 instance MYINSTANCE
TimesTen server pid 3436 started on port 15002
----------------------------------------------------------------Data store c:\temp\subscriberds
There are no connections to the data store
cache agent restart policy: manual
----------------------------------------------------------------Data store c:\temp\masterds
There are no connections to the data store
cache agent restart policy: manual
----------------------------------------------------------------End of report
Example 4–3 TimesTen daemon and replication agent are not running
> ttStatus
ttStatus: Could not connect to TimesTen daemon: Connection refused
Check that replication agents are communicating
Use ttRepAdmin -receiver -list to see that the replication agents are communicating
with each other. If the masterds database is replicating to subscriberds, the output
should look similar to the following:
Example 4–4 Check that the replication agents are communicating
> ttRepAdmin -receiver -list masterDSN
Peer name
Host name
Port
---------------- ------------------------ -----SUBSCRIBERDS
MYHOST
Auto
State Proto
------- ----Start
10
Last Msg Sent Last Msg Recv Latency TPS
RecordsPS Logs
------------- ------------- ------- ------- --------- ---0:01:12
19.41
5
52
2
Check replication state
Use the ttReplicationStatus procedure to check the state of the subscriber database
with respect to its master. If the subscriber is in the Stop, Pause, or Failed state, use
the ttReplicationStatus procedure to reset the subscriber state to Start, as described
in "Setting the replication state of subscribers" in the Oracle TimesTen In-Memory
Database Replication Guide.
Example 4–5 Obtain status of the subscriber database from the master database
Use ttReplicationStatus to obtain the status of the subscriberds database from its
master database, masterDSN, enter:
> ttIsql masterDSN
Command> CALL ttReplicationStatus ('subscriberds');
< SUBSCRIBERDS, MYHOST, 0, pause, 1, 10, REPSCHEME, REPL >
1 row found.
To reset state to Start call the ttRepSubscriberStateSet procedure:
Command> CALL ttRepSubscriberStateSet('REPSCHEME', 'REPL', 'SUBSCRIBERDS',
'MYHOST', 0)
Command> CALL ttReplicationStatus ('subscriberds');
< SUBSCRIBERDS, MYHOST, 0, start, 1, 152959, REPSCHEME, REPL >
1 row found.
Troubleshooting Replication
4-5