Re: Unique Error comes during backup

From: Holger Baer <holger.baer_at_science-computing.de>
Date: Tue, 09 Mar 2004 16:50:55 +0100
Message-ID: <c2kp50$7rm$1@news.BelWue.DE>

BSena wrote:
> Hi
>

<snip>

>
> ORA-12012RA-06508: PL/SQL: could not find program unit being called:
> error on auto execute of job 9
>
> ORA-04031: unable to allocate 4096 bytes of shared memory ("shared
> pool","DECLARE job BINARY_INTEGER :...","PL/SQL MPCODE","BAMIMA: Bam
> Buffer")
>
>

It would be nice to know the version of Oracle but anyway... Seems like there are two errors worth investigating:

ORA-12571 and ORA-04031

Check Metalink, there is a note on how to detect and correct the reason for ORA-04031, which means basically that either your shared pool is plain to small, or your application is not using bind variables thus trashing the shared pool.

Most likely if you solve the ORA-04031, the ORA-12571 will go away.

HTH Holger Received on Tue Mar 09 2004 - 09:50:55 CST