topic Re: ArcGIS 10.3 user geodatabase error in Developers Questions

ArcGIS 10.3 user geodatabase error

PranaviGaddipati — Wed, 17 Jun 2015 06:09:48 GMT

Hi,

we are using ArcGIS 10.3 and have SDE master geodatabase and one user geodatabase already.

However, when i am trying to create a second user geodatabase, I get the below error.

"Unable to start shared memory. If giomgr is up and running, shutdown and try again"

We have tried checking the database parameters for memory issues but could not find a cause.

Can someone please help on this. Thanks.

Re: ArcGIS 10.3 user geodatabase error

George_Thompson — Wed, 17 Jun 2015 12:00:30 GMT

Hi Pranavi,

I think that we will need a little more information in order to help.

I assume that you are using Oracle, correct? If so, what version of Oracle.

Could you copy/paste the last information from the sde_setup.log into the post?

Make sure you followed the directions for multiple geodatabases in Oracle.

-Did you close the ArcCatalog client and then try the Create Enterprise Geodatabase GP tool again?

Look forward to your responses.

-George

Geodatabase Enterprise GIS

Re: ArcGIS 10.3 user geodatabase error

PranaviGaddipati — Thu, 18 Jun 2015 01:32:32 GMT

Hi George,

We are using oracle 11.2.0.3 version. Both DB and client.

Also,

We have created other user geodatabases in the same DB few days back without any errors.

This is the 3rd user gdb we are trying to create and facing this issue.

The same information is written to the sde_setup.log. there are no extra errors. Below are the details.

........

[Wed Jun 17 14:39:14 2015] LOGFILE_POOL tables created...

[Wed Jun 17 14:39:14 2015] DBTUNE table being created...

[Wed Jun 17 14:39:14 2015] DBTUNE table created...

[Wed Jun 17 14:39:14 2015] SERVER_CONFIG tables being created...

[Wed Jun 17 14:39:14 2015] SERVER_CONFIG tables created...

[Wed Jun 17 14:39:14 2015] SDENUMTAB type being created...

[Wed Jun 17 14:39:14 2015] SDENUMTAB type created...

[Wed Jun 17 14:39:15 2015] DBMS stored procedures being created or updated...

[Wed Jun 17 14:39:18 2015] DBMS stored procedures created or updated...

[Wed Jun 17 14:39:18 2015] Unable to start up shared memory. Error: -51

If giomgr is up and running, shutdown and try again.

[Wed Jun 17 14:39:18 2015] SDE schema object install not completed.

[Wed Jun 17 14:39:18 2015] ERROR installing/upgrading ArcSDE, Error = -530

.......

Re: ArcGIS 10.3 user geodatabase error

AsrujitSengupta — Thu, 18 Jun 2015 01:55:53 GMT

Is the same error occurring on different desktop machines?

Have you created the tablespaces and granted permissions to the Schema Owner prior to running the 'Create Enterprise Geodatabase' tool?

Can you re-grant the below permissions and try again:

GRANT EXECUTE ON dbms_pipe TO public;

GRANT EXECUTE ON dbms_lock TO public;

GRANT EXECUTE ON dbms_lob TO public;

GRANT EXECUTE ON dbms_utility TO public;

GRANT EXECUTE ON dbms_sql TO public;

GRANT EXECUTE ON utl_raw TO public;

Also, just for testing, grant DBA to the Schema owner and then try. You can revoke this later.

Privileges for geodatabases in Oracle—Help | ArcGIS for Desktop

Re: ArcGIS 10.3 user geodatabase error

PranaviGaddipati — Thu, 18 Jun 2015 03:15:02 GMT

Hi,

All the other privileges are already there except DBA.

Grant DBA to <user_schema> worked.

Thanks a lot.