5 Replies Latest reply: Apr 12, 2013 4:29 AM by Chrisjenkins-Oracle RSS

    Automatically respawning cache agent after Oracle bounces

    chris_here
      Hello,

      I am using TimesTen 11.2.2.4.1 as a read-only cache for an Oracle 11.2.0.3 database under RedHat Linux 6.3 x86_64. The setup works fine at first.
      # ttAdmin -query ttcache
      RAM Residence Policy            : inUse
      Replication Agent Policy        : manual
      Replication Manually Started    : False
      Cache Agent Policy              : always
      Cache Agent Manually Started    : True
      What is very annoying is that if the Oracle database (located on another node) is restarted, the cache agents exits and doesn't restart after the DB is back up. Instead the cache restart policy resets itself to 'Manual'.
      # dbshut $ORACLE_HOME
      # dbstart $ORACLE_HOME
      # ttAdmin -query ttcache
      RAM Residence Policy            : inUse
      Replication Agent Policy        : manual
      Replication Manually Started    : False
      Cache Agent Policy              : manual
      Cache Agent Manually Started    : False
      The agent can be readily restarted manually but that's not what I want. I want it to be always on and to recover automatically.
      # ttadmin -cachepolicy always ttcache
      RAM Residence Policy            : inUse
      Replication Agent Policy        : manual
      Replication Manually Started    : False
      Cache Agent Policy              : always
      Cache Agent Manually Started    : True
      So the questions are: how can this be done? And why does it seem to be discussed nowhere (neither in the doc nor in the forums)? Isn't it a basic requirement for a database cache?

      Thanks for your insight,
      Chris