pfoppe

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

Discussion created by pfoppe on Jan 6, 2011
Latest reply on Jan 7, 2011 by pfoppe
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!

Outcomes