This OBE describes how to monitoring NetApp Storage Devices using Oracle Enterprise Manager 10g Grid Control Release 2.
Approximately ½ hour
This tutorial covers the following topics:
| Overview | ||
| Prerequisite | ||
| Monitoring NetApp Storage Device | ||
| Summary | ||
| Related information | ||
Place the cursor over this icon to load and view all
the screenshots for this tutorial. (Caution: Because this action loads all screenshots
simultaneously, response time may be slow depending on your Internet connection.)
Note: Alternatively, you can place the cursor over each individual icon in the following steps to load and view only the screenshot associated with that step.
The screenshots will not reflect the specific environment you are using. They are provided to give you an idea of where to locate specific functionality in the Oracle Enterprise Manager 10g Grid Control console.
Oracle Enterprise Manager in addition to monitoring Oracle database, middleware and applications can also monitor other 3rd party components. Storage is a vital component in the data center stack and Enterprise Manager can monitor storage systems from vendors such as Network Appliance and EMC. This exercise, designed for database administrators, storage and systems administrators as well as for application administrators, will demonstrate Enterprise Manager's abilities in navigating from database to storage systems and will provide detailed information related to monitoring Network Appliance filers.
You should atleast have one NetApp Storage device managed and monitored using Oracle Enterprise Manager 10g Grid Control Release 2.
This OBE provides database administrators, application administrators, systems and storage administrator with a simple but critical exercise that allows them to drill down from tables containing rows to the storage devices for a NetApp filer that contains the table. In addition, the administrators will be able to view key performance metrics and monitoring parameters that Enterprise Manager uses to monitor NetApp filers.
Perform the following steps to monitor NetApp Storage Device:
| 1. |
Open the browser and enter the following URL: http://<management service hostname>.<domain>:<port>/em/ The default port value on a clean machine is 7777. However, if there are other instances running on the machine, then the port may be different. The login page will be displayed. Enter the User Name and Password, and then click the Login button.
|
| 2. |
Click the Targets tab.
|
| 3. |
Click the Databases subtab.
|
| 4. |
Click the database instance.
|
| 5. |
Click the Administration subtab.
|
| 6. |
Click the Tables link under the Schema -> Database Objects section.
|
| 7. |
Specify the database credentials and click the Login button.
|
| 8. |
Click the flashlight icon to select the GL schema.
|
| 9. |
Search for the schema by entering "GL" in Schema field and click the Go button.
|
| 10. |
Select the GL schema and click the Select button.
|
| 11. |
Click the Go button.
|
| 12. |
View the list of tables under the GL schema
|
| 13. |
Scroll down the list of tables and select the GL_BALANCES table.
|
| 14. |
Click the GL_BALANCES table.
|
| 15. |
From here you can identify that the tablespace used for the GL_BALANCES table is USER_DATA.
|
| 16. |
Now lets drill-down and find the associated datafile for the USER_DATA tablespace. Click the Database Instance locator link. Click the Tablespaces link under the Database Administration -> Storage section.
|
| 17. |
Click the USER_DATA tablespace.
|
| 18. |
From here you can identify the datafile name and the directory. You can also notice that the datafile is managed by ASM. Now lets identify the diskgroup for the USER_DATA tablespace. Click the Database Instance locator link.
|
| 19. |
Click the Disk Groups link under the Database Administration -> Storage section.
|
| 20. |
Specify the database credentials and click the Login button.
|
| 21. |
All the disk groups managed by ASM are listed. Click DATA disk group.
|
| 22. |
The General page displays charts showing the Disk Group Usage and the Disk Group History. You can see that there are several in this Disk Group. Click any one of them, e.g. DATA_0000
|
| 23. |
Use the Disk Properties page to display all properties of the selected disk along with time line graphs for Disk Response, Disk I/O Operations per Second, and Disk Throughput. Disk metrics are displayed along with other disk parameters in the statistic section at the bottom of the page. Note the path for the DATA_0000 diskgroup points to /netapps/db10_vol02/disk02.
|
| 24. |
Click the Host locator link.
|
| 25. |
From the Host home page click the Storage Details link under the Related Links section.
|
| 26. |
The graphs at the top of the Storage Details page provide intelligence about the storage utilization. Such intelligence is provided at the host level when launched in the context of a host target and associated hosts level when launched in the context of a group. Click the File Systems subtab.
|
| 27. |
This will help you identify the storage devices for the disk. Select All from the list of File Systems
|
| 28. |
This will help you identify the storage devices for the disk. Observe that the file system /netapps/db10_vol02/disk02 is mounted from volume db10_vol_02 associated with the NetApp filer netapp1.oracleworld.com
|
| 29. |
Click the NetApp Filers subtab.
|
| 30. |
Select the netapp2 filer from the list of filers.
|
| 31. |
View the summary view of the filer. It provides capacity information and available space as well as information on the current Filer configuration, such as software version, Model number. Click the Volumes subtab.
|
| 32. |
Select All from the list to view All Volumes.
|
| 33. |
Observe details about the volume db10_vol_02 such as its Flexible Volume type and capacity.
|
| 34. |
Click the Performance tab to view key performance metrics. Select various date ranges to view the historical performance of the filer.
|
| 35. |
Select Metrics and Thresholds from the Related Links section to view metrics related to the filer tracked by Enterprise Manager. On the Metrics Page, you can view all metrics by selecting All Metrics from the list.
|
In this lesson, you learned how to:
| Navigate from table to datafile to file system to storage device. | ||
| Monitor NetApp Storage Device. | ||
| To ask a question about this OBE tutorial, post a query on the OBE Discussion Forum. |
Place the cursor over this icon
to hide all screenshots.