Latest Contributions by danan

‎03-20-2012

Our service request with Oracle is not providing workarounds, tips or solutions for working with SDE to avoid the data dictionary corruption or avoiding the breakage of Data Pump. We have just rebuilt SDE manually in another database so have a good export to try importing into another working instance, hopefully not breaking Data Pump and keeping the d.d. intact and no missing ST_GEOMETRY data types. I have just completed a support call to ESRI for their help. I will keep you updated. Jane Thanks for the update Jane. If and when our downstream customer opens a support ticket with Esri I will also report any findings.

‎03-16-2012

We have come to the conclusion that our problems of Data PUmp not working are related to Oracle Note, Ora-21700 Object Does Not Exist Or Is Marked For Delete When Dropping a User With ST_GEOMETRY Dependencies [ID 1385929.1]. Dictionary gets corrupted when tables using a specific object type (SDE.ST_GEOMETRY) are tried to be dropped after the type was tried to get dropped. This corruption in the dictionary may have affected the DBMS_DATAPUMP package. I have tried re-installing the package with no success. ESRI has a note on the subject of dropping the user SDE and/or other users who use the ST_GEOMETRY datatype, http://support.esri.com/en/knowledgebase/techarticles/detail/34483. Drop the users using the ST_GEOMETRY, before dropping the SDE user, not the other way around. Yes, we use the SDE for business. We are in the midst of moving the instance to a new server and have been pulling our hair out trying to move SDE. On our source database, Data Pump is broken with no solution from Oracle Support to fix it. Now the new destination database has a broken Data Pump as well with some schemas up and running in production. We are working towards re-building the instance, re-build SDE from scratch and bring in the other schemas again. And be very clear which user schemas use the ST_GEOMETRY datatype and never drop them! Hi Jane, Thanks for posting your findings. Sorry you're having so much trouble. We may ask our customer to open a ticket with Esri. Although the support forums are terrific, they aren't intended to be a replacement for Esri Support. Many problems can be solved here but this issue is particularly stubborn / tricky. I cannot open a ticket myself so I can only suggest it as an option. Incidentally, at a class this week on Oracle Enterprise Manager (Grid Control) I mentioned the datapump issue to an instructor. His take was that many 3rd party UDTs have trouble with datapump. My (over-?)interpretation: Esri may be the victim here, not the culprit. Still, it would be nice to have official guidance. I'll post an update if we open a ticket or have success in some other way. What about using a file geodatabase as an intermediate medium for versioned feature classes? There's no ST_GEOMETRY for Oracle spatial data type in a file GDB (naturally). But I wonder if the customer could run a Python geoprocessing task to recreate things as ST_GEOMETRY from a FGDB source to the desired Oracle target. Anyone done this? It's not entirely clear to me if the customer needs versioned edits and state trees preserved during the migration process. Will ask for clarification. Likely overthinking this? Happy Friday. 🙂 Best, Dana

‎03-13-2012

I can replicate your missing SDE types. There is 1 missing subobject: OBJECT_NAME SUBOBJECT_NAME STATUS ------------------------------ ------------------------------ ---------- ST_DOMAIN_METHODS $VSN_1 VALID No progress here. Jane, are you using ST_GEOMETRY because it's the default spatial data type for SDE on Oracle, because you have a business requirement for spatial SQL functions, or another reason? For us, SQL functions were a "nice to have." Don't know that anyone is currently using them. And what's very much not nice to have: limited options for moving data around. I believe we also chose it because of a belief that ST_GEOMETRY being the default spatial data type means it would be the focus of future development.

‎03-12-2012

I did not assert that the combinarion was unsupported -- I started the sentence with "If". Please do not over-interpret what I write; I might be discouraged from writing at all. - V Ok. Your conditional statement is duly noted.

‎03-12-2012

