laptop and a wrench

Bug

Upgrading the Oracle geodatabase causes crashes if the total length of the SDE user password and connection string is more than 32 characters.

Last Published: August 25, 2014 No Product Found
Bug ID Number NIM079768
SubmittedApril 6, 2012
Last ModifiedJune 5, 2024
Applies toNo Product Found
Version found10.1
Version FixedN/A
StatusFixed

Description

When trying to upgrade an Oracle Enterprise geodatabase to 10.0 or 10.1 through a connection that uses a long Oracle easy connection string, the upgrade may crash during the geodatabase schema update.

Cause

There is an internal string length limitation that the total length of the user password and the connection string, in combination, must be less than 31 characters. When the total length of the password and the connection exceeds this limitation, upgrade may crash due to a memory corruption.

This issue is planned to be addressed at 10.0 SP5 and 10.1 SP1.

Workaround

Create a TNS entry with a shorter length for the Oracle instance, and use the TNS entry for the geodatabase connection to perform the upgrade. Also, if needed, use a shorter password.

    Steps to Reproduce

    Bug ID: NIM079768

    Software:

    • No Product Found

    Get notified when the status of a bug changes

    Download the Esri Support App

    Related Information

    Discover more on this topic

    Get help from ArcGIS experts

    Contact technical support

    Download the Esri Support App

    Go to download options