Oracle
Enterprise Manager Administrator's Guide
Release 1.6 A63731-01 |
|
The Navigator discovers and graphically displays network objects, and allows you to administer the objects. The Navigator tree displays a direct view of the network's nodes and services, the objects they contain, and the relationships among objects. The topics discussed in this chapter include:
The Navigator window provides:
The Navigator window can be hidden or shown by selecting
Show Navigator Pane in the Console View menu. You can also hide or show
the window by clicking on the Navigator icon in the Console toolbar.
Some objects in the Navigator tree can be multi-selected
using the standard Windows Shift and Ctrl key mouse click combinations.
This technique can be useful when creating maps and copying tree objects.
For more information on using keystrokes in the tree, see Keystroke
Shortcuts on page 2-19.
Each object type in the Navigator tree is identified by an
icon and name. If there is a '+' or '-' to the left an object's icon and
name, the object is a container that can be expanded to display other objects.
A container that is represented by a folder icon is a logical grouping,
or collection, of one specific type of object, such as databases. Other
containers are objects that hold multiple types of objects. See Figure
2-1, "Navigator Menu and Window" for an illustration of a Navigator
window.
The top-most object in the Navigator tree is the network container. The network folder contains:
You can expand tree containers to view the objects and relationships
in the environment. For example, you can expand a node to view the databases
and listeners on the node. If you expand a database, you can view datafiles,
in-doubt transactions, profiles, redo log groups, roles, rollback segments,
schema objects, tablespaces, and users. See the specific DBA tools chapter
that administers an object for more information on an object's relationships.
The Navigator tree is populated with services that the Communication Daemon retrieves with the Service Discovery feature or by reading an Oracle Parallel Server (OPS) topology file (topo_ops.ora). The types of services in the network include:
In large, complex environments you may not want to view the
entire network system in one tree. The Navigator has been designed to be
highly flexible for viewing objects. With the Split View menu option, you
can split the Navigator tree into views that are displayed in separate
pages in the Navigator window. Simply click on the tab of a page to move
the page and its contents to the front of the Navigator window.
With the Filter Folder menu option, you can specify the objects
in a tree folder that want to manage. In a very large system, this option
allows you to display only those objects that you need to access. You can
use standard SQL wildcard characters when entering the filtering criteria.
Before you launch a database tool from the Console, select
the database or database object in the Navigator tree that you want to
access. You can then execute a tool from the Tools menu or with the Related
Tools option of the right-mouse menu.
You are connected to the database according to the user preferences
that have been set up for the database or the credentials you used to log
on to the Console. If connection to the database fails for any reason,
the Login Information dialog box displays. For information about connecting
to an instance of a database, see Connecting
to an Instance on page 1-23. For information on user preferences,
see Console User Preferences on page
1-25.
User-defined groups are created with the Create Group option of the Map menu. You can use groups to organize related objects in the tree. For information on groups, see User-Defined Groups on page 3-3. The group types are:
You can drag and drop nodes, databases, groups, and listeners
from the Navigator tree to the Map window to add those objects to a map.
See Manipulating Map Views on page 3-2.
The Navigator menu allows you to manage objects in the Navigator
window. The menu options are enabled according to the object selected in
the Navigator tree. Usually the Create, Create Like, Quick Edit, and Remove
menu options are available when an object is selected. See Figure
2-1, "Navigator Menu and Window" for an illustration of the Navigator
menu.
For information on operations for an object type, see the chapter in this guide that discusses the specific application that manipulates the object type. For example, if you want information on the create or alter property sheet of user, profile, or role object types, see Chapter 9, "Managing Database Security". For an overview of the database application tools, see Chapter 7, "Overview of the Database Tools".
Allows you to create a specified object type. The property sheet for the type displays.
Allows you to create an object similar to the selected object in the tree list.
Allows you to alter or edit an object of a specified type. The Object is determined by the type of the object selected in the tree list.
Allows you to delete all occurrences of the selected object
in the tree list.
It is often much easier to Filter Folders than remove objects
in the Navigator tree. Filtering allows you to quickly include the object
in the tree if necessary in the future.
If you remove a node from the Navigator tree that was discovered
with the Discover New Services or Refresh Services wizard, the node and
all its services are removed from the Navigator tree, and the node is removed
from the pages of Refresh Services wizard.
If you remove a database, listener, or other service object
from the Navigator tree that was discovered with the Discover New Services
or Refresh Services wizard, the object appears again in the Navigator tree
when the node that contains the service is rediscovered with the Refresh
Services wizard.
If you do not want a service discovered by an Intelligent Agent, do not include an entry for the service in the tnsnames.ora file on the node where the service is located. On a Unix platform, remove the service from the oratab file also.
Displays the Login Information dialog box to connect to a database instance. For information about connecting to an instance of a database, see Connecting to an Instance on page 1-23.
Disconnects from a database instance.
Starts up a database. See Chapter 10, "Managing Instances and Sessions".
Shuts down a database. See Chapter 10, "Managing Instances and Sessions".
Discovers services on a node in the network. You can also display the status of network services. See Discovering Services on page 2-8.
Creates a new view page in the Navigator window that contains only the currently selected object, such as a single folder, group, or user. This feature allows you to create separate views that display specific objects. For example, to create a new view that only contains the DEMO database:
Removes the current split view from the Navigator. Make sure the view that you want to delete is at the front of the Navigator window.
Filters a folder contents based on the criteria you enter
in the filter dialog box. You can use SQL operators in the criteria field.
See Filtering Folders on page 2-18.
For example, if you click the right mouse button on a user, such as SCOTT, the following menu options would display:
Related Tools in this example are the database tools that
administer users. In this case, Security Manager is a related tool.
For information on menu options for an object type, see the
chapter in this guide that discusses the specific application that manipulates
the object type. For example, if you want information on the menu options
for user, profile, or role object types, see Chapter
9, "Managing Database Security". For an overview of the database application
tools, see Chapter 7, "Overview of the Database
Tools".
The Navigator Service Discovery feature provides wizards for identifying network services and populating the Navigator tree. These services, such as databases and listeners, can be administered with Enterprise Manager components. Navigator Service Discovery functions are:
Use the Discover New Services and Refresh Services wizards
for nodes that have the Intelligent Agent release 7.3.3 or higher running.
If you add services to these nodes, you must restart the agent on the nodes
before discovering the new services with the Discovery wizard option.
Use the Manual Define Services wizard for nodes that do not
have an Oracle Intelligent Agent installed or do not have a release 7.3.3
or higher agent installed.
The Discover New Services Wizard option of the Navigator Discovery feature allows you to add nodes where you want to discover services. These nodes must have an Oracle Intelligent Agent release 7.3.3 or higher running. After the nodes and services are discovered, they are added to the Navigator tree. Nodes can be discovered in two modes:
The pages in the wizard are:
This wizard also re-discovers nodes in the Navigator tree.
If you do not want you to refresh previously discovered nodes, use the
Refresh Services wizard to stop refreshing the nodes.
Add the nodes where you want to discover services. These are nodes in the network with release 7.3.3 or higher Intelligent Agents. You cannot add nodes that have been previously added and are listed in the Refresh page of the Refresh Services wizard or the Retry page of this wizard. Use the Refresh Services wizard to refresh those nodes. Use the Retry page of this wizard or the Refresh Services wizard to retry nodes where discovery has failed.
Enter the node name and choose the Add button.
Select the load button to load a text file that contains
a list of the nodes that you want to discover. The Load dialog box allows
you to browse for the text file. In the text file, each node name must
be on a separate line followed by a carriage return. To create a file that
contains a list of currently discovered nodes, see Repository
Manager Wizard on page 1-21.
After the list of nodes has been loaded, edit the list if necessary to remove any nodes that you do not want to discover.
If you do not want to discover services on a node that you
have entered, select the node and choose the Remove button.
The nodes where service discovery has failed are listed. See Status Option on page 2-13 for possible discovery problems. The wizard continues to retry discovery on these nodes unless a node is removed from the list.
Select a node where discovery has failed and choose the Remove
button if you do not want to re-discover the node. If you remove the node
from the list, the node and services on the node are removed from the Navigator
tree if they existed.
Nodes can be discovered in Immediate or Interval modes:
With Immediate discovery, the nodes are discovered as soon as you select Finish. The nodes are not re-discovered until you initiate Immediate discovery again.
With interval discovery, the nodes that you enter are automatically re-discovered on the interval that you specify.
Enter the frequency interval in minutes for node re-discovery.
The update option updates the network configuration file
(tnsnames.ora) with node information. This should be run after a Discovery
operation. If the network configuration is not updated, you may not be
able to access a service. If you do not choose automatic updating, you
can select the Update Network Configuration menu option to update the network
configuration file.
Review the summary page to verify your selections.
After you select Finish, the status of the current discovery
process is displayed as the wizard attempts to discover the services on
the nodes in the list. If the service discovery is successful, the service
information is added to the Navigator tree. If a discovery operation fails,
it is noted in the Status dialog box. For information on possible problems,
see Status Option on page 2-13.
If a node is successfully discovered, it is set to automatic
refresh mode in the Refresh Nodes page of the Refresh Services wizard.
All nodes that are not successfully discovered are automatically retried
unless they are removed from the Retry Nodes page.
The Refresh Services Wizard option of the Navigator Discovery feature allows you to re-discover services on nodes. These nodes must have an Oracle Intelligent Agent release 7.3.3 or higher running. After the nodes and services are discovered, they are added to the Navigator tree. Nodes can be discovered in two modes:
The pages in the wizard are:
The nodes where services have been successfully discovered are listed. Determine the nodes where you want to refresh service information.
Check the boxes next to the nodes where you want to re-discover
service information.
Review the summary page to verify your selections.
After you select Finish, the status of the current discovery
process is displayed as the wizard attempts to discover the services on
the nodes in the list. If the service discovery is successful, the service
information is added to the Navigator tree. If a discovery operation fails,
that is noted in the Status dialog box. For information on possible problems,
see Status Option on page 2-13.
If a node is successfully discovered, it is set to automatic
refresh mode in the Refresh Nodes page of the Refresh Services wizard.
All nodes that are not successfully discovered are automatically retried
unless removed from the Retry Nodes page.
Use this wizard to manually enter and update services on nodes in the network. The pages in the wizard are:
The services on these nodes cannot be discovered with the
Discover New Services wizard because a 7.3.3 or higher Oracle Intelligent
Agent is not running on the nodes.
After you have defined the nodes and services, they are added
to the Navigator tree. To access the nodes and services, you must add valid
entries for the databases and agents in the tnsnames.ora file on the Console
machine. To submit jobs or events to these nodes, an entry for the agent
on the node must be in the tnsnames.ora file in order for the destination
to be validated. For information on the tnsnames.ora file, see the Oracle
Enterprise Manager Configuration Guide. Also, see the Oracle networking
documentation for the specific platform and release of your Oracle database.
Add nodes or services on the nodes with this page. Nodes and services previously discovered are listed here and can be updated.
Enter a new node name to add the node or any services on the node to the Navigator tree. Select Add after you have entered the name.
Check the box if the node contains a pre-7.3.3 Oracle Intelligent Agent. This box must be checked and the node must have an Intelligent Agent running to use the Jobs or Events system. See Destination Validation Dialog on page 2-14.
After the node name has been added, add the names of the databases on the node. If you plan to use an Intelligent Agent to manage jobs or events on the database, the database name must match the name in the SNMP.VISIBLESERVICES parameter in the snmp.ora file on the agent machine.
After a new node has been entered, select the Add button.
Select a node or service and choose the Remove button to
remove it from the list and the Navigator tree.
Review the summary page to verify your selections.
After you select Finish, the nodes and services are updated
in the Navigator tree. The services, such as databases and agents, must
have valid entries in the tnsnames.ora file on the Console machine.
The status of the most recent discovery attempt is displayed
in the Status dialog box after a discovery operation and when the Status
menu option is selected. Status is not displayed after the Manually Define
Services menu option. Any error conditions for nodes are listed.
The following are common problems to check if service discovery has failed:
The following are common problems to check if a service has not been discovered:
After you correct any problems, you can execute the Discover
New Services wizard to retry discovery on nodes where discovery has failed.
If the problem cannot be fixed, you can remove the node from discovery
operations with the Retry Nodes Page. If discovery succeeds but a service
on a node is missing, use the Refresh Services Wizard to rediscover the
node after you have resolved the problem.
This option updates the network configuration file (tnsnames.ora)
with current service discovery information from the most recent successful
discovery. This function should be run after a Discover New Services or
Refresh Services discovery operation to ensure access to services in the
Navigator tree.
When the Discover New Services and Refresh Services wizards
are executed, service discovery information is updated. If you use choose
automatic updating, or explicitly choose the Update Network Configuration
option, new addresses are added and previously discovered addresses are
updated in the tnsnames.ora file.
This function does not update services entered with the Manually
Define Service wizard. You must manually add entries in the tnsnames.ora
file for services updated with that wizard.
The agents at the specified destinations must be validated
before the destinations can be sent jobs and events. Any problems are displayed
in the Destination Validation dialog and must be corrected before a job
or event can be submitted to the destination.
To use a destination entered with the Navigator Manually
Define Services wizard, the Agent box must be checked and there must be
valid entry for the agent in the tnsnames.ora file on the Console machine.
This entry must include the agent name listed in the dialog box and must
match the DBSNMP.ADDRESS parameter in the snmp.ora file on the machine
where the agent is located. If there is a sqlnet.ora file that specifies
a default domain, such as world, that domain must be added to the agent
name. For example, AGENT_name.world.
The Navigator interface provides easy manipulation of the
services and objects in the tree list. For manipulating objects with keystrokes,
see Keystroke Shortcuts on page 2-19.
The Navigator tree provides various methods for expanding
and collapsing objects.
To expand and display the contents of a container, click
the '+' to the left of a container's icon and name. The contents of the
container varies depending on the type of object container. To collapse
a container, click the '-' to the left of a container's icon and name.
You can also double-click on containers to collapse and expand them.
The tree list display is often the result of queries executed
on a database over a network. Because of this, there may be a delay when
expanding a container.
When you expand a database, you implicitly connect to the
database. The Console uses the preferred credentials that have been set
up or the credentials used when you logged on to the Console. If the connection
to the database fails for any reason, the Login Information dialog box
displays.
For information on the user preferences, see Console
User Preferences on page 1-25. For information about connecting
to an instance of a database, see Connecting
to an Instance on page 1-23.
You can perform some of the administrative tasks that are
in the DBA tool applications with the Navigator. The Navigator provides
a subset of the options for administering an object.
To administer an object, select the object in the Navigator
tree and choose the administration task from the Navigator menu. The menu
options available vary according to the object selected. See Navigator
Menu on page 2-5. When you create or edit an object, the property
sheet for that object displays. For information on the property sheets,
see the chapter on the DBA tool that administers the object.
When you choose to edit a database, the database property
sheet displays. If the connection to the database fails for any reason,
the Login Information dialog box displays.
For information on the user preferences, see Console
User Preferences on page 1-25. For information about connecting
to an instance of a database, see Connecting
to an Instance on page 1-23. For information on the database instance
property sheet, see Chapter 10, "Managing Instances
and Sessions".
When you select tree objects with the right mouse button,
a context-sensitive menu displays with a subset of the Navigator menu options
and a Related Tools menu. The Related Tools menu lists the database tools
that administer the object. For information on the context-sensitive (right
mouse) menu options, see Navigator Context-Sensitive
Menus on page 2-7. For information on the Navigator menu options,
see Navigator Menu on page 2-5.
You can drag and drop some objects in the tree list to make
copies of the object in different locations. For example, you can drag
and drop a user or role from one database to another to create an identical
user in a different database. If you attempt a drag and drop operation
that cannot be done, a circle with a slash appears to alert you. You can
select multiple objects using the standard Windows selection keys.
To make an identical copy of a user in several databases,
select the user you want to copy from one database and drag and drop the
user to the additional databases where you want the user to appear. To
add a role or privilege to a user in a database, select the role or privilege
in the tree and drag and drop the role or privilege onto the use or to
the appropriate folder under the user.
If you drag and drop a user to a database where the user's
Default or System tablespace does not exist, you are prompted to reassign
the tablespace. If you choose to reassign the tablespace, the User property
sheet displays. If you do not choose to reassign the tablespace, you cannot
add the user.
This example shows you how to manipulate various objects in the Navigator tree.
With the Filter Folder menu item you can filter folders to
display specific sets of objects. When you select the Filter Folder menu
item, the Filter Folder dialog box displays.
To filter a folder:
To turn off filtering:
The following keystrokes can be used in the Navigator tree to perform various actions. Functionality is dependent on the object selected.