DBASolved

  • GoldenGate
    • GoldenGate 101
    • GoldenGate Classic
    • GoldenGate Microservices
  • Database
    • Oracle Database
    • OEM
  • Infrastructure
  • General
    • About
    • Scripts
    • Speaking
    • Books
  • Ask a Question

September 13, 2014 by dbasolved 3 Comments

Change unknown SYSMAN password on #EM12c

When I normally start work on a new EM 12c environment, I would request to have a userid created; however, I don’t have a userid in this environment and I need access EM 12c as SYSMAN.  Without knowing the password for SYSMAN, how can I access the EM 12c interface?  The short answer is that I can change the SYSMAN password from the OS where EM 12c is running.
Note:
Before changing the SYSMAN password for EM 12c, make sure to understand the following:

  1. SYSMAN is used by the OMS to login to the OMR to store and query all activity
  2. SYSMAN password has to be changed at both the OMS and OMR to EM 12c to work correctly
  3. Do not modify the SYSMAN or any  other repository user at the OMR level (not recommended)

The steps to change an unknown SYSMAN password is as follows:
Tip: Make sure you know what the SYS password is for the OMR.  It will be needed to reset SYSMAN.
1. Stop all OMS processes
cd <oms home>/bin
emctl stop oms 
Image 1:
sysman_pwd_stop_oms.png
 
 
 
 
 
 
2. Change the SYSMAN password
cd <oms home>/bin
emctl config oms -change_repos_pwd -use_sys_pwd -sys_pwd <sys password> -new_pwd <new sysman password>
In Image 2, notice that I didn’t pass the password for SYS or SYSMAN on the command line.  EMCTL will ask you to provide the password if you don’t put it on the command line.
Image 2:
sysman_pwd_change_pwd.png
 
 
 
 
 
 
 
3. Stop the Admin Server on the primary OMS and restart OMS
cd <oms home>/bin
emctl stop oms -all
emctl start oms
Image 3:
sysman_pwd_start_oms.png
 
 
 
 
 
 
 
 
 
4. Verify that all of OMS is up and running
cd <oms home>/bin
emctl status oms -details
Image 4:
sysman_pwd_oms_status.png
 
 
 
 
 
 
 
 
 
 
After verifying that the OMS is backup, I can now try to login to the OMS interface.
Image 5:
sysman_pwd_oem_access.png
 
 
 
 
 
 
 
 
 
 
 
As we can see, I’m able to access OEM as SYSMAN now with the new SYSMAN password.
Enjoy!!
about.me: http://about.me/dbasolved

Filed Under: OEM Tagged With: @em12c, 12c, change password, enterprise manager, management, oracle 12c, oracle password, oracle sysman password, sysman password

Comments

  1. dineshramitc says

    September 15, 2014 at 10:49 am

    Reblogged this on Dinesh Ram Kali..

    Reply
  2. Roy says

    December 9, 2015 at 3:18 am

    I have tried this several times even after an install. It doesn’t work for me. Could it be a lower case vs. upper case issue?

    Reply
    • curtisbl says

      January 7, 2016 at 3:24 am

      Could be.

      Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Follow if you like:

RSS
Follow by Email
Twitter
Follow
LinkedIn

411 on Me

Search Blog

Recent Posts

  • Installing Oracle GoldenGate Microservices – Part 1 of 2
  • Installing Oracle GoldenGate Microservices – Part 2 of 2
  • Oracle Database Views and Tables for Oracle GoldenGate
  • Home
  • About

Copyright © 2019 · Generate Pro on Genesis Framework · WordPress · Log in