apps password Veritas Cluster

classic Classic list List threaded Threaded
7 messages Options
Reply | Threaded
Open this post in threaded view
|

apps password Veritas Cluster

Roshan
Hello,
 
I have EBS r12.1 on a cluster for high availability. I have stopped the application services using:
/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
 
before changing APPS password.
 
When I started it, only the concurrent manager could not be started. It was giving an error message like 'could not connect to ORACLE..' in the conc log file.
conc.txt

We had to run Autoconfig and start it manually using adcmtl.sh
 
Is there a field in Veritas where the password is hardcoded? so that we the system can be started from Veritas Cluster manager

VeritasCluster.PNG
Reply | Threaded
Open this post in threaded view
|

Re: apps password Veritas Cluster

ErmanArslansOracleBlog
Administrator
It is invalid user pass error.,
Routine AFPCSQ encountered an ORACLE error. ORA-01017: invalid
username/password; logon denied

How did you change the apps passwd?

Tell me the exacts steps that you have taken
Reply | Threaded
Open this post in threaded view
|

Re: apps password Veritas Cluster

Roshan
-----I shutdown the application services using:
/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

----Then I ran the command:
FNDCPASS apps/<appspwd> 0 Y system/manager SYSTEM APPLSYS WELCOME


---- I also changed all schema passwords
FNDCPASS apps/apps 0 Y system/manager ALLORACLE WELCOME


----Then I started application services
/opt/VRTSvcs/bin/hares -online PROD_HRMS_OPMN   -sys csishrm1
/opt/VRTSvcs/bin/hares -online PROD_HRMS_FormSrvr   -sys csishrm1
/opt/VRTSvcs/bin/hares -online OID-APPS_ORACLE   -sys csishrm1
/opt/VRTSvcs/bin/hares -online OID-APP-LISTENER   -sys csishrm1
/opt/VRTSvcs/bin/hares -online HRMS-lsnr-cmgr   -sys csishrm1
/opt/VRTSvcs/bin/hares -online HRMS-APPS-CMANAGER   -sys csishrm1
/opt/VRTSvcs/bin/hares -online OID-APP   -sys csishrm1
/opt/VRTSvcs/bin/hares -online PROD_HRMS_HTTPSVR   -sys csishrm1
/opt/VRTSvcs/bin/hares -online PROD_HRMS_OACORE   -sys csishrm1
/opt/VRTSvcs/bin/hares -online PROD_HRMS_OAFM   -sys csishrm1

Reply | Threaded
Open this post in threaded view
|

Re: apps password Veritas Cluster

ErmanArslansOracleBlog
Administrator
Did you check the log file of your FNDCPASS run?  Check the logs and if you see any erros during your FNDCPASS run.
Also, Didnt you run autoconfig?  (apps tier autoconfig)
The approach should be "change the password, run autoconfig and restart apps tier. " (also check your autoconfig log to ensure that is it successful)
Reply | Threaded
Open this post in threaded view
|

Re: apps password Veritas Cluster

Roshan
The FNDCPASS log did not contain errors. I did not run autoconfig and restart apps tier. Thanks
Reply | Threaded
Open this post in threaded view
|

Re: apps password Veritas Cluster

ErmanArslansOracleBlog
Administrator
Do the work as I told you in my previous comment and then update me.
Reply | Threaded
Open this post in threaded view
|

Re: apps password Veritas Cluster

Roshan
It is OK now. Once we ran autoconfig and restarted apps using script, it was ok.