topic Re: Error: Starting Multiple Geodatabase Instances in Data Management Questions

Error: Starting Multiple Geodatabase Instances

SathiaG — Thu, 29 Jul 2010 14:46:38 GMT

Hi,

We are using multiple Geodatabase instance running on seperate Oracle databases on single machine. [ArcSDE 9.3.1, Oracle 10gR2]

We are using it sucessfully over a month now. The thing we have done from where it all went wrong is, Instead of stopping the services from back end (CMD) by giving proper path of the SDE home, we have stopped through services.msc window [very unfortunate 😞 ]. Which actually resulted in the error.

We are trying now to start it properly through CMD by giving the SDE home path. But it is very stubborn in rejecting the same. And it is giving the following errors,

For Instance 1 : ================================================

C:\Documents and Settings\145986>sdemon -o start -H "C:\Program Files\ArcGIS\ArcSDE\ora10gexe
Please enter ArcSDE DBA password:
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. "

For Instance 2 : ================================================

C:\>sdemon -o start -H "C:\Program Files\ArcGIS\ArcSDE\ora10gexe_GAPD"
Please enter ArcSDE DBA password:
esri_sde_gapd service failed during initialization.
Please check event log or error log files.
Error starting esri_sde_gapd service(0)
Could not start ArcSDE -- Check Network, $SDEHOME disk, DBMS settings and dbinit.sde.

And the SDE log file is giving me these....

Thu Jul 29 20:22:36 2010 - ****** Spatial Database I/O Manager ******
Thu Jul 29 20:22:36 2010 - SDE System Startup Initiated . . .
Thu Jul 29 20:22:36 2010 - Validated System Paths.
Thu Jul 29 20:22:36 2010 - SDE IOMGR going into background . . .
Thu Jul 29 20:22:41 2010 - System Parameter table 'SERVER_CONFIG' Read.
Thu Jul 29 20:22:52 2010 - Initialized Shared Memory Segment.
Thu Jul 29 20:22:52 2010 - Validated License.
Thu Jul 29 20:22:52 2010 - IOMGR Process ID (PID): 1400
Thu Jul 29 20:22:52 2010 - Initialized Client Tables.
Thu Jul 29 20:22:52 2010 - Server Validated.

Where the problem lies? How shall we get this on track again? Any idea? Any Clue? Any small idea could strike a spark out. Kindly help us.

Cheers !

-Sathia & Tilak

Re: Error: Starting Multiple Geodatabase Instances

SathiaG — Wed, 11 Aug 2010 08:53:11 GMT

Hi Gyz..

Seems like ppl are clueless against this..

Well, we too.. So we kindaa followed the other way around.. We dropped the DB & created a new one.. Now we have One Oracle instance & Multiple GDB instances inside it..

& by the way we dint forget to write a big sticky notes in the server monitor panel "NEVER STOP SDE SERVICE FROM FRONT END"

Cheers ppl ! 🙂

Re: Error: Starting Multiple Geodatabase Instances

VinceAngelo — Wed, 11 Aug 2010 12:52:31 GMT

I run multiple ArcSDE instances all the time. On Windows hosts you just have to correctly
configure the services so that they use the appropriate SDEHOME ('sdemon' just starts the
service, so if your service is misconfigured, a '-H' flag won't help). The easiest way to
do this is to:
1) Open a new CMD window
2) Set the SDEHOME variable (preferably to a path without any spaces)
3) Set the PATH variable to prepend %SDEHOME%\bin
4) Use 'sdeservice -o create' to create the service
5) [For non-Oracle installs] Use 'sdeservice -o modify' to set the Admin_database variable
to the database name
6) [For remote installs] You may need to edit the dbinit.sde to use the appropriate
connection variables (e.g., LOCAL instead ot ORACLE_SID)

Given that you want services to start after reboot, you should *always* use Windows services
to start and stop ArcSDE on Windows hosts. If it doesn't work for you, contact Tech Support
to have them work you though the steps.

- V