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
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
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.
Did anyone figure it out?
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.
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.