nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

RicaSaporta

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

Finde mehr Beiträge mit dem Tag

Accepted answers

All comments

Asrujit_SenGupta

It doesn't seem so: Oracle database requirements for ArcGIS 10.2.x

Supported database versions
Standard/Standard One/Enterprise Editions:
Oracle 10g R2 (64-bit) 10.2.0.3
Oracle 11g R1 (64-bit) 11.1.0.7 (see note below)
Oracle 11g R2 (64-bit) 11.2.0.1 (see note below)
Oracle 11g R2 (64-bit) 11.2.0.3 (see note below)
Oracle 12c R1 (64-bit) 12.1.0.1 (see note below)

Also check this thread: ArcMap 10.2.2 Oracle 12c : Crash

Support for Oracle 12c R2 seems to have started from ArcGIS 10.5.x : Oracle database requirements for ArcGIS 10.5.x—System Requirements | ArcGIS Desktop

MeenaShankar

Please let me know whether ArcGIS 10.2.1 supports Oralce 12c R2

mvolz47

James:

Can you provide a screenshot of what your Oracle SDE connection properties look like in ArcCatalog, specifically the Instance that is saved?

mvolz47

Forrest:

I built a new 64-bit Windows 2012 Server server with ArcGIS Desktop 10.5.1 that will perform all of my organization's GIS scheduled tasks. I initially installed a 32-bit Oracle 11g Client on the machine to see if tasks copied over from a server with ArcGIS Desktop 10.3.1 would still work if I updated necessary items to point to 10.5.1 objects (python reference) and the scheduled tasks still ran successfully against an Oracle 11g SDE database. I used the same tnsadmin file that was on the current 64-bit Windows 2008 Server with ArcGIS Desktop 10.3.1.

The SDE database was upgraded to Oracle 12c, so I added a 32-bit Oracle 12c Client on the machine making sure that the 12c client was specified first in the PATH environmental variable. I updated the tnsadmin file on the new 64-bit Windows 2012 Server with ArcGIS Desktop 10.5.1 to point to the Oracle 12c SDE database. When I created a new database connection I only added the database instance name (e.g. Dev) to the Instance portion of the Database Connection dialog box. After the connection file was successfully created, I opened up the Database Connection dialog box and sde:oracle11g was added to the Instance so it looked like sde:oracle11g:Dev even though the Oracle 12c Client was referenced first in the PATH environmental variable.

I then tried to explicitly create a new SDE connection with the Instance being sde:oracle12c:Dev, but I received the following error:

"Failed to connect to the specified server. Do you want to continue? Underlying DBMS error[ORA-12154: TNS: could not resolve the connect identifier specifiedNo extended error.]"

I then removed the reference to the Oracle 11g SDE database in the tnsadmin file. When I created a SDE connection with Instance = Dev it still added the sde:oracle11g: to the Instance name and I was able to connect to the database even though only the Oracle 12c SDE database. If I added the sde:oracle12c explicitly to the Instance Name of a SDE connection file, the connection still failed.

So why is ArcCatalog/Desktop holding onto sde:oracle11g and won't even let me add sde:oracle12c explicitly to the Instance Name of a SDE connection file?

JamesFox1

We replaced our 11.2 client with 12.1 client and it works fine, aside from some squirrel-ly PL/SQL syntax nuances we had to fix (object arrays)

-Jim

ForrestJones

Hi Michael. A few questions:

-what error do you receive?

-are you trying to connect with ArcGIS desktop or Pro,etc. and what version e.g. 10.2.1 do you have

-Is the oracle instant client 12.1.0.1 32-bit or admin client 64-bit etc.?

mvolz47

Has anyone gotten the 12c Client to work on a machine where the 11g client also exists? I ask because I have both clients on the same machine with the 12c client first, but I am getting an error when trying to make a connection with the 12c client (No problem with the 11g client which was installed first and worked without issue).

shafitrumboo

Rica Saporta‌ I want to know what you finally did as I have to also migrate from 11g to 12c. Since in 12c we have multitenant architecture.

JohnBaleja

Oracle 12c was released in July 2013 on Oracle Solaris and Oracle
Linux. So the earliest we began supporting 12c was ArcGIS 10.2.1 Here is the link to the 10.2.x System Requirements page for Oracle:

‌

System Requirements

Here was the GA press release for 12c R1 if you’re interested.

http://www.oracle.com/us/corporate/press/1967380?utm_source=rss&utm_medium=rss&utm_campaign=oracle-announces-general-availability-of-oracle-database-12c-the-first-database-designed-for-the

SherrieKubis

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.

VinceAngelo

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

SherrieKubis

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?

JamesFox1

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

VinceAngelo

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

ForrestJones

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

GerardVidrine

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...)

MelitaKennedy

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.

mvolz47

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

ForrestJones

Hi Michael,

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

mvolz47

FJ:

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

ForrestJones

Hi all,

Oracle 12c support is planned for ArcGIS 10.2.1.

VinceAngelo

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.

mvolz47

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

RicaSaporta

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

MuhammadImran2

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.

NidhinKarthikeyan

Rica,

ArcSDE 10.2 is not compatible with Oracle 12g.

Oracle database requirements for ArcGIS 10.2

Regards,

mvolz47

Rica:

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

Nimm an der Unterhaltung teil

Angemeldete Mitglieder können Beiträge verfassen, Updates folgen und mehr. Neu hier? Registriere ein kostenloses Konto.

Schnellzugriffe

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.