Included Tips Page starts here Upcoming News.Copying Oracle Datafiles Between Linux and Windows Servers.IRR Iranian Rial rates, news, and tools xe.Get Iranian Rial rates, news, and facts.Also available are Iran Rial services.MrrJr.png' alt='Oracle Update Multiple Columns From Select Statement Sas' title='Oracle Update Multiple Columns From Select Statement Sas' />Oracle Exadata Command Reference, Part 3.Oracle Exadata Commands Reference.Part 3 Storage Managementby Arup Nanda.A detailed explanation of the Cell.CLI and DCLI commands, all their parameters and options, and how they are used for managing storage cells Back to Series TOCThe purpose of this guide is educational to jump start the transition from DBA to DMA and serve as a quick reference for practicing DMAs.It is not intended to replace official Oracle provided manuals or other documentation.The information in this guide is not validated by Oracle, is not supported by Oracle, and should only be used at your own risk.In the previous two installments, you learned how the Oracle Exadata Database Machine works, about its various components, and the categories of commands applicable to each of those components.One such component is the storage cells, which manage the disks.For many DBAs transitioning into the role of DMAs, perhaps the biggest challenge is becoming comfortable with storage operations, something many DBAs never had to address.K.jpg' alt='Oracle Update Multiple Columns From Select Statement Sas' title='Oracle Update Multiple Columns From Select Statement Sas' />The storage cells in Exadata Database Machine are managed via two tools called Cell.CLI and DCLI. You had a glimpse of the Cell.CLI commands in action in Part 2, when configuring Exadata for the first time.In this installment, you will learn the detailed commands of these tools.In doing so, hopefully you will appreciate that it is not as difficult as you thought it would be.Basics. The cellcli command is invoked from the Linux command line in the storage cells, not in the compute nodes.Similar to SQLlus showing SQL prompt, Cell.CLI show the Cell.CLI prompt where you will enter the commands.Cell. CLI Release 1.Production on Fri Apr 0.EDT 2. 01. 1Copyright c 2.Oracle. All rights reserved.Cell Efficiency Ratio 3.MThis will display the Cell.CLI prompt where you are expected to enter the commands.Cell. CLI enter your commands here HELPThe first command you may want to enter is know about all the other commands available.Well, get some help Cell.CLI help HELP topicAvailable Topics ALTERALTER ALERTHISTORYALTER CELL output truncated If you want to get more context sensitive help on a specific command, Cell.CLI help list. By the way, you dont need to be in the Cell.CLI command prompt to give a command.If you know the command you want to give, you call it directly from Linux command prompt with the e option.Or, you can use the typical Linux type command terminators, as shown below celladminprolcel.EOF list cell EOFCell.CLI Release 1. 1.Production on Sat May 1.EDT 2. 01. 1Copyright c 2.Oracle. All rights reserved.Cell Efficiency Ratio 1.MCell. CLI list cellprolcel.To exit from Cell.CLI, use the commands exit or quit.Recording the Output.Like SQLlus, Cell.CLI also has a spool command that records the output to a file.Here is an example where you want to record the output to a file named mycellcli.Cell. CLI spool mycellcli.To append to a file you already have, use append.Cell. CLI spool mycellcli.Or, if you want to overwrite the file, use replace.Cell. CLI spool mycellcli.To stop spooling, just issue SPOOL OFF.What if you want to know what file the output is being written to Use SPOOL without any argument.It will show the name of the file.Cell. CLI spool currently spooling to mycellcli.Continuation Character.You will learn later in the article that you can issue complex queries in Cell.CLI. Some of these queries might span multiple lines.Since there is no command terminator like in SQL, ending a line makes Cell.CLI to start interpreting it immediately.To make sure Cell.CLI understands the line extends beyond the current line, you can use the continuation character, just as you would have done in SQLlus.Cell. CLI spool mycellcli.Note the continuation prompt above.However, unlike SQLlus, Cell.CLI does not show line numbers for the continued lines.Scripting. When you want to execute a standard command in Cell.CLI, you can create a script file with the commands and execute it using START or commands.For instance, to execute a script called listdisks.Cell. CLI listdisks.Cell. CLI start listdisks.Note that the there is no restriction on the extension.I used cli merely as a convenience, it could have been anything else.You can also use the routine Linux redirection command.Here is an example where you put all the commands in the file mycellci.This is good for automatic monitoring systems.Comments. You can put comments in scripts as well.Comments start with REM, REMARK or, as shown below REM This is a comment.REMARK This is another comment This is yet another commentlist physicaldisk.Environment. You can define two environmental settingsdateformat to show the format of the date when it is displayed.Cell. CLI set dateformat local.Date format was set Apr 1, 2.PM. Cell. CLI set dateformat standard.Date format was set 2.T1. 5 3. 5 3. 0 0.Cell. CLI set echo on.Cell. CLI set echo off.I am sure you can find resemblance of the control commands with SQLlus, a tool you are undoubtedly familiar with.The learning curve should not be tat difficult.Now that you know about the basic commands, lets dive down to more advanced ones.General Structure.The Cell. CLI commands have the following general structure lt Verb lt Object lt Modifier lt Filter A verb is what you want or the action, e.An object is what you want the action on, e.A modifier optional shows how you want to operation to be modified, e.A filter optional is similar to the WHERE predicate of a SQL statement, used with WHERE clause.There are only a few primary verbs you will use mostly and need to remember.They are LIST to show something, e.Resource Manager Plans, etc.CREATE to create something, e.ALTER to change something that has been established, e.DROP to delete something, e.DESCRIBE to display the various attributes of an object.There are more verbs but these five are the most common ones among the Cell.CLI commands. Lets see how they are used in common operations.In the following sections you will learn how to perform the management operations View, Creation, Deletion and Modification of various components of the storage, e.Physical Disks, Grid Disks, LUN, etc.Physical Disk Operations.Storage cell is all about disks.As you learned in first two installments, each storage cell has 1.To display the physical disks in this particular cell, you execute the following command Cell.CLI list physicaldisk.E1. K5. JW normal.E1. L9. NC normal output truncted 4 0 2 0 5.FMOD2 normal4 0 3 0 5.FMOD3 normal. You can notice that there is no heading above the output, making it difficult to understand what these values mean.Fortunately we can fix that as we will see later.For now lets focus on something else To know more detail about each disk, you can use the detail modifier.It will show details on each disk.Here is a partial output Cell.CLI list physicaldisk detailname 3.Id 3.Type Hard.Diskenclosure. Device.Id 3. 4err. Media.Count 0err.Other. Count 0foreign.State falseluns 00make.Model SEAGATE ST3.SSUN6. 00. Gphysical.Firmware 0.Insert. Time 2.T1. 4 3. 2 3. 5 0.Interface sasphysical.Serial XXXXXXphysical.Size 5.Gslot. Number 0status normal name 3.Id 3.Type Hard.Diskenclosure. Device.Id 3. 4err. Media.Count 0err.Other. Count 0foreign.State falseluns 01make.Model SEAGATE ST3.SSUN6. 00. Gphysical.Firmware 0.Insert. Time 2.T1. 4 3. 2 4. 0 0.Interface sasphysical. Toy Story 3 Psp Game Download Cso Offline . Serial XXXXXXphysical.Size 5.Gslot. Number 1status normal output truncated The output shows the details of every disk, making it somewhat unreadable.Many times when you encounter issues with specific disks you may want to find the details of a particular disk.For that, use the name of the disk as another modifier.The name is shown in both types of commands, normal and detail.Cell. CLI list physicaldisk 3.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |