Bug: creation of Windows service for Oracle BI 12.2.1.2.0 within installation

During the installation of Oracle BI 12c (Version 12.2.1.2.0) a Windows service called “Oracle Business Intelligence [bi]” is automatically created to start & stop the BI services (Weblogic + BI Domain) as a Windows service e.g. to auto startup the BI Services in case the complete windows server is re-booted.

For the current version 12.2.1.2.0 a bug exist which configures the Environment variables incorrectly when the Oracle BI installation is not done to the C:\ drive, but another hard drive within the server, such as D:\ . The issue only applies to starting and stopping the BI Services via the Windows Service method and not to starting/stopping via from the start.cmd command line (as the Windows service points to a different start script located in the oracle.bi.sysman directory and does not use the regular bitools/bin/start.cmd script). The incorrect setting of the Environment variables prevents the Windows service from starting the BI Services and the following error is written to the windows services log file:

BI_PRODUCT_HOME set as c:\windows\system32
ORACLE_HOME set as C:\Windows
[…]
The system cannot find the path specifiedimage
This is caused by an within the start.cmd script which is called from the Windows service “Oracle Business Intelligence [bi]” and located in the following directory:

D:\Oracle\Obiee12c\bi\modules\oracle.bi.sysman\scripts\start.cmd

The script uses the windows shell command pushd and popd to write the current working directory into the session, but doesn’t catch if the installation is done to a different drive from C:\ when performing a cd (change directory) command. This can be seen by the fact that the BI_PRODUCT_HOME and ORACLE_HOME are referencing (pointing) to the patch of the windows cmd tool C:\windows\system32 rather then the correct Oracle BI installation directory.

As a workaround the pushd and popd have been removed from the start.cmd script and the path has been specified for path Environment variables BI_PRODUCT_HOME & ORACLE_HOME.

SET BI_PRODUCT_HOME=D:\Oracle\Obiee12c\bi\
ECHO BI_PRODUCT_HOME set as %BI_PRODUCT_HOME%
SET ORACLE_HOME=D:\Oracle\Obiee12c
ECHO ORACLE_HOME set as %ORACLE_HOME%
SET default_biDomainHome=%ORACLE_HOME%\user_projects\domains\bi


after saving the file like above the Windows service uses the correct environment variable path, as seen by comparing both highlighted areas below:

Advertisements

starting selective BI Services with OPMN

OPMN allows to control all BI 11g Services including starting and stopping.

The installer often installs two executables into the directory structure:

image

However only one is typically working right after the installation, the other will throw the following error message:

opmnctl: ORACLE_INSTANCE is not set.
opmnctl status requires that ORACLE_INSTANCE be correctly set 
in your environment.
Make sure you are using ORACLE_INSTANCE/bin/opmnctl, or set 
ORACLE_INSTANCE in your environment.

image

In this case the working opmn is installed in the following directory:

/home/oracle/Middleware/instances/instance1/bin

image

the status can be check with the following command:

./opmnctl status

image

To start an individual service the following command needs to be used:

./opmnctl startproc ias-component=coreapplication_obips1

image

After this, the Oracle BI Presentation Service is up alive.