{1 - 24} GreyGrey
{25 - 49} GreenGreen
{50 - 499} BlueBlue
{500 - 4999} OrangeOrange
{5000 - 24999} RedRed
{25000+} BlackBlack

Please confirm that you would like to report this for an admin to review.


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



Confirm that you would like to Remove Email Alerts for your question. You cant undo this and you will not be able to re-subscribe.


Tags

No Answers

You must be Logged In to Answer this Question

Already a Member, Log In
Not a member yet? Sign Up

Categories

Sponsors


oracle forum