emctl 提示 ora-28001 口令已经实效 解决方法
日期：2014-05-16 浏览次数：20507 次
emctl 提示 ora-28001 口令已经实效 解决办法
What to do when Enterprise Manager is not able to connect to
the database instance (ORA-28001)
the database instance (ORA-28001)
出处：http://blog.csdn.net/tgflf/archive/2009/08/06/4418885.aspx
If you are trying to connect to the Oracle enterprise Manger and you get the following errors:
Enterprise Manager is not able to connect to the database instance.
And in t
Enterprise Manager is not able to connect to the database instance.
Enterprise Manager is not able to connect to the database instance.
And in the “Agent connection to instance” section:
Status: Failed
Details: ORA-28001: the password has expired (DBD ERROR: OCISessionBegin)
Details: ORA-28001: the password has expired (DBD ERROR: OCISessionBegin)
One of the reasons could be that the password for the SYSMAN user is expired. However, changing the password alone will not solve this issue. Several additional steps are required in order to make Oracle Enterprise Manager connect:
Before you start: Verify that ORACLE_HOME, ORACLE_SID environment variables are set. – If not, set them using as? environment variables or open a command line and type SET ORACLE_SID=<The database SID>
1. Stop the dbconsole: emctl stop dbconsole (dos and Unix) or? using the windows services stop the OrcleDBConsole<The database SID>.
2. Connect to the database as a user with DBA privilege with SQL*Plus
and run the following command:
and run the following command:
alter user sysman identified by <the new password> ;
3. Verify that the new password works
SQL> connect sysman/<the new password>
SQL> connect sysman/<the new password>
4. Go to ORACLE_HOME/<HostName_SID>/sysman/config and save a backup of the emoms.properties file.
a) Open the file emoms.properties and search for:
oracle.sysman.eml.mntr.emdRepPwd= <some encrypted value>
oracle.sysman.eml.mntr.emdRepPwd= <some encrypted value>
Replace the encrypted value with the new password value
b) Search for oracle.sysman.eml.mntr.emdRepPwdEncrypted=TRUE
and change TRUE to FALSE
and change TRUE to FALSE
c) Save and close emoms.properties
5. Restart the dbconsole:
emctl start dbconsole (dos and Unix) or? using the windows services start the OrcleDBConsole<The database SID>.
6. Open? emoms.properties again and Search for:
a)oracle.sysman.eml.mntr.emdRepPwd=
verify? that the password is encrypted
a)oracle.sysman.eml.mntr.emdRepPwd=
verify? that the password is encrypted
b) oracle.sysman.eml.mntr.emdRepPwdEncrypted=
verify? that the value is set to? TRUE
verify? that the value is set to? TRUE
7. Refresh Oracle Enterprise Manager
免责声明： 本文仅代表作者个人观点，与爱易网无关。其原创性以及文中陈述文字和内容未经本站证实，对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺，请读者仅作参考，并请自行核实相关内容。
