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


Related Topics

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

You May Also Like

ORA-32771: cannot add file to bigfile tablespace
Apply database proactive bundle patch in RAC using manual process
Defgen utility in Oracle goldengate
Shell script for monitoring blocking sessions
DEFERRED_SEGMENT_CREATION parameter in oracle
How to move controlfile to a new location in oracle
How to multiplex control file in standalone database
ORA-20101: TABLESPACE is not a ASSM (Automatic Segment Space Management) tablespace
REUSE_DUMPFILES parameter in EXPDP
Useful ADRCI commands in oracle

From This Website

Apply database proactive bundle patch in RAC using manual process
how to send mail using utl_mail in oracle 11g
Upgrade database using OEM 12C cloud control
Shell script to report failed login attempt in oracle
Lock account automatically with INACTIVE_ACCOUNT_TIME
Alert log rotation script in oracle
Script to get cpu usage and wait event information in oracle database
How to restart MySQL on Linux and Windows
How to use oratop tool for oracle database monitoring
TRUST_EXISTING_TABLE_PARTITIONS in oracle 12.2 datapump