Preliminaries

When installed out-of-the-box, OBIEE must be started manually each time the server starts, via a shortcut in the Oracle BI program menu group. The instructions in this document will set up windows services that will start automatically when the server starts. Two of these services are already installed out-of-the-box and we will be creating two more.

Basic Steps

  1. Insure that “boot.properties” file is correct
  2. Edit or create service scripts
  3. Execute service scripts
  4. Edit Windows registry so that services start in correct order
  5. Reboot server and test

boot.properties

When you started the BI server the first time it should have asked for the weblogic admin id and password. It stores this id and password in a file named “boot.properties” so that subsequent startups do not require the id and password to be entered. Chances are this is already working and nothing more needs to be done. If however there is no boot.properties files then you can manually create one as follows…

  1. Create the folder “\user_projects\domains\bifoundation_domain\servers\AdminServer\security” if it does not already exist.
  2. Create a file named “boot.properties” in this folder with the following two linesusername=weblogic
    password=___________
  3. When you restart the BI server it should use this file to supply the weblogic id and password. It will also encrypt the two lines.

Create Service Creation Scripts

Create a script named “InstallAdminService.cmd” located in the “\wlserver_10.3\server\bin” folder and insert the following lines into it…

 

SETLOCAL
set OBI_HOME={your BI home folder}
set DOMAIN_NAME=bifoundation_domain
set USERDOMAIN_HOME=%OBI_HOME%\user_projects\domains\bifoundation_domain
set SERVER_NAME=AdminServer
set PRODUCTION_MODE=true
set JAVA_VENDOR=Sun
set JAVA_HOME=%OBI_HOME%\Oracle_BI1\jdk
cd %USERDOMAIN_HOME%
call %USERDOMAIN_HOME%\bin\setDomainEnv.cmd
set SERVER_MEM_ARGS=-Xms1024m -Xmx2048m -XX:MaxPermSize=512m -XX:-UseSSE42Intrinsics
call “%OBI_HOME%\wlserver_10.3\server\bin\installSvc.cmd”
ENDLOCAL

Create a second script in the same folder named “InstallBIService.cmd” and insert the following lines into it…

SETLOCAL
set OBI_HOME={your BI home folder}
set DOMAIN_NAME=bifoundation_domain
set USERDOMAIN_HOME=%OBI_HOME%\user_projects\domains\bifoundation_domain
set SERVER_NAME=bi_server1
set PRODUCTION_MODE=true
set JAVA_VENDOR=Sun
set JAVA_HOME=%OBI_HOME%\Oracle_BI1\jdk
set ADMIN_URL=http://localhost:7001
cd %USERDOMAIN_HOME%
call %USERDOMAIN_HOME%\bin\setDomainEnv.cmd
@rem set SERVER_MEM_ARGS=-Xms4096m -Xmx4096m -XX:MaxPermSize=512m
call “%OBI_HOME%\wlserver_10.3\server\bin\installSvc.cmd”
ENDLOCAL

Run both of these two scripts as administrator and you should now see two new services (in the Windows services application)…

Oracle_bifoundation_domain_AdminServer

Oracle_bifoundation_domain_bi_server1

Note: If you need to remove these services you can do so with the following commands in a command prompt (ran as administrator)…

sc delete Oracle_bifoundation_domain_AdminServer

sc delete Oracle_bifoundation_domain_bi_server1

Editing the Registry

The following steps will insure that the (4) services (the two that were created out-of-the-box and the two that you just created above) will start in the proper order.

  1. Open the Registry Editor (regedit.exe)
  2. Locate: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\ServiceGroupOrder
  3. Open (double click) the “List” item and add the following four lines to the end of the value…OBI Node Manager
    OBI Admin Server
    OBI Managed Server
    OBI OPMN
  4. Locate: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet
  5. Find the WebLogic node manager
  6. Right click on the entry and select New / String Value:
  7. Enter the name “Group”
  8. Double click on “Group” and enter the “OBI Node Manager” group name created above
  9. Repeat for “Oracle_bifoundation_domain_AdminServer” and “OBI Admin Server”
  10. Repeat for “Oracle_bifoundation_domain_bi_server1” and “OBI Managed Server”
  11. Repeat for “OracleProcessManager_instance1” and “OBI OPMN”
  12. Right click on “Oracle_bifoundation_domain_AdminServer” and select New / Multi-String Value.
  13. Name it “DependOnService”
  14. Edit the value and add the name of the node manager service…Oracle WebLogic NodeManager (c_app_obiee_wlserver_10.3)
  15. Do the same for “Oracle_bifoundation_domain_bi_server1” but add two services…Oracle WebLogic NodeManager (c_app_obiee_wlserver_10.3)
    Oracle_bifoundation_domain_AdminServer
  16. Do the same for “OracleProcessManager_instance1” but add three services…Oracle WebLogic NodeManager (c_app_obiee_wlserver_10.3)
    Oracle_bifoundation_domain_AdminServer
    Oracle_bifoundation_domain_bi_server1

Testing

To test everything, restart the server. Even though the OBIEE servers have been started as services they still require the same amount of time to start. Wait 10 to 15 minutes and then check that the 4 services are all running and that OBIEE is accessible.

References

Oracle Fusion Middleware Administrator’s Guide
http://docs.oracle.com/cd/E28280_01/core.1111/e10105.pdf

Managing Server Startup and Shutdown for Oracle WebLogic Server
http://docs.oracle.com/cd/E23943_01/web.1111/e13708.pdf

Have more questions? We can help: