Cannot Start ArcSDE 9.3.1 on Oracle 10g - DBMS error code: -6508

3183
3
01-06-2011 12:57 PM
PF1
by
Occasional Contributor II
Hello,

Instance was running fine for days and after attempting to bounce the instance we cannot bring it back up.  Messages below:

[INDENT]>sdemon -o start
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.
[/INDENT]

ArcSDE log file: [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...
Error -51 in purge unused shared entries.
DBMS error code: -6508
Error in PL/SQL block to clean  upleftover entries for SDE instance
ORA-06508: PL/SQL: could not find program unit being called
ERROR: Cannot Initialize Shared Memory (-51)
[/INDENT]


We did try to revoke the execute permissiosn to the DBMS_PIPE and DBMS_LOCK for the PUBLIC role and specifically allow only the SDE user to execute those, and that didnt seem to help.  We re granted the permissions for the PUBLIC role to have execute permissions on DBMS_PIPE and DBMS_LOCK so we are not sure if that was causing the problem for us...

SQL> select * from dba_tab_privs where TABLE_NAME = 'DBMS_PIPE';

GRANTEE                        OWNER
------------------------------ ------------------------------
TABLE_NAME                     GRANTOR
------------------------------ ------------------------------
PRIVILEGE                                GRA HIE
---------------------------------------- --- ---
SDE                            SYS
DBMS_PIPE                      SYS
EXECUTE                                  NO  NO

------------------------------ ------------------------------
TABLE_NAME                     GRANTOR
------------------------------ ------------------------------
PRIVILEGE                                GRA HIE
---------------------------------------- --- ---
PUBLIC                         SYS
DBMS_PIPE                      SYS
EXECUTE                                  NO  NO


We compared the dbinit.sde, dbtune.sde, and services.sde with another ORACLE instance with the same configuration - all values seem correct.  We also tried to delete and re-create the sde service using the 'sdeservice' command with no luck.  Our DBA has run various sanity checks to make sure that ORACLE is behaving normally and could not find anything out of the ordinary.  We can connect to the DB using NON-ESRI tools such as sql developer and sqlplus just fine. 

We are running Windows 2003 Server 64-bit
Oracle 10.2.0.4
SDE 9.3.1 SP2

Any help/support would be greatly appreciated.  Another instance just like this one is running just fine, so we have had opportunity to compare configurations.  Thank you for any support!
0 Kudos
3 Replies
anthonysanchez
New Contributor III
Hello,
I'd recommend putting a level 12 trace login trigger for the sde user in place and trying to start the service again. This would tell us the exact SQL and object that are throwing the error.

Search for "err=" in the raw tracefile.

-anthony
0 Kudos
PF1
by
Occasional Contributor II
Thank you for the suggestion Anthony.  I will work with our DBA to attempt your suggestion, and update with any progress!
0 Kudos
PF1
by
Occasional Contributor II
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]
0 Kudos