Steps to Change SYSMAN Password in OMS Database

1. Change password in the Repository Database

Log in to the repository database as sysdba:

    sqlplus / as sysdba

    Connect to the SYSMAN user and change the password:

    ALTER USER sysman IDENTIFIED BY "<new_password>";

    2. Update password in OMS Configuration

    After changing in the database, you must update OMS so it can connect.

    Go to the OMS host and set the environment:

    export ORACLE_HOME=/u01/app/oracle/middleware
    export OMS_HOME=$ORACLE_HOME/oms

      Run the emctl command to update the SYSMAN password:

      $OMS_HOME/bin/emctl config oms -change_repos_pwd -repos_user sysman -repos_pwd <new_password>
      

      3. Restart OMS

      $OMS_HOME/bin/emctl stop oms -all
      $OMS_HOME/bin/emctl start oms

      4. Check the status of OMS

      $OMS_HOME/bin/emctl status oms -details
      This entry was posted in Oracle on by .
      Unknown's avatar

      About SandeepSingh

      Hi, I am working in IT industry with having more than 15 year of experience, worked as an Oracle DBA with a Company and handling different databases like Oracle, SQL Server , DB2 etc Worked as a Development and Database Administrator.

      Leave a Reply