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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment