Latest Contributions by VinceAngelo

Did you make the SDE user the owner of the database?  Or grant administrative access to SDE? - V ... View more

The answer is "Neither" or "Both". The SDO_GEOMETRY type is used by both Oracle Spatial and Esri ArcGIS, but it is provided by Intermedia, which is part of the base Oracle install capability.  I never install Spatial, and I always have SDO_GEOMETRY available. ArcSDE is the Esri technology which integrates Esri's client applications with major databases to provide versioned geodatabase and ST_GEOMETRY capability.  It does nothing of its own volition, though clients like Catalog are fond of generating indexes when data tables are created and populated through ArcObjects (after all, they can't be effectively queried without. an index).  If you don't wish a spatial index to be constructed, you may need to code your own import tool (or to drop it before performing further processing). There is no relationship whatsoever between the index on file geodatabases and the index Oracle provides for SDO_GEOMETRY columns. - V ... View more

Certification was done with the releases listed as certified.  Releases above the certified values are "assumed to work", though if known *not* to work, that will also be specified. Oracle 11.2.0.3 should be compatible on AIX, though that's a smaller pool of users than other OSes, so there won't be as much feedback if something were wrong. - V ... View more

On which platform are you trying to install?  All the ArcSDE installers should be in the same general neighborhood, though sometimes the Unix versions are distributed on a different disk.  Make sure you're distinguishing between Enterprise ArcSDE, which runs on 5-7 different databases (depending on how you count them) and Personal and Workgroup ArcSDE, which only work under SQL-Server Express. - V ... View more

If you're loading geometry on your own, then you have to be able to validate the construction on your own.  Oracle doesn't enforce topology rules on insert because the detection tools need loaded data, but ArcSDE does enforce ring orientation. (errors should be logged in $SDEHOME/etc).  I haven't had to use Oracle's tools much because I usually have access to the API functions, but all you really need is a parser and a function to calculate area via the trapezoid rule across the array of segment vertex pairs. The least confusing way to make up connection parameters is to just use "server", "instance", "database", "user" and "password" for the respective values (something like "notThePassword" is a close second). - V ... View more

Have you used Oracle's tools for validting the geometry topology? Internal rings in WKT must be wrapped clockwise (SDO_GEOMETRY is left-hand rule). Check the ArcSDE logs to see if there are geometry errors... - V BTW: Please edit your post to remove password information -- no one here needs that. ... View more

I hope there weren't any outstanding ST_GEOMETRY columns at the time SDE was blown away -- if so, you might experience some unrecoverable referential integrity issues within the Oracle instance 😞 - V ... View more

Is the listener pointing at the old ST_GEOMETRY libraries? - V ... View more

If it's a view, then the spatial index parameters of the base table are what matters -- does Catalog report those correctly? I do question the wisdom of using three levels of spatial index.  I've only seen one table in the past fifteen years of SDE consulting which got a performance benefit from three vs two indexing levels, and the overall performance was so bad, the (very diiferent) data sources should really have been mapped to different tables. - V ... View more

I haven't used MapObjects since 2.0 was released, so all I can do is direct you to the support pages. MapObjects 2.4 was last supported with ArcSDE 9.2. Oracle 11g support did not begin until ArcSDE 9.3. What was supported with what is of limited use, because support for MapObjects 2.4 ended in July 2010 (MO 2.3 support ended in 2007),  Oracle's support for 10gR2 ended in May 2010, and ArcSDE 9.2 support ends with 10.1 release this summer, so you're still deep in Unsupportedland. You can prototype the upgrade to see if it might work (some 9.2 ArcSDE clients [post SP4] were supported to connect to 9.3/9.3.1 ArcSDE servers, so there's some hope), but it's probably not wise to pursue a full upgrade if your app doesn't work perfectly under rigorous testing on a modern host running 9.3.1SP2 on Oracle 11.1.0.2. I should also point out that ArcSDE 9.3 won't function without a license key, so you'll need to engage your local Esri office to get the evaluation license to test this configuration.   - V ... View more

Support for Oracle 11g was added at ArcSDE 9.3 (not 9.2), with 64-bit support introduced at 9.3.1.  Given that ArcGIS 9.2 will be retired with the release of ArcGIS 10.1, I'd normally suggest a more recent ArcGIS release, but MapObjects 2.4 was retired nearly two years ago, so there isn't any combination of ArcSDE and MapObjects which will work together under Oracle 11g.  If you want to go with all-retired software, then your versions would be Oracle 10.2.0.3/10.2.0.4, ArcSDE 9.2, and MO 2.4, but I wouldn't suggest trying to run this software stack on anything more recent than Windows Server 2003. - V ... View more

Any time you get a "wrong ELF class" error, it means you're mixing application word sizes between components.  I've already directed you to the use of 'file' to determine which is incorrect.  This time it appears you have a 32-bit ArcSDE with a 64-bit PostgreSQL, while last time you had a 64-bit ArcSDE with a 32-bit database.  Esri always specifies "64" in the folder name for 64-bit applications; if 'file' reports 32-bit ArcSDE, try going back to your distribution media and copying the 64-bit ArcSDE installer, then go to the support site to download the latest 64-bit service pack (which should be installed before you run 'sdesetup -o install'). - V ... View more