This discussion is archived
1 Reply Latest reply: Feb 21, 2013 1:26 PM by 840367 RSS

EPM services fails to restart

954965 Newbie
Currently Being Moderated
I have a simple script that stops and starts the services (of Oracle Hyperion)




sleep 1200


I have scheduled it for every night and it does run, however there is an issue with database connectivity afterwards:

When i try to open a BQY file in IR web client and run a query, It fails to execute, and shows one of the following errors:

1. SQL*NET not loaded successfully
2. Failed to access DAS
3. Unknown error related to DasComm brio

But when i run and manually, there is no such issue.

So apparently there is an issue with how those scripts run in cron.

Here's the output from crontab -l (for oracle user)

00 02 * * * /usr/bin/sh /export/home/oracle/

Could someone please advise on the problem? Thanks.
  • 1. Re: EPM services fails to restart
    840367 Newbie
    Currently Being Moderated
    The way the scripts run is a little different depending on the permission levels provided for the corntab

    try this in crontab and see what kind of error is generated,

    02 02 * * * /apps/hyperion/Planning/scripts<Your PAth> / 1> /apps/hyperion/Planning/logs/startup.out 2> /apps/hyperion/Planning/logs/startup.err

    Let me know what you have found in the log and see

    Edited by: Awesome on Feb 21, 2013 1:26 PM


  • Correct Answers - 10 points
  • Helpful Answers - 5 points