OBIEE 12c Administration

Commands to start and stop services

No More OPMN....  All weblogic now

Stopping OBIEE 12c:

Go to the directory: [ORACLE_HOME]/user_projects/domains/bi12/bitools/bin

Unix: ./stop.sh or ./stop.sh -i obis1,obips1

Command Prompt: stop.cmd or stop.cmd {-i <list of instances>} {-r}

Note: If no instances are specified as arguments in the command, 
the administration server, managed server and all system components are shutdown by default.

Starting OBIEE 12c

[ORACLE_HOME]/user_projects/domains/bi12/bitools/bin

./start.sh | start.cmd {-noprompt} {-i <list of instances>} {-r}

For example, ./start.sh -i obis1,obips1
If no instances are specified as arguments in the command,
the administration server, managed server, all system components, and local node manager are started by default.

Status of OBIEE 12c Services (All Weblogic)

./status.sh | status.cmd {-v}

where {-v} is verbose

The command displays component name, type, status, and machine name.

·                     BI Server (OBIS) — This component provides the query and data access capabilities at the heart of Oracle Business Intelligence and provides services for accessing and managing the enterprise semantic model (stored in a file with an .RPD extension).

·                     BI Scheduler (OBISCH) — This component provides extensible scheduling for analyses to be delivered to users at specified times. (Oracle BI Publisher has its own scheduler.)

·                     BI JavaHost (OBIJH) — This component provides component services that enable Oracle BI Presentation Services to support various components such as Java tasks for Oracle BI Scheduler, Oracle BI Publisher, and graph generation. It also enables Oracle BI Server query access to Hyperion Financial Management and Hyperion Planning data sources.

·                     Essbase — This component provides support for Essbase.

·                     BI Presentation Server (OPBIPS) — This component provides the framework and interface for the presentation of business intelligence data to web clients. It maintains an Oracle BI Presentation Catalog service on the file system for the customization of this presentation framework.

·                     Cluster Controller (OBICCS) — This component distributes requests to the BI Server, ensuring requests are evenly load-balanced across all BI Server process instances in the BI domain.

RPD DEPLOYMENT IN OBIEE 12C

Go to the path :

/app/oracle/biee/user_projects/domains/bi/bitools/bin

Run the below command:

./data-model-cmd.sh uploadrpd -I /app/oracle/biee/GSEOBIA.rpd -W Admin123 -SI ssi -U weblogic -P Admin123

Note: The path highlighted in green is the one where you have placed RPD which is to be deployed.

After this start the services. To start the whole server (Admin and managed servers) run the below command:

./start.sh

./stop.sh

And to start the biserver and presentation server, run the below commands:

./start.sh -i bi_server1,obips1

./stop.sh -i bi_server1,obips1

./status.sh

PATH WHERE WE CAN FIND THE RPD DEPLOYED ON THE SERVER

In 11g you could simply FTP the current RPD file down from the server, edit it in the Administrator utility and then use the Enterprise Manager Deployment screen to upload it, followed by a manual restart of the OBIEE components. Or if you preferred, stopped OBIEE, FTP’d the file back to the server and restarted OBIEE.

In 12c you cannot simply FTP the current RPD down from the server and the enterprise manager no longer contains a deployment screen to put it back!

So firstly, where is the RPD file? Many directories in the OBIEE installation have changed in 12c and the RPD now is located in:

/app/oracle/biee/user_projects/domains/bi/bidata/service_instances/ssi/metadata/datamodel/customizations