topic Upgrading Oracle Client to 19c in Geodatabase Questions

Upgrading Oracle Client to 19c

Tony_J_Van_Der_Wielen — Wed, 07 Jul 2021 15:45:00 GMT

We are in the process of updating our Oracle 11g client to Oracle 19c on all our workstations and servers. Currently when we create an .sde connection file using our tnsnames alias the connections property reflects the Oracle 11g client.

sde:oracle11g:OD068

After uninstalling the 11g client and installing the 19c client and updating the PATH environment variable the connections seem to work with 19c, but the properties still reflect 11g.

Should the connection properties be updated?

If so what are the best steps to do so?

Re: Upgrading Oracle Client to 19c

George_Thompson — Wed, 07 Jul 2021 16:32:24 GMT

If you are putting just the TNS name (OD068) in the Instance field, you should be good.

I know in previous releases, that it appended the "sde:oracle11g:" to the TNS name entered (legacy thing). I do not remember there being any issues per se, but that was a few years ago and pre-19C.

Re: Upgrading Oracle Client to 19c

MichaelVolz — Wed, 07 Jul 2021 18:51:50 GMT

You should be fine with the sde:oracle11g in the connection string. My org did thorough testing in this area and SDE data still works as expected.