Oracle Enterprise Manager Administrator's Guide Release 1.4.0 A53702_01 |
|
This chapter provides an introduction to the Oracle Enterprise Manager database administration (DBA) tools and utilities and describes their organization and basic elements. This chapter covers the following topics:
The database tool and utility applications are the primary administrative components of Oracle Enterprise Manager. You can use these applications to perform most of your DBA administration tasks.
The design of the applications allows you to:
The applications allow you to perform the following database administration tasks:
Additional applications can be purchased to allow you to:
This section provides an overview of the objects administered by the database tools and utilities and briefly describes the objects that each application manages. For detailed descriptions of the objects and commands available in each application, see the specific chapter on the application.
The database tools and utilities, like the Oracle Enterprise Manger Console, provide a navigator tree list of groups and instances to organize the objects associated with the application. The navigator displays on the left side of an application window after the application has successfully connected to a database. See Figure 7-1, "An Application Window" for an example of a navigator in an application window.
The groups and instances are usually contained in a database folder. The database folder is the root of the Navigator and displays the name of the database that the application is connected to.
Folders hold other objects and display a '+' or '-' to the left of the object's icon and name. A folder can be expanded or collapsed to show or hide its contents. Objects that do not contain other objects do not display a '+' or '-' to the left of the object's icon or name.
With the Navigator, you can:
For the fastest performance when expanding or collapsing folders in the navigator, click only on the '+' or '-' to the left of the folder rather than double-clicking an object name. If you select an object in the Navigator, the application pauses to refresh the contents of the window on the right side before expanding or collapsing the folder.
An example of a list is shown in Figure 7-1, "An Application Window" . For information about multi-column scrolling lists, see Multi-Column Lists on page 7-11 .
For information about property sheets, see Property Sheets on page 7-14.
If you alter an instance, such as a datafile named DATA1 or a role named CLERK, in any location of the Navigator, all occurrences of the object in the tree are changed.
With the Instance application you can start up or shut down a database, examine and edit database initialization parameters, manage in-doubt transactions, and manage users' sessions. The Instance application manages the following groups:
With the Schema application you can create, edit, and examine schema objects. The Schema application manages the following groups:
With the Security application you can create, alter, and drop users, roles, and profiles. The Security application manages the following groups:
With the Storage Manager you can perform administrative tasks associated with managing database storage. These tasks include managing tablespaces and rollback segments, and adding and renaming datafiles. The Storage Manager manages the following groups:
A SQL Worksheet allows you to dynamically enter SQL statements, PL/SQL code, and Server Manager DBA commands. You can also run scripts from a SQL Worksheet.
A SQL Worksheet maintains a history of the commands you have entered. Thus, you can use the SQL Worksheet to edit and re-execute an earlier command without having to retype it.
You can have multiple SQL Worksheets open at a time, each of which is separate from the others. So, you can commit or roll back work in each worksheet independently.
Backup Manager allows you to administer your backup and recovery environment. You can now select from three backup subsystems:
Using an intuititive wizard to guide you, Oracle Data Manager provides the Export, Import, and Load utilities.
The Export utility allows you to export data from an Oracle database. The exported data is written to an operating system file in Oracle-binary format and can only be read by the Import utility. Export files can be used to transfer data between databases or used as backups. The Export utility provides dialog boxes that allow you to define how the data is exported.
The Import utility allows you to import data to an Oracle database. Import can only read data that has been created with the Export utility. The Import utility provides dialog boxes that allow you to define how the data is imported.
The Load utility allows you to transfer data to an Oracle database from files, such as text files, that have not been exported from an Oracle database. By using a control file you specify how the data is stored externally and how it is to be loaded into the database.
Database tools and utilities applications include four main pull-down menus in the menu bar:
The applications include other menus that are specific to the groups that the application manages. For example, the Security Manager provides the User, Profile, and Role menus in addition to the standard menus.
When a menu item is dimmed, it is not currently available. Menu items that end with an ellipsis (...) indicate that you will be asked to enter more information to complete the command.
The File menu items allow you to open or close application windows and create new connections. The File menu includes:
Displays the Connect dialog box to connect to an instance and open a window for that database. See Connecting to an Instance on page 1-22. To connect to multiple databases concurrently, you need to launch the application multiple times from the console.
Allows you to select a role from the multi-column list of available roles.
Exits the application.
The View menu allows you to show or hide objects, such as the toolbar or status line, and expand, collapse, or refresh the Navigator.
Refreshes the Navigator. This command is useful when other database administrators are making changes to the objects you are viewing, or when you are making changes in a different window, such as a SQL Worksheet.
Filters the Navigator based on criteria you choose. This allows you to display only the objects that match the criteria.
Opens and displays the next level of items contained in the selected objects in the tree.
Expanding a folder can be delayed because the objects displayed in the listing are often queries on remote databases.
Closes the selected folder in the Navigator.
Closes all open folders in the Navigator.
Shows or hides the toolbar.
Shows or hides the status bar.
Allows you to choose between basic property sheet functionality (Basic Mode) or complete property sheet functionality (Advanced Mode). By default, Advanced Mode is selected.
The Log menu options allow you to record and save the SQL statements that you have executed. When you save the statements to a file, you can also choose to schedule a job using the file on multiple databases. This feature provides the ability to perform identical actions on multiple databases without having to enter each SQL statement over again. If the databases are not identical, you can simply edit the SQL statements in the file before running the file on a database.
Start recording the SQL statements that are executed through the application.
Stop recording SQL statements. A dialog displays for you to save the recorded statements in a file. Enter a filename. Schedule a job that would run the file of SQL statements.
Pause the recording of statements while you execute actions that you do not want recorded.
From the Help menu, you can access the Oracle Enterprise Manager online Help system. For more information about Oracle Enterprise Manager online Help system, Online Help on page 1-8.
Displays the overview page for Oracle Enterprise Manager help.
Displays a search dialog box. You can either search by index or key word.
Displays a dialog box containing information about the Help system. Online Help on page 1-8 for information about the Help dialog box.
Displays a dialog box containing version information about the application.
Most database tool and utility applications include pull-down menus that contain the commands available for specific groups. The menu titles usually match the names of the groups. For example, the Security application provides the User, Profile, and Role menus.
Some of the menu commands, such as Drop, require that you select an individual object first. These commands are unavailable until you select an appropriate object. Unavailable commands are represented by dimmed menu items. Other menu items, such as Create, do not require an object selection and are never dimmed.
A menu item can be dimmed even when an object is selected because the command does not apply to that particular object. For example, you cannot drop an object type group, such as the Users group.
Some menu items are followed by an ellipsis (...). This indicates that to complete the command, the application prompts you for more information with a dialog box or property sheet.
Context-sensitive menus may also be provided when you select a Navigator object or item in the multi-column list with the right mouse button. This feature provides quick access to a subset of the menu options provided in the menu bars. Normally, objects in an application navigator (or the console Navigator) and objects in a multi-column list have associated context-sensitive menus.
For detailed information about the application menus, see the chapters on the specific applications.
A multi-column list displays when a group folder, such as a Users group, is selected. Each row in the list provides a quick view of summary information about an object in the selected folder. Additionally, you can select and alter items through their respective property sheets,
If an object has a property sheet, display the property sheet if you want more detailed information. See Property Sheets on page 7-14 for information.
The location of a group folder determines the columns that are displayed in the list. For example, the Roles group that is a main branch of the database folder displays different columns than a Roles group under a user.
By default, the objects are sorted on the first column. You can sort a list on any column by clicking on the column heading. The column heading appears in bold to indicate that the list is sorted on that column.
If the list is longer than the its window display area, you can use the vertical scroll bar at the side of list to scroll to the first or last row. You can also resize the application window to make the window display area taller.
If the list is wider than its window display area, you can use the horizontal scroll bar at the bottom of the list to scroll to the first or last column. You can also resize the application window or drag the splitter bar in the window to widen the right side of the window that contains the multi-column list.
An example of a multi-column list is shown in Figure 7-2, "Multi-column List" .
Dialog boxes allow you to make selections, enter information, or confirm actions.
You exit a dialog box by clicking a button. In many cases, you first enter field values, or choose options from pop-up menus or buttons, before you exit. An example of a dialog box is shown in Figure 7-3, "Dialog Box".
The boxes generally contain one or more of the following command buttons:
Executes the action button that was specified and closes the dialog box. The name of this button may vary.
Cancels any changes made and closes the dialog box.
Implements any changes made to the dialog box.
Opens or closes the SQL window to show or hide the SQL statements that are used to execute commands.
Displays online Help about the dialog box.
A property sheet is a dialog box used to specify options when you are creating or altering a composite instance, such as a user or tablespace. A property sheet consists of one or more pages that are labeled with page tabs. By default, one page is open when the sheet is entered, but all pages show page tabs. To access another page, click its page tab.
When a composite instance is selected in the navigator on the left side of an application window, the Alter property sheet that is associated with the object is usually displayed on the right side of the window. The properties available for each sheet are specific to the group type. An example of an Alter property sheet for a user is shown in Figure 7-4, "Property Sheet".
Some property sheets, particularly those requiring large amounts of data, use spreadsheets for simplified data entry. Spreadsheets consist of a table in which data is typed directly into rows and categorized by columns. Some entry fields in the spreadsheet have predefined content and are toggled by clicking on the table cell with the left mouse button (e.g. setting the Admin Option on or off by clicking directly on the cell).
For most spreadsheets, context-sensitive menus are available. You first select a single row with the left mouse button and then click the right mouse button to call up a context-sensitive menu that is appropriate for a particular application.
Newly added rows are indicated by a plus '+' sign in the far left column of the spreadsheet until you click Apply.
The property sheets generally contain the following command buttons:
Implements an action specified in the property sheet. Apply would save any changes made to the Quick Edit property sheet and Create would create a new the object specified by the Create property sheet.
Cancels any changes made to the property sheet and resets the fields to previously saved values.
Opens or closes the SQL window to show or hide the SQL statements that are used to execute commands.
Displays online Help about the property sheet.
To start an application, click its icon in the Launch Palette or select its name from the Launch menu in the Oracle Enterprise Manager Console.
You can change the database connection with the Change Database Connection option in the application File menu.
After a successful connection to a database, the navigator displays a navigator of objects managed by the application. The display on the right side of the window is determined by the object selected in the navigator. A multi-column list, property sheet, or other information displays.
For example, after the Security application completes a connection to a database, the Users, Profiles, and Roles groups display under the database folder in a navigator on the left side of the Security window. The Users, Profiles, and Roles groups can be expanded to show the objects they contain. An example of an application window with an expanded navigator tree list is shown in Figure 7-1, "An Application Window".