Error: Starting ArcSDE: Oracle error ORA-01403

Error Message

ERROR getting SDE server Release. (1403).
Could not start ArcSDE -- -- Check Network, $SDEHOME disk, DBMS setting and dbinit.sde.


The ORA-01403 indicates "No data found". This can be caused for different reasons. Here are some of them.
1) The table SDE.VERSION table exists but does not contain a record. This can happen when ArcSDE startup is attempted but does not complete correctly, in which case subsequent attempts result in this error message.
2) Rollback segments are too small.

Solution or Workaround

  1. Drop the table SDE.VERSIONS, using SQL or the Enterprise Manager. Then, restart ArcSDE
  2. Create rollback segments, or increase their size.