topic Creating Oracle enterprise: ???failed to insert a value to the geodatabase system???, in Data Management Questions

Creating Oracle enterprise: ???failed to insert a value to the geodatabase system???,

Anonymous User — Fri, 11 Jan 2013 06:13:30 GMT

Original User: Jamal432@gmail.com

Creating Oracle enterprise: �??failed to insert a value to the geodatabase system�?�

As I�??m trying to �??create enterprise geodatabase�?� based on Oracle platform, I got the message below:

[ATTACH=CONFIG]20638[/ATTACH]

I�??ve installed the oracle database (Oracle_Database_11g_R2_64bits) of desktop class and client side (Oracle_Database_Instance_11g_R2_Client) on the same machine. The path in the environment system/variable system is provided with the path of the client instance.

[ATTACH=CONFIG]20639[/ATTACH]

What might be the reason?

Thank you for the answer

Best

Jamal

Re: Creating Oracle enterprise: �??failed to insert a value to the geodatabase system�?�,

Anonymous User — Fri, 11 Jan 2013 11:41:36 GMT

Original User: vangelo

Are you creating a number of user-schema geodatabases, using 10.1 SP1? I'm trying
to create a reproducible case of this, to submit it to Tech Support. If you can reproduce
this error, please contact Tech Support.

- V

Re: Creating Oracle enterprise: �??failed to insert a value to the geodatabase system�?�,

ForrestJones — Fri, 11 Jan 2013 14:57:05 GMT

Hi Jamal,

Is there any more information in the sde_setup.log mentioned in the create enterprise geodatabase output shown in your first attachment?

Re: Creating Oracle enterprise: �??failed to insert a value to the geodatabase system�?�,

Anonymous User — Fri, 11 Jan 2013 17:52:16 GMT

Original User: Jamal432@gmail.com

Hi Jamal,

Is there any more information in the sde_setup.log mentioned in the create enterprise geodatabase output shown in your first attachment?

Thank you Vince Fojo for the contribution.

What I did is formatting the machine. And now it is working perfect. Instead, I got the message below:

�??The ST_Geometry shape library path may be invalid, or the EXTPROC is not configured correctly in the Oracle instance. [ (Unable to determine current version of ST_SHAPELIB. The latest ST_GEOMETRY and dependent libraries need to be copied to the correct software location. Refer to the ArcGIS help topics for more details�?�

[ATTACH=CONFIG]20668[/ATTACH]

What might be the issue?
Best

Jamal

Re: Creating Oracle enterprise: �??failed to insert a value to the geodatabase system�?�,

ForrestJones — Fri, 11 Jan 2013 18:01:12 GMT

Hi Jamal,

It looks like the create enterprise geodatabase is now successful. What you are seeing is a warning about configuring the extproc to run sql against st_geometry objects.

See this web help topic for more information:

ArcGIS Documentation: Configuring the Oracle listener to use ST_Geometry and ST_Raster

Re: Creating Oracle enterprise: �??failed to insert a value to the geodatabase system�?�,

Anonymous User — Fri, 11 Jan 2013 18:47:54 GMT

Original User: Jamal432@gmail.com

Hi Jamal,

It looks like the create enterprise geodatabase is now successful. What you are seeing is a warning about configuring the extproc to run sql against st_geometry objects.

See this web help topic for more information:

ArcGIS Documentation: Configuring the Oracle listener to use ST_Geometry and ST_Raster

Thank you Fojo for the prompt answer.

I had a look on the valuable link that you have sent but couldn�??t figure out precisely the impact of such warning on the database and its behaviour

Best

Jamal