This discussion is archived
2 Replies Latest reply: Oct 16, 2012 2:49 AM by 936666 RSS

TimesTen Replication with Oracle Error  5056:

936666 Newbie
Currently Being Moderated
Hi i facing problem in Replication

at ttisql (TimesTen) end

Command> call ttcacheStart;
Command> cachegroups;

Cache Group CACHEADMIN.myCACHE:

Cache Group Type: Asynchronous Writethrough (Dynamic)
Autorefresh: No
Aging: LRU on

Root Table: ORATT.MyTEST_REP
Table Type: Propagate

1 cache group found.

Command> call ttRepStart;

Command> LOAD CACHE GROUP CACHEADMIN.myCACHE COMMIT EVERY 10000 ROWS;

5056: The cache operation fails: error_type=<Oracle Error>, error_code=<12154>, error_message: ORA-12154: TNS:could not resolve the connect identifier specified

In SQLPLUS (Oracle) login i am have created the table

ORATT.MyTEST_REP;

SQL> SELECT Count(*) from ORATT.MyTEST_REP;

COUNT(*)
----------
0

In my TimesTen database DSN , under IMDB Cache i have specified Oracle Net Service Name as myDB (Oracle Database name.)


TNSname.ora
---------------

REPTT =(DESCRIPTION=(CONNECT_DATA = (SERVICE_NAME = REPTT)(SERVER = timesten_direct))) /*TimesTen */


myDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = myDB)
)
)
/*oracle */

Thanks!

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points