change apps password(ebs)

[Roshan]

Hello Erman,
 
how can i change apps password in ebs on a cluster? Is there is a table I need to backup before I launch:
 
FNDCPASS apps/current_password 0 Y system/password SYSTEM APPLSYS newpassword
 
Thanks,
Joe

[ErmanArslansOracleBlog]

Hi,

There is nothing special with RAC.
The FND_USER and FND_ORACLE_USERID tables should be backed up before any passwords are changed.

I assume, your env is EBS 12.2, so follow this document: Steps to change the APPS, APPLSYS, and APPS_NE password using FNDCPASS or AFPASSWD for EBS 12.2 (Doc ID 1674462.1)

[Roshan]

Thanks. I have backed up the tables. Before I run FNDCPASS, I need to start the application nodes. I have found a script(shutdownEBSPROD) with the following commands in crontab.

# cat /sysadmscripts/shutdown_EBSPROD.sh
/opt/VRTSvcs/bin/hares -offline HRMS-APPS-CMANAGER   -sys csishrm1
sleep 20;
/opt/VRTSvcs/bin/hares -offline PROD_HRMS_HTTPSVR   -sys csishrm1
/opt/VRTSvcs/bin/hares -offline PROD_HRMS_OACORE   -sys csishrm1
/opt/VRTSvcs/bin/hares -offline PROD_HRMS_OAFM   -sys csishrm1
/opt/VRTSvcs/bin/hares -offline OID-APP   -sys csishrm1
/opt/VRTSvcs/bin/hares -offline OID-APP-LISTENER   -sys csishrm1
/opt/VRTSvcs/bin/hares -offline HRMS-lsnr-cmgr   -sys csishrm1
/opt/VRTSvcs/bin/hares -offline OID-APPS_ORACLE   -sys csishrm1
/opt/VRTSvcs/bin/hares -offline PROD_HRMS_FormSrvr   -sys csishrm1
/opt/VRTSvcs/bin/hares -offline PROD_HRMS_OPMN   -sys csishrm1

Is it ok if I run it? How many nodes do I need to stop?
I have checked the doc below:
https://docs.oracle.com/cd/E11882_01/install.112/e41962/procstop.htm#RILIN1173

Thanks,
Roshan

[ErmanArslansOracleBlog]

Is it Veritas Cluster? It seems like.
so "hares" is related with Veritas.
I can't give any confirmation for that, at least I can't without knowing your exact environment.
check veritas and symantec. This info is publically available.

[Roshan]

My environment is:
AIX peopleconnect 1 6 00CC5FF44C00
The cluster consists of 2 nodes(10.10.10.212 and 10.10.10.213).
The password to be changed is on 212.
Oracle Database version: 10.1.0.5.0
EBS: R12.1

Veritas cluster is installed on it
/opt/VRTSvcs/bin/hagui

[ErmanArslansOracleBlog]

It is not your environment that I asked for Roshan .
I need to know your Veritas env and also need to analyze it in order to confirm your script.
This is a Veritas question .
The resources that you operate here seems to be specific to your env. (for ex: HRMS-APPS-CMANAGER)

Check this:
http://monsterjam.org/veritas/readme_vcs.txt

and then check your resources using hares and check your script accordingly.

Also read this:

Cluster Server Agent for Oracle e-Business Components Installation and Configuration Guide
https://sort.veritas.com/agents/download_docs/15/vcs_oraebizcomponents_install


These are veritas related questions, Roshan...