Update_db_password command can be used to updates DBNSMP password of the target in the Enterprise Manager Credential sub-system and change the password on the target database as well.
The command need to be run from OMS home.
SYNTAX:
emcli login -username=sysman -password=
emcli update_db_password -target_name="" -target_type="oracle_database" -user_name="dbsnmp" -change_at_target=yes -old_password="" -new_password="" -retype_new_password=""
For standalone database:(TESTDB)
1. login to sysman user in OMS
cd $OMS_HOME/bin
./emcli login -username=sysman -password=oracle1234
Login successful
2. Check the target staus:
./emcli get_targets -target="oracle_database" | grep TESTDB
1 Up oracle_database TESTDB
3. Update the dbsnmp password
./emcli update_db_password -target_name="TESTDB" -target_type="oracle_database" -user_name="dbsnmp" -change_at_target=yes -old_password="dbsnmp" -new_password="oracle" -retype_new_password="oracle"
Successfully submitted a job to change the password in Enterprise Manager and on the target database: "TESTDB"
Execute "emcli get_jobs -job_id=49A8A308BB280CAFE0540010E01F328C" to check the status of the job.
Search for job name "CHANGE_PWD_JOB_1488359226974" on the Jobs home page to check job execution details.
4. Check the job status:
./emcli get_jobs -job_id=49A8A308BB280CAFE0540010E01F328C
Name Type Job ID Execution ID Scheduled Completed TZ Offset Status Status ID Owner Target Type Target Name
CHANGE_PWD_JOB_1488359226974 dbUpdateDBPassword 49A8A308BB280CAFE0540010E01F328C 49A8A308BB2B0CAFE0540010E01F328C 2017-03-01 12:07:07 2017-03-01 12:07:11 GMT+03:00 Succeeded 5 SYSMAN oracle_database TESTDB
FOR RAC DATABASE USE BELOW SYNTAX:
emcli update_db_password -target_name="" -user_name= -target_type=rac_database -change_all_references=yes -change_at_target=yes -old_password= -new_password= -retype_new_password=
emcli set_monitoring_credential -target_type="rac_database" -target_name="" -set_name="DBCredsMonitoring" -cred_type="DBCreds" -attributes="DBUserName:;DBPassword:;DBRole:"
12c CLOUD