case sensitivity when changing dbsnmp password in a 12c database via emcli

From: Sweetser, Joe <JSweetser_at_icat.com>
Date: Tue, 5 Jan 2016 19:06:49 +0000
Message-ID: <SN2PR0701MB7658C8C0DDBA17122899A4CD4F30_at_SN2PR0701MB765.namprd07.prod.outlook.com>



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.

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Jan 05 2016 - 20:06:49 CET

Original text of this message