topic Re: ArcSDE and Oracle 11.2.03 in Data Management Questions

ArcSDE and Oracle 11.2.03

Anonymous User — Mon, 01 Apr 2013 21:14:04 GMT

Hello! I see in the documentation that Oracle 11.2.03 is not compatible with ArcSDE. Does anyone have any details about this? Our IT upgraded their Oracle, and we're looking for a way to support them. Our GIS is in SQL Server, and in the past, we have replicated some datasets to Oracle for their use. Looks like they may be out of luck... any input is welcome. Thanks!

Re: ArcSDE and Oracle 11.2.03

VinceAngelo — Mon, 01 Apr 2013 21:21:03 GMT

How did you determine that Oracle 11.2.0.3 was "not compatible" with ArcGIS?

- V

Re: ArcSDE and Oracle 11.2.03

Anonymous User — Mon, 01 Apr 2013 21:23:15 GMT

The Oracle ArcSDE requirements omit reference to 11.2.03, mentioning up only to a known bug with 11.2.02. I think "not supported" would be a better choice of words on my part.

http://resources.arcgis.com/content/arcsde/10.0/oracle-system-requirements

Re: ArcSDE and Oracle 11.2.03

VinceAngelo — Mon, 01 Apr 2013 21:47:48 GMT

Even "not supported" is too strong. "Not certified" is the correct designation, which
means that extensive certification testing was not performed. The requirements
page links to the supported environment policy page.

- V

Re: ArcSDE and Oracle 11.2.03

Anonymous User — Mon, 01 Apr 2013 21:53:02 GMT

I see, thanks. Well, then this has become a different post. Upon attempting to install SDE on Oracle 11.2.03, we receive an error (attached) which seemed to support the theory. ArcSDE is at version 10, SP 3.

Re: ArcSDE and Oracle 11.2.03

VinceAngelo — Mon, 01 Apr 2013 23:26:26 GMT

That error message has nothing to do with Oracle release. It refers to the
geodatabase itself. What version of ArcSDE is installed in the database?

- V

Re: ArcSDE and Oracle 11.2.03

Anonymous User — Tue, 02 Apr 2013 13:24:21 GMT

ArcSDE is at version 10, SP 3. In researching the error message, I find the common theme is an incompatibility between the ArcSDE version and the ArcCatalog version. That is not the case here. So it didn't seem like too much of a stretch to suppose the Oracle client could be causing a similar error. Thanks for the interest; I'm up to give anything a shot.

Re: ArcSDE and Oracle 11.2.03

VinceAngelo — Tue, 02 Apr 2013 13:35:20 GMT

What Oracle release had IT been using before installing 11.2.0.3? If it was 10gR2,
then an upgrade would still be necessary.

BTW: There isn't much call for 10.0 SP3 when SP5 is current and SP4 would permit
10.1 interoperability.

- V

Re: ArcSDE and Oracle 11.2.03

Anonymous User — Tue, 02 Apr 2013 16:41:53 GMT

Prior to 11.2.0.3, IT was on 10.2.0.3. Thank you for the tip on versions; SP4 introduced a bug we couldn't live with, SP5 fixed it, but we're waiting for IT to have time to push the update to our clients before we schedule the databases.

Re: ArcSDE and Oracle 11.2.03

VinceAngelo — Tue, 02 Apr 2013 17:08:31 GMT

So there is room to upgrade -- You need to execute geodatabase upgrade procedure (via
ArcCatalog or Python) using an 11g client (as SDE, with the necessary permissions) to install
the 11g geodatabase stored procedures.

- V

Re: ArcSDE and Oracle 11.2.03

Anonymous User — Tue, 02 Apr 2013 20:00:08 GMT

Do you offer that info simply as a recommendation, or are you also suggesting it is related to the error I reported in my initial post?

Re: ArcSDE and Oracle 11.2.03

VinceAngelo — Tue, 02 Apr 2013 20:20:25 GMT

I expect that an upgrade will be your solution. ArcGIS may occasionally forget that
an upgrade is necessary, but I've never seen it erroneously request one.

- V

Re: ArcSDE and Oracle 11.2.03

Anonymous User — Tue, 02 Apr 2013 20:29:56 GMT

Thanks for your time; I appreciate the insight!

Re: ArcSDE and Oracle 11.2.03

VinceAngelo — Tue, 02 Apr 2013 20:46:51 GMT

I just realized it might not be perfertly clear that I'm recommending you upgrade
the "10.0 SP3 (Oracle 10g)" geodatabase to "10.0 SP3 (Oracle 11g)".

- V

Re: ArcSDE and Oracle 11.2.03

Anonymous User — Wed, 03 Apr 2013 13:34:52 GMT

Yes, thanks; that is what I understood you to suggest. I will update the thread once I have completed the upgrade; I'm waiting on my DBA to migrate the st_geometry library, then I will ask him to grant the SDE user the necessary privileges. Update soon [hopefully]. Thanks again!

Re: ArcSDE and Oracle 11.2.03

DavidSwenson — Wed, 03 Apr 2013 21:30:04 GMT

Just to get back to the original question and make sure it is answered for others that might find this thread.

We build ArcSDE on specific platform and DBMS combinations. We often certify certain higher DBMS releases. For example we build on Oracle 11.1.0.7.0 and certify Oracle 11.2.0.1.0. You can find our support policy on higher versions of Oracle releases and patches if you scroll down the System Requirements web page to "Oracle database patch support". We do not test every DBMS patch and minor release. Oracle 11.2.0.2.0 and 11.2.0.3.0 are considered patches of Oracle 11.2.0.1.0 and not significant releases. On very rare occasions problems will be identified with a DBMS patch and ArcSDE. When this happens we work with the customer and/or the DBMS manufacturer to resolve the problem.

--David