Read the geodatabase release problem

4241
7
12-10-2013 02:58 AM
LeonardoAraújo
New Contributor III
Hi all,

I'm having a problem trying to connect to my Oracle geodatabases through ArcMap after a restore of my database.
When trying to connect I get the error "This release of the GeoDatabase is either invalid or out of date, DBMS table not found [ORA-00942: table or view does not exist] [SDE GDB_Release]".

I get a similar error when I try to perform the "sdesetup -o list" command. I get an error message saying "Error getting server release information (-1)."

Has anyone gone through this problem? Could anyone help me solve it?

I am using ArcSDE 10.0 sp5 on a Centos 5.

Thanks,

Leonardo.
7 Replies
VinceAngelo
Esri Esteemed Contributor
It's possible that your database restore was not complete.  How many tables, views, triggers
and packages do you have under your SDE user?  What are the names of the tables?

It's been a while since I've had an Oracle database running 10.0sp5, so I can't tell you the
exact counts, but under 10.2, this is what I'm seeing:*


SQL> select count(object_type),object_type
  2  from user_objects group by object_type
  3  order by object_type;

COUNT(OBJECT_TYPE) OBJECT_TYPE
------------------ -------------------
                 3 FUNCTION
               103 INDEX
                 1 INDEXTYPE
                 1 LIBRARY
                20 LOB
                69 OPERATOR
                33 PACKAGE
                33 PACKAGE BODY
                23 SEQUENCE
                62 TABLE
                12 TRIGGER
                32 TYPE
                24 TYPE BODY
                 5 VIEW


*Note: I never load user tables as the SDE user, so this is the bare minimum for SDE
user ownership.

Tech Support can help you evaluate your options; I suggest you give them a call.

- V
0 Kudos
LeonardoAraújo
New Contributor III
Dear Vincent,

I ran the query you have sent and received the following results:

3 FUNCTION
101 INDEX
1 INDEXTYPE
2 LIBRARY
20 LOB
69 OPERATOR
33 PACKAGE
33 PACKAGE BODY
1 PROCEDURE
23 SEQUENCE
62 TABLE
12 TRIGGER
41 TYPE
26 TYPE BODY
5 VIEW


But I compared these results with another test environment I have and the data are the same. Any other suggestion?

Thanks,

Leonardo.
0 Kudos
VinceAngelo
Esri Esteemed Contributor
Tech Support can help you evaluate your options; I suggest you give them a call.

- V
0 Kudos
ChunjieXu1
New Contributor

Hi, Leonardo:

    How did you solve this problem finally? I know it's a long time, but we are facing the exact the same error when connecting the gdb while restore it from another instance.

   It would be great if you can post the methods how you resolve this problem.

   Thank you very much.

ChelseaRozek
MVP Regular Contributor

Did anyone figure it out?

0 Kudos
PrasannaS
New Contributor

Facing exact same error when trying to connect to Oracle geodatabase from ArcCatalog. Error window includes "Failed to connect to the specified server. Do you want to continue?" along with the error posted.

If this issue got resolved please post how this got resolved.

0 Kudos
ChelseaRozek
MVP Regular Contributor

ESRI Support ended up directing us to reimage our 32-bit PCs to 64-bit. Whether or not that was the actual issue is still debated, but the reimaging fixed their connection issues.

0 Kudos