topic Migrate storage tool : insufficient memory error in Data Management Questions

Migrate storage tool : insufficient memory error

SrijanaTuladhar — Mon, 07 Apr 2014 14:23:30 GMT

Hi,
We're having a shared memory issue while using 'Migrate storage' tool. We recently migrated from SDE 9.3 to 10.2.1 and Oracle 10g to 11gR2. Everything else work fine but we get this error only when we use 'Migrate Storage' tool. We're trying to migrate 9.3 ESRI Binary spatial type to ST_Geometry.

ORA-12853: insufficient memory for PX buffers: current 229936K, max needed 16879104K
ORA-0431:unable to allocate 65560 bytes of shared memory (�??large pool�?�, unknown object�?�, �??large pool�?�, �??PX msg pool�?�)

Have anyone experienced this? Thank for your help in advance.

Re: Migrate storage tool : insufficient memory error

WilliamCraft — Mon, 07 Apr 2014 14:38:32 GMT

It sounds like your database needs more resources allocated to the SGA in order to perform the operation. You can reconfigure your Oracle database's SGA to include at least (max - current) bytes of additional memory. Try making the MAX SIZE and TARGET values the same:

create pfile from spfile (must be done as sys user)
ALTER SYSTEM SET sga_max_size=16879104K scope=spfile;
ALTER SYSTEM SET sga_target=16879104K scope=spfile;
SHUTDOWN IMMEDIATE
STARTUP
show parameter sga_max_size
show parameter sga_target

If the database starts up without issue, then:
create pfile from spfile

If it does not come start up, then perform these steps:
SHUTDOWN IMMEDIATE
startup pfile=<path to pfile>
Alter SGA to whatever values were configured from your old settings (229936K) with scope=spfile
SHUTDOWN IMMEDIATE
STARTUP (which should start from spfile)

If the database starts correctly, then:
create pfile from spfile

Re: Migrate storage tool : insufficient memory error

VinceAngelo — Mon, 07 Apr 2014 15:25:45 GMT

Not everyone has the RAM necessary to allocate 16+Gb to the SGA. If you have some
seriously massive geometries that exceed the ability to migrate in situ, you may need
to export the troublesome table(s), truncate them, then migrate the empty template
and append the export file contents.

This of course assumes the table is a simple feature class (not versioned, not using
geodatabase behaviors,...). If it isn't simple, migration should still be possible, but
it will be more involved.

- V

Re: Migrate storage tool : insufficient memory error

SrijanaTuladhar — Mon, 07 Apr 2014 15:40:25 GMT

Vince,
You are right, I don't think we can allocate 16GB of RAM.

We get this error everytime we use this tool for almost all the feature classes regardless of it's size. We have been doing a work around as you mentioned, copying and pasting the data to migrate the storage type but it is not feasible for the datasets that are versioned and have archiving enabled. Do you know if it's is a bug with Migrate Storage tool? Why is it consuming so much memory resources? Thanks in advance.

Re: Migrate storage tool : insufficient memory error

VinceAngelo — Mon, 07 Apr 2014 16:13:09 GMT

First off, try making the SGA as large as you can (if 256Mb is the best you can do,
the host is unsuitable for 11g use), then try to migrate again.

I doubt this is a bug with the migrate utility, but it could have something to do
with the data, or with the way the utility is being used. Tech Support could help
you there.

- V