laptop and a wrench

Bug

Unable to authorize an expired enterprise geodatabase in Oracle if the geodatabase administrator password is about to expire.

Last Published: August 30, 2016 ArcGIS for Desktop
Bug ID Number BUG-000098698
SubmittedAugust 17, 2016
Last ModifiedJune 5, 2024
Applies toArcGIS for Desktop
Version found10.4.1
Operating SystemWindows OS
Operating System Version10.0
Version Fixed10.5.0
StatusFixed

Workaround

Workaround 1: Change the geodatabase administrator (SDE) password through SQL*PLUS: Alter user SDE identified by <PASSWORD>; Workaround 2: To prevent this from reoccurring, set the profile to have an UNLIMITED PASSWORD_LIFE_TIME and UNLIMITED PASSWORD_GRACE_TIME in SQL*PLUS while connected as sys or system: SELECT PROFILE FROM dba_users WHERE username = 'SDE'; Use the profile returned from executing the above query in place of the <PROFILE> in the following queries: ALTER PROFILE <PROFILE> limit password_life_time UNLIMITED; ALTER PROFILE <PROFILE> limit password_grace_time UNLIMITED; ALTER USER <USER name> IDENTIFIED BY <password>;

Steps to Reproduce

Bug ID: BUG-000098698

Software:

  • ArcGIS for Desktop

Get notified when the status of a bug changes

Download the Esri Support App

Discover more on this topic

Esri Community

Search for related information

Training

Find training related to this topic

ArcGIS Ideas

Explore ideas and give feedback

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options