Is it possible to connect to an Oracle Database 12c from ArcMap 10.2.2 ?
I tried and Arcmap closed without any error message.
- Add database 12c addresse in the tnsnames.ora
- Arcmap > Gis Servers > Connect to my GIS server 10.2
- Server Properties > Datastore > Register Database 12c
- Ok => Arcmap closed
Thank you for help.
Oracle 12cR1 (22.214.171.124.x) support was added to ArcGIS at 10.2.1.
Esri support for Oracle 12cR2 (126.96.36.199.x) wasn't added until a recent patch to ArcGIS 10.5.1. It's unlikely 10.2.2, which will be the oldest supported build of ArcGIS next week, will work with Oracle 12cR2.
If you're using a supported configuration, you'll need to provide all the critical details:
As you are attempting to register the Oracle connection with Server as a registered data store you will also need to ensure that the machine where ArcGIS Server is installed has the ability to connect to the Oracle Database server / database as well. This will mean:
Hope this helps!
Hello Magaly- thanks for the follow-up and screenshots. Can you provide the full Oracle version and information as Vince mentioned above? We need to ensure this is a compatible release from which to register. Do you have ArcGIS Desktop or better yet ArcGIS Pro installed on the ArcGIS Server machine? If so can you connect via database connection from Pro or Desktop to the Oracle database (take server out of the equation)?
Oracle 12c R1 (64 bits) 188.8.131.52
No I don't have ArcGis Pro installer on the ArcGIS Server Machine.
I contacted the support. It may be user rigths into Oracle.
When we put the rights "dba" it works.
As it was a temporary solution before migration, we stop searching and will choose another solution. Thanks for the help.
Ultimately, it looks like this might come down to version incompatibility. It appears you are trying to connect / register using ArcMap 10.2.2 to a 184.108.40.206 Oracle geodatabase. Unfortunately, the highest supported version of Oracle at 10.2.2 was 220.127.116.11 as can be found here: System Requirements
The first version to support 18.104.22.168 Oracle connectivity would be 10.4 - so if possible you could attempt upgrading your Desktop / Server or downgrade Oracle to 22.214.171.124 and re-test. Hopefully, this is helpful!