Re: Unable to do a normal shutdown or Export

I've checked metalink and there seems to be several people with the same type of issue .

See note 146599.1

The basic thrust of the responses seem to be apply the most recent patches. upping J_P_S doesn't seem to help.

HTH "Tony Rees" <antonie.rees_at_btinternet.com> wrote in message news:b13bo6$l1b$1$8300dec7_at_news.demon.co.uk...
> I have attempted to increase the JAVA_POOL_SIZE parameter and also the
> shared_pool_size and will run the export once again and see how i get on.
Am
> not sure if this will help
>
> "Tony Rees" <tony_rees_at_stratexnet.com> wrote in message
> news:b12udq$g28$1$830fa7a5_at_news.demon.co.uk...
> > I wander if any one can help with this one. I have two Oracle instances
on
> a
> > Win2k server 816 (Report) and 817(DEV).
> >
> > Since I installed the second instance I am unable to do a full export
from
> > the 816 instance and also am unable to do a normal shutdown as it
results
> in
> > the following error.
> >
> > For the export the following error
> >
> > . . exporting table TOAD_PLAN_TABLE 4179 rows exported
> > . . exporting table TOAD_SECURITY 3 rows exported
> > . exporting referential integrity constraints
> > . exporting synonyms
> > EXP-00008: ORACLE error 4031 encountered
> > ORA-04031: unable to allocate 4032 bytes of shared memory ("shared
> > pool","oracle/jdbc/driver/OracleLogSYS","joxlod: in
> ehe","ioc_allocate_pal")
> > EXP-00000: Export terminated unsuccessfully
> >
> > In the Alert file I see the following
> >
> > Errors in file f:\oracle816\admin\REPORT\udump\ORA01208.TRC:
> > ORA-00604: error occurred at recursive SQL level 1
> > ORA-04031: unable to allocate 4032 bytes of shared memory ("shared
> > pool","unknown object","joxlod: in ehe","ioc_allocate_pal")
> > ORA-06512: at "SYS.DBMS_JAVA", line 0
> > ORA-06512: at line 2
> >
> > The init.ora file for both is very similar
> >
> > Errors in file f:\oracle816\admin\REPORT\udump\ORA01208.TRC:
> > ORA-00604: error occurred at recursive SQL level 1
> > ORA-04031: unable to allocate 4032 bytes of shared memory ("shared
> > pool","unknown object","joxlod: in ehe","ioc_allocate_pal")
> > ORA-06512: at "SYS.DBMS_JAVA", line 0
> > ORA-06512: at line 2
> >
> >
> >
> >
> >
>
>
Received on Mon Jan 27 2003 - 08:43:03 CST