We have created a table containing SDO_GEOMETRY in Oracle 11g.We are trying to register this table as a layer in ArcSDE.SDE user is already granted CONNECT,RESOURCE,DBA role.Geometries in the table are of same type (POINT).We are contineuosly getting error of;
ArcSDE 9.2 for Oracle11g Build 3056 Fri Sep 10 09:41:17 2010
Layer Administration Utility
-----------------------------------------------------
Error: Operation Failed (-1).
Error: Could not create a connection.
Our command line command is : sdelayer -o register -l tbl_equipment1,SHAPE -e p -C oid -i 5161 -s 172.21.51.10 -u ne -p ne
where table is tbl_equipment1 and geometry field is SHAPE.We ave created spatial index and entered the record in user_sdo_geom_metadata view also.
Please help us to resolve the conflict.
Thanks in advance