1.Oracle创建后默认用户密码180天超期。查看方式select * from dba_profiles where profile= 'DEFAULT'and resource_name='PASSWORD_LIFE_TIME'; 修改为用不超期 ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED; 2.查询过期用户 select * from dba_users; 激活过期用户 alter user xxx identified by yyyy; alter user sysman account unlock; 3.重启过期用户的相关服务 1)gis (sde、gtgis、onemapgis) 重启 ArcSde、ArcGisServeer 2)oracle em (sysman、dbsnmp) 重启em (注意如果不确定em用户密码是否与原来一致,参考下面em修改密码) 3)资源生成器、studio运行期(bizmodel 、gtruntime、gtspace) 修改sysman密码的步骤 1) emctl stop dbconsole 2) alter user sysman identified by newpass; 3) 修改$ORACLE_HOME/host_sid/sysman/config下emoms.properties文件 oracle.sysman.eml.mntr.emdRepPwd=新的密码 oracle.sysman.eml.mntr.emdRepPwdEncrypted=FALSE 5) emctl start dbconsole [size=13.3333px] 修改dbnsmp密码的步骤 1)emctl stop dbconsole 2)alter user dbsnmp identified by <new_password> ; 3)修改文件$ORACLE_HOME/host_sid/sysman/emd/targets.xml <Property NAME="password" VALUE="<encrypted_string>" ENCRYPTED="TRUE"/> 修改为 <Property NAME="password" VALUE="<new_password>" ENCRYPTED="FALSE"/> 4)emctl start dbconsole |
|