topic Re: Upgrading ArcSDE 10 installation to sp2 in Data Management Questions

Upgrading ArcSDE 10 installation to sp2

HugoAhlenius — Sat, 11 Dec 2021 17:32:05 GMT

I am trying to upgrade a SQL Server 2005 setup, on 32-bit Windows Server 2003, to ArcSDE 10 sp2 - but it won't start after the service pack is applied!

All I get is:

esri_sde service failed during initialization.
Please check event log or error log files.
Error starting esri_sde service(0)
Could not start ArcSDE -- Check Network, $SDEHOME disk, DBMS settings and dbinit
.sde.

And the log file says:

-------------------------------------------------------
ArcSDE 10.0  for SQL Server Build 1343 Thu Feb 17 11:45:42  2011
-------------------------------------------------------
Connected to instance . . .
WARNING: SDETMP: Setting temp path to c:\temp
ERROR in checking system stored procedures (1).
Run the Upgrade Geodatabase tool to install/upgrade system tables.
Refer ArcSDE installation guide for instructions.

I have tried to rebuild the service, but that doesn't help. giomgr_esri_sde.log doesn't contain anything useful.

Re: Upgrading ArcSDE 10 installation to sp2

HugoAhlenius — Wed, 08 Jun 2011 11:26:22 GMT

Any tips/ideas are welcome!

Re: Upgrading ArcSDE 10 installation to sp2

VinceAngelo — Wed, 08 Jun 2011 11:43:01 GMT

Starting with ArcSDE 10.0, all upgrades which involve ArcSDE instances with geodatabase functionality
must be done from an ArcGIS client (Python or ArcCatalog GUI). The documentation covers upgrade
procedures.

- V

Re: Upgrading ArcSDE 10 installation to sp2

HugoAhlenius — Wed, 08 Jun 2011 11:46:51 GMT

Thanks - I just figured it out... I kind of assumed that the service needed to be running to perform the upgrade (I didn't remember from the sp1 routine, which I assume was the same).

So I did a Direct Connection from another machine, in ArcCatalog, and run the upgrade database tool, and now things seem to work the way they should!

Re: Upgrading ArcSDE 10 installation to sp2

VinceAngelo — Wed, 08 Jun 2011 12:17:18 GMT

Yes, realizing that Direct Connect is required is the key to unravel the chicken-egg
conundrum of an ArcGIS upgrade of an application server before it can be started.

- V

Re: Upgrading ArcSDE 10 installation to sp2

HugoAhlenius — Wed, 08 Jun 2011 12:19:58 GMT

Vince, it would be handy if the error message on the server (when trying to start the service) was more useful (pointing me in the right direction), as well as the download page for the service pack - the latter could have mentioned the direct connect, for instance.

Re: Upgrading ArcSDE 10 installation to sp2

HugoAhlenius — Wed, 08 Jun 2011 12:20:31 GMT

Re: Upgrading ArcSDE 10 installation to sp2

VinceAngelo — Wed, 08 Jun 2011 12:36:47 GMT

The error does refer you to the documentation, which does state that Direct Connect
is necessary... You are certainly free to contact Tech Support or use the Ideas page
to recommend a change. I'm not sure how a recommendation to circumvent reading
the upgrade documentation would be received.

- V

Re: Upgrading ArcSDE 10 installation to sp2

JohnLovato — Thu, 15 Jan 2015 17:07:29 GMT

After upgrading from my enterprise geodatabase from 10.1 SP1 to 10.2.2 Patch 290200 I cannot start the new 10.2 application server.

I am running application server as "root" not "sde" Linux user...

In ArcCatalog, the "General" tab "Upgrade Status" section says:

"This 10.2.2 Patch 290200 geodatabase matches the ArcGIS release you are currently using.

When trying to start the 10.2 Application Server in Linux I get:

-------------------------------------------------------

10.2.2 geodatabase

-------------------------------------------------------

ST_Geometry Schema Owner: (SDE) Type Release: 1007

Instance initialized for ((sde)) . . .

Connected to instance . . .

C:\Users\TEMP\AppData\Local\Temp\arcC63F\: No such file or directory

WARNING: SDETMP: Setting temp path to /tmp

ERROR in checking system stored procedures (1).

Run the Upgrade Geodatabase tool to install/upgrade system tables.

Refer to the ArcGIS help topics for instructions.

ERROR in checking system stored procedures (1).

Run the Upgrade Geodatabase tool Could not start ArcSDE -- Check Network, $SDEHOME disk, DBMS settings and dbinit.sde.

How can I get my application server to start up? Any help you could provide would be appreciated.

Thank you.

Re: Upgrading ArcSDE 10 installation to sp2

JohnLovato — Thu, 15 Jan 2015 19:57:56 GMT

UPDATE: I have created an sde account and still get the same result when trying to use sdemon to start the application server. Please advise...

Re: Upgrading ArcSDE 10 installation to sp2

VinceAngelo — Thu, 15 Jan 2015 20:38:34 GMT

It's not recommended to run any application server daemon as root, ever (except for software which immediately uses setuid() to reduce privilege at startup, like Apache). The Oracle ArcSDE application server is designed to run *only* as the owner of the $SDEHOME directory (which should not be root).

It's possible to get into a tangle where ArcGIS Desktop/Server is convinced an upgrade isn't necessary, but the application server has a different opinion (and is usually right). Contacting Tech Support is the best way through this particular twisty maze.

- V

Re: Upgrading ArcSDE 10 installation to sp2

JohnLovato — Thu, 15 Jan 2015 20:40:30 GMT

Thank you sir. Putting in a support ticket now.