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 ModifiedJanuary 27, 2021
Applies toArcGIS for Desktop
Version found10.4.1
Operating SystemWindows
Operating System Version10
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 help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Discover more on this topic