Blog

admin
Oct 15 th, 2012
Oracle DatabaseNo Comments

Oracle: ORA-12801: error signaled in parallel query server P002

Oracle Consultant needs help regarding “ORA-12801: error signaled in parallel query server P002″



Hi,

Its my first time here, I would really appreciate if you can help me in this problem found at my alert.log

Mon Oct 15 11:06:28 2012
DBMS_INDEX_UTL: Error executing ALTER INDEX “APPS”.”BIL_BI_PIPE_G_MV_N2″ REBUILD PARALLEL 2
DBMS_INDEX_UTL: Caused by ORA-12801: error signaled in parallel query server P002
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-01031: insufficient privileges
Mon Oct 15 11:06:28 2012
Errors in file /u02/PROD/db/tech_st/11.2.0.2/dbhome/admin/VMCLONE_vmclone/diag/rdbms/vmclone/VMCLONE/trace/VMCLONE_j000_20887.trc:
ORA-12012: error on auto execute of job “SYS”.”IDX_RB$ J_2122_1″
ORA-12801: error signaled in parallel query server P002
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-01031: insufficient privileges
ORA-06512: at “SYS.DBMS_I_INDEX_UTL”, line 1346
ORA-06512: at line 1

Thanks… :)


Consultant, needs help regarding ORA-12801: error signaled in parallel query server P002Help!

Oracle Discussion Forums : Thread List – Oracle Database

Be the first to post a comment.

Add a comment