This discussion is archived
3 Replies Latest reply: Jul 19, 2013 6:57 AM by Tim Vincent RSS

Unable to create READONLY cache

user8610659 Newbie
Currently Being Moderated

Dear All,

 

 

We are trying to create a Readonly cache. Following are the details:

 

con1: Command> dssize

  PERM_ALLOCATED_SIZE:      307200
  PERM_IN_USE_SIZE:         9585
  PERM_IN_USE_HIGH_WATER:   9585
  TEMP_ALLOCATED_SIZE:      65536
  TEMP_IN_USE_SIZE:         10915
  TEMP_IN_USE_HIGH_WATER:   13728

 

 

con1: Command> cachegroups;

 

Cache Group CACHEADM.TEST:

  Cache Group Type: Read Only
  Autorefresh: Yes
  Autorefresh Mode: Incremental
  Autorefresh State: Paused
  Autorefresh Interval: 5 Seconds
  Autorefresh Status: ok
  Aging: No aging defined

  Root Table: HR.BIGDATA
  Table Type: Read Only

1 cache group found.

 

 

con1: Command> call ttgridstatus;

            < MYGRID1_alone1_1: member update phase 9 >

1 row found.

 

But when we try to LOAD the CACHE, we get following error:

 

con1: Command> LOAD CACHE GROUP test  COMMIT EVERY 256 ROWS;

5056: The cache operation fails: error_type=<Oracle Error>, error_code=<1740>,

error_message: ORA-01740: missing double quote in identifier

The command failed.

 

and again if if execute the above command we get

 

con1: Command> LOAD CACHE GROUP test  COMMIT EVERY 256 ROWS;

  799: Unable to connect to daemon; check daemon status

The command failed.

 

 

but the Daemon is Running..

 

 

Please help????

Legend

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