Forum Stats

  • 3,851,386 Users
  • 2,263,969 Discussions
  • 7,904,692 Comments

Discussions

Start up script for EPM 11.1.2 in Unix or Windows...

user10774818
user10774818 Member Posts: 42
edited Sep 15, 2011 9:52AM in EPM System Infrastructure
Is there a sample start up script for starting required services in EPM 11.1.2 ?

I saw that the Program Files item for EPM, has a link to some start up script but
it starts everything and it seems to refer to many scripts and seem complicated.
Is there a simple script for EPM 11 ? In System 9, I used Net Start to start services in a batch file and
used Sleep command between commands to give enough time for the services. But it would be nice
if there is a script which automatically checks to make sure to start the next service only after a dependent service has started.

cheers
Z
«1

Answers

  • epm23
    epm23 Member Posts: 11
    I am afraid, no such simple script exist in version 11.1.2. You need to create one for your environment if you don't want to use the default script.

    K
  • EPM System Installer installs a single start script in EPM_ORACLE_INSTANCE/bin, called start.bat|sh. Running the single start script on a machine in your EPM System deployment starts all EPM System services installed on that machine.

    Refer: Page 283 of http://download.oracle.com/docs/cd/E17236_01/epm.1112/epm_install_11121.pdf

    HTH-
    Jasmine.
  • just some thoughts...

    You can have some command which can actually check whether the port is listening for that particular services and then ask the script to execute the next line.I have seen people using VB to do the same.
  • Thank you all for the inputs. I know the location of the Start up script in 11.1.2. But that script call several other scripts and those scripts call others.

    In 9.3.1, I used a batch file where I would just start each service in the recommended order with the NET START command (NET START <service_name>.
    I used sleep command (SLEEP <seconds>) to give enough time for each service to start. I used to have different scripts depending on what components of System 9 I want to start at that time.

    Can I use this method for 11.1.2? Because the default Start.bat starts all the installed/configured components. But some times, I just want to start specific components.

    Thanks
    Z
  • Manoj G
    Manoj G Member Posts: 222
    Hi

    netstart or sc should work in your custom script.
  • Thanks Manoj. But I am wondering. The 11.1.2 startup.bat calls several functions like setenv.bat. Startup.bat calls Starter.bat in another folder. Starter.bat calls several scripts including some XML files. It's nested and complicated compared to a simple batch file using NETSTART and Sleep commands that I used in 9.3.1.

    I'm wondering how this complicated can be equated with a simple script using NET START. Won't I be missing a lot of steps that the default script is doing like setenv etc..?
  • Manoj G
    Manoj G Member Posts: 222
    I'm currently working on a very simple script using sc.Will keep you posted.
  • Hi Manoj,

    Do you have the script using SC yet?

    thanks
    H
  • 844993
    844993 Member Posts: 18
    edited Sep 15, 2011 9:52AM
    Simple examples for EPM11.1.2.1 on Windows env.

    epmStart.bat
    @ECHO OFF
    ECHO EPM 11.1.2.1 STARTING / Batch EPM full start script by Antun Kulkov, 2011
    ECHO See more at http://silw.blogspot.com
    ECHO SQL Server Starting
    sc start "MSSQLSERVER"
    waitfor NONEXISTINGSIGNAL /T 5
    ECHO Oracle Process Manager (ohsInstance)
    sc start "OracleProcessManager_ohsInstance1649849633"
    waitfor NONEXISTINGSIGNAL /T 10
    ECHO Oracle Process Manager (EPM_epmsystem1)
    sc start "opmn_EPM_epmsystem1"
    waitfor NONEXISTINGSIGNAL /T 10
    ECHO Oracle Process Manager (ConfigurationManager)
    sc start "OracleEpmSystem_Administratord_oracle_middleware_user_projects_epmsystem1ConfigurationManager"
    waitfor NONEXISTINGSIGNAL /T 10
    ECHO Hyperion RMI Registry
    sc start "Hyperion RMI Registry"
    waitfor NONEXISTINGSIGNAL /T 10
    ECHO Hyperion Foundation Services - Managed Server
    sc start HyS9FoundationServices
    waitfor NONEXISTINGSIGNAL /T 5
    ECHO Hyperion Administration Services - Web Application
    sc start HyS9eas
    waitfor NONEXISTINGSIGNAL /T 5
    ECHO Hyperion Integration Services
    sc start "Essbase Integration Server"
    waitfor NONEXISTINGSIGNAL /T 5
    ECHO Hyperion Provider Services - Web Application
    sc start HyS9aps
    waitfor NONEXISTINGSIGNAL /T 5
    ECHO Hyperion Studio Service BPMS
    sc start "Hyperion Studio Service BPMS bpms1"
    waitfor NONEXISTINGSIGNAL /T 5
    ECHO Hyperion EPM Architect - Process Manager
    sc start EPMA_Server
    waitfor NONEXISTINGSIGNAL /T 30
    ECHO Hyperion EPMA Data Synchronizer - Web Application
    sc start HyS9EPMADataSynchronizer
    waitfor NONEXISTINGSIGNAL /T 5
    ECHO Hyperion EPMA Web Tier - Web Application
    sc start HyS9EPMAWebTier
    waitfor NONEXISTINGSIGNAL /T 5
    ECHO Hyperion CALC Manager - Web Application
    sc start HyS9CALC
    waitfor NONEXISTINGSIGNAL /T 5
    ECHO Hyperion Planning - WebHyS9Planning Application
    sc start HyS9Planning
    waitfor NONEXISTINGSIGNAL /T 5
    ECHO Hyperion Web Analysis - Web Application
    sc start HyS9WebAnalysis
    waitfor NONEXISTINGSIGNAL /T 5
    ECHO Hyperion Reporting and Analysis Framework
    sc start HyS9RaFrameworkAgent
    waitfor NONEXISTINGSIGNAL /T 5
    ECHO Hyperion Financial Reporting - Web Application
    sc start HyS9FRReports
    waitfor NONEXISTINGSIGNAL /T 5
    ECHO Hyperion Reporting and Analysis Framework - Web Application
    sc start HyS9RaFramework
    waitfor NONEXISTINGSIGNAL /T 5
    ECHO ALL DONE!
    waitfor NONEXISTINGSIGNAL /T 10
    ECHO Oracle EPM System has been started.


    epmStop.bat
    @ECHO OFF
    ECHO EPM 11.1.2.1 STOPPING / Batch EPM full stop script by Antun Kulkov, 2011
    ECHO See more at http://silw.blogspot.com
    ECHO Hyperion Web Analysis - Web Application
    sc stop HyS9WebAnalysis
    waitfor NONEXISTINGSIGNAL /T 5
    ECHO Hyperion Reporting and Analysis Framework
    sc stop HyS9RaFrameworkAgent
    waitfor NONEXISTINGSIGNAL /T 5
    ECHO Hyperion Financial Reporting - Web Application
    sc stop HyS9FRReports
    waitfor NONEXISTINGSIGNAL /T 5
    ECHO Hyperion Reporting and Analysis Framework - Web Application
    sc stop HyS9RaFramework
    waitfor NONEXISTINGSIGNAL /T 5
    ECHO Hyperion Planning - WebHyS9Planning Application
    sc stop HyS9Planning
    waitfor NONEXISTINGSIGNAL /T 5
    ECHO Hyperion CALC Manager - Web Application
    sc stop HyS9CALC
    waitfor NONEXISTINGSIGNAL /T 5
    ECHO Hyperion EPMA Web Tier - Web Application
    sc stop HyS9EPMAWebTier
    waitfor NONEXISTINGSIGNAL /T 5
    ECHO Hyperion EPMA Data Synchronizer - Web Application
    sc stop HyS9EPMADataSynchronizer
    waitfor NONEXISTINGSIGNAL /T 5
    ECHO Hyperion EPM Architect - Process Manager
    sc stop EPMA_Server
    waitfor NONEXISTINGSIGNAL /T 30
    ECHO Hyperion Studio Service BPMS
    sc stop "Hyperion Studio Service BPMS bpms1"
    waitfor NONEXISTINGSIGNAL /T 5
    ECHO Hyperion Provider Services - Web Application
    sc stop HyS9aps
    waitfor NONEXISTINGSIGNAL /T 5
    ECHO Hyperion Integration Services
    sc stop "Essbase Integration Server"
    waitfor NONEXISTINGSIGNAL /T 5
    ECHO Hyperion Administration Services - Web Application
    sc stop HyS9eas
    waitfor NONEXISTINGSIGNAL /T 5
    ECHO Hyperion Foundation Services - Managed Server
    sc stop HyS9FoundationServices
    waitfor NONEXISTINGSIGNAL /T 5
    ECHO Hyperion RMI Registry
    sc stop "Hyperion RMI Registry"
    waitfor NONEXISTINGSIGNAL /T 10
    ECHO Oracle Process Manager (ConfigurationManager)
    sc stop "OracleEpmSystem_Administratord_oracle_middleware_user_projects_epmsystem1ConfigurationManager"
    waitfor NONEXISTINGSIGNAL /T 10
    ECHO Oracle Process Manager (ohsInstance)
    sc stop "OracleProcessManager_ohsInstance1649849633"
    waitfor NONEXISTINGSIGNAL /T 10
    ECHO Oracle Process Manager (EPM_epmsystem1)
    sc stop "opmn_EPM_epmsystem1"
    waitfor NONEXISTINGSIGNAL /T 10
    ECHO SQL Server Stopping
    sc stop "MSSQLSERVER"
    waitfor NONEXISTINGSIGNAL /T 5
    ECHO ALL DONE!
    waitfor NONEXISTINGSIGNAL /T 10
    ECHO Oracle EPM System has been stopped.
  • 844993
    844993 Member Posts: 18
    Simple examples for EPM11.1.2.1

    epmStart.bat
    @ECHO OFF
    ECHO EPM 11.1.2.1 STARTING / Batch EPM full start script by Antun Kulkov, 2011
    ECHO See more at http://silw.blogspot.com
    ECHO SQL Server Starting
    sc start "MSSQLSERVER"
    waitfor NONEXISTINGSIGNAL /T 5
    ECHO Oracle Process Manager (ohsInstance)
    sc start "OracleProcessManager_ohsInstance1649849633"
    waitfor NONEXISTINGSIGNAL /T 10
    ECHO Oracle Process Manager (EPM_epmsystem1)
    sc start "opmn_EPM_epmsystem1"
    waitfor NONEXISTINGSIGNAL /T 10
    ECHO Oracle Process Manager (ConfigurationManager)
    sc start "OracleEpmSystem_Administratord_oracle_middleware_user_projects_epmsystem1ConfigurationManager"
    waitfor NONEXISTINGSIGNAL /T 10
    ECHO Hyperion RMI Registry
    sc start "Hyperion RMI Registry"
    waitfor NONEXISTINGSIGNAL /T 10
    ECHO Hyperion Foundation Services - Managed Server
    sc start HyS9FoundationServices
    waitfor NONEXISTINGSIGNAL /T 5
    ECHO Hyperion Administration Services - Web Application
    sc start HyS9eas
    waitfor NONEXISTINGSIGNAL /T 5
    ECHO Hyperion Integration Services
    sc start "Essbase Integration Server"
    waitfor NONEXISTINGSIGNAL /T 5
    ECHO Hyperion Provider Services - Web Application
    sc start HyS9aps
    waitfor NONEXISTINGSIGNAL /T 5
    ECHO Hyperion Studio Service BPMS
    sc start "Hyperion Studio Service BPMS bpms1"
    waitfor NONEXISTINGSIGNAL /T 5
    ECHO Hyperion EPM Architect - Process Manager
    sc start EPMA_Server
    waitfor NONEXISTINGSIGNAL /T 30
    ECHO Hyperion EPMA Data Synchronizer - Web Application
    sc start HyS9EPMADataSynchronizer
    waitfor NONEXISTINGSIGNAL /T 5
    ECHO Hyperion EPMA Web Tier - Web Application
    sc start HyS9EPMAWebTier
    waitfor NONEXISTINGSIGNAL /T 5
    ECHO Hyperion CALC Manager - Web Application
    sc start HyS9CALC
    waitfor NONEXISTINGSIGNAL /T 5
    ECHO Hyperion Planning - WebHyS9Planning Application
    sc start HyS9Planning
    waitfor NONEXISTINGSIGNAL /T 5
    ECHO Hyperion Web Analysis - Web Application
    sc start HyS9WebAnalysis
    waitfor NONEXISTINGSIGNAL /T 5
    ECHO Hyperion Reporting and Analysis Framework
    sc start HyS9RaFrameworkAgent
    waitfor NONEXISTINGSIGNAL /T 5
    ECHO Hyperion Financial Reporting - Web Application
    sc start HyS9FRReports
    waitfor NONEXISTINGSIGNAL /T 5
    ECHO Hyperion Reporting and Analysis Framework - Web Application
    sc start HyS9RaFramework
    waitfor NONEXISTINGSIGNAL /T 5
    ECHO ALL DONE!
    waitfor NONEXISTINGSIGNAL /T 10
    ECHO Oracle EPM System has been started.


    epmStop.bat
    @ECHO OFF
    ECHO EPM 11.1.2.1 STOPPING / Batch EPM full stop script by Antun Kulkov, 2011
    ECHO See more at http://silw.blogspot.com
    ECHO Hyperion Web Analysis - Web Application
    sc stop HyS9WebAnalysis
    waitfor NONEXISTINGSIGNAL /T 5
    ECHO Hyperion Reporting and Analysis Framework
    sc stop HyS9RaFrameworkAgent
    waitfor NONEXISTINGSIGNAL /T 5
    ECHO Hyperion Financial Reporting - Web Application
    sc stop HyS9FRReports
    waitfor NONEXISTINGSIGNAL /T 5
    ECHO Hyperion Reporting and Analysis Framework - Web Application
    sc stop HyS9RaFramework
    waitfor NONEXISTINGSIGNAL /T 5
    ECHO Hyperion Planning - WebHyS9Planning Application
    sc stop HyS9Planning
    waitfor NONEXISTINGSIGNAL /T 5
    ECHO Hyperion CALC Manager - Web Application
    sc stop HyS9CALC
    waitfor NONEXISTINGSIGNAL /T 5
    ECHO Hyperion EPMA Web Tier - Web Application
    sc stop HyS9EPMAWebTier
    waitfor NONEXISTINGSIGNAL /T 5
    ECHO Hyperion EPMA Data Synchronizer - Web Application
    sc stop HyS9EPMADataSynchronizer
    waitfor NONEXISTINGSIGNAL /T 5
    ECHO Hyperion EPM Architect - Process Manager
    sc stop EPMA_Server
    waitfor NONEXISTINGSIGNAL /T 30
    ECHO Hyperion Studio Service BPMS
    sc stop "Hyperion Studio Service BPMS bpms1"
    waitfor NONEXISTINGSIGNAL /T 5
    ECHO Hyperion Provider Services - Web Application
    sc stop HyS9aps
    waitfor NONEXISTINGSIGNAL /T 5
    ECHO Hyperion Integration Services
    sc stop "Essbase Integration Server"
    waitfor NONEXISTINGSIGNAL /T 5
    ECHO Hyperion Administration Services - Web Application
    sc stop HyS9eas
    waitfor NONEXISTINGSIGNAL /T 5
    ECHO Hyperion Foundation Services - Managed Server
    sc stop HyS9FoundationServices
    waitfor NONEXISTINGSIGNAL /T 5
    ECHO Hyperion RMI Registry
    sc stop "Hyperion RMI Registry"
    waitfor NONEXISTINGSIGNAL /T 10
    ECHO Oracle Process Manager (ConfigurationManager)
    sc stop "OracleEpmSystem_Administratord_oracle_middleware_user_projects_epmsystem1ConfigurationManager"
    waitfor NONEXISTINGSIGNAL /T 10
    ECHO Oracle Process Manager (ohsInstance)
    sc stop "OracleProcessManager_ohsInstance1649849633"
    waitfor NONEXISTINGSIGNAL /T 10
    ECHO Oracle Process Manager (EPM_epmsystem1)
    sc stop "opmn_EPM_epmsystem1"
    waitfor NONEXISTINGSIGNAL /T 10
    ECHO SQL Server Stopping
    sc stop "MSSQLSERVER"
    waitfor NONEXISTINGSIGNAL /T 5
    ECHO ALL DONE!
    waitfor NONEXISTINGSIGNAL /T 10
    ECHO Oracle EPM System has been stopped.
This discussion has been closed.