9.7.7.3 LIST DBSERVER

Purpose

The LIST DBSERVER command displays all alerts that occurred on the database server.

Syntax

LIST DBSERVER [ name |  attribute_filters ]  [attribute_list]  [DETAIL]

Usage Notes

You can use the DESCRIBE DBSERVER command to view the complete list of DBSERVER attributes.

Examples

Example 9-62 shows the output of the LIST DBSERVER DETAIL command.

Example 9-63 shows how to display the value of the rescuePlan attribute.

Example 9-64 shows how to retrieve the value of the httpsAccess attribute.

Example 9-62 Listing DBSERVER Attributes

DDBMCLI> LIST DBSERVER DETAIL
         name:                   myexadb03
         bbuStatus:              normal
         cpuCount:               24
         diagHistoryDays:        7
         fanCount:               16/16
         fanStatus:              normal
         httpsAccess             ALL
         id:                     1029FMM085
         interconnectCount:      2
         ipaddress1:             192.168.10.25/22
         kernelVersion:          2.6.39-400.220.0.el6uek.x86_64
         locatorLEDStatus:       on
         makeModel:              Oracle Corporation SUN FIRE X4170 M2 SERVER
         metricHistoryDays:      7
         msVersion:              OSS_MAIN_LINUX.X64_140921
         powerCount:             2/2
         powerStatus:            normal
         releaseImageStatus:     success
         releaseVersion:         12.1.2.1.0.140728
         releaseTrackingBug:     17885582
         snmpSubscriber:          
         host=10.133.131.130,port=162,community=public,type=asr
         status:                 online
         temperatureReading:     20.0
         temperatureStatus:      normal
         upTime:                 55 days, 5:12
         msStatus:               running
         rsStatus:               running

DBMCLI> LIST DBSERVER ATTRIBUTES status,uptime
         online  161 days, 3:11

Example 9-63 Displaying the rescuePlan Attribute

DBMCLI> LIST DBSERVER ATTRIBUTES rescuePlan

CREATE ROLE "listdbserverattrs"

GRANT PRIVILEGE list ON DBSERVER ATTRIBUTES bbuStatus, coreCount WITH ALL OPTIONS TO ROLE "listdbserverattrs"

ALTER DBSERVER diagHistoryDays="7", metricHistoryDays="7", bbuLearnSchedule="MONTH 1 DATE 17 HOUR 2 MINUTE 0", alertSummaryStartTime="2016-09-26T08:00:00-07:00", alertSummaryInterval=weekly, pendingCoreCount="128" force

Example 9-64 Displaying the HTTPs Access Control List

This example shows how to view the HTTPs access control list for the Exadata RESTful service.

DBMCLI> LIST DBSERVER ATTRIBUTES httpsAccesss
         ALL

The value of ALL is the default value and allows access to all hosts.