Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Unable to do a normal shutdown or Export
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 - 07:22:33 CST