ArcMap 10.6.1 ORA-0933

[AshrafMousa]

Connecting to Oracle From ArcMap 10.6.1 Give ORA-0933

Recently we upgraded to ArcGIS 10.6.1 and migrated our Oracle client to 12c R1, now when I am trying to create a new connection using ArcMap or ArcCatalog I am getting ORA-0933 Error (command not properly ended).

I am able to connect using the cmd but not using the Add Connection of ArcMap / ArcCatalog.

Is this a bug in 10.6.1? Is there any solution or workaround for this?

[ThomasNoble]

Hi Ashraf,

You might be encountering the following bug: BUG-000115420: The following error message, "Failed to connect. ORA.. 

The suggested workaround is to grant CREATE TABLE and CREATE SESSION privileges to the user from Oracle database.

If the workaround doesn't resolve the pragmatic behavior, please give Esri Technical Support a call at 1-(888)-377-4575 and choose option 2. You can also visit our website to request a case or begin a live chat: https://support.esri.com/en/contact-tech-support

Best Regards,

Thomas

[JariSiiskonen]

Patch: ArcGIS (Desktop, Engine, Server) 10.6.1 Support for Oracle 18c Patch 

[MichaelVolz]

Is Oracle client 12c R1 equivalent to Oracle 18c?  It's very confusing with this new updated naming convention that has two different numbers.

[JariSiiskonen]

Yes, the patch fixes connection to Oracle 11.2 and 12.x and adds support for connection to new 18.