Oracle DBA Tips and Techniques

By Arjun Raja

CHANGE SYSMAN PASSWORD IN ORACLE 12C CLOUD CONTROL

Posted by Arjun Raja on September 3, 2013

STEPS TO CHANGE SYSMAN PASSWORD IN ORACLE 12C CLOUD CONTROL.

These are the steps incase you are aware of the sysman password.

Login to Server as owner of OMS- usually oracle.

1. Stop the OMS:

export OMS_HOME=/u01/oracle/Middleware/oms

cd $OMS_HOME/bin

./emctl stop oms

Do not include ‘-all’ as the Admin Server needs to be up during this operation.

2. Modify the SYSMAN password:

cd $OMS_HOME/bin

./emctl config oms -change_repos_pwd

Note:

– The above command will prompt you for the current password of the SYSMAN user and the new password.

– The password will be modified at the Repository Database as well as the WLS Credential store and the monitoring credentials for the ‘OMS and Repository’ target.

– Along with the SYSMAN password, this command will modify the password for the EM users (SYSMAN_MDS, BIP, SYSMAN_OPSS, SYSMAN_APM, SYSMAN_RO) created in the Repository Database.

Example output:

emrep:/u01/oracle/Middleware/oms/bin> ./emctl config oms -change_repos_pwd
Oracle Enterprise Manager Cloud Control 12c Release 2
Copyright (c) 1996, 2012 Oracle Corporation. All rights reserved.
Enter Repository User’s Current Password :
Enter Repository User’s New Password :

Changing passwords in backend …
Passwords changed in backend successfully.
Updating repository password in Credential Store…
Successfully updated Repository password in Credential Store.
Restart all the OMSs using ’emctl stop oms -all’ and ’emctl start oms’.
Successfully changed repository password.

Make sure you note down the new password.

3. Stop the Admin server on the primary OMS machine and re-start all the OMS:

emrep:/u01/oracle/Middleware/oms/bin> ./emctl stop oms -all
Oracle Enterprise Manager Cloud Control 12c Release 2
Copyright (c) 1996, 2012 Oracle Corporation. All rights reserved.
Stopping WebTier…
WebTier Successfully Stopped
Stopping Oracle Management Server…
Oracle Management Server Already Stopped
AdminServer Successfully Stopped
Oracle Management Server is Down

Start the OMS

emrep:/u01/oracle/Middleware/oms/bin> ./emctl start oms
Oracle Enterprise Manager Cloud Control 12c Release 2
Copyright (c) 1996, 2012 Oracle Corporation. All rights reserved.
Starting Oracle Management Server…
Starting WebTier…
WebTier Successfully Started
Oracle Management Server Successfully Started
Oracle Management Server is Up

Login to webpage and make sure sysman password works :

https://xxxxxx.xxxxx.com:7800/em

MOS note 1365930.1 is the reference note and can be used for other scenarios too.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: