Monitoring and Managing Exadata Storage Servers with ExaCLI
Learn to use the ExaCLI command-line utility to perform monitoring and management functions on Exadata storage servers in the Exadata Cloud Service.
- About the ExaCLI Command
The ExaCLI command provides a subset of the commands found in the on-premises Exadata command line utility. - Exadata Storage Server Username and Password
You need a username and password to connect to the Exadata Storage Server. - ExaCLI Command
Use ExaCLI (exacli
) to configure cell, database node configuration, and objects in the remote node environment, and to monitor your Oracle Exadata Database Service on Cloud@Customer service and objects. - Connecting to a Storage Server with ExaCLI
To use ExaCLI on storage servers, you will need to know your target storage server's IP address.
About the ExaCLI Command
The ExaCLI command provides a subset of the commands found in the on-premises Exadata command line utility.
ExaCLI offers a subset of the commands found in the on-premises Exadata command line utility. The utility runs on the database compute nodes in the Exadata Cloud Service.
Related Topics
Exadata Storage Server Username and Password
You need a username and password to connect to the Exadata Storage Server.
On Exadata Database Service on Cloud@Customer, the preconfigured user for Exadata Storage
Server is cloud_user_clustername
, where
clustername
is the name of the virtual
machine (VM) cluster that is being used.
crsctl
command as the grid
user on any cluster
node:crsctl get cluster name
cloud_user_clustername
is initially
set to a random value, which you can view by running the following command as the
opc
user on any cluster
node:/opt/exacloud/get_cs_data.py
ExaCLI Command
Use ExaCLI (exacli
) to configure cell, database node configuration, and objects in the remote node environment, and to monitor your Oracle Exadata Database Service on
Cloud@Customer service and objects.
Purpose
ExaCLI (exacli
) enables you configure your Oracle Exadata Database Service on
Cloud@Customer system, and to obtain real-time information about your Exadata Cloud Service. To obtain information about the services and options on your system, run ExaCLI using the monitoring command parameter that you require.
To obtain a list of the system monitoring parameters you can use with
ExaCLI, run the LIST
parameter.
Syntax
exacli -c [username@]remotehost[:port]
[-l username]
[--xml]
[--cookie-jar filename]
[-e {command | 'command; command' | @batchfile}]
Options
Option | Description |
---|---|
|
Specifies the remote node to which you want to connect. ExaCLI prompts for the user name if not specified. |
|
Specifies the user name to log into the remote node.
The preconfigured user is cloud_user_clustername .
|
|
Displays the output in XML format. |
|
Specifies the file name of the cookie jar to use. If you do not specify a file name, then the cookie is stored in a default cookie jar located at The presence of a valid cookie allows the ExaCLI user to run commands without requiring the user to log in during subsequent ExaCLI sessions. |
|
Specifies either the ExaCLI commands to run, or a batch file. After running the commands, ExaCLI quits. If you are specifying multiple commands to run, then enclose the commands in single quotes to prevent the shell from interpreting the semicolon. To start an interactive ExaCLI session, omit this command. |
--cert-proxy
proxy[:port] |
Specifies the proxy server that you want to use when
downloading certificates. If port is
omitted, then port 80 is used by default.
|
|
Suppresses prompting for user input. |
Command Parameters
To obtain information about objects and services on your system, use these ExaCLI command parameters.
Table 7-1 Command
Command Parameter | Description |
---|---|
|
Lists all active requests that are currently being served by the storage servers. |
|
Lists all possible alerts and their sources for storage servers. |
|
Lists all alerts that have been issues for the storage servers. |
|
Used to list the details of a specific attribute of
the storage servers or storage cells. The syntax is as follows:
|
|
Lists the attributes of the cell disks in the
storage servers. Use the following syntax to list the cell disk
details: |
|
Lists details of the databases. Uses the regular
|
|
Lists the details of the Exadata system's flash
cache. For this object, you can use the following syntax
patterns: |
|
Lists the details of all objects in the flash cache,
or the details of a specified object ID. To list all the details
of all objects, use To list details for a specific object, use a where
clause as follows: Example query: finding the
object_id value of an
object
|
|
Lists the attributes for the Oracle Exadata Smart Flash Log. |
|
Lists the details of a particular grid disk. The
syntax is similar to the |
|
Lists details of the InfiniBand ports. Syntax is
|
|
Use the ExaCLI |
|
Lists any IORM profiles that have been set on the
storage servers. You can also refer back to the profile
attribute on the |
|
Lists the command parameter options available with ExaCLI for the Exadata Database Service on Cloud@Customer services and objects. |
|
The LUN (logical unit number) object returns the
number and the detail of the physical disks in the storage
servers. List the LUNs of the disks with |
|
Lists the current metrics for a particular object
type. Syntax is This command also allows for sorting and results
limits as seen in the following
example:
|
|
Lists metric definitions for the object that you can
then get details for. With the command
LIST
metricDefinition WHERE objectType=cell , you can get
all the metrics for that object type. You can then use the
metric definition object again to get details for one of those
specific metrics just
listed:
|
|
List metrics over a specified period of time. For
example, with the command Use |
|
Lists the attributes for the offload group that are
running on your storage servers. You can list all details for
all groups with |
|
Lists all physical disks. Use the results of
|
|
Lists all PDBs. View the details of a specific PDB
with |
|
Lists all SQL statements that you prevented from
using Smart Scans. The syntax is |
|
Use the ExaCLI To download a diagnostic package, use
|
Usage Notes
- Notes for the
--cookie-jar
option:- The user name and password are sent to the remote node for
authentication. On successful authentication, the remote node issues a
cookie (the login credentials) that is stored in the specified filename
on the database node. If filename is not specified, the cookie is stored
in a default cookie jar located at
HOME/.exacli/cookiejar
, whereHOME
is the home directory of the operating system user running the ExaCLI command. For theopc
user, the home is/home/opc
. - The operating system user running the ExaCLI command is the owner of the cookie jar file.
- A cookie jar can contain multiple cookies from multiple users on multiple nodes in parallel sessions.
- Cookies are invalidated after 24 hours.
- If the cookie is not found or is no longer valid, ExaCLI
prompts for the password. The new cookie is stored in the cookie jar
identified by
filename
, or the default cookie jar iffilename
is not specified. - Even without the
--cookie-jar
option, ExaCLI still checks for cookies from the default cookie jar. However, if the cookie does not exist or is no longer valid, the new cookie will not be stored in the default cookie jar if the--cookie-jar
option is not specified.
- The user name and password are sent to the remote node for
authentication. On successful authentication, the remote node issues a
cookie (the login credentials) that is stored in the specified filename
on the database node. If filename is not specified, the cookie is stored
in a default cookie jar located at
- Notes for the
-e
option:- ExaCLI exits after running the commands.
- If specifying multiple commands to run, be sure to enclose the commands in single quotes to prevent the shell from interpreting the semi-colon.
- The batch file is a text file that contains one or more ExaCLI commands to run.
- Notes for the
-n
(--no-prompt
) option:- If ExaCLI needs additional information from the user, for example, if ExaCLI needs to prompt the user for a password (possibly because there were no valid cookies in the cookie-jar) or to prompt the user to confirm the remote node’s identity, then ExaCLI prints an error message and exits.
Examples
Example 7-57 Starting an Interactive ExaCLI Session on a Storage Server
exacli -l cloud_user_clustername -c 192.168.136.7
See "Finding the IP addresses of storage cells using the cellip.ora file" for information about how to determine your storage server IP address.
exacli cloud_user_clustername@192.168.136.7> LIST DATABASE
ASM
HRCDB
Example 7-58 Issuing a Single Command on a Compute Node
- Connects to a storage server
- Performs a
LIST
action - Exits the session (specified with the
-e
option)
exacli -l cloud_user_clustername -c 192.168.136.7 --xml --cookie-jar -e list griddisk detail
Related Topics
Connecting to a Storage Server with ExaCLI
To use ExaCLI on storage servers, you will need to know your target storage server's IP address.
If you do not know the IP address of the node you want to connect to, you can
find it by viewing the contents of the cellip.ora
file.
cat /etc/oracle/cell/
network-config/cellip.oracle
cell="192.168.136.5;cell="192.168.136.6"
cell="192.168.136.7;cell="192.168.136.8"
cell="192.168.136.9;cell="192.168.136.10"
exacli -l cloud_user_clustername -c 192.168.136.7 --cookie-jar
No cookies found for cloud_user_clustername@192.168.136.7
Password: *********
EXA-30016: This connection is not secure. You have asked ExaCLI to connect to cell 192.168.136.7 securely. The identity of 192.168.136.7 cannot be verified.
Got certificate from server:
C=US,ST=California,L=Redwood City,O=Oracle Corporation,OU=Oracle Exadata,CN=ed1cl03clu01-priv2.usdc2.oraclecloud.com
Do you want to accept and store this certificate? (Press y/n)
Accept the self-signed Oracle certificate by pressing "y" to continue using ExaCLI.