Administration Commands For COD

Let's continue from previous post of capacity of demand. Well, we will discuss that what all steps are required to increase CPU cores in Database Machine as a part of COD.

Step-1 Verify the number of active physical cores using the following command

DBMCLI> LIST DBSERVER attributes coreCount

Step-2 Use the following command to increase the number of active physical cores:

DBMCLI> ALTER DBSERVER pendingCoreCount = new_number_of_active_physical_cores

Step-3 Verify the pending number of active physical cores using the following command:

DBMCLI> LIST DBSERVER attributes pendingCoreCount

Step-4 Restart the server

Step-5 Verify the number of active physical cores using the following command:

DBMCLI> LIST DBSERVER attributes coreCount

The database server must be restarted after enabling additional cores. 

If the database servers are part of a cluster, then they can be enabled in a rolling fashion. 

Following table shows the Capacity On Demand core processor configuration for database machine.

http://docs.oracle.com/cd/E50790_01/doc/doc.121/e51951/db_server.htm#DBMMN22026

You would also like:

• What is the Capacity On Demand?
• Oracle Exadata Interview Questions & Answers
• What is DBMCLI?

What is DBMCLI in Exadata?

Definition:

Starting Exadata Storage Server Release 12.1.2.1.0 a new command-line interface called DBMCLI is introduced for database server.

DBMCLI is the database machine command line interface to administrate exadata database server.

It runs on each database machine. By default it is pre-installed on each database server and on virtualized machine while it shipped.

DBMCLI utility is included in latest release 12.1.2.1.0 of Exadata image

Using DBMCLI:

• Configure ASR, capacity-on-demand, infrastructure as a service
• Configure database server e-mail alerts
• Configure, manage and monitor database servers
• Start stop server
• Manage server configuration information
• Enable or disable the server
• It can be start through SSH by executing DBMCLI command
• Used to monitor database server metrcis
• It uses DB server OS authentication, it doesn't required login parameter, moreover like CELLCLI

Syntax:

  

$dbmcli [port_number] [-n] [-m] [-xml] [-v | -vv | -vvv] [-x] [-e command]

Here 

Port_number  - Specifies HTTP port number of database server. If not specified it will use the port from cellinit.ora file.If it is not in cellinit.ora than port number 8888 will be used.

n                 - Execute DBMCLI command in non-interactive mode

m                - Run DBMLI in run monitor mode (Read Only)

xml              - Display output in xml format, can be used for OEM

v, vv, vvv      - Set log level, Fine, Finer and Finest level of log

x                 - Suppress the banner

e                 - To execute specific DBMCLI command 

Users:

DBMCLI has two users

dbmadmin   - Used for administration purpose

dbmmonitor - Used for monitoring purpose

You can follow our Exadata Certification Question Bank to achieve maximum success in your Exadata certification.