CAUAJM_E_18402 ORA-00942: table or view does not exist on autorep with Oracle Exadata

Document ID : KB000009225
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

After an Oracle Exadata Rollover, autorep fails with following error in the as_server logs:

 CAUAJM_E_18416 Event Server: Failed Query: <SELECT type,cond_job_name,cond_job_autoserv,operator,value,indx_ptr,test_glovalue,lookback_secs FROM ujo_job_cond WHERE joid=jobname  AND job_ver=1 AND over_num=-1 AND nvl(cond_job_name,' ')=nvl(cond_job_name,' ') AND cond_mode=1 order by indx ASC NULLS FIRST >

CAUAJM_E_18402 ORA-00942: table or view does not exist

CAUAJM_I_18403 Processing OCI function not used(4)

CAUAJM_E_18400 An error has occurred while interfacing with ORACLE. CAUAJM_E_18401 Function <doExecute> invoked from <execute> failed <879>

 

Restarting Application fixed the problem but the problem was back the next day.

There are not any problems on the Scheduler nor on the Application Server on the Shadow node. 

Environment:
WAAE 11.3.6 SP6 on Linux + Oracle Exadata
Resolution:

The recommended solution is to make sure to set the following options in your "tnsnames.ora" file:

 

(LOAD_BALANCE = yes)

(FAILOVER = on)

(FAILOVER_MODE = (TYPE=none))

(ENABLE = broken)