I'm running on 32-bit RHEL 5.4 at home, and haven't had problems that couldn't be attributed to running on a six year old P4 host with only 2Gb RAM, but I'm not using 11.2.0.3. If both Oracle and Esri don't support 5.4, then that should be a source of real concern. - V Thanks Vince. Didn't realize 64 bit RHEL Server 5.4 / Oracle 11.2.0.3.X was now an unsupported platform. For new Oracle hosts, we wanted to go with RHEL Server 6.X. But Oracle has not certified that for 11.2.0.3.X. So I believe we're going with 5.8. OS version is a decision made by our sysadmins here and not the DBAs (me and my colleagues).

‎03-12-2012

SDE.ST_GEOMETRY has consistently better performance than SDE_LOB. You should evaluate the cost of moving to LOBs before deciding to do so. - V Thanks Vince. I have also heard the opposite. In principle ST_GEOMETRY should be consistently faster. But I don't know if that's the result for every customer on every sub-platform. Seems reasonable to test in one's own environment to see what is actually the case. That said, what to do about migrating feature classes with the ST_GEOMETRY User Defined Type? Is there a current Best Practice? Is datapump no longer recommended (if it ever was), etc? It's also been recommended to me to use RMAN to clone a DB instance as a means of moving ST_GEOMETRY-based data from instance to instance. Dana

‎03-10-2012

Similar to Esri's current "ArcGIS for Home Use" program ($100 per year for ArcView only and several extensions), please create an ArcGIS Server for Home / ArcSDE for Home Use program. Some use cases: Person wants to learn to be an ArcGIS Server Administrator / ArcSDE Administrator but has no access to the technology Developer wants to learn more about Web Services but has no access to the technology Current ArcGIS Server Administrator / ArcSDE Administrator wants to prep for newer release. Would be especially helpful for some orgs that are prevented from adopting new releases until they are security certified or market-tested by other orgs... Former ArcGIS Server Administrator / ArcSDE Administrator wants to keep current with the technology A student or career-changer wants to learn Esri technology but has no access to the technology If distributing ArcGIS Server / ArcSDE media for educational purposes is unreasonable, consider a Cloud option. If third party licensing challenges arise with, for example, an Educational Amazon AMI offering, presents, perhaps such an AMI could be deployed on a Linux OS with PostgreSQL as a database. For commercial use AMIs, I believe Esri has only made two available, perhaps because these are the only ones they are able to freely distribute: One using SQL Server Express as the RDBMS An Enterprise offering using PostgreSQL for the RDBMS Don't forget Oracle. Evidently ArcSDE 10.0 works with Oracle XE 11g. And Oracle makes most of its products freely available, even full Enterprise versions, for educational use. Could you partner with them to help Esri and its customers meet their respective education and training missions? If Hybrid IT is increasingly our future (e.g. a mixture of on-premise data centers and cloud-sourced "maps and apps"), an educational Cloud offering may benefit Esri customers. Familiarity breeds adoption, preparedness, etc? Think of Malcolm Gladwell and Tipping Points. For any of this to be effective, the ArcGIS for Home program should include a minimum of ArcEditor. Interested parties can vote for that option below: Offer ArcGIS for Home at ArcEditor (Standard) license level--not just ArcView (Basic) https://community.esri.com/ideas/3895 Include ArcGIS for Home with Esri Enterprise License Agreements (ELAs) https://community.esri.com/ideas/4009 Implementing some or all of the above ideas would help Esri better serve the educational, professional, and career needs of its customers. It's interesting to see the certification program take off. But how does one get certified if one doesn't have sufficient access to the technologies? This is a potential Win-Win. Great potential synergy with other educational efforts Esri has moved forward with. Keep up the good work and continue to unlock and expand the value in your ArcGIS for Home and Certification concepts. Hopefully others will vote and encourage Esri to do what seems to me to be in the best interests of both vendor and customer--being successful together.

‎03-10-2012

