Hi Cris
We created Timesten DSN without oracle cache and trying to create failover for Timesten databse.
Following are the steps taken while created failover or recover process
1)We create two DSN on timesten database
[STANDALONE_DSN]
Driver=/mtsapp1/onlytt/TimesTen/STANDALONE_TT/lib/libtten.so
DataStore=/mtsapp1/onlytt/STANDALONEDB_DATASTORE
LogDir=/mtsapp1/onlytt/STANALONEDB_LOGDIR
PermSize=8000
TempSize=500
PLSQL=1
DatabaseCharacterSet=WE8ISO8859P1
Connections=500
PassThrough=0
SQLQueryTimeout=250
LogBufMB=500
LogFileSize=500
LogPurge=1
[STANDBY_DSN]
Driver=/mtsapp1/onlytt/TimesTen/STANDALONE_TT/lib/libtten.so
DataStore=/mtsapp1/onlytt/STANDBYDB_DATASTORE/STANDBYDB_DATASTORE
LogDir=/mtsapp1/onlytt/STANDBY_LOGDIR
PermSize=8000
TempSize=500
PLSQL=1
DatabaseCharacterSet=WE8ISO8859P1
Connections=500
PassThrough=0
SQLQueryTimeout=250
LogBufMB=500
LogFileSize=500
LogPurge=1
2)Now connect to STANDALONE_DSN
ttisql "dsn=STANDALONE_DSN"
3)Now create one user ttuser with admin privillages on both DSN's
4)Create one table ON STANDALONE_DSN
5)Create STANDBY PAIR on standalone_dsn with the following command
create active standby pair STANDALONEDB_DATASTORE on "tcseibs", STANDBY_DATASTORE on "tcseibs" store STANDALONEDB_DATASTORE on "tcseibs" PORT 16080 store STANDBY_DATASTORE on "tcseibs" PORT 16081 ;
6)Start replication
call ttRepStart;
7)Now I try to duplicate the databse
ttRepAdmin -duplicate -from STANDALONE_DSN -host "tcseibs" -uid ttuser -pwd ttuser "dsn=STANDBY_DSN"
This command shows an error :-
TT12039: Could not get port number of TimesTen replication agent on remote host. Either the replication agent was not started, or it was just started and has not communicated its port number to the TimesTen daemon
Please find the output of the following command :-
1) ttrepadmin -showstatus STANDALONE_DSN
Replication Agent Status as of: 2015-12-10 11:45:20
DSN : STANDALONE_DSN
Process ID : 15262 (Started)
Replication Agent Policy : manual
Host : TCSEIBS
RepListener Port : 16080
Last write LSN : 0.18131208
Last LSN forced to disk : 0.18130944
Replication hold LSN : 0.17977752
Replication Peers:
Name : STANDBY_DATASTORE
Host : TCSEIBS
Port : 0 (Not Connected)
Replication State : STARTED
Communication Protocol : 38
TRANSMITTER thread(s):
For : STANDBY_DATASTORE (track 0)
Start/Restart count : 1
Send LSN : 0.17977752
Transactions sent : 0
Total packets sent : 0
Tick packets sent : 0
Total Packets received: 0
TXNs Allocated : 0
TXNs In Use : 0
ACTs Allocated : 0
ACTs In Use : 0
ACTs Data Allocated : 0
Most recent errors (max 5):
TT16025 in repagent.c (line 1227) at 11:44:43 on 12-10-2015
TT16285 in transmitter.c (line 1100) at 11:44:43 on 12-10-2015
TT16999 in transmitter.c (line 1427) at 11:44:43 on 12-10-2015
TT16032 in transmitter.c (line 1823) at 11:45:19 on 12-10-2015
2)ttRepAdmin -showconfig STANDALONE_DSN
Self host "TCSEIBS", port 16080, name "STANDALONEDB_DATASTORE", LSN 0/17977752, timeout 120, threshold 0
List of subscribers
-------------------
Peer name Host name Port State Proto Track
---------------- ------------------------ ------ ------- ----- -----
STANDBY_DATASTORE TCSEIBS 16081 Start 38 0
Last Msg Sent Last Msg Recv Latency TPS RecordsPS
------------- ------------- ------- ------- ---------
- - -1.00 -1 -1
List of objects and subscriptions
---------------------------------
Table details
-------------
Table : DOMTTORS.TAB Timestamp updates : -
Master Name Subscriber name
----------- ---------------
STANDBY_DATASTORE STANDALONEDB_DATASTORE
Table details
-------------
Table : DOMTTORS.TAB Timestamp updates : -
Master Name Subscriber name
----------- ---------------
STANDALONEDB_DATASTORE STANDBY_DATASTORE
Datastore details
-----------------
Master Name Subscriber name
----------- ---------------
STANDBY_DATASTORE STANDALONEDB_DATASTORE
Datastore details
-----------------
Master Name Subscriber name
----------- ---------------
STANDALONEDB_DATASTORE STANDBY_DATASTORE
Error relieved in error logs is
11:20:35.61 Warn: REP: 26674: [0x424d0940, 0, noAwt] STANDALONEDB_DATASTORE:repagent.c(1227): TT16025: Thread 'RECEIVER' (context 0x32cd860) starting
11:20:35.71 Err : : 16269: subd: Error identified in [sub.c: line 2396]
11:20:35.71 Err : : 16269: subd: (Error 8519): TT8519: Invalid PLSQL_MEMORY_ADDRESS specified -- file "db.c", lineno 10311, procedure "sbDbConnect"
11:20:35.71 Err : : 16269: -- file "db.c", lineno 10311, procedure "sbDbConnect"
11:20:35.71 Warn: : 16269: subd: connect trouble, rc 1, reason 8519
11:20:35.71 Err : : 16269: Err 8519: TT8519: Invalid PLSQL_MEMORY_ADDRESS specified -- file "db.c", lineno 10311, procedure "sbDbConnect"
11:20:35.71 Err : : 16265: TT14000: TimesTen daemon internal error: Could not send 'manage' request to subdaemon rc 400 err1 703 err2 8519
11:20:35.71 Warn: REP: 26674: [0x424d0940, -1, notKnown] STANDALONEDB_DATASTORE:receiver.c(3259): TT16999: stopRcvrThreads (track 0) set to 1
11:20:35.71 Warn: REP: 26674: [0x424d0940, 0, noAwt] STANDALONEDB_DATASTORE:receiver.c(3260): TT16060: Failed to read data from the network. select() timed out isAwt (false) parallelism (1) trackId (0) socket (15)
11:20:35.71 Err : : 16265: TT14000: TimesTen daemon internal error: Got notInRestore command for data store '/mtsapp1/onlytt/STANDBYDB_DATASTORE/STANDBYDB_DATASTORE', but not in flux for restore
11:20:35.72 Warn: REP: 26674: [0x424d0940, 0, noAwt] STANDALONEDB_DATASTORE:repagent.c(1276): TT16999: Receiver exiting isAwt (false)
11:20:36.71 Warn: : 16265: 16269 ------------------: subdaemon process exited
11:20:37.02 Err : REP: 26674: [0x406fa940, 0, noAwt] STANDALONEDB_DATASTORE:transmitter.c(1823): TT16032: Call to connect() failed. System Error: 111
11:20:39.02 Err : REP: 26674: [0x406fa940, 0, noAwt] STANDALONEDB_DATASTORE:transmitter.c(1823): TT16032: Call to connect() failed. System Error: 111
11:20:41.03 Err : REP: 26674: [0x406fa940, 0, noAwt] STANDALONEDB_DATASTORE:transmitter.c(1823): TT16032: Call to connect() failed. System Error: 111
11:20:43.03 Err : REP: 26674: [0x406fa940, 0, noAwt] STANDALONEDB_DATASTORE:transmitter.c(1823): TT16032: Call to connect() failed. System Error: 111
11:20:45.03 Err : REP: 26674: [0x406fa940, 0, noAwt] STANDALONEDB_DATASTORE:transmitter.c(1823): TT16032: Call to connect() failed. System Error: 111
11:20:47.03 Err : REP: 26674: [0x406fa940, 0, noAwt] STANDALONEDB_DATASTORE:transmitter.c(1823): TT16032: Call to connect() failed. System Error: 111
11:20:49.03 Err : REP: 26674: [0x406fa940, 0, noAwt] STANDALONEDB_DATASTORE:transmitter.c(1823): TT16032: Call to connect() failed. System Error: 111
11:20:51.04 Err : REP: 26674: [0x406fa940, 0, noAwt] STANDALONEDB_DATASTORE:transmitter.c(1823): TT16032: Call to connect() failed. System Error: 111
11:20:53.04 Err : REP: 26674: [0x406fa940, 0, noAwt] STANDALONEDB_DATASTORE:transmitter.c(1823): TT16032: Call to connect() failed. System Error: 111
11:20:55.04 Err : REP: 26674: [0x406fa940, 0, noAwt] STANDALONEDB_DATASTORE:transmitter.c(1823): TT16032: Call to connect() failed. System Error: 111
11:20:57.04 Err : REP: 26674: [0x406fa940, 0, noAwt] STANDALONEDB_DATASTORE:transmitter.c(1823): TT16032: Call to connect() failed. System Error: 111