I have spent quite a bit of time learning the ins and outs of starting and stopping Oracle EPM System on versions: 22.214.171.124, 126.96.36.199 and 188.8.131.52.
It all started with a customer that asked me to come in and review their environment, due to some stability issues. I immediately noticed a few quick wins, and asked them to restart services while we went for lunch. I got the deer in headlights stare. You know that look. Well, what typically takes 30 minutes on 184.108.40.206, was taking them 1h 45m to complete on a normal basis. Granted, they had 85+ services due to triple redundancy on the web tier as well as High Availability on the app tier, but it still should not take this long.
Ultimately, I was able to reduce their startup time from almost two hours to a respectable 25 minutes. Since, I have created several permutations for different sets of requirements. Some are all Windows, while others are all Linux. Some customers will not allow PsExec, and we have alternatives for that, too. The most frequently implemented is my latest, v3.0.6, which will control EPM System across multiple servers, even in mixed environments.
And our start / stop scripts are not limited to EPM, either. We have streamlined solutions for OBIEE and Exalytics, as well.
A side note for you Linux geeks, I typically like to create aliases (.bashrc) for even further convenience. Adding EPM_ORACLE_HOME and EPM_INSTANCE_HOME to .bash_profile is nice to have, too.
I have made general observations regarding startup times of EPM System on the following versions with my scripts:
EPM 220.127.116.11: Startup typically takes 20-35mins
EPM 18.104.22.168: Startup typically takes 12-20mins
EPM 22.214.171.124: Startup typically takes 2-8mins (I have Exalytics environments completely up in 1.5m)
Oracle is definitely making improvements to these times, as there were a lot of grumblings around this in 126.96.36.199. Well, Oracle, it’s been noticed! I have a couple of other tricks I use in conjunction to speed things up, and would be glad to share with those interested.