Hi all. Happy New Year.
EM version: 12.1.0.3.0
Repository database version: 11.2.0.3.0
Target database version: 12.1.0.2.0
While changing my dbsnmp passwords today, I ran into what looks like a
case-sensitivity issue. To wit:
$ emcli update_db_password -target_name=<db_name> -user_name=dbsnmp
-old_password=<old p/w> -new_password=<new p/w> -retype_new_password=<new p/w>
-change_at_target=yes
Error: User or Key value "dbsnmp" does not exist for the given target
$ emcli update_db_password -target_name=<db_name> -user_name=DBSNMP
-old_password=<old p/w> -new_password=<new p/w> -retype_new_password=<new p/w>
-change_at_target=yes
Successfully submitted a job to change the password in Enterprise Manager and
on the target database: "<db_name>"
Execute "emcli get_jobs -job_id=28999E6B05E443E1E053CF01A8C020C4" to check the
status of the job.
Search for job name "CHANGE_PWD_JOB_28999E6B05E343E1E053CF01A8C020C4" on the
Jobs home page to check job execution details.
The only difference in the 2 commands is the user_name being lower or upper
case. The case appears to not matter for 11g databases...though to be
completely honest, I have not tried to change an 11g password with an
uppercase DBSNMP.
Just an FYI in 'case' someone else runs into this. :)
-joe
Confidentiality Note: This message contains information that may be
confidential and/or privileged. If you are not the intended recipient, you
should not use, copy, disclose, distribute or take any action based on this
message. If you have received this message in error, please advise the sender
immediately by reply email and delete this message. Although ICAT, Underwriters
at Lloyd's, Syndicate 4242, scans e-mail and attachments for viruses, it does
not guarantee that either are virus-free and accepts no liability for any
damage sustained as a result of viruses. Thank you.
--
//www.freelists.org/webpage/oracle-l