Automating OBIEE Startup and Shutdown Service


As we all know that there are couple of steps that we need to adhere before starup OBIEE services and also same for shutdown . How if it will be automated through two scripts only …i.e one for Startup and other for Shutdown OBIEE service . This utility necessarily free us from juggling around windows services .

Lets find how the tid-bit applicable for IIS Web server first . I have two batch file in desktop that do the stuff for me one is : OBIEE Start-IIS.bat having below script behind it .

===========================
cls
echo “Starting BI ……”
net start IISADMIN
net start W3SVC
net start “Oracle BI Server”
net start “Oracle BI Java Host”
net start “Oracle BI Presentation Server”
start iexplore “http://localhost/analytics/saw.dll?Dashboard&NQUser=Administrator&NQPassword=Administrator
===========================

Another one for stopping BI Services i.e OBIEE Stop-IIS.bat having underline script .

===========================
cls
echo “Stopping BI ……”
net stop “Oracle BI Presentation Server”
net stop “Oracle BI Java Host”
net stop “Oracle BI Server”
net stop IISADMIN /Y
===========================

N.B : In above scripts while starting the BI service it will kickoff IIS and its dependent process first and finally the command window unloaded after invoking iExplore process .Now while stopping the BI service it will forcefully stop IIS and its dependent process like WWW Publishing etc .

Lets find the solution for the same in OC4J Web controller .

OBIEE Start-OC4J.bat

====================================
cd D:\OracleBI\oc4j_bi\j2ee\home
D:
cls
echo “Starting BI ……”
start D:\OracleBI\oc4j_bi\bin\oc4j.cmd -start
sleep 10
net start “Oracle BI Server”
net start “Oracle BI Java Host”
net start “Oracle BI Presentation Server”
start iexplore “http://localhost/analytics/saw.dll?Dashboard&NQUser=Administrator&NQPassword=Administrator
====================================

OBIEE Stop-OC4J.bat

============================
cls
echo “Stopping BI ……”
net stop “Oracle BI Presentation Server”
net stop “Oracle BI Java Host”
net stop “Oracle BI Server”
cd D:\OracleBI\oc4j_bi\j2ee\home
d:
java -jar admin.jar ormi://  oc4jadmin oc4jadmin -shutdown force
taskkill /IM cmd.exe
============================

Only thing you need to know is that for OC4J you need to change the j2ee home directory as per your enviornment settings .

So finally this make life bit easy for me as you are also far away from 2 simple click on two readymade batch file 😀

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s