Bug
Upgrading an Enterprise geodatabase using a database connection established with the traditional syntax for direct connections fails with error 'ORA-00933: SQL command not properly ended'
| Bug ID Number | NIM086410 |
|---|---|
| Submitted | November 9, 2012 |
| Last Modified | April 2, 2025 |
| Applies to | ArcSDE/Enterprise Geodatabase |
| Version found | 10.1 |
| Status | Will Not Be Addressed |
Additional Information
With the new connection dialog, the best practice is to directly user TNS name or easy connection string for the INSTANCE parameter.Workaround
Do not use the old syntax of sde:oracle11g:tnsname within the connection that is upgrading the geodatabase. Ensure that a new connection is established with one of the following: 1 - Make a connection to the Oracle geodatabase by typing only the TNSNAME in the 'Instance' textbox and the geodatabase will upgrade successfully.OR2 - Modify the sqlnet.ora file on the client machine to enable easy connect:NAMES.DIRECTORY_PATH= (TNSNAMES,EZCONNECT)Then connect to the geodatabase with the easy connect string (refer to ArcGIS 10.1 documentation) and upgrade the geodatabase.Steps to Reproduce
Bug ID: NIM086410
Software:
- ArcSDE/Enterprise Geodatabase
Get notified when the status of a bug changes
Discover more on this topic
Search for related information
Find training related to this topic
Explore ideas and give feedback
Get help from ArcGIS experts
Download the Esri Support App