If the Oracle BI Scheduler instance selected is inactive, then select Activate

6.4.1 Viewing and Managing Cluster Information

The section describes how to view status, cache, and session information about a cluster and the meaning of the information provided.

6.4.1.1 Status Information

The Status view is automatically displayed when you first open the Cluster Manager window. You can also access the Status view by selecting View, then Status in the Cluster Manager window.

The categories of information that are displayed in the Information pane might vary depending on the server to which the Administration Tool is connected. Table 6–4

describes categories that might appear.

Table 6–4 Status Columns

Column Description

Last Reported Time

The time that the Cluster Controller or Oracle BI Server communicated with the Controlling Cluster Controller. If the server or controller is offline, then this field might be blank.

Name The name of the computer that is hosting the Oracle BI Server or Cluster Controller.

Role The role of the object in the cluster:

■ Controlling. A Cluster Controller that is currently assigned the responsibility

for control of the cluster.

■ Primary. The Primary Cluster Controller. This role is not displayed if the

Primary Cluster Controller is currently the controlling Cluster Controller.

■ Secondary. The Secondary Cluster Controller. This role is not displayed if the

Secondary Cluster Controller is currently the controlling Cluster Controller.

■ Clustered server. An Oracle BI Server that is a member of the cluster. This

role is not displayed for the clustered server that is defined as the master server.

■ Master. The clustered server that the Administration Tool connects to for

editing repositories in online mode.

■ Active. The Oracle BI Scheduler is active.

Sessions This field is available when either Servers or an individual server is selected in the Explorer pane. It shows the number of sessions that are currently logged on to a clustered server.

Start Time The timestamp showing when the Cluster Controller or Oracle BI Server was last started. This field is blank if the Cluster Controller or clustered server is offline.

Using the Cluster Manager

6.4.1.2 Cache Information

The Cache view is available in the Cluster Manager window if caching is enabled. The categories of information and their display sequence are controlled by the Options settings. Table 6–5 describes categories that might appear.

Status The status of the object in the cluster:

■ Online. The Cluster Controller or Oracle BI Server is online. Online Cluster

Controllers can accept session requests and assign them to available servers within the cluster. Online Oracle BI Servers can be assigned sessions by the Cluster Controller.

■ Quiesce. This status is applicable to clustered servers only. When a server is

quiesced, any activity in progress on outstanding sessions is allowed to complete before the server transitions to Offline status.

■ Offline. The Cluster Controller or Oracle BI Server is offline. Offline Cluster

Controllers cannot accept session requests or assign sessions to available servers within the cluster. Offline Oracle BI Servers do not communicate with the controlling Cluster Controller and cannot accept sessions assigned by the controlling Cluster Controller. If the server subsequently becomes available, then it is allowed to participate in the cluster. To stop the Cluster Controller or clustered server after quiescing it, issue the Stop command.

■ Forced Offline. This status applies to clustered servers only. The Oracle BI

Server has been stopped. This is identical to the offline status, except that if the Oracle BI Server comes back online, it is not assigned requests. The server remains in this state until the Start command is issued against this server from the Administration Tool Cluster Manager, or both Cluster Controllers are shut down and restarted.

■ Online: Active. The Oracle BI Scheduler instance is online, running, and the

one to which Oracle BI Scheduler clients connect. This instance executes jobs.

■ Online: Inactive. The Oracle BI Scheduler is online but not running. This

instance is ready to take over for the active instance if the active instance becomes unavailable.

■ Online: Inactive Pending. The Oracle BI Scheduler was active and is trying

to go into an inactive state. This might take a few minutes (for example, if multiple jobs are running).

Type When Clusters is selected in the Explorer pane, this field is available. There are three types:

■ Controller. The object is a Cluster Controller. ■ Server. The object is an Oracle BI Server. ■ Scheduler. The object is a Scheduler Server.

Table 6–5 Cache View Columns

Column Description

Business Model Name of the business model that is associated with the cache entry. Column count Number of columns in each row of this cache entry's result set. Created Time the result set of the cache entry was created.

Creation elapsed time

Time, in milliseconds, needed to create the result set for this cache entry. Full size Full size is the maximum size used, considering variable length columns,

compression algorithm, and other factors. The actual size of the result set is smaller than Full size.

Table 6–4 (Cont.) Status Columns

Using the Cluster Manager

Deploying Oracle Business Intelligence for High Availability 6-11

To view cache information: