Discussion:
Update passwords in OEM through script
(too old to reply)
Sandra Becker
2018-09-21 15:11:40 UTC
Permalink
EM Cloud Control v12c
Oracle DB v11.2.0.4

We have an audit project wherein password changes are required at certain
intervals or when a DBA leaves the company. The DBA in charge of the
project is not familiar with Oracle so has asked me how to script something
that can change all the relevant passwords in OEM rather than doing them
manually.

Should it be done? Can it be done safely? If it is safe to do so, can
anyone point me to docs or scripts that I can reference?

Thank you,
--
Sandy B.
Courtney Llamas
2018-09-21 16:36:53 UTC
Permalink
Yes, there’s an EMCLI cmd that will update the pwd for you on the target side.

https://blog.pythian.com/change-database-passwords-oem/

http://www.redstk.com/saving-you-15-minutes-em13-1-blog-blitz-new-emcli-command-for-db-account-management/

 

 

The update pwd feature is available in OEM 12c. 

 

 
--
- Courtney

http://www.oracle.com/
Courtney Llamas | Consulting Member of Technical Staff
Phone: HYPERLINK "tel:+2814108258"+2814108258 | Mobile: HYPERLINK "tel:+8324720596"+8324720596
Oracle Strategic Customer Program

Oracle

http://www.oracle.com/commitment

Oracle is committed to developing practices and products that help protect the environment

 

From: Sandra Becker <***@gmail.com>
Sent: Friday, September 21, 2018 10:12 AM
To: oracle-l <oracle-***@freelists.org>
Subject: Update passwords in OEM through script

 

EM Cloud Control v12c

Oracle DB v11.2.0.4

 

We have an audit project wherein password changes are required at certain intervals or when a DBA leaves the company.  The DBA in charge of the project is not familiar with Oracle so has asked me how to script something that can change all the relevant passwords in OEM rather than doing them manually.

 

Should it be done?  Can it be done safely?  If it is safe to do so, can anyone point me to docs or scripts that I can reference?

 

Thank you,
--
Sandy B.
Fernando N. de Souza
2018-09-21 18:08:51 UTC
Permalink
I hope it works for you.

I have an SR opened for two months because it fails with ORA-20400.
Apparently no one at Oracle has seen this error before.

--
Fernando.

“The single biggest problem in communication is the illusion that it has
taken place.”
George Bernard Shaw
Post by Courtney Llamas
Yes, there’s an EMCLI cmd that will update the pwd for you on the target side.
https://blog.pythian.com/change-database-passwords-oem/
http://www.redstk.com/saving-you-15-minutes-em13-1-blog-blitz-new-emcli-command-for-db-account-management/
The update pwd feature is available in OEM 12c.
--
- Courtney
[image: Oracle] <http://www.oracle.com/>
Courtney Llamas | Consulting Member of Technical Staff
Phone: +2814108258 | Mobile: +8324720596
Oracle Strategic Customer Program
Oracle
[image: Green Oracle] <http://www.oracle.com/commitment>
Oracle is committed to developing practices and products that help protect the environment
*Sent:* Friday, September 21, 2018 10:12 AM
*Subject:* Update passwords in OEM through script
EM Cloud Control v12c
Oracle DB v11.2.0.4
We have an audit project wherein password changes are required at certain
intervals or when a DBA leaves the company. The DBA in charge of the
project is not familiar with Oracle so has asked me how to script something
that can change all the relevant passwords in OEM rather than doing them
manually.
Should it be done? Can it be done safely? If it is safe to do so, can
anyone point me to docs or scripts that I can reference?
Thank you,
--
Sandy B.
Loading...