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

[ForrestJones]

Yes - if you use the old tnsnames connection syntax. This does not mean that oracle 11g is being used to connect though and you don't have to provide the "sde:oracle11g", just the instance "Dev" in your case. Adding "sde:oracle12c" is incorrect and is expected to fail. The easiest and best solution is to just use the newer syntax of "server/orainstance" (or another valid easy connect syntax detailed in the help: Database connections in ArcMap—Help | ArcGIS Desktop ).

[ForrestJones]

Hi Michael, will you try connecting using the ez connect syntax, please? Make sure on the server you are connecting to the sqlnet.ora file has EZCONNECT specified within the NAMES.DIRECTORY_PATH parameter, and then use server/servicename in the instance parameter. See this blog post by Melissa Jarman‌: Easy Connect – Connecting to ArcSDE just got easier!

Does this work for you?

[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 

[MichaelVolz]

James:

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