Memory Based Snapshot Worker 64 Bit Linux Failing with ORA-24010 (Doc ID 2330207.1)

Last updated on NOVEMBER 20, 2017

Applies to:

Symptoms

On : 12.2.7 version, Memory Based Planner

Memory Based Snapshot Worker 64 bit Linux Failing

This is a fresh install if 12.2.6 patched to 12.2.7. I had no issue collecting the data but when I go to run a plan I get an error on Memory Based Snapshot Worker 64 bit Linux.



ERROR
-----------------------
APP-FND-01564: ORACLE error 24010 in send_task_msg

Cause: send_task_msg failed due to ORA-24010: QUEUE APPS.IN_IPC does not exist
ORA-06512: at "APPS.MSC_CL_AQ_IPC", line 1576
ORA-06512: at line 1
.

The SQL statement being executed at the time of the error was: begin msc_cl_aq_ipc . send_task_msg ( :out_ipc_name , :in_ipc_name , : and was executed from the file .
APP-MRP-22075: An internal error has occurred (mrnspscm, 1000, 4294967295, SQL Error)
@ERRORTEXT Cause: The current routine encountered the specified@ERRORTEXT x Action: Contact your customer supportrepresentative.
APP-MRP-22075: An internal error has occurred (mrnspgmsg, 51, , )
@ERRORTEXT Cause: The current routine encountered the specified@ERRORTEXT x Action: Contact your customer supportrepresentative.
APP-MRP-22075: An internal error has occurred (main, 58, 0, )
@ERRORTEXT Cause: The current routine encountered the specified@ERRORTEXT x Action: Contact your customer supportrepresentative.
Error string=
Statement with the error:
begin msc_cl_aq_ipc . send_task_msg ( :out_ipc_name , :in_ipc_name , :


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run Plan

Cause