I have stored procedure, which has parallel queries and hints. Frequently we are getting error details as below.
An error occurred executing the stored procedure. TM_6159 [4294965496] [ ORA-12801: error signaled in parallel query server P011, instance dbssd0011:proddb1 (1) ORA-08103: object no longer exists ORA-06512: at "PROD1.PKG_PTS", line 5068 ORA-06512: at line 2 Database driver error... Function Name : ExecuteSP Oracle Fatal Error Database driver error... Function Name : ExecuteSP Oracle Fatal Error]**
After rerun it got succeeded, we are getting this error frequently every alternate day. We are in Oracle 10g.
Please share your inputs on the same.
Regards, Shamsheer