Automated OBIEE Database and Application Restart Script

Introduction: In today's fast-paced world of business intelligence, maintaining a seamless and efficient Oracle Business Intelligence Enterprise Edition (OBIEE) environment is crucial. To ensure the smooth functioning of your OBIEE system, it is essential to periodically restart both the database and application services. In this blog, we will guide you through the process of creating an automation script to automatically restart the OBIEE database and application, which you can schedule to run every Friday evening and start the services again on Monday morning.

Prerequisites:

1. Access to the OBIEE server and its components.
2. Administrative privileges to execute the necessary actions on the server.

Creating the Automation Script:

Scheduling the Script:

On OBIEE Application server
#Stop OBIEE
45 6 25 4 0 /u02/scripts/stop_obiee.sh
#Start OBIEE
45 5 25 4 0 /u02/scripts/start_obiee.sh

On OBIEE Database server
#Stop OBIEE DB
45 06 25 4 0 /home/oracle/OBIEEDDB/scripts/stop_DB.sh
#Start OBIEE DB
32 05 25 4 0 /home/oracle/OBIEEDDB/scripts/start_DB.sh

Testing and Maintenance:

1. Before letting the script run in the production environment, test it on a staging or testing environment to ensure it works as expected.
2. Monitor the script execution regularly to identify any potential issues or improvements.
3. Keep the script and OBIEE environment up-to-date, especially when new patches or versions are released.

Conclusion: Automating the restart process for your OBIEE database and application can significantly improve efficiency and reduce manual intervention. By scheduling the script to run every Friday evening and start the services on Monday morning, you ensure your OBIEE system runs smoothly, allowing your team to focus on extracting valuable insights and making data-driven decisions with confidence. Remember to perform regular testing and maintenance to keep the automation process robust and reliable.

With this automation in place, your OBIEE environment will be better equipped to handle your organization's business intelligence needs effectively and efficiently.