Appart from the bug why don't you frist try with a
shared_pool_reserved_size to a 15 or 25% if it isn't
enough ?. For instance there is another bug: 1397603.
However and just as a workaround try with the reserved
size thing.
Regards.
- "Toepke, Kevin M" <ktoepke_at_cms.cendant.com> wrote:
> John:
>
> This is bug #1640583.
>
> Kevin
>
> -----Original Message-----
> Sent: Wednesday, July 11, 2001 8:54 AM
> To: 'ORACLE-L_at_fatcity.com'
> Cc: Toepke, Kevin M
>
>
> Kevin
>
> Thanks...it that documented anywhere?
>
> John
>
> > -----Original Message-----
> > From: Toepke, Kevin M
> [SMTP:ktoepke_at_cms.cendant.com]
> > Sent: 11 July 2001 14:06
> > To: Multiple recipients of list ORACLE-L
> > Subject: RE: unable to allocate 4096 bytes of
> shared memory -
> > HELP!!!!
> >
> > That is a bug. You have to apply, I believe, the
> 8.1.7.3 patchset.
> >
> > -----Original Message-----
> > Sent: Wednesday, July 11, 2001 7:41 AM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > We have just upgraded from 8.0.5 to 8.1.7 and are
> getting problems as
> > follows :
> >
> > It appears to be related to dbms_job
> >
> > Can any one help?
> >
> > John
> >
> > Errors in file
>
/u01/app/oracle/admin/PRTGH1/bdump/snp2_28976_prtgh1.trc:
> > ORA-12012: error on auto execute of job 11223917
> >
> > ORA-04031: unable to allocate 4096 bytes of shared
> memory ("shared
> > pool","SERVER
> > _PRINTER_RESET","PL/SQL MPCODE","BAMIMA: Bam
> Buffer")
> > ORA-06508: PL/SQL: could not find program unit
> being called
> > ORA-06512: at line 1
> > Sun Jul 8 23:52:14 2001
> > Errors in file
>
/u01/app/oracle/admin/PRTGH1/bdump/snp1_19492_prtgh1.trc:
> >
> > ORA-12012: error on auto execute of job 11227622
> > ORA-04031: unable to allocate 4096 bytes of shared
> memory ("shared
> > pool","SERVER
> > _RECEPTION","PL/SQL MPCODE","BAMIMA: Bam Buffer")
> > ORA-06508: PL/SQL: could not find program unit
> being called
> > ORA-06512: at line 1
> >
> > --
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> > --
> > Author: John Dunn
> > INET: john.dunn_at_sefas.co.uk
> >
> > Fat City Network Services -- (858) 538-5051
> FAX: (858) 538-5051
> > San Diego, California -- Public Internet
> access / Mailing Lists
> >
>
> > To REMOVE yourself from this mailing list, send an
> E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB
> ORACLE-L
> > (or the name of mailing list you want to be
> removed from). You may
> > also send the HELP command for other information
> (like subscribing).
> > --
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> > --
> > Author: Toepke, Kevin M
> > INET: ktoepke_at_cms.cendant.com
> >
> > Fat City Network Services -- (858) 538-5051
> FAX: (858) 538-5051
> > San Diego, California -- Public Internet
> access / Mailing Lists
> >
>
> > To REMOVE yourself from this mailing list, send an
> E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB
> ORACLE-L
> > (or the name of mailing list you want to be
> removed from). You may
> > also send the HELP command for other information
> (like subscribing).
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Toepke, Kevin M
> INET: ktoepke_at_cms.cendant.com
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
Eng. Christian Trassens
Senior DBA
Systems Engineer
ctrassens_at_yahoo.com
ctrassens_at_hotmail.com
Phone : 541149816062
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Christian Trassens
INET: ctrassens_at_yahoo.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Wed Jul 11 2001 - 09:19:31 CDT
