4 Replies Latest reply: Jul 13, 2011 12:51 PM by Samuel Rabini RSS

    Apply patchset 11.2.0.2 problem

    Samuel Rabini
      Hi,

      I'm upgrading my Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production to the 11.2.0.2 release.
      I followed the MOS Doc ID 1276368.1 guidline and everything go fine till the execution of @catupgrd.sql.

      after a lot of pl/sql executed correctly I start to receive

      ORA-00604: error occurred at recursive SQL level 2
      ORA-04031: unable to allocate 40 bytes of shared memory ("shared pool","select
      pos#,intcol#,col#,spa...","SQLA^c5417817","kggsmInitCompact:segVec")

      I got the same when I try to execute the @utlrp.sql script. Into the alert I have:

      Errors in file /u01/app/diag/rdbms/evodbtst/EVODBTST/trace/EVODBTST_j001_1621.trc (incident=9896):
      ORA-04031: unable to allocate 400 bytes of shared memory ("shared pool","ALTER VIEW "SYS"."KU$_10_2_F...","SQLA^86a64b41","opixpop:kctdef")
      Incident details in: /u01/app/diag/rdbms/evodbtst/EVODBTST/incident/incdir_9896/EVODBTST_j001_1621_i9896.trc
      Wed Jul 13 16:03:19 2011
      Errors in file /u01/app/diag/rdbms/evodbtst/EVODBTST/trace/EVODBTST_j000_1619.trc (incident=9888):
      ORA-04031: unable to allocate 96 bytes of shared memory ("shared pool","ALTER VIEW "SYS"."KU$_10_1_F...","SQLA^41ec9a10","kkdoac : qcsoicti")
      Incident details in: /u01/app/diag/rdbms/evodbtst/EVODBTST/incident/incdir_9888/EVODBTST_j000_1619_i9888.trc
      Wed Jul 13 16:03:19 2011
      Errors in file /u01/app/diag/rdbms/evodbtst/EVODBTST/trace/EVODBTST_j002_1623.trc (incident=9904):
      ORA-04031: unable to allocate 32 bytes of shared memory ("shared pool","select /*+ rule */ bucket_cn...","SQLA","tmp")
      Incident details in: /u01/app/diag/rdbms/evodbtst/EVODBTST/incident/incdir_9904/EVODBTST_j002_1623_i9904.trc
      Wed Jul 13 16:03:33 2011
      Errors in file /u01/app/diag/rdbms/evodbtst/EVODBTST/trace/EVODBTST_ora_1570.trc (incident=9832):
      ORA-04031: unable to allocate 32 bytes of shared memory ("shared pool","unknown object","JOXLP^95af5330","kglHeapInitialize:temp")
      Incident details in: /u01/app/diag/rdbms/evodbtst/EVODBTST/incident/incdir_9832/EVODBTST_ora_1570_i9832.trc
      Wed Jul 13 16:03:40 2011
      Errors in file /u01/app/diag/rdbms/evodbtst/EVODBTST/trace/EVODBTST_asmb_1544.trc (incident=9776):
      ORA-04031: unable to allocate 4120 bytes of shared memory ("shared pool","unknown object","sga heap(1,0)","ASM extent pointer array")
      Incident details in: /u01/app/diag/rdbms/evodbtst/EVODBTST/incident/incdir_9776/EVODBTST_asmb_1544_i9776.trc
      Use ADRCI or Support Workbench to package the incident.
      See Note 411.1 at My Oracle Support for error and packaging details.
      NOTE: ASMB terminating
      Errors in file /u01/app/diag/rdbms/evodbtst/EVODBTST/trace/EVODBTST_asmb_1544.trc:
      ORA-04031: unable to allocate 4120 bytes of shared memory ("shared pool","unknown object","sga heap(1,0)","ASM extent pointer array")
      Errors in file /u01/app/diag/rdbms/evodbtst/EVODBTST/trace/EVODBTST_asmb_1544.trc:
      ORA-04031: unable to allocate 4120 bytes of shared memory ("shared pool","unknown object","sga heap(1,0)","ASM extent pointer array")
      ASMB (ospid: 1544): terminating the instance due to error 4031
      Wed Jul 13 16:03:42 2011
      System state dump requested by (instance=1, osid=1544 (ASMB)), summary=[abnormal instance termination].
      System State dumped to trace file /u01/app/diag/rdbms/evodbtst/EVODBTST/trace/EVODBTST_diag_1524.trc
      Wed Jul 13 16:03:44 2011
      Errors in file /u01/app/diag/rdbms/evodbtst/EVODBTST/trace/EVODBTST_j002_1623.trc (incident=9905):
      ORA-04031: unable to allocate bytes of shared memory ("","","","")
      ORA-04031: unable to allocate 32 bytes of shared memory ("shared pool","select /*+ rule */ bucket_cn...","SQLA","tmp")
      Use ADRCI or Support Workbench to package the incident.
      See Note 411.1 at My Oracle Support for error and packaging details.
      Errors in file /u01/app/diag/rdbms/evodbtst/EVODBTST/trace/EVODBTST_j002_1623.trc (incident=9906):
      ORA-04031: unable to allocate bytes of shared memory ("","","","")
      ORA-04031: unable to allocate bytes of shared memory ("","","","")
      ORA-04031: unable to allocate 32 bytes of shared memory ("shared pool","select /*+ rule */ bucket_cn...","SQLA","tmp")
      Use ADRCI or Support Workbench to package the incident.
      See Note 411.1 at My Oracle Support for error and packaging details.
      Wed Jul 13 16:03:46 2011
      Use ADRCI or Support Workbench to package the incident.
      See Note 411.1 at My Oracle Support for error and packaging details.
      Errors in file /u01/app/diag/rdbms/evodbtst/EVODBTST/trace/EVODBTST_j002_1623.trc (incident=9907):
      ORA-04031: unable to allocate bytes of shared memory ("","","","")
      ORA-04031: unable to allocate bytes of shared memory ("","","","")
      ORA-04031: unable to allocate bytes of shared memory ("","","","")
      ORA-04031: unable to allocate 32 bytes of shared memory ("shared pool","select /*+ rule */ bucket_cn...","SQLA","tmp")
      Use ADRCI or Support Workbench to package the incident.
      See Note 411.1 at My Oracle Support for error and packaging details.
      Errors in file /u01/app/diag/rdbms/evodbtst/EVODBTST/trace/EVODBTST_j002_1623.trc (incident=9908):
      ORA-04031: unable to allocate bytes of shared memory ("","","","")
      ORA-04031: unable to allocate bytes of shared memory ("","","","")
      ORA-04031: unable to allocate bytes of shared memory ("","","","")
      ORA-04031: unable to allocate bytes of shared memory ("","","","")
      ORA-04031: unable to allocate 32 bytes of shared memory ("shared pool","select /*+ rule */ bucket_cn...","SQLA","tmp")
      Use ADRCI or Support Workbench to package the incident.
      See Note 411.1 at My Oracle Support for error and packaging details.
      Errors in file /u01/app/diag/rdbms/evodbtst/EVODBTST/incident/incdir_9904/EVODBTST_j002_1623_i9904.trc:
      ORA-04031: unable to allocate bytes of shared memory ("","","","")
      ORA-04031: unable to allocate bytes of shared memory ("","","","")
      ORA-04031: unable to allocate bytes of shared memory ("","","","")
      ORA-04031: unable to allocate bytes of shared memory ("","","","")
      ORA-04031: unable to allocate 32 bytes of shared memory ("shared pool","select /*+ rule */ bucket_cn...","SQLA","tmp")
      Use ADRCI or Support Workbench to package the incident.
      See Note 411.1 at My Oracle Support for error and packaging details.
      Dumping diagnostic data in directory=[cdmp_20110713160342], requested by (instance=1, osid=1544 (ASMB)), summary=[abnormal instance termination].
      Wed Jul 13 16:03:57 2011
      Use ADRCI or Support Workbench to package the incident.
      See Note 411.1 at My Oracle Support for error and packaging details.
      Wed Jul 13 16:03:58 2011
      Use ADRCI or Support Workbench to package the incident.
      See Note 411.1 at My Oracle Support for error and packaging details.
      Wed Jul 13 16:04:03 2011
      Instance terminated by ASMB, pid = 1544

      and the instance is shut down.

      How can I fix the values of sharedpool?
      Is there something else I've to to?

      Thanks in advance,
      Samuel