@forestknutsen1 - if ArcGIS is not changing, then there is no need to recreate the connection files
A. once you are using TNSNAMES as you pointed out then you will not need to edit any of the geodatabase connection files and they will work just fine to connect to the geodatabases on the new oracle server as you mentioned yourself, hence there is no need to recreate any of the geodatabase connection files.
or
(B) and (C) below apply if using Easy Connect Syntax and not using TNSNAMES in the geodatabase connection files
B. create new geodatabase connection files that point to the geodatabases on the new oracle server
or
C. make a copy of the old geodatabase connection files and manually edit each one of them to point to the geodatabases on the new oracle server
Note: if using ArcGIS Server and there are services published that connect to the geodatabases in the Oracle Server with Easy Connect Syntax, then those service will break and will need to be republished, now if you used TNSNAMES to publish the ArcGIS Server services then everything will continue to work as expected as well.
| Marcelo Marques | Principal Product Engineer | Esri |
| Cloud & Database Administrator | OCP - Oracle Certified Professional |
I work with Enterprise Geodatabases since 1997.
“ I do not fear computers. I fear the lack of them." Isaac Isimov