ORA-28001: vypršela platnost hesla (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 Oracle<oracle_home_name>DBConsole
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 Oracle<oracle_home_name>DBConsole
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 <new_password> ;
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 Oracle<oracle_home_name>DBConsole
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
Ensure that ORACLE_HOME is set to the correct home1. Stop the standalone dbconsoleon Unix$ emctl stop dbconsoleon WindowsStop the Windows Service Oracle<oracle_home_name>DBConsoleOrOpen a DOS Command Window and typeC> emctl stop dbconsole2. Check that the standalone dbconsole is stoppedon Unix$ emctl status dbconsoleon WindowsCheck the status of the Windows Service Oracle<oracle_home_name>DBConsoleOrOpen a DOS Command Window and typeC> emctl status dbconsole3. Connect to the database as a user with DBA privilege with SQL*Plus and executeSQL> alter user sysman identified by <new_password> ;4. Check the new passwordSQL> connect sysman/<new_password>[@database_alias]5. Go to $ORACLE_HOME/host_sid/sysman/config5.1 Save the file emoms.properties to emoms.properties.orig5.2 Edit the file emoms.propertiesa. Search for the line beginning with:oracle.sysman.eml.mntr.emdRepPwd=Replace the encrypted value by the new password valueb. Search for the line:oracle.sysman.eml.mntr.emdRepPwdEncrypted=TRUEReplace TRUE by FALSE6. Restart the standalone dbconsoleon Unix$ emctl start dbconsoleon WindowsStart the Windows Service Oracle<oracle_home_name>DBConsoleOrOpen a DOS Command Window and typeC> emctl start dbconsole7. Check that the password has been encryptedEdit the file emoms.properties7.1 Search for the line beginning with:oracle.sysman.eml.mntr.emdRepPwd=Check that the password is encrypted7.2 Search for the line beginning with:oracle.sysman.eml.mntr.emdRepPwdEncrypted=Check that the value is TRUE