ALTER PROFILE DEFAULT LIMIT FAILED_LOGIN_ATTEMPTS UNLIMITED PASSWORD_LIFE_TIME UNLIMITED;
martes, 27 de abril de 2010
¡Me salvo el trabajo!
Estas instrucciones me ayudaron a resolver el problema de contraseña vencida del sysman, cuenta con la que se puede accesar a la consola del oracle
Ensure that ORACLE_HOME is set to the correct home
- 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 - 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 - Connect to the database as a user with DBA privilege with SQL*Plus and execute
SQL> alter user sysman identified by <new_password> ; - Check the new password
SQL> connect sysman/<new_password>[@database_alias] - Go to $ORACLE_HOME/host_sid/sysman/config
- Save the file emoms.properties to emoms.properties.orig
- Edit the file emoms.properties
- Search for the line beginning with:
oracle.sysman.eml.mntr.emdRepPwd=
Replace the encrypted value by the new password value - Search for the line:
oracle.sysman.eml.mntr.emdRepPwdEncrypted=TRUE
Replace TRUE by FALSE - 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 - Check that the password has been encrypted
Edit the file emoms.properties - Search for the line beginning with:
oracle.sysman.eml.mntr.emdRepPwd=
Check that the password is encrypted - Search for the line beginning with:
oracle.sysman.eml.mntr.emdRepPwdEncrypted=
Check that the value is TRUE
Suscribirse a:
Entradas (Atom)