English
Bug Number BUG-000098698
Submitted Aug 17, 2016
Modified May 04, 2020
Severity Medium
Applies To ArcSDE/Enterprise Geodatabase
Version Found 10.4.1
Prog Language N/A
Server Platform Windows 10.0
Client Platform Windows 10.0
Database Oracle
Locale N/A
Status Implemented
Version Fixed 10.5.0
SP Fixed 10.5 Approved

Bug BUG-000098698

Synopsis

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


Additional Information

N/A


Alternate Solution

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