Unable to authorize an expired enterprise geodatabase in Oracle if the geodatabase administrator password is about to expire.
上次发布: August 30, 2016ArcGIS for Desktop
漏洞 ID 编号
BUG-000098698
已提交
August 17, 2016
上次修改时间
January 27, 2021
适用范围
ArcGIS for Desktop
找到的版本
10.4.1
服务器平台
Windows
客户端平台
10
Version Fixed
10.5.0
状态
Fixed
此漏洞已得到修复。 有关详细信息,请参阅“版本修复”和“其他信息”(如果适用)。
解决办法
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>;