3 Replies Latest reply on Jan 7, 2011 12:53 PM by pfoppe

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

    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!
        • Re: Cannot Start ArcSDE 9.3.1 on Oracle 10g - DBMS error code: -6508
          geomofo
          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
          • Re: Cannot Start ArcSDE 9.3.1 on Oracle 10g - DBMS error code: -6508
            pfoppe
            Thank you for the suggestion Anthony.  I will work with our DBA to attempt your suggestion, and update with any progress!
            • Re: Cannot Start ArcSDE 9.3.1 on Oracle 10g - DBMS error code: -6508
              pfoppe
              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]