laptop and a wrench

Bogue

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

Dernière publication: August 30, 2016 ArcGIS for Desktop
Numéro d’ID de bogue BUG-000098698
EnvoiAugust 17, 2016
Dernière modificationJanuary 27, 2021
S’applique àArcGIS for Desktop
Version trouvée10.4.1
Plateforme serveurWindows
Plateforme client10
Version Fixed10.5.0
StatutFixed

Solution de contournement

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>;

Étapes pour reproduire

ID de bogue: BUG-000098698

Logiciel:

  • ArcGIS for Desktop

Obtenir de l’aide auprès des experts ArcGIS

Contacter le support technique

Télécharger l’application Esri Support

Accéder aux options de téléchargement

En savoir plus sur ce sujet

Esri Community

Rechercher des informations associées

Formation

Rechercher une formation sur ce sujet

ArcGIS Ideas

Explorer des pistes et donner un avis