+ Reply to Thread
Results 1 to 4 of 4

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

  1. #1
    pat f
    Join Date
    Dec 2010
    Posts
    61
    Points
    23
    Answers Provided
    5


    0

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

    Hello,

    Instance was running fine for days and after attempting to bounce the instance we cannot bring it back up. Messages below:
    >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.
    ArcSDE log file:

    -------------------------------------------------------
    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)

    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';

    Code:
    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!
    Last edited by pfoppe; 01-06-2011 at 06:00 PM.

  2. #2
    anthony sanchez
    Join Date
    May 2010
    Posts
    45
    Points
    6
    Answers Provided
    1


    0

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

    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

  3. #3
    pat f
    Join Date
    Dec 2010
    Posts
    61
    Points
    23
    Answers Provided
    5


    0

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

    Thank you for the suggestion Anthony. I will work with our DBA to attempt your suggestion, and update with any progress!

  4. #4
    pat f
    Join Date
    Dec 2010
    Posts
    61
    Points
    23
    Answers Provided
    5


    0

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

    We finnally got SDE up and running again. There were some invalid objects in the ORACLE instance:

    Code:
    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:

    Code:
    SQL> alter package sde.pinfo_util compile;
    
    Package altered.
    Which then gave us a few more invalid packages:

    Code:
    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!

    Code:
    SQL> select * from dba_objects where status = 'INVALID';
    
    no rows selected
    SDE STARTUP LOG:
    -------------------------------------------------------
    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)) . . .

+ Reply to Thread

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts