SDE file are not working anymore (Oracle DB)

Question

Hello, this morning I had a surprise. My services are not working. They are running but not working, if I try to restart them they fail after a while with error:

In english something like 'Construction of service instance 'xyz.MapServer' failed. Service starting expired.'

I cannot validate the SDE files from this DB in AGS.

In ArcCatalog, I don't have any error but my Catalog cannot connect to sde, it just tries to connect to DB indefinitely.

In sqldev, no problem to connect to the DB, everything works fine.

Another DB is on the same server and it works perfectly fine too.

I really don't know what could cause this behavior, do you have any idea? Or places i could find more info?

Polopolo · Answer

It was a database problem which was really slow to connect (so I guess ArcCatalog got a timeout but the UI made me thought it was still trying to connect). After restarting the VM, it is working fine

MMBR · Answer

This can also help diagnose the problem.

How To: Diagnose ArcSDE Connection and Performance Issues Using SDEINTERCEPT (esri.com)

ChrisUnderwood · Answer

Using ArcCatalog you can create a connection log file if you add a couple of Environment Variables like this.

SDESVRLOG      TRUE

SDESVRLOGLOC   C:\Users\username\Documents (or similar location)

Make sure you have OK'd the Environment Variables form, and restarted ArcCatalog. The file will be called sdedc_Oracle.log