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

  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/<new_password>[@database_alias]
  5. Go to $ORACLE_HOME/host_sid/sysman/config
    1. Save the file emoms.properties to  emoms.properties.orig
    2. Edit the file emoms.properties
      1. Search for the line beginning with:
        oracle.sysman.eml.mntr.emdRepPwd=
        Replace the encrypted value by the new password value
      2. 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
    1. Search for the line beginning with:
      oracle.sysman.eml.mntr.emdRepPwd=
      Check that the password is encrypted
    2. Search for the line beginning with:
      oracle.sysman.eml.mntr.emdRepPwdEncrypted=
      Check that the value is TRUE

No hay comentarios: