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.


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



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:"

Related Topics

Apply database patch from OEM Cloud control
How to change sysman password for oracle 12c cloud control
EMCLI command - OEM 12C
Generate custom report from OEM cloud control
Deinstall Management Agents Oracle 12c cloud control
Change dbsnmp password for target db in oem 12c
Blackout targets in OEM 12c cloud control
Add database as target oracle 12c cloud control
Upgrade database using OEM 12C cloud control
Install oracle enterprise manager cloud control 12c

You May Also Like

Oracle database Security Assessment Tool
TNS-12542: TNS:address already in use
How to run expdp in pluggable database(PDB)
ORA-30034: Undo tablespace cannot be specified as temporary tablespace
sec_case_sensitive_logon parameter in oracle
Find the active transactions in oracle database
ORA-32771: cannot add file to bigfile tablespace
Script to get cpu usage and wait event information in oracle database

From This Website

How to find execution history of an sql_id
Flashback primary database in dataguard environment
How to install oracle client in silent mode using response file
Upgrade grid infrastructure to 19C oracle
How to find weblogic version in oracle weblogic 12
Apply patch on oracle 12.2 database ( Release update)
_use_adaptive_log_file_sync parameter in oracle
Script to get cpu usage and wait event information in oracle database
Standby redologs in oracle dataguard
Create, configure and mount a Linux file system on Oracle VM