1. User's Guide
  2. Using the CellCLI Utility
  3. CellCLI Command Reference
  4. ALTER
  5. ALTER CELL
  6. ALTER CELL Commands for Setting Attributes
  7. Miscellaneous Attributes

7.7.1.2.4.9 Miscellaneous Attributes

Note:

For a complete list of cell attributes, see DESCRIBE CELL.

dbPerfDataSuppress

Use the dbPerfDataSuppress attribute to hide performance output information for specific databases. Specify the databases to mask as a comma-delimited list of names. The performance information for the specified databases is still collected, but is only visible when queried from that database. If you query V$CELL_DB from a different database, then the performance information for the hidden databases appears in the category of OTHER.

diagPackEmailAttach

Use the diagPackEmailAttach attribute to turn on and off adding the diagnostic pack attachment to emails, for example: 

alter cell diagPackEmailAttach=FALSE

See CREATE DIAGPACK for information about diagnostic packs.

diagPackUploadEnabled

Use the diagPackUploadEnabled attribute to enable or disable automatically uploading diagnostic data to a service request using Oracle ASR.

Example 7-28 Enabling/Disabling Auto Diagpack Upload

You can enable or disable this feature by setting the diagPackUploadEnabled attribute on the cell object.

Set the attribute to false to disable this feature, true to enable it. The default is true. 

CellCLI> ALTER CELL diagPackUploadEnabled=FALSE

enableSmartStorage

The enableSmartStorage attribute can be set to TRUE to enable the use of Oracle Exadata System Software capabilities such as Smart Scan and Storage Index on Exadata Extended (XT) Storage Server after you have procured the necessary software licenses.

httpsAccess

Starting with Oracle Exadata System Software release 19.1.0, the httpsAccess attribute can be used to specify a list of IP addresses or IP subnet masks that control who can access the RESTful service via HTTPs. The value you specify for httpsAccess overwrites any previous value. You can use the following values for httpsAccess:

  • ALL — to allow access to all hosts (Default)
  • NONE — to disable the HTTPs port completely
  • IP1, IP2,..., IPn — to only allow access to hosts with IP addresses IP1, IP2,..., IPn where IPn is a valid IP address in IPv4, IPv4 subnet, IPv6 or IPv4-embedded IPv6 format. You can specify a maximum of 512 IP addresses for the access control list.

Additionally, instead of a single IP address, you can use the / character to specify a range of IP addresses using a subnet mask. For example the range '192.168.10.0/24' corresponds to hosts having IP addresses from 192.168.10.1 to 192.168.10.255. If you specify an IP address range, you need to enclose the IP address string in quotes.

Example 7-29 Restricting HTTPS Access to the Exadata RESTful Service

This example shows how to configure an access control list for HTTPs access to the Exadata RESTful service. The following command allows HTTPs port access to hosts having IP addresses in the range from 192.168.10.1 to 192.168.10.255.

CellCLI> ALTER CELL httpsAccess="192.168.10.0/24"

interconnectN

The ALTER CELL interconnectN="" command removes the RDMA Network Fabric configuration information for the cell for the specified interface (N).

If the IP address to an RDMA Network Fabric interface is changed, then the command service openibd restart must be run as the root user before the service network restart command.

After changing an IP address, you must restart all services using the ALTER CELL RESTART SERVICES ALL command.

Example 7-30 Setting RDMA Network Fabric Interconnections

This example shows how to set the RDMA Network Fabric interconnections.

For systems that use InfiniBand Network Fabric, use a command such as the following: 

CellCLI> ALTER CELL interconnect1='ib0', interconnect2='ib1'

For systems that use RoCE Network Fabric, use a command such as the following: 

CellCLI> ALTER CELL interconnect1='re0', interconnect2='re1'

After making the updates, restart all services in the storage server:

CellCLI> ALTER CELL RESTART SERVICES ALL

iotimeoutthreshold

Use the iotimeoutthreshold attribute to change the timeout threshold. If cell I/O takes longer than the defined threshold, then the I/O is canceled, and Oracle ASM redirects the I/O to another mirror copy of the data. Any I/Os issued to the last valid mirror copy of the data are not canceled, even if the timeout threshold is exceeded.

The default value for iotimeoutthreshold is 1000s. The command takes a value, such as 5, and a unit. The valid unit is s, for seconds.

Caution:

Setting the timeout threshold too low can negatively impact system performance. Oracle recommends reviewing the Automatic Workload Repository (AWR) reports of peak I/O loads, and setting the threshold value to a value higher than the peak I/O latency with sufficient safety margin.

Example 7-31 Setting the iotimeoutthreshold Value

This example demonstrates how to set the iotimeoutthreshold to 5 seconds. 

CellCLI> ALTER CELL iotimeoutthreshold = '5s'

To reset the iotimeoutthreshold to the default value, use the following command: 

CellCLI> ALTER CELL iotimeoutthreshold = ""

listeningInterface

Starting with Oracle Exadata System Software release 24.1.0, the listeningInterface attribute specifies the network interfaces that listen for commands using the Exadata RESTful service. The value you specify for listeningInterface overwrites any previous value. You can use the following values for listeningInterface:

  • ALL — to allow access on all network interfaces (Default)
  • NONE — to disable access on all network interfaces
  • IP1, IP2, ..., IPn — to allow access only through the network interfaces associated with the specified IP addresses

The listeningInterface attribute complements the httpsAccess attribute. The listeningInterface attribute specifies which server network interfaces accept REST requests, while the httpsAccess attribute restricts the source of requests to the Exadata RESTful service.

Example 7-32 Restricting Access to the Exadata RESTful Service

This example shows how to identify a specific network interface on the server that listens for commands using the Exadata RESTful service.

CellCLI> ALTER CELL listeningInterface="192.168.10.11"

name

The name attribute contains the host name of the storage server, for example, dm01celladm01.

Example 7-33 Altering Cell Name

This example shows the ALTER command with the CELL object. 

CellCLI> ALTER CELL name=cell02

traceLevel

The level for which trace messages are written. The default is FINE. The value can be:

  • A valid Java logging level

    • SEVERE
    • WARNING
    • INFO
    • CONFIG
    • FINE
    • FINER
    • FINEST

  • A valid Oracle Diagnostic Logging (ODL) logging level

    • INCIDENT_ERROR:1
    • ERROR:1
    • WARNING:1
    • NOTIFICATION:1
    • NOTIFICATION:16
    • TRACE:1
    • TRACE:16
    • TRACE:32

To reset this attribute to its default value, use a value of "".

Examples

Example 7-34 Setting the traceLevel Value to its Default Value

This example shows how to set the traceLevel value to its default value. 

CellCLI> ALTER CELL traceLevel=""

Parent topic: ALTER CELL Commands for Setting Attributes