Updating Target Credentials for PeopleSoft Targets
Target credentials are stored for each PeopleSoft target when it is discovered or created on Enterprise Manager Cloud Console. The target credentials are stored in $AGENT_HOME\sysman\emd\targets.xml and used for target metric collection. Due to security restrictions, it is likely that the password will expire eventually for hosts. If the password expires, metric collection fails for the PeopleSoft targets.
If the password for target credentials expires, one of the following solutions can be used to change the password for the PeopleSoft targets.
Remove the target from your system in Enterprise Manager, and rediscover it.
Use the Enterprise Manager Command Line Interface (EM CLI).
EM CLI installation and setup instructions are available at the following local Enterprise Manager Cloud Console link.
https://<machinename>:<portnumber>/em/console/emcli/download
For example:
https://st-hp16.peoplesoft.com:7880/em/console/emcli/download
For more information on EM CLI refer to the EM CLI documentation provided by Oracle.
The syntax of the EM CLI command to change the password is:
emcli update_password -target_type="ttype" -target_name="tname" -credential_type="cred_type" -key_column="column_name:column_value" -non_key_column="col:oldvalue:newvalue;..."
For example, the following command changes the password for target credentials of an application server target:
>emcli update_password -target_type=ps_app_server -target_name=newapp1.app.st-hpp03.ds1_home_psoft_psft_pt_853-809-I1 -credential_type=PsoftHostCreds -key_column="HOST_USERNAME:psoft" -non_key_column="HOST_PASSWORD:psoft456:psoft"
Similarly, the password can be changed for other PeopleSoft target types. Change the target name, type, username and password in the above command for other PeopleSoft targets.
Target |
target_type Value |
---|---|
PS Application Server Domain |
ps_app_server |
PS Process Scheduler Domain |
ps_process_scheduler |
PS Search Server Domain |
ps_search_server |
PS PIA |
ps_pia |
PS Website |
ps_web_site |
PS Process Monitor |
ps_process_monitor |
PS Application Database |
ps_app_db |
Note: To change the password for multiple targets, the change password commands for multiple targets can be stored in a script and run once to update multiple passwords.