9.7.3.3 DESCRIBE DBSERVER

Purpose

The DESCRIBE DBSERVER command displays a list of attributes for the DBSERVER object type.

Syntax

DESCRIBE DBSERVER

Usage Notes

The following table lists the attributes for the DESCRIBE DBSERVER command.

Table 9-4 DESCRIBE DBSERVER Attributes

Attribute	Description
accountLockInDays	Number of days after a password expires before a user account is locked.
bbuStatus	Status of hard disk controller battery-backed unit (BBU).
comment	User-supplied text string.
corecount	Number of CPU cores in the database server. If expressed using the format n1/n2, then n1 is the number of currently enabled CPU cores and n2 is the total number of CPU cores in the database server.
cpuCount	Number of CPUs on the database server as reported by the operating system in /proc/cpuinfo and other utilities. This value factors in hyperthreading, so will always be twice the value of corecount. If expressed using the format n1/n2, then n1 is twice the number of currently enabled CPU cores and n2 is twice the total number of CPU cores in the database server.
diagHistoryDays	Number of days ADR files are retained. The default is 7 days.
diagPackEmailAttach	Whether a diagpack is included as an attachment in the alert email or not. The default is true.
diagPackUploadEnabled	Whether the auto diagpack upload feature is enabled or not. The default is true.
emailFormat	File format for email messages. The value can be HTML or text.
fanCount	Count of working fans and total fans, displayed as working/total.
fanStatus	Status of the fan. The value can be normal, warning, or critical.
httpsAccess	Control list of IP addresses for HTTPs port access to the Exadata RESTful Service
id	Global unique identifier (GUID) supplied by the hardware vendor.
interconnect1-4	Interconnect 1 to 4 for the database server. For example: bondeth0.
interconnectCount	Number of network interconnects.
ipaddress1-4	IP address 1 to 4 for the database server.
kernelVersion	Version of the host kernel software.
location	Physical location of the cell hardware supplied by the user.
locatorLEDStatus	Status of cell LOCATE LED. The value can be on or off.
mailServer	Fully qualified domain name of the email relay server used to send alert notifications. This attribute only requires specification in cases where DNS returns an unreachable or invalid mail exchange (MX) record for the email server specified in smtpToAddr.
makeModel	Make and model of the cell hardware supplied by the vendor.
metricCollection	Indicator for whether Management Server performs metric collection. Values are TRUE or FALSE. If set to FALSE, then all collection and alert mining is stopped. The default setting is TRUE.
metricHistoryDays	Number of days that regular metric history files are retained. The default is 7 days.
msVersion	Version of the management server.
name	Name of the database server.
notificationMethod	Notification method for alerts. The value should be mail, snmp, none, or both mail and snmp.
notificationPolicy	Indicator for severity alerts to be sent to subscribers. The value for notificationPolicy should be none or any combination of critical, warning, and clear.
powerCount	Count of power supplies, displayed as working/total.
powerStatus	Status of the power. The value can be normal, warning, or critical.
pwdExpInDays	The number of days before a user's password expires.
pwdExpWarnInDays	The number of days before a user's password expires that a warning message is issued during login attempts.
releaseImageStatus	Indicator for knowing whether imaging is successful or not.
releaseTrackingBug	Patch number for the cell software, such as 11223344.
releaseVersion	Release number for the cell software, such as 11.2.2.3.0.
remotePwdChangeAllowed	Whether or not a user password can be changed remotely through REST services.
rescuePlan	A list of commands that you can run after a server rescue to restore settings, such as thresholds and notifications, to the last known values.
smtpFrom	User name that appears in the From: header of the alert notifications.
smtpFromAddr	Email address that appears in the From: header of the alert notifications. This email address is not authenticated with the email server.
smtpPort	Email server port used to send alert notifications.
smtpSubscriber	List of hosts that subscribe to the SNMP alert notifications.
smtpToAddr	Address to which email is sent. It can be a comma-delimited list in quotation marks to allow multiple subscribers to alerts.
smtpUseSSL	Specification to use Secure Socket Layer (SSL) encryption for alert notifications.
status	Status of the database server.
syslogConf	Rules for the system logging utility syslogd.
temperatureReading	Current temperature (Celsius) of the cell obtained from the BMC.
temperatureStatus	Status of the temperature. The value can be normal, warning, or critical.
traceLevel	Level for which trace messages are written. This can be a valid Java logging level (SEVERE, WARNING, INFO, CONFIG, FINE, FINER, FINEST) or 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). The default is FINE.
upTime	Time (days, hours:minutes) since the system was restarted.

Examples

Example 9-40 Describing the DBSERVER Object

DBMCLI> DESCRIBE DBSERVER

	name                   modifiable
	bbuStatus
	comment                modifiable
	coreCount
	cpuCount
	diagHistoryDays        modifiable
	diagPackEmailAttach    modifiable
	diagPackUploadEnabled  modifiable
	emailFormat            modifiable
	emailSubscriber        modifiable
	fanCount
	fanStatus
	httpsAccess            modifiable
	iaasIdleInUse          modifiable
	iaasMode               modifiable
	iaasReason             modifiable
	id
	interconnectCount
	interconnect1          modifiable
	interconnect2          modifiable
	interconnect3          modifiable
	interconnect4          modifiable
	interconnect5          modifiable
	interconnect6          modifiable
	interconnect7          modifiable
	interconnect8          modifiable
	ipaddress1
	ipaddress2
	ipaddress3
	ipaddress4
	ipaddress5
	ipaddress6
	ipaddress7
	ipaddress8
	kernelVersion
	locatorLEDStatus
	location               modifiable
	mailServer             modifiable
	makeModel
	metricCollection       modifiable
	metricHistoryDays      modifiable
	msVersion
	notificationMethod     modifiable
	notificationPolicy     modifiable
	pendingCoreCount       modifiable
	powerCount
	powerStatus
	releaseImageStatus
	releaseVersion
	releaseTrackingBug
	securityCert           modifiable
	smtpFrom               modifiable
	smtpFromAddr           modifiable
	smtpPort               modifiable
	smtpToAddr             modifiable
	smtpUseSSL             modifiable
	snmpSubscriber         modifiable
	snmpUser               modifiable
	status
	syslogConf             modifiable
	temperatureReading
	temperatureStatus
	traceLevel             modifiable
	upTime
	msStatus
	rsStatus