Hi Dana, I have encountered the exact problem and symptoms as you have described, with my Oracle 11.2.0.3 and SDE 9.3. How to move the data between instances? We have also encountered in 3 databases that Data Pump broke. Rebuilding the DBMS_DATAPUMP PL/SQL package has not been successful. Oracle Support has designated it a bug, 13829814, with their development. Through testing or rebuilding instances and bringing in the SDE data that the SDE data breaks Data Pump. Then yesterday I encountered the same errors as yours. The previous thread of using export/import with the grants to PUBLIC is being tested as I write. Please keep this thread updated with any new information as I will also. Thanks, Jane Thanks Jane. Sorry for your troubles and hope you succeed. I'll add to the thread if we have any success. Hoping others out there can comment since data migration is a fundamental function. But not something I've seen definitively addressed where ST_GEOMETRY is concerned. I suppose one solution (compromise) might be to jettison ST_GEOMETRY completely and convert to SDE_LOB. Another might be to use RMAN to clone an instance. I wonder if datapump failing is specific to Esri's ST_GEOMETRY UDT (User Defined Type). Or if the datapump problem exists for migrating UDTs from a variety of vendors. Based on some other issues we've had with ST_GEOMETRY, I wonder if it's best to switch to SDE_LOB unless ST_GEOMETRY spatial *functions* are an absolute business requirement.

‎03-10-2012

That URL always has the current information (by definition). The support for newer patches of a certified release continues to be "assumed to work, unless otherwise noted." It's unlikely that anyone at Esri will promise support for any release which has not been certified (certification tests are exhaustive and exhausting; they are not done lightly, and usually only on the reference OS available a year or more before the ArcGIS release date). - V Thanks Vince. I understand about rigors and resources involved in testing and certification.So it sounds like our downstream customer would be accepting some risk, but perhaps a small amount, in upgrading to ArcSDE 10.0 on Oracle 11.2.0.2 or 11.2.0.3.1. Fortunately there are several lower stages to test on prior to a Production server rollout. Would you absolutely not recommend running ArcSDE 10.0 on RHEL Server 5.4 given the minimum listed OS version is 5.5? Don't know if it's appropriate to ask on this thread, but has anyone reading run into trouble running ArcSDE 10.0 on an RHEL 5 / Oracle 11.2.0.3 platform?

‎03-09-2012

ArcSDE is certified on the "supported" platforms. This means that extensive testing has been done on that configuration, and is known to work. There's also a "not tested, but assumed to work" status which usually covers most of the patches above the specified release (unless otherwise noted). It's generally safe to assume that an Update 6, 7, or 8 of a supported release will work, but less safe to assume that Update 1 of the *next* release works. For the most part, Unix releases are very stable, with working backwards compatibility, but Esri only supports that which they've tested. - V Hi Vince, I am looking at the following doc in anticipation of upgrading an Oracle 11g R2 (64-bit) 11.2.0.2 instance, running on RHEL Server 5, from ArcSDE 9.3.1 SP2 to ArcSDE 10.0: http://resources.arcgis.com/content/arcsde/10.0/oracle-system-requirements In the doc above I only see that the following platform is supported: Oracle 11g R2 (64-bit) 11.2.0.1 - Red Hat Enterprise Linux Server 5 (64-bit) Minimum OS version: Update 5. Maximum OS version: Update 5. We are only at RHEL 5.4 Server; So presumably we'll need to upgrade the OS to 5.5. So RHEL Server 5.5 is certified. But you're saying future updates could reasonably be expected to work? e.g. 5.6, 5.7, 5.8; but not RHEL Server 6.x? Oracle 11gR2 itself isn't even certified for RHEL Server 6 as far as I know. What concerns me more than the OS upgrade is support for Oracle 11.2.0.2. That's where we're at. And we were hoping to upgrade Oracle to 11.2.0.3.1. Is ArcSDE 10.0 certified for any Oracle release beyond 11.2.0.2? Just wanted to check if the URL I referenced has the most current info. Also, is the question of ArcSDE 10.0 platform support (e.g. RHEL Server 5.5+ with Oracle 11.2.0.3.1 better taken up with our local Esri rep?

‎03-08-2012

What is the current recommended way to move versioned feature classses having ST_GEOMETRY columns from one 11gR2 Oracle instance to another? Is this supported at all with datapump? The primary use case: developers want occassional data refreshes from production spatial data on another instance at the same Oracle/SDE version. Another use case might be for recovery. We have tried using datapump and had errors like the following for any FC with an ST_GEOMETRY column: ORA-31693: Table data object "<schema here>"."<feature class here>" failed to load/unload and is being skipped due to error: ORA-02354: error in exporting/importing data ORA-00600: internal error code, arguments: [kpudpxcs_ctxConvertStream_ref_1], [SYS_TYPEID("SHAPE")], [], [], [], [], [], [], [], [], [], [] We've used expdp and impdp in various ways and always get the same type of error above. We've tried: * Exported SDE and all data owner schemas in one expdp statement; then used impdp to import all schemas simultaneously with that dump file * Exported SDE and data owner schemas with separate expdp statements; then imported the SDE first and data owner schemas afterwards In a related thread from a year ago (where I'd asked about using datapump to go from a 10g to 11g instance), some suggested that datapump wasn't up to this sort of task; that there were too many dependencies like PUBLIC synonyms and various grants to PUBLIC, etc. Does that hold true for the 11.2.0.2 incarnation of datapump working with ArcSDE 9.3.1 SP2? We are using: Oracle version: 11.2.0.2 on RHEL 5.4 SDE version: 9.3.1 SP2 What options do we have considering ST_GEOMETRY is a "user defined" data type? It makes sense to me that the SDE schema should be imported first to get ST_GEOMETRY created; presuming the type lives in the SDE schema as it seems to. Here is an object count from the Oracle source instance: select owner, object_type, count(*) from dba_objects where owner = 'SDE' and object_type like '%TYPE%' group by owner, object_type order by object_type; OWNER OBJECT_TYPE COUNT(*) ------------------------------ ------------------- ---------- SDE INDEXTYPE 1 SDE TYPE 39 SDE TYPE BODY 24 After importing, the Oracle target instance has only 31 TYPEs under the SDE schema. It is missing the following 8. However, all %TYPE% objects that *did* import have a status of VALID. So again, here are objects that are valid on the source instance but missing on the target instance. Not sure datapump even complained about these. I noticed they all have subobject names: OWNER OBJECT_TYPE OBJECT_NAME SUBOBJECT_NAME STATUS ------------------------------ ------------------- ------------------------------ ----------------------------- SDE TYPE ST_DOMAIN_METHODS $VSN_4 VALID SDE TYPE ST_DOMAIN_METHODS $VSN_3 VALID SDE TYPE ST_DOMAIN_METHODS $VSN_2 VALID SDE TYPE ST_DOMAIN_METHODS $VSN_5 VALID SDE TYPE ST_DOMAIN_METHODS $VSN_1 VALID SDE TYPE ST_DOMAIN_STATS $VSN_3 VALID SDE TYPE ST_DOMAIN_STATS $VSN_2 VALID SDE TYPE ST_DOMAIN_STATS $VSN_1 VALID UPDATE: Would doing a datapump import of the SDE schema first (which has been error-free for us), creating public synonyms as recommended by the KB article below, *then* importing the data owner schemas be a good workaround? Or are we looking at having to use the full option in datapump to make things work? Exporting and importing an Oracle SDE schema does not include public synonyms http://support.esri.com/en/knowledgebase/techarticles/detail/34328

‎01-20-2012

Sparx Systems may be releasing a non-beta version of its ArcGIS profile (a UML profile of the geodatabase) to coincide with the official release of ArcGIS 10.1. So stay tuned: http://www.sparxsystems.com/arcgis

‎10-17-2011

Bugmenot, thanks for the excellent explanation.

‎09-01-2011

The geodatabase modeling and design requirements survey closes tomorrow (Wed) August 31st at 11:59pm Eastern US time. Thanks to those who've already participated. It's a user-driven survey I helped create in support of the Geodatabase Modeling and Design Special Interest Group (SIG) for Esri's 2011 International User Conference. I'd love to see more International representation. Most responses are from the US. Qualitative answers (text entries) are more valuable than quantitative ones (check boxes, etc). Please mention specific use cases and anything that would help in your daily work. Skip whatever isn't relevant. The survey isn't just for experts. It's for anyone who designs geodatabases. Of particular interest to me in designing the survey was integration of Enterprise GDB Design with Relational Database Design and the rest of Enterprise IT. A summary of survey results will be posted to my blog, http://SpatialDba.com, by October 31st. Direct survey link: http://spatialdba.com/limesurvey/index.php?sid=72916&lang=en A review of the 2011 SIG event can be found below. Hope to do another in 2012: A View of the Geodatabase Modeling and Design SIG Event at Esri�??s 2011 International User Conference http://spatialdba.com/?p=104 The survey has been extended by one day. It will now close today, Sept 1, at 5pm Eastern US time.

‎09-01-2011

The geodatabase modeling and design requirements survey closes tomorrow (Wed) August 31st at 11:59pm Eastern US time. Thanks to those who've already participated. It's a user-driven survey I helped create in support of the Geodatabase Modeling and Design Special Interest Group (SIG) for Esri's 2011 International User Conference. I'd love to see more International representation. Most responses are from the US. Qualitative answers (text entries) are more valuable than quantitative ones (check boxes, etc). Please mention specific use cases and anything that would help in your daily work. Skip whatever isn't relevant. The survey isn't just for experts. It's for anyone who designs geodatabases. Of particular interest to me in designing the survey was integration of Enterprise GDB Design with Relational Database Design and the rest of Enterprise IT. A summary of survey results will be posted to my blog, http://SpatialDba.com, by October 31st. Direct survey link: http://spatialdba.com/limesurvey/index.php?sid=72916&lang=en A review of the 2011 SIG event can be found below. Hope to do another in 2012: A View of the Geodatabase Modeling and Design SIG Event at Esri�??s 2011 International User Conference http://spatialdba.com/?p=104 The survey has been extended by one day. It will now close today, Sept 1, at 5pm Eastern US time.

Online Status	Offline
Date Last Visited	‎11-11-2020 02:23 AM

My Ideas

Latest Contributions by danan

Re: Best way to move versioned ST_GEOMETRY FCs between Oracle 11gR2 instances?

Re: Best way to move versioned ST_GEOMETRY FCs between Oracle 11gR2 instances?

Re: Best way to move versioned ST_GEOMETRY FCs between Oracle 11gR2 instances?

Re: ArcSDE 10 Oracle Database Requirements

Re: ArcSDE 10 Oracle Database Requirements

Re: Best way to move versioned ST_GEOMETRY FCs between Oracle 11gR2 instances?

Offer ArcGIS Server for Home / ArcSDE for Home educational-use programs

Re: Best way to move versioned ST_GEOMETRY FCs between Oracle 11gR2 instances?

Re: ArcSDE 10 Oracle Database Requirements

Re: ArcSDE 10 Oracle Database Requirements

Best way to move versioned ST_GEOMETRY FCs between Oracle 11gR2 instances?

Re: Integrate with Sparx Systems Enterprise Architect CASE tool for Geodatabase modeling

Re: Provide options for when to validate attribute data against domains, e.g. not just when explicitly requested

Re: Is it possible create annotation feature class with Case tool?

Re: Geodatabase Modeling and Design SIG and survey @ 2011 Int'l UC

Use low isolation map services to support more 4X ...

ArcGIS Server for Home / ArcSDE for Home use (in t...

Re: Best way to move versioned ST_GEOMETRY FCs bet...

Offer ArcGIS Server for Home / ArcSDE for Home edu...

Offer metered licensing for ArcGIS Server in the C...