Getting error while registering oracle spatial layer to ArcSDE

[SourishChakraborty]

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

[VinceAngelo]

The error states "could not create a connection" -- can that same user connect with an
'sdetable -o describe -t tbl_equipment1'?

Since 11g support was introduced at 9.3, seeing a banner that states "ArcSDE 9.2 for Oracle11g"
makes me wonder what else may be odd...

What version of Oracle do you have installed?  What exact patchset (A.B.C.D notation)?

What version of ArcSDE? What service pack is reported by the patch finder?

What does DESCRIBE in SQLPLUS return on the table?

What is the contents of USER_SDO_GEOM_METADATA for TBL_EQUIPMENT1?

Is there a primary key constraint on the table? 

Does the OID column exist, is it NOT NULL, and does it map to SE_INT32_TYPE?

- V

[SourishChakraborty]

The error states "could not create a connection" -- can that same user connect with an
'sdetable -o describe -t tbl_equipment1'?

Since 11g support was introduced at 9.3, seeing a banner that states "ArcSDE 9.2 for Oracle11g"
makes me wonder what else may be odd...

What version of Oracle do you have installed? What exact patchset (A.B.C.D notation)?

What version of ArcSDE? What service pack is reported by the patch finder?

What does DESCRIBE in SQLPLUS return on the table?

What is the contents of USER_SDO_GEOM_METADATA for TBL_EQUIPMENT1?

Is there a primary key constraint on the table?

Does the OID column exist, is it NOT NULL, and does it map to SE_INT32_TYPE?

No same user can't connect with an 'sdetable -o describe -t tbl_equipment1';;it's showing error :
Error: Operation Failed (-1).
Error: Could not create a connection on server 172.21.51.10, for user ne.

banner that states "ArcSDE 9.2 for Oracle11g" ; I am trying to connect ArcSDE Server 9.3
with Oracle 11g;my client machine is having ArcSDE 9.2 installed,so i am firing the command from
ArcSDE 9.2 client machine to ArcSDE 9.3 server

Oracle 11g is installed details below:

SQL> select * from v$version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
PL/SQL Release 11.1.0.7.0 - Production
CORE    11.1.0.7.0      Production
TNS for Solaris: Version 11.1.0.7.0 - Production
NLSRTL Version 11.1.0.7.0 - Production

Content of USER_SDO_GEOM_METADATA for TBL_EQUIPMENT1 is TABLE_NAME,COLUMN_NAME,SRID,DIMINFO.I am able to create spatial index and execute spatial queries correctly also.;
OID exists and it's not null.OID is having primary key constraint.

The error states "could not create a connection" -- can that same user connect with an
'sdetable -o describe -t tbl_equipment1'?

Since 11g support was introduced at 9.3, seeing a banner that states "ArcSDE 9.2 for Oracle11g"
makes me wonder what else may be odd...

What version of Oracle do you have installed? What exact patchset (A.B.C.D notation)?

What version of ArcSDE? What service pack is reported by the patch finder?

What does DESCRIBE in SQLPLUS return on the table?

What is the contents of USER_SDO_GEOM_METADATA for TBL_EQUIPMENT1?

Is there a primary key constraint on the table?

Does the OID column exist, is it NOT NULL, and does it map to SE_INT32_TYPE?

- V

[VinceAngelo]

While 9.2 SP5 & SP6 can connect to 9.3 servers, Oracle 11g is not supported for layer
creation (though from connect failure, it's possible you're not even using SP5 or newer).

Try using a homogeneous client for layer registration (or just registering on the server).
Keep in mind that registration is unlikely to succeed if 'sdetable -o describe' doesn't report
SE_INT32_TYPE on the prospective registered rowid column.

- V