AnsweredAssumed Answered

ArcGIS Server Cache Update Problems in Oracle RAC Environment

Question asked by mvolz47 on Sep 3, 2015
Latest reply on Sep 11, 2015 by mvolz47

My organization is moving from SDE data stored in an Oracle 11g RDMS to an Oracle 12c RAC (Real Application Clusters) RDBMS using TAF (Transparent Application Failover).  I have built a cache against the 11g Oracle SDE data which has worked for years.  I have now switched the data to an Oracle 12c database and I am getting the following types of errors when trying to build a new cached mapservice:

 

 

Data access failure, layer = Parcels, error string = Underlying DBMS error[ORA-25401: can not continue fetches

 

]

 

Failed to cache extent: 2420000.000977 137250.094482 2648922.311279 355805.450439 at scale 32000

 

Data access failure, layer = Parcels, error string = Underlying DBMS error[ORA-25401: can not continue fetches

 

]

 

I have already looked at the below article and our environment is in compliance with the Best Practices:

 

http://support.esri.com/en/knowledgebase/techarticles/detail/42292

 

Has anyone had any similar type AGS caching issues when using Oracle 12c RAC data with TAF?

 

I have many dynamic mapservices using the same Oracle 12c RAC database working for months now without any issues.

 

Any help or hints regarding this issue are greatly appreciated.

 

Outcomes