connection of aracle database to arcmap

[IndiraKhanal1]

hello...I have been trying to connect oracle databse in to arcmap 10.1. It got connected but while trying to add feature type ( route network file) to the map it says "Coodinate system identifier is invalid". The tables which are not associated with any geometry are displayed but the geometry related files are not showing up. I would really appreciate on any comment and thoughts.

[WilliamCraft]

In what spatial data type does your data (route network file) exist inside Oracle (i.e., SDO_GEOMETRY, SDE_LOB, ST_GEOMETRY)? 

Are these tables registered with ArcSDE as spatial data (i.e., do they have a geometry column such as a SHAPE field)?   

How are you making your connection to Oracle in ArcMap... is it through database connections or are you using a Query Layer?

[IndiraKhanal1]

It is SDO_GEOMETRY type. Yes they have geometry columns and I am using database connections to connect oracle to arcmap.

[WilliamCraft · Accepted solution]

I can't say for certain, but to me this sounds like an issue with how these tables were registered as layers.  More specifically, I am thinking that the SRID used during the layer registration is not one that ArcSDE recongnizes or interprets correctly.  How did these tables get registered with SDE... was it via SDE command line or some other method?  Try performing a describe_long on one of the tables to see what the SRID value is.  You can also see if the spatial column is set correctly and what the coordinate system attribute comes back with.  Here's an example output:

ArcSDE 9.3.1  for Oracle11g Build 3056 Fri Sep 10 09:41:17  2010

Layer   Administration Utility

-----------------------------------------------------

Layer Description ....: <None>

Table Owner ..........: LA

Table Name ...........: BUILDING_PY

Spatial Column .......: SHAPE

Layer Id .............: 476

SRID .................: 34

Minimum Shape Id .....: 1

Offset ...............:

  falsex: -124791099.998718

  falsey:  -91255499.999136

System Units .........:       3906.249996

Z Offset..............:          0.000000

Z Units ..............:          1.000000

Measure Offset .......: <None>

Measure Units ........: <None>

XY Cluster Tolerance .:          0.008192000008

Spatial Index ........:

  parameter:    SPIDX_GRID,GRID0=2000,GRID1=6000,FULL

  exist:        Yes

  array form:   2000,6000,0

Layer Envelope .......:

  minx:   2643628.63990, miny:    483129.61769

  maxx:   3710047.75462, maxy:   1457660.51806

Entities .............: nac+

Layer Type ...........: SDE-LOB

Creation Date ........: 07/07/11 14:02:02

I/O Mode .............: NORMAL

Autolocking ..........: Enabled

Precision.............: High

User Privileges ......: SELECT, UPDATE, INSERT, DELETE

Coordinate System ....: PROJCS["NAD_1983_StatePlane_Louisiana_South_FIPS_1702_Feet",GEOGCS["GCS_North_American_1983",DATUM["D_North_American_1983",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Lambert_Conformal_Conic"],PARAMETER["False_Easting",3280833.333333333],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-91.33333333333333],PARAMETER["Standard_Parallel_1",29.3],PARAMETER["Standard_Parallel_2",30.7],PARAMETER["Latitude_Of_Origin",28.5],UNIT["Foot_US",0.3048006096012192]]



Layer Configuration ..: DEFAULTS

[VinceAngelo]

I'm wondering if they were registered at all.  Query Layers don't require
pre-registration, but Enterprise Geodatabase (ArcSDE) feature classes do.

- V