AnsweredAssumed Answered

Unable to connect to the Geodatabase

Question asked by ARaheem on May 19, 2017
Latest reply on May 22, 2017 by George_Thompson-esristaff

Like • Show 0 Likes0
Comment • 9

When I am trying to connect to the Geodatabase with sde user but the connecting not establishing and getting a -51 error code with message "Underlying DBMS error". Previously I had no issue connecting Geodatabase but from a week I am getting this error. I am using Oracle11g and ArcSDE 10.1.

Is this something related to ArcSDE or DBMS? If it is related to DBMS what could be the cause of the issue and how can I resolve it?.

Any help in identifying and resolving the issue is greatly appreciated.

Thanks in Advance.

No one else has this question

Outcomes

9 Replies

George_Thompson-esristaff May 19, 2017 7:45 AM
Mark Correct
Correct Answer
First Question: What has changed in the RDBMS or the client in the last week?

What version of ArcGIS Client are you using?

Are you using direct connection, if so what is the syntax? EZConnect or TNS?

Can you put a screenshot of the error?

Since it is Oracle, can you connect to the DB via SQLPlus or TOAD as the SDE user?
2 people found this helpful
Like • Show 0 Likes0
Actions
- ARaheem @ George_Thompson-esristaff on May 21, 2017 11:57 PM
  Mark Correct
  Correct Answer
  What has changed in the RDBMS or the client in the last week? : Database backup to clone and create new database in different server has been performed.
  
  What version of ArcGIS Client are you using? : It is ArcGIS 10.1
  
  Are you using direct connection, if so what is the syntax? EZConnect or TNS?: We are using EZConnect.
  
  Can you put a screenshot of the error?: Unfortunately I don't have the screenshot with me. This is the only error message I get from the log file.
  
  "Connection to SDE encountered a -51 error:
  Underlying DBMS error
  Extended error code: 0, extended error string:
  Ends with status 1"
  
  Since it is Oracle, can you connect to the DB via SQLPlus or TOAD as the SDE user?: Yes.
  
  I am getting this error when I am connecting to the database using C++.
  I have published maps in the ArcGIS server and the data is visible in the maps.
  Like • Show 0 Likes0
  Actions
  - George_Thompson-esristaff @ ARaheem on May 22, 2017 4:49 AM
    Mark Correct
    Correct Answer
    Thanks for that information, I am not sure how to make a connection via C++.
    
    Can you make a connection directly in the ArcGIS Client (Catalog/ArcMap)? What are the results?
    Like • Show 0 Likes0
    Actions
    - ARaheem @ George_Thompson-esristaff on May 22, 2017 5:02 AM
      Mark Correct
      Correct Answer
      I tried connecting ArcGIS client(Catalog) and the connection is successfully established in it.
      Like • Show 0 Likes0
      Actions
      - George_Thompson-esristaff @ ARaheem on May 22, 2017 5:05 AM
        Mark Correct
        Correct Answer
        Ok, If you can connect to the Oracle GDB via Catalog that tells me that it is something in the C++ code that may need to be tweaked.
        
        Developer Communities
        Like • Show 0 Likes0
        Actions
        ARaheem @ George_Thompson-esristaff on May 22, 2017 5:20 AM
        Mark Correct
        Correct Answer
        Hi George,
        
        I don't think there is any issue in that C++ code since it is a working solution for long from now. Besides the same code is working in other environment.
        Like • Show 0 Likes0
        Actions
        George_Thompson-esristaff @ ARaheem on May 22, 2017 5:28 AM
        Mark Correct
        Correct Answer
        Ok, then a comparison between a "working" machine and this "non-working" machine needs to be made.
        
        Have you reviewed the direct connection logs? Deciphering Errors within ArcSDE | Support Services Blog
        2 people found this helpful
        Like • Show 0 Likes0
        Actions
rleclair-esristaff May 19, 2017 8:07 AM
Mark Correct
Correct Answer
To add to George's list of questions - did the DEFAULT version permission get changed to PRIVATE by chance?
1 person found this helpful
Like • Show 0 Likes0
Actions
- ARaheem @ rleclair-esristaff on May 22, 2017 4:38 AM
  Mark Correct
  Correct Answer
  No, I have checked the DEFAULT version permission and it is in public mode.
  Like • Show 0 Likes0
  Actions

GeoNet

The Esri Community

Unable to connect to the Geodatabase

Outcomes

Related Content

Recommended Content