On SDE Server gsrve.exe process crashes. Log shows exit'd with status 255

[MonjurChowdhury]

Greetings,

It happens at random. We are running ArcSDE 9.3.1 SP2 64 bit on Oracle 11.2.0.1, 64 bit. O/S - Windows Server 2008 R2 Enterprise, 64 bit.


Any idea how to find the root cause?


Thank you.

Monjur Chowdhury

[JonDeRose]

Monjur,

Exit Status 255 is not an ArcSDE exit code but from Oracle.  Could you upload the logs from ArcSDE from when this issue was encountered?  We may be able to glean more information from these errors.

Check out the Oracle alert.log and Windows Event Viewer for additional information outside of that seen within the %SDEHOME%\etc error logs.  Does this behavior affect direct-connections?

- Jon

[MonjurChowdhury]

Here is the giomgr log entry:

Tue Oct 16 10:36:32 2012 - SDE Server 6692 exit'd with status 255
Tue Oct 16 10:36:32 2012 - SDE Server Pid 6692 Stopped, User: TMEZZAN Schema: sde.

Here is the Oracle Alert Log entry at the time of gsrvr.exe process crash.

Tue Oct 16 10:35:37 2012
Errors in file d:\oracle\diag\rdbms\novgisp\novgisp\trace\novgisp_ora_4284.trc  (incident=102614):
ORA-03137: TTC protocol internal error : [12333] [5] [196] [41] [] [] [] []
Incident details in: d:\oracle\diag\rdbms\novgisp\novgisp\incident\incdir_102614\novgisp_ora_4284_i102614.trc
Tue Oct 16 10:35:41 2012
Trace dumping is performing id=[cdmp_20121016103541]
Tue Oct 16 10:35:45 2012

Thank you.

Monjur

[VinceAngelo]

If Oracle is crashing with an internal protocol error, it's *really* unlikely that it would have
anything to do with ArcSDE or any other Esri product.  The configuration is supported, so
you can try to go to Esri Tech Support, but I can't see this going anywhere but an Oracle
support queue.

- V