Use the Cluster Manager

The Cluster Manager in the Administration Tool was used in previous updates to monitor and manage Oracle BI Server, Oracle BI Scheduler, and Cluster Controller instances.

Although you use Fusion Middleware Control for most administrative tasks that relate to clustered components, the Cluster Manager provides a useful way to view the state of clustered components. For example, you can view the currently active Oracle BI Scheduler instance and see which Oracle BI Server is the primary BI Server. Fusion Middleware Control shows the current status of clustered components, but doesn't provide a way to view the current state.

The Cluster Manager enables you to monitor, analyze, and manage the operations of Oracle BI Server, Oracle BI Scheduler, and Cluster Controller instances in a cluster. It provides status, cache, and session information. The Cluster Manager is available only when the Administration Tool is connected to a clustered DSN.

If all Cluster Controllers or Oracle BI Servers in the cluster are currently stopped or offline, then you can't access the Cluster Manager to start them. You must manually start one Cluster Controller (generally, the primary) and one Oracle BI Server.

The Cluster Manager window has two panes: the Explorer pane on the left side and the Information pane on the right side. The Explorer pane displays hierarchical information about the servers, schedulers, and controllers that comprise a cluster. The Information pane shows detailed information about an item selected in the Explorer pane.

The Cluster Manager window refreshes every minute by default. You can change the interval.

  1. In the Administration Tool, open a repository.

  2. Select Manage, then Clusters.

  3. Select Refresh, then Every, and select another value from the list.

  4. To refresh the display at any time, ensure that the Cluster Manager is the active window and press F5, or select Refresh, then Now. This action retrieves the most current information for the cluster.

View and Manage Cluster Information

Cluster information provides an insight into the application.

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

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. The following table describes categories that might appear.

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's hosting the Oracle BI Server or Cluster Controller.

Role

The role of the object in the cluster:

  • Controlling. A Cluster Controller that's currently assigned the responsibility for control of the cluster.

  • Primary. The Primary Cluster Controller. This role isn't displayed if the Primary Cluster Controller is currently the controlling Cluster Controller.

  • Secondary. The Secondary Cluster Controller. This role isn't displayed if the Secondary Cluster Controller is currently the controlling Cluster Controller.

  • Clustered server. An Oracle BI Server that's a member of the cluster. This role isn't displayed for the clustered server that's defined as the master server.

  • Master. The clustered server that the Administration Tool connects to for editing repositories.

  • 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.

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 can complete before the server transitions to Offline status.

  • Offline. The Cluster Controller or Oracle BI Server is offline. Offline Cluster Controllers can't accept session requests or assign sessions to available servers within the cluster. Offline Oracle BI Servers don't communicate with the controlling Cluster Controller and can't accept sessions assigned by the controlling Cluster Controller. If the server subsequently becomes available, then the server can participate in the cluster. To stop the Cluster Controller or clustered server after quiescing it, enter 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's 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 runs 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.

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. The table below describes categories that might appear.

Column Description

Business Model

Name of the business model that's 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.

Last used

Last time the result set of the cache entry satisfied a query. (After an unexpected shutdown of an Oracle BI Server, the Last used time might temporarily have a stale value, that's older than the true value.)

Row count

Number of rows that are generated by the query.

Row size

Size of each row (in bytes) in this cache entry's result set.

SQL

Text of the SQL statement that generated the cache entry.

Use count

Number of times that this cache entry's result set has satisfied a query (since Oracle BI Server startup).

User

Name of the user who submitted the query that resulted in the cache entry.

To view cache information click an individual server in the Explorer pane, and then select View, then Cache.

Session Information

You can review Session information in two places.

The Session view is available for Oracle BI Servers. The information is arranged in two windows, described in the table.

  • Session window: Appears on the top. Shows users currently logged on to the Oracle BI Server.

  • Request window: Appears on the bottom. Shows active query requests for the user selected in the Session window.

The following table describes the information that's displayed in the Session window.

Column Description

Catalog

Name of the Presentation Catalog to which the session is connected.

Client Type

Type of client session. The client type of Administration is reserved for the user who's logged in with the Administrator user ID.

Last Active Time

Timestamp of the last activity on the session or the query.

Logon Time

Timestamp when the session logged on to the Oracle BI Server.

Repository

Logical name of the repository to which the session is connected.

Session ID

Unique internal identifier that the Oracle BI Server assigns each session when the session is initiated.

User

Name of the user connected.

The following table describes the information that's displayed in the Request window.

Column Description

Last Active Time

Timestamp of the last activity on the session or the query.

Request ID

Unique internal identifier that the Oracle BI Server assigns each query when the query is initiated.

Session ID

Unique internal identifier that the Oracle BI Server assigns each session when the session is initiated.

Start Time

Time of the initial query request.

Status

These are the possible values. Due to the speed at which some processes complete, not all values for any given request or session might appear.

  • Idle. There's presently no activity on the request or session.

  • Fetching. The request is being retrieved.

  • Fetched. The request has been retrieved.

  • Preparing. The request is being prepared for processing.

  • Prepared. The request has been prepared for processing and is ready for execution.

  • Executing. The request is currently running. To terminate a request, select it and click Kill Request. The user receives an informational message that indicates that the Administrator canceled the request.

  • Executed. The request has finished running.

  • Succeeded. The request ran to completion successfully.

  • Canceled. The request has been canceled.

  • Failed. An error was encountered during the processing or running of the request.

To view session information:

  • Select a server in the Explorer pane, and select View, then Sessions.

    Session information for the server is displayed in the Information pane. It shows all users logged into the server and all current query requests for each user.

To disconnect a session:

  • In the Session view, right-click the session in the Session window (top window) and click Disconnect.

    When you disconnect a session, the ODBC session is terminated. Users who were connected during this session receive error messages if they attempt to run queries. Users must log out, then log back in again to start a new session.

To terminate a query request:

  • In the Session view, right-click the request in the Request window (bottom window) and click Kill Request.

    When you terminate a query request, the user who's initiating the query receives an error.

Server Information

Information about the cluster server is available from the application menu.

Selecting Server info from the View menu provides information about the cluster server, such as server version number.