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, 2014No Product Found
Bug ID Number
NIM079768
Submitted
April 6, 2012
Last Modified
June 5, 2024
Applies to
No Product Found
Version found
10.1
Version Fixed
N/A
Status
Fixed
The bug has been fixed. See the Version Fixed and Additional Information, if applicable, for more information.
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.