topic Re: ArcSDE in Oracle 12c ... anyone ... anyone ... in Data Management Questions

ArcSDE in Oracle 12c ... anyone ... anyone ...

RicaSaporta — Mon, 23 Sep 2013 12:11:12 GMT

Hello all,
we are currently using ArcSDE in Oracle 11g R2 environment.
We have been able to convert most of our connections to 'direct connect' with a goal to removing all 'application connections' where possible.
Our DBAs are now looking at moving to Oracle 12c on all of our databases.
Does anyone know what impact this will have to the ArcSDE? and/or any impact to the connections associated with it?
Is SDE supported on Oracle 12c?

I can not find any discussion on this at this time ... so can we please start one?

thank you
rica

Re: ArcSDE in Oracle 12c ... anyone ... anyone ...

MichaelVolz — Mon, 23 Sep 2013 12:37:17 GMT

Rica:

Do you know how long Oracle 12c has been out in the market place as a production product (non-beta)?

Re: ArcSDE in Oracle 12c ... anyone ... anyone ...

NidhinKarthikeyan — Mon, 23 Sep 2013 14:29:14 GMT

Rica,

ArcSDE 10.2 is not compatible with Oracle 12g.

Oracle database requirements for ArcGIS 10.2

Regards,

Re: ArcSDE in Oracle 12c ... anyone ... anyone ...

MuhammadImran2 — Mon, 23 Sep 2013 15:13:11 GMT

Usually ArcSDE is not forward compatible if newer behavior has been introduced in new version of geodatabase. So hopefully previous versions of ArcSDE are not compatible with Oracle 12C.

Re: ArcSDE in Oracle 12c ... anyone ... anyone ...

RicaSaporta — Tue, 24 Sep 2013 12:00:15 GMT

I have looked at the forums and help file and noted that 12c, in fact any Oracle 12 version, is not mentioned at all. This is why I posted this question.
Oracle 12c was released (full not beta) on July 1, 2013. One of the reasons we are looking at it is its ability to handle "multitenants" databases.

has anyone tried this or has an inkling of what support may be available?
thank you
rica

Re: ArcSDE in Oracle 12c ... anyone ... anyone ...

MichaelVolz — Tue, 24 Sep 2013 12:14:27 GMT

Does anyone from ESRI have a tentative idea of when Oracle 12c will be supported for ArcSDE?

Re: ArcSDE in Oracle 12c ... anyone ... anyone ...

VinceAngelo — Tue, 24 Sep 2013 13:06:33 GMT

While it's likely that 12c support will be added as soon as possible, Oracle only
released a Windows version of 12c in the past couple of weeks, and hasn't yet
released on all the platforms that Esri usually supports. I expect* it will be a
while yet for development and testing (and certification, which is likely the
hardest step) to be completed.

- V

* Disclaimer: I don't work in Development, and I have no direct knowledge of
the development or release schedule.

Re: ArcSDE in Oracle 12c ... anyone ... anyone ...

ForrestJones — Tue, 24 Sep 2013 15:52:23 GMT

Hi all,

Oracle 12c support is planned for ArcGIS 10.2.1.

Re: ArcSDE in Oracle 12c ... anyone ... anyone ...

MichaelVolz — Tue, 24 Sep 2013 15:55:03 GMT

FJ:

Is that service pack 1 for ArcGIS 10.2 which can be installed over 10.2? Or will this require an uninstall process?

Re: ArcSDE in Oracle 12c ... anyone ... anyone ...

ForrestJones — Tue, 24 Sep 2013 16:54:05 GMT

Hi Michael,

ArcGIS 10.2.1 can be installed on a machine with ArcGIS 10.2 already and it will replace 10.2.

Re: ArcSDE in Oracle 12c ... anyone ... anyone ...

MichaelVolz — Tue, 24 Sep 2013 17:00:28 GMT

Would you have a ballpark idea of when ArcGIS 10.2.1 will be released (e.g. 6 months from now)?

Re: ArcSDE in Oracle 12c ... anyone ... anyone ...

MelitaKennedy — Tue, 24 Sep 2013 18:57:23 GMT

Not an "official Esri" statement and I always feel nervous doing this. However, I found statement about the 10.2.1 release schedule in the UC2013 Q&A: What is version 11, is that the next ArcGIS release?

It says "end of 2013" for 10.2.1. Based on the current internal schedule and what I know about where we are in the release process, we're still on track.

Re: ArcSDE in Oracle 12c ... anyone ... anyone ...

GerardVidrine — Wed, 22 Jan 2014 17:37:44 GMT

FYI...

We have migrated our Ora11g/SDE 10.1 database up to Ora12c/Sde 10.2.1 successfully. And all of our 10.2.1 clients connect fine. But we have found that even though the documentation shows that 10.1/10.2 clients can connect to 10.2.1 geodatabase, that will not work if that database is stored in 12c... I am trying different combinations of instantclients/full clients to see if I can make that work, but so far it hasn't worked. Also, our AGS Servers are not connecting either (I would assume that same version issues are happening here as well...)

Re: ArcSDE in Oracle 12c ... anyone ... anyone ...

ForrestJones — Wed, 22 Jan 2014 17:44:41 GMT

Hi Gerard,

12c support starts at 10.2.1. You must have a 10.2.1 client in order to connect to 12c.

See:

10.2.1 system requirements for Oracle

Re: ArcSDE in Oracle 12c ... anyone ... anyone ...

VinceAngelo — Wed, 22 Jan 2014 21:29:14 GMT

Forward compatibility in geodatabases is only supported if the RDBMS is also supported at the
older release. 10.2.0 and 10.1.x clients cannot connect to Oracle 12c.

- V

Re: ArcSDE in Oracle 12c ... anyone ... anyone ...

JamesFox1 — Fri, 14 Feb 2014 15:22:22 GMT

The 12c now has two types of databases; a "container" database (CDB) to manage the system resources of the relational database "instance" (memory and processes, analogous to SYSTEM in a SQL Server environment) with the actual business table databases now being "pluggable" databases (PDBs) which can be individaully swapped in and out the instance environment(analogous to the USE {DB} in a SQL Serevr environment) which should prove to be an enhancement for many of the large data cloud environments that are growing today.

That said, however the new Oracle 12c multi-tenancy database architecture has enhanced the user and role security along those same lines. A "common" user can only be defined in a container but has access to objects in any of it's pluggable databases however a local user defined in a pluggable database does not have the same access to the container objects with individual roles defined for each.

Since ArcGIS relies heavily on databases roles and system priviledges for management of it's GIS metadata, I would not try a 12c database on any version of ArcGIS that ESRI has not CERTIFIED AS COMPATABLE with this type of database architecture.

-Jim

Re: ArcSDE in Oracle 12c ... anyone ... anyone ...

SherrieKubis — Fri, 01 Aug 2014 13:56:41 GMT

We are upgrading Oracle from 11.1.0.7 to 12.1.0.4 (or the latest when we get there), as well as our SDE to ArcGIS 10.1 SP1.

The reason for moving to Oracle 12c is that Oracle 11.2 premium support ends Jan 2015, it will take us that long to get there.

Our new database servers are beefy, making Oracle 12c multitenancy a good fit.

I need time to put my hands on these latest versions, from the onset I can't see how SDE would work at the container level, but perhaps it would work from the pluggable level. Or maybe there would be a way to make it work. We use roles extensively in our current SDE management with one data owner. The concept of one data owner with versioned geodatabases needs to change with SDE 10.1 prompting a rearchitecture of how we have been doing GIS database business anyway. The only certainty is change I guess.

Has anyone implemented SDE with Oracle 12c? What are you experiences?

Re: ArcSDE in Oracle 12c ... anyone ... anyone ...

VinceAngelo — Fri, 01 Aug 2014 14:09:55 GMT

Oracle 12c support in ArcGIS was introduced at 10.2.1, and only at the pluggable database level.
I doubt you could make ArcSDE 10.1sp1 function with Oracle 12c.

- V

Re: ArcSDE in Oracle 12c ... anyone ... anyone ...

SherrieKubis — Fri, 01 Aug 2014 16:05:31 GMT

Thanks Vince.

I was mistaken, we are going to ArcGIS 10.2 at the latest SP when we get there.

I was behind the time on the planning.

I suspected that SDE wouldn't work at the CDB, but only at the PDB.

Re: ArcSDE in Oracle 12c ... anyone ... anyone ...

VinceAngelo — Fri, 01 Aug 2014 16:20:44 GMT

No promises, of course, but It seems likely that Esri would try to leverage multiple database containers with a future enterprise geodatabase implementation within Oracle 12c+, as supported in other RDBMS solutions with multiple independent databases.

- V