a. dbmcli -d -u control, – Login b. dbmcli -d -u control, db_offline|db_state| db_online – Shutdown c. dbmcli db_enum & sdbuninst -l – Identify. The Database Manager has a command-line oriented client, the Database Manager CLI (DBMCLI). The Database Manager CLI is. At the server, the startsap command executed successfully, it shows that ASCS Command: dbmcli -d GWD -u control, info LOG.
|Published (Last):||16 July 2009|
|PDF File Size:||8.27 Mb|
|ePub File Size:||19.92 Mb|
|Price:||Free* [*Free Regsitration Required]|
This chapter contains the following topics:. Monitoring Database Server with Metrics. The DBMCLI utility is the command-line administration tool for configuring database servers, and managing objects in the server environment. You use DBMCLI to start and stop the server, to manage server configuration information, and to enable or disable servers.
The command-line utility is already installed when Oracle Exadata Database Machine is shipped. This section contains the following topics:. The command-line syntax is as follows:. This option suppresses the command prompt and disables the command-line editing features. Sets the log level. The -v option is for fine, -vv is for finer, and -vvv is for the finest level. Commands, objects, and options are not case-sensitive except where explicitly stated, such as in string patterns used in filtering strings with the LIKE operator.
Use single quotation marks or double quotation marks around the name of an object that includes spaces or punctuation. The use of quotation marks should match.
For example, “this is incorrect’ is incorrect because the first mark is double quotation marks, and the second is a single quotation mark. The database command-line utility reads commands from standard input and writes output to standard output.
You can use the host operating system options for redirecting input and output to compose and process command scripts.
For example, you can perform the following redirection:. In the preceding example, the output from DBMCLI commands in the command-script-in file are written to the results-out file. To continue a long command on to the next line, insert a hyphen – at the end of the line. Then, press Enter, and continue typing the command. The dbmadmin user should be used to run all services on the database server.
The dbmmonitor user is for monitoring purposes. The dbmmonitor user can run the following commands:. Alerts are defined on metrics and other sources of alerts. LUNs are automatically discovered when the server is started. They are assigned to the corresponding disk when the disk is first created or when disks are discovered after the system is restarted. The rules include boundary threshold values and how long the metric values can violate these boundaries before an alert is generated.
Not all possible command-object combinations are valid. For valid command-object combinations, review the syntax for the specific object command.
Attribute filters and lists are used to specify which attributes and objects are displayed in the output of the LIST command. All attributes can be displayed, but only some can be modified directly by the user. The value of the name attribute must be less than characters and composed only of the following ASCII characters alphanumeric and underscore only:.
The value of the comment attribute must be less than characters. You can specify which attributes to display for the LIST command with the following optional clause:.
You can specify which objects to display with the LIST command using the following optional clause:. Each attribute-filterN has the following syntax:.
The supported operators are listed in Table These operators can be combined with NOT or! Tests for a regular expression match with a string attribute using case-sensitive matching. Value delimited by single quotation marks ” or double quotation marks ” “. Metrics are recorded observations of important run-time properties or internal instrumentation values of the data abase server and its components, such as Commadns.
Metrics are a series of measurements that are computed and retained in memory for an interval of time, and stored on a disk for a more permanent history. Metric values typically record either the absolute value of a cumulative counter or a rate of change in a cumulative counter over an observed time period. Some metrics are used to record the time of state transitions as well.
Metric values can cause alerts to signal by comparing those values against threshold boundaries. Metrics can be associated with warning and critical thresholds when extreme values in the metric might indicate a problem or other event of interest to an administrator. You can display metric definitions, current metrics, and metric history using the LIST command.
A metric definition listing shows the configuration of a metric. A current metric listing shows a set of observations on the current value of an individual metric.
A metric history listing shows a collection of past individual observations of all metric values. The retention period for metric history files is specified by the metricHistoryDays attribute. Database server metrics provide information about the server, such as CPU utilization, memory or network interconnections. Example shows how to display database server metrics.
The following list describes the metric names and descriptions for database server metrics. The percentage of total space utilized on the file system that is currently in use. This metric shows the space utilization in the various files systems on the server. The percentage of total physical memory used on the server.
Using the DBMCLI Utility
The number of swap pages written in KB per second. The number of megabytes received by the InfiniBand interfaces dbmli second. The number of megabytes transmitted by the InfiniBand interfaces per second. The number of megabytes received by an InfiniBand port per second. The number of megabytes transmitted by an InfiniBand port per second.
The percentage of an InfiniBand port capacity utilized for receiving data. The percentage of an InfiniBand port capacity utilized for transmitting data. The number of kilobytes received by the Ethernet interfaces per second. The number of kilobytes transmitted by the Ethernet interfaces per second. The ALTER command performs an action on or changes attributes of a single database server object or multiple objects. When multiple objects are the target of an ALTER command, there is the possibility of partial success.
If an error occurs, then the command is interrupted, and the remaining objects are not changed. The identifier of the alerts to be changed. The name of the user who acknowledged the alert. You can manually set the LED to light to indicate that cmomands database server requires maintenance.
SAP ERP with MaxDB
The LED is also set to light automatically if a component fails. Configures the BMC for hardware alerts to the local database server so that Management Server can pick up the alerts. The smtpToAddr attribute can be set to a list of comma-delimited e-mail addresses that are the recipients of the alert notification. The list must be enclosed in quotation marks.
These targets are specified as follows:. To add to the list of SNMP targets ensure that you include the existing values in the command.
The following message is displayed after running the command:. The snmpSubscriber attribute is used to configure Auto Service Request. The default value for port is The default value for community is public. The default value is mail. For types v3 and v3ASRa snmpUser must be defined, and the user name is provided instead of community.
These are the only protocols supported by ASR Manager. There is no string to specify this type. To use this type, just omit the type field. The fromIP field enables you to specify an IP address from which the trap is sent.
If this field is not specified, it defaults to the IP address associated with eth0. The default value for this port is The syntax for the attribute is as follows:. The critical value also refers to a metric alert when the value exceeds the critical threshold specified in the metric definition. The warning value refers to a metric alert when the value exceeds the warning threshold specified in the metric definition.
The clear value refers to a metric alert when the value is below the threshold boundary after having previously exceeded a warning or critical threshold. The maintenance value refers to all hardware-related errors. The hardware errors are reported as “Maintenance” in e-mail message subject lines. For each subscriber, the host must be specified as either a domain name or an IP address. Enclose the host name or IP address in quotation marks if it contains non-alphanumeric characters.
Port and community values are optional.