Re: Export problem - so many synonyms.

I would go to /etc/system, open it in vi, and compare the values for semaphores and shared memory with those recommended by Oracle in the installation files on the CD and at technet.

Daniel Morgan

Ray Teale wrote:

> Hi All,
>
> I posted this question a while ago but didn't get any replies that I could
> see.
> It is still a problem for me so I'm posting again in the hope somebody can
> help.
>
> I was trying to do a full database export (Version 8.1.6.0.0 on Sun Sparc)
> of a fairly small database but got the following error message:
>
> . 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/aurora/rdbms/DbmsJavaSYS","joxlod: in ehe","ioc_allocate_pal")
> EXP-00000: Export terminated unsuccessfully
>
> .. after all the database users and tables had been exported, just at the
> time the system was ". exporting synonyms."
>
> Well I thought this was a bit strange for such a small database but I
> doubled the shared_pool_size, bounced the database and tried again. Same
> problem - it failed at the same spot.
> So I tried again - this time the shared pool was 15 times the original size
> but still the export failed at the same spot.
>
> So I checked the synonyms and found there are nearly 10000, most owned by
> PUBLIC and pointing to tables in SYS, and none created by me for my
> application.
> Couple of questions:
> 1. What are synonyms in the following format for (examples chosen at random
> below) and do I need them (there are lots) :
>
> SYNONYM_NAME TABLE_NAME
> ------------------------------ -----------------------------
> -
> /10076b23_OraCustomDatumClosur /10076b23_OraCustomDatumClosur
> /10322588_HandlerRegistryHelpe /10322588_HandlerRegistryHelpe
> /10739900_GenericURLDirContext /10739900_GenericURLDirContext
> /1079c94d_NumberConstantData /1079c94d_NumberConstantData
> java/security/KeyPairGenerator java/security/KeyPairGenerator
> java/security/MessageDigest java/security/MessageDigest
>
> 2. Would exporting synonyms really put that much of a strain on the shared
> pool? Why?
>
> OK .. so that was about four questions..
>
> Kindest Regards (and apologies for any formatting issues.)
>
> Ray Teale
Received on Sun Apr 14 2002 - 20:20:36 CDT