3 Replies Latest reply: May 26, 2011 3:50 AM by Karan Kukreja RSS

    Ora-12801,Ora-00018,Ora-06512 encountered running utlrp.sql

    Karan Kukreja
      Hi All ,

      I am on oracle version 11.1.0.7.0 and OS is solaris SPARC.

      I am applying the CPU April 2011 patch..

      I ran the catbundle.sql file and post that , most of views under sys schema got invalid.

      So i ran @$ORACLE_HOME/cpu/view_recompile/recompile_precheck_jan2008cpu.sql
      and
      @$ORACLE_HOME/cpu/view_recompile/view_recompile_jan2008cpu.sql

      Inspite of this they were invalid.

      So i tried running utlrp.sql query and I facing these errors while running the query :
      ERROR at line 1:
      ORA-12801: error signaled in parallel query server P051
      ORA-00018: maximum number of sessions exceeded
      ORA-06512: at "SYS.UTL_RECOMP", line 760
      ORA-06512: at line 4
      I increased the number of processes.. but still I am facing this error... I am searching on metalink also..

      Any help would be appreciated..

      Regards
      Kk