/ OBIEE

Starting and Stopping OBIEE

OBIEE 11g init.d Script

Right away I suggest you take a look at RittmanMead's init.d script located here on github. This script is really well written and handles the startup and shutdown of Node Manager, Admin Server, bi_server, and OPMN. Enable it with chkconfig and and it will nicely handle server reboots. I also like to call this script via Ansible playbooks after deploying RPDs or doing a security migration to make changes take affect.

OBIEE 11g Manually

I would highly recommend setting up your boot.properties files for both AdminServer and bi_servers. This way you will not be prompted to enter a username/password during the service startups.

Create boot.properties files in these locations:

$ORACLE_HOME/user_projects/domains/bifoundation_domain/servers/AdminServer/security/boot.properties
$ORACLE_HOME/user_projects/domains/bifoundation_domain/servers/bi_server1/security/boot.properties

Put your weblogic username and password in these files like this:

password=<MyWeblogicPassword>
username=weblogic

On the next server startup the contents of these files will be encrypted and used to startup the server without login prompts.

Nodemanager

BASH

Startup

$ $ORACLE_HOME/wlserver_10.3/server/bin/startNodeManager.sh

Shutdown

$ ps aux |grep NodeManager
$ kill PID

WLST

Startup

startNodeManager(verbose='true', NodeManagerHome='$ORACLE_HOME/wlserver_10.3/common/nodemanager/', ListenAddress='0.0.0.0');
exit()

Shutdown
In this example I am using keyfile to login without username/password

nmConnect(userConfigFile='/home/oracle/installers/wlst/configfile.secure',
 userKeyFile='/home/oracle/installers/wlst/keyfile.secure',
 port=9556, domainName='bifoundation_domain',
 domainDir='$ORACLE_HOME/user_projects/domains/bifoundation_domain/')
stopNodeManager()

Admin Server

Startup Script

$ $ORACLE_HOME/user_projects/domains/bifoundation_domain/bin/startWebLogic.sh 

Shutdown Script

$ $ORACLE_HOME/user_projects/domains/bifoundation_domain/bin/stopWebLogic.sh 

bi_server

In these examples I am using bi_server1, but might be another server number if this is a cluster.

Startup Script

$ $ORACLE_HOME/user_projects/domains/bifoundation_domain/bin/startManagedWebLogic.sh bi_server1

Shutdown Script

$ $ORACLE_HOME/user_projects/domains/bifoundation_domain/bin/stopManagedWebLogic.sh bi_server1

OPMN

In these examples I am using instance1, but might be another instance number if this is a cluster.

Start All

$ $ORACLE_HOME/instance1/bin/opmnctl startall

Stop All

$ $ORACLE_HOME/instance1/bin/opmnctl stopall

Start/stop single OPMN processes

  • First get a status to see what is needing attention. This will also display the ias-component name
$ ORACLE_HOME/instance1/bin/opmnctl status

Processes in Instance: instance1
---------------------------------+--------------------+---------+---------
ias-component                    | process-type       |     pid | status
---------------------------------+--------------------+---------+---------
essbasestudio1                   | EssbaseStudio      |   27439 | Alive
essbaseserver1                   | Essbase            |   27440 | Alive
coreapplication_obiccs1          | OracleBIClusterCo~ |   27438 | Alive
coreapplication_obisch1          | OracleBIScheduler~ |   27437 | Alive
coreapplication_obijh1           | OracleBIJavaHostC~ |   27436 | Alive
coreapplication_obips1           | OracleBIPresentat~ |     N/A | Down
coreapplication_obis1            | OracleBIServerCom~ |   27435 | Alive

In this case obips1 is down.

  • Lets start it up using startproc with the ias-component name
$ ORACLE_HOME/instance1/bin/opmnctl startproc ias-component=coreapplication_obips1
opmnctl startproc: starting opmn managed processes...
  • Check the status again and verify it is running
coreapplication_obips1           | OracleBIPresentat~ |     N/A | Alive

12c

There are a couple of nice surprises when it comes to 12c. First, there are no more OPMN components to worry about. Second, Oracle was kind enough to provide startup/shutdown scripts out of the box! These scripts will control the Node Manager, Admin Server, and the BI server/components.

The scripts

Startup

$ $ORACLE_HOME/user_projects/domains/bi/bitools/bin/start.sh

Shutdown

$ $ORACLE_HOME/user_projects/domains/bi/bitools/bin/stop.sh

Status

$ $ORACLE_HOME/user_projects/domains/bi/bitools/bin/status.sh

Start/Stop single process

In this example I am starting obips1

$ $ORACLE_HOME/user_projects/domains/bi/bitools/bin/start.sh -i obips1

Clusters

Another nice feature about 12c is controlling nodes in a cluster. On any additional nodes the only thing you need to start is the Node Manager, and then the primary server will handle the rest.

Additional Nodes

$ nohup $ORACLE_HOME/user_projects/domains/bi/bin/startNodeManager.sh &