Wednesday, September 7, 2011

Details: ORA-28001: the password has expired (DBD ERROR: OCISessionBegin)

Ensure that ORACLE_HOME is set to the correct home 1. Stop the standalone dbconsole on Unix $ emctl stop dbconsole on Windows Stop the Windows Service OracleDBConsole Or Open a DOS Command Window and type C> emctl stop dbconsole 2. Check that the standalone dbconsole is stopped on Unix $ emctl status dbconsole on Windows Check the status of the Windows Service OracleDBConsole Or Open a DOS Command Window and type C> emctl status dbconsole 3. Connect to the database as a user with DBA privilege with SQL*Plus and execute SQL> alter user sysman identified by ; 4. Check the new password SQL> connect sysman/[@database_alias] 5. Go to $ORACLE_HOME/host_sid/sysman/config 5.1 Save the file emoms.properties to emoms.properties.orig 5.2 Edit the file emoms.properties a. Search for the line beginning with: oracle.sysman.eml.mntr.emdRepPwd= Replace the encrypted value by the new password value b. Search for the line: oracle.sysman.eml.mntr.emdRepPwdEncrypted=TRUE Replace TRUE by FALSE 6. Restart the standalone dbconsole on Unix $ emctl start dbconsole on Windows Start the Windows Service OracleDBConsole Or Open a DOS Command Window and type C> emctl start dbconsole 7. Check that the password has been encrypted Edit the file emoms.properties 7.1 Search for the line beginning with: oracle.sysman.eml.mntr.emdRepPwd= Check that the password is encrypted 7.2 Search for the line beginning with: oracle.sysman.eml.mntr.emdRepPwdEncrypted= Check that the value is TRUE BY DBMS Direct

No comments: