Latest Contributions by VinceAngelo

It's best to avoid Oracle 10.2.0.1 on all platforms.  It is not certified for use with any Esri software -- Oracle 10.2.0.3 is the minimum stable version.  I'm allergic to directory paths that contain spaces and other special characters, and try to avoid install on the C: drive as general policy. - V ... View more

Yes.  It's usually wise to define GEOGCS-based coordinate references which are capable of mapping the full globe (since I don't need to map individual bacteria, I generally use '-x -210,-120,1000000', which also reduces storage requirements 10-30% and improves query performance significantly). - V ... View more

I doubt that would work reliably (SR_TEXT is only a part of the SE_COORDREF definition):   1  SELECT count(sr_name) FROM sde.st_spatial_references   2* WHERE sr_name = 'GCS_WGS_1984' SQL> / COUNT(SR_NAME) --------------             12 It would probably be better to create an application configuration table that would allow you to control the SRID used by the app (see SDE.SERVER_CONFIG for an example): SQL>  describe sde.server_config Name                                      Null?    Type ----------------------------------------- -------- ---------------------------- PROP_NAME                                 NOT NULL NVARCHAR2(32) CHAR_PROP_VALUE                                    NVARCHAR2(512) NUM_PROP_VALUE                                     NUMBER(38) - V ... View more

Yes, the SRID must exist.  If it doesn't, create a layer in the desired coordref, then DROP the table (SRIDs persist). - V ... View more

http://webhelp.esri.com/arcgisdesktop/9.2/index.cfm?TopicName=ST_Transform The projection must of course be reversible. - V ... View more

There's no need to update the license key (which resides in the database). Did you follow step 13 to replace the "ORACLE_SID" variable name with "LOCAL"? [You shouldn't run multiple application servers in the same instance, so the original service should be stopped when you test, and eventually deleted with 'sdeservice -o delete'.] Do you have multiple Oracle installs on the same host? If so, is the tnsnames.ora the same in all ORACLE_HOMEs? - V ... View more

If you provide the text of your error messages in your posts, there are three main benefits: 1) There will never be an issue with missing attachments 2) More people will view your error message (this is especially true for large images or for non-image attactments, e.g. *.doc) 3) Others who have the same problem will be able to search on the error text and find your solution (IMHO, this is the most important reason -- you can help others while getting help) Creating a service is not the end of the configuration process for a remote Oracle host. You also need to change the "ORACLE_SID" variable in SDEHOME/etc/dbinit.sde to use the special Oracle TNS variable "LOCAL" ("TWO_TASK" on Linux).  It's hard to tell what else may be wrong without the contents of the etc logs and configuration files.  If you had contacted Tech Support they would have asked for these before you spoke with the analyst. - V ... View more

A hole poked for an ArcSDE application server service would be on the ArcSDE port (which defaults to 5151).  It seems you're using Direct Connect (which is RDBMS-dependent). - V ... View more

Technically, you don't need ArcGIS installed to develop or deploy ArcSDE applications (either Java or 'C' API).  In practice, it's useful for developers to have access to the ArcSDE administration binaries ('sdelayer', 'sdetable', etc) in an ArcSDE for {DBMS} installation, but once the application is compiled, then you only need one ArcSDE client install (which includes ArcGIS Desktop and Server, the SDK, and all ArcSDE server installations). - V ... View more

Please contact Tech Support.  They will tell you what they need. - V ... View more

The documentation details the needed privileges (way down at the bottom). I'm not recommending you violate your license terms (though if you don't have more than 50 *real* users, I don't see an ethical quandry).  I *am* recommending a work-around until you can get Tech Support in the loop (you really shouldn't need to reboot the server weekly; quarterly maybe, but that's just good practice on Windows anyway). - V ... View more

The information you provided did not answer all of the initial questions. You will need to provide even more data to Tech Support to discover why you got this message. - V ... View more

In this context, row width does not include geometry storage.  Keep in mind that ATTRBUFSIZE impacts *every* table.  You'll need to give Tech Support the DBTUNE creation parameters and a data sample if they're going to be able to reproduce the error. - V ... View more

The process for creating tablespaces and users in Oracle on a Windows host is identical to that on a Unix host (the only difference is the presence of a drive letter and direction of slashes in the file name). I don't ever use the post-installer. I suggest reading the entire New Installations section of the install guide, and if you're still having difficulty, contacting Tech Support for assistance. - V ... View more

I couldn't begin to help you before you answered the litany of questions I posed last time. In addition, you'd need to tell: Which database you're using, and its version and service pack level, Which version and service pack of ArcSDE you are using, Which version and service pack of ArcGIS you are using, , and Whether the table you are accessing is versioned. This is probably a topic best raised with Tech Support, but you still need to collect the answers to all these questions, since they'll ask them as well. - V ... View more