We finnally got SDE up and running again. There were some invalid objects in the ORACLE instance: SQL> select * from dba_objects where status = 'INVALID';
OWNER
------------------------------
OBJECT_NAME
--------------------------------------------------------------------------------
SUBOBJECT_NAME OBJECT_ID DATA_OBJECT_ID OBJECT_TYPE
------------------------------ ---------- -------------- -------------------
CREATED LAST_DDL_ TIMESTAMP STATUS T G S
--------- --------- ------------------- ------- - - -
SDE
PINFO_UTIL
50216 PACKAGE BODY
23-NOV-10 23-NOV-10 2010-11-23:11:09:49 INVALID N N N
We fixed the invalid packages: SQL> alter package sde.pinfo_util compile;
Package altered.
Which then gave us a few more invalid packages: SQL> select * from dba_objects where status = 'INVALID';
OWNER
------------------------------
OBJECT_NAME
--------------------------------------------------------------------------------
SUBOBJECT_NAME OBJECT_ID DATA_OBJECT_ID OBJECT_TYPE
------------------------------ ---------- -------------- -------------------
CREATED LAST_DDL_ TIMESTAMP STATUS T G S
--------- --------- ------------------- ------- - - -
SDE
LOCK_UTIL
50218 PACKAGE
23-NOV-10 23-NOV-10 2010-11-23:11:09:49 INVALID N N N
OWNER
------------------------------
OBJECT_NAME
--------------------------------------------------------------------------------
SUBOBJECT_NAME OBJECT_ID DATA_OBJECT_ID OBJECT_TYPE
------------------------------ ---------- -------------- -------------------
CREATED LAST_DDL_ TIMESTAMP STATUS T G S
--------- --------- ------------------- ------- - - -
SDE
LOCK_UTIL
50219 PACKAGE BODY
23-NOV-10 23-NOV-10 2010-11-23:11:09:49 INVALID N N N
OWNER
------------------------------
OBJECT_NAME
--------------------------------------------------------------------------------
SUBOBJECT_NAME OBJECT_ID DATA_OBJECT_ID OBJECT_TYPE
------------------------------ ---------- -------------- -------------------
CREATED LAST_DDL_ TIMESTAMP STATUS T G S
--------- --------- ------------------- ------- - - -
SDE
VERSION_UTIL
50221 PACKAGE BODY
23-NOV-10 23-NOV-10 2010-11-23:11:26:29 INVALID N N N
OWNER
------------------------------
OBJECT_NAME
--------------------------------------------------------------------------------
SUBOBJECT_NAME OBJECT_ID DATA_OBJECT_ID OBJECT_TYPE
------------------------------ ---------- -------------- -------------------
CREATED LAST_DDL_ TIMESTAMP STATUS T G S
--------- --------- ------------------- ------- - - -
SDE
VERSION_USER_DDL
50233 PACKAGE BODY
23-NOV-10 23-NOV-10 2010-11-23:11:09:50 INVALID N N N
Fixed those and all seems good again!SQL> select * from dba_objects where status = 'INVALID';
no rows selected
SDE STARTUP LOG: [INDENT]-------------------------------------------------------
ArcSDE 9.3.1 for Oracle10g Build 3056 Fri Sep 10 09:41:17 2010
-------------------------------------------------------
ST_Geometry Schema Owner: (SDE) Type Release: 1007
Instance initialized for ((sde)) . . .
Connected to instance . . .
DBMS Connection established...
RDBMS: "Oracle"
Instance Name: "esri_sde"
IOMGR Process ID (PID): 4864
ST_Geometry Schema Owner: (SDE) Type Release: 1007
Instance initialized for ((sde)) . . .[/INDENT]