2 Replies Latest reply: Oct 16, 2012 4:49 AM by 936666 RSS

    TimesTen Replication with Oracle Error  5056:

    936666
      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!