ch05.htm

Teach yourself Oracle8 in 21 day

	representation of the systems to be administered. This graphical display allows you
	to drill down into various sites and administer systems worldwide.
	<P>
	<LI>The Job pane--This pane allows you to view and administer various jobs that are
	running in the system. Through this pane, you can schedule jobs to run on various
	nodes in the system at various times. This provides you with a way of scheduling
	routine operations from a single console.
</UL>

<P>The Event pane--This pane is used to view system events that occur on any node
that you are administering from this console. <I>Events</I> are occurrences that
trigger some kind of action. This action can be a simple alert or can be some type
of action.


<BLOCKQUOTE>
	<P>
<HR>
<FONT COLOR="#000077"><B>NOTE:</B></FONT><B> </B>When Enterprise Manager is invoked,
	the Administrator toolbar is also invoked (as seen in the center of the Enterprise
	Manager). This toolbar allows quick access to the Enterprise Manager utilities. Some
	administrators like to move the toolbar or remove it altogether. This is up to you.
	I like to use it on occasion, but usually I remove it. 
<HR>


</BLOCKQUOTE>

<H2><FONT COLOR="#000077"><B>Using the Enterprise Manager</B></FONT></H2>
<P>The Enterprise Manager is distinguished from Enterprise Manager applications in
this book in that the applications are presented in the section that applies to that
application's function. For example, the Schema Manager is covered in the chapter
that covers the Oracle schema, the Backup Manager is covered in the chapters covering
backup and recovery, and so on. Today's focus is on configuring Enterprise Manager
and using the functions associated with the Navigator, Map, Job, and Event panes.</P>
<H3><FONT COLOR="#000077"><B>General</B></FONT></H3>
<P>A few general setup parameters can be modified with Enterprise Manager. These
pertain primarily to how Enterprise Manager looks and acts.</P>
<H4><FONT COLOR="#000077"><B>The View Menu</B></FONT></H4>
<P>The View drop-down menu can be used to modify the display. Select the View menu
as shown in Figure 5.4.</P>
<P><A NAME="04"></A><A HREF="04.htm"><B>Figure 5.4.</B></A></P>
<P><I>The View menu.</I></P>
<P>From here you can uncheck the various panes that you do not want to view. For
example, if you unselect the Show Map Pane button, the Map pane will be removed from
the screen.</P>
<H4><FONT COLOR="#000077"><B>The Navigator Menu</B></FONT></H4>
<P>The Navigator drop-down menu can be used to invoke the Discover New Services wizard.
To access the wizard, select Navigator | Discovery, as shown in Figure 5.5.</P>
<P><A NAME="05"></A><A HREF="05.htm"><B>Figure 5.5.</B></A></P>
<P><I>The Navigator menu.</I></P>
<P>Depending on whether a database is selected in the Navigator pane, you will see
several available options. One of the options is for the Discover New Services wizard.
This wizard finds the available services on specified systems. To use this wizard
for this purpose, do the following:

<DL>
	<DD><B>1. </B>Select Discover New Services Wizard, and you will see the first screen
	of the Discover New Services wizard, as shown in Figure 5.6.
</DL>

<P><A NAME="06"></A><A HREF="06.htm"><B>Figure 5.6.</B></A></P>
<P><I>The first screen of the Discover New Services wizard.</I></P>

<DL>
	<DD><B>2. </B>Click Next to move to the next screen. This screen allows you to specify
	node names for the discovery process to run on. After the discovery process has run,
	Enterprise Manager can communicate with that node and manage the various instances
	available on that node.
	<P><B>3. </B>Type the node name, then click Add. This node will then be ready to
	be discovered when you click the Finish button (see Figure 5.7).</P>
	<P><B>4.</B> After you click the Next button, you are asked for the time interval
	at which you want discovery to occur. You can retrieve this information immediately
	or on a regular basis.</P>
	<P><B>5.</B> Finally, you are presented with a summary of your choices. If you are
	satisified that everything is correct, you can proceed with the discovery by clicking
	Finish.
</DL>

<P><A NAME="07"></A><A HREF="07.htm"><B>Figure 5.7.</B></A></P>
<P><I>The Discover New Services wizard Add Nodes screen allows you to add nodes to
be discovered.</I></P>

<DL>
	<DD><B>6.</B> After you click the Finish button, the Discover New Services wizard
	proceeds to discover that node. When it has completed, you will see the discovered
	status in the Service Discovery Status screen, shown in Figure 5.8.
</DL>

<P><A NAME="08"></A><A HREF="08.htm"><B>Figure 5.8.</B></A></P>
<P><I>The Service Discovery Status screen shows you the discovery process in action.</I></P>


<BLOCKQUOTE>
	<P>
<HR>
<FONT COLOR="#000077"><B>NOTE:</B></FONT><B> </B>Using the Discover New Services
	wizard is the best way to configure the Enterprise network topology. Enterprise Manager
	uses a combination of the discovery feature, the Oracle intelligent agents, and the
	<TT>TOPOLOGY.ORA</TT> file described later today. 
<HR>


</BLOCKQUOTE>

<H4><FONT COLOR="#000077"><B>File Menu</B></FONT></H4>
<P>The File menu is important to the configuration in that it is where the user preferences
setup is found. When you select the user preferences setup, you will see a screen
that displays the services found in the discovery process (see Figure 5.9).</P>
<P><A NAME="09"></A><A HREF="09.htm"><B>Figure 5.9.</B></A></P>
<P><I>The User Preferences screen.</I></P>
<P>The User Preferences screen allows you to configure the username, password, and
role assigned to the connection that the Enterprise Manager will use to that service.
This allows you to keep separate passwords and DBA accounts for each system on your
network, but still administer all of them from a common console.</P>
<P>Setting the user preferences now will save you a lot of time and aggravation later.
It will allow you to connect directly to these services without having to go through
the entire login procedure.</P>
<H3><FONT COLOR="#000077"><B>Using the Navigator Pane</B></FONT></H3>
<P>The Navigator pane is probably where you will do most of your work. As I mentioned,
the Navigator pane provides a tree-like presentation with the following top-level
branches:

<UL>
	<LI>Databases--This branch shows all the databases known by Enterprise Manager (either
	by discovery or with the <TT>TOPOLOGY.ORA</TT> file).
	<P>
	<LI>Groups--These allow you to arrange objects with similar functions together, thus
	allowing you to administer these objects together.
	<P>
	<LI>Listeners--The known listeners to which Enterprise Manager can connect.
	<P>
	<LI>Nameservers--The nameservers of which Enterprise Manager is aware.
	<P>
	<LI>Nodes--The nodes known to Enterprise Manager.
	<P>
	<LI>Parallel servers--The parallel-server systems known to Enterprise Manager.
</UL>

<P>An example of the Navigator pane with the first-level trees expanded is shown
in Figure 5.10. Note that all the other panes except the Navigator pane are closed
in this figure. Most of the objects here are the default database objects from the
installation procedure.</P>
<P><A NAME="10"></A><A HREF="10.htm"><B>Figure 5.10.</B></A></P>
<P><I>The Navigator pane.</I></P>
<H3><FONT COLOR="#000077"><B>Using the Map Pane</B></FONT></H3>
<P>The Map pane is designed to facilitate the administration of systems located worldwide.
The Map pane allows you to create groups of systems that can be administered by drilling
down on the map. After Enterprise Manager groups are set up, you can drill down into
a group by simply clicking the map location.</P>
<P>To create a map, perform the following steps:

<DL>
	<DD><B>1. </B>Select the Map pane from the View | Map Pane menu.
	<P><B>2.</B> Select Map | Create Map.</P>
	<P><B>3. </B>At this point, you will see the Create a New Map screen, shown in Figure
	5.11. Fill in the name of the map, choose a bitmap file for the map, and click OK.
</DL>

<P>After the map is created, you will see a picture of the map (see Figure 5.12).
By creating a group, you can then move the icon of the group to the location on the
map where those systems reside.</P>
<P>The map can be very useful if you are administering a large number of systems
that are geographically disparate. You can even draw your own graphics that depict
a building or a floor in a building where these systems reside. Take some time and
play around with the Map pane. Most of the features are fairly self-explanatory and
easy to use.</P>
<P><A NAME="11"></A><A HREF="11.htm"><B>Figure 5.11.</B></A></P>
<P><I>Creating a map.</I></P>
<P><A NAME="12"></A><A HREF="12.htm"><B>Figure 5.12.</B></A></P>
<P><I>The map.</I></P>


<BLOCKQUOTE>
	<P>
<HR>
<FONT COLOR="#000077"><B>TIP:</B></FONT><B> </B>Play around with the Map pane. See
	what kind of configurations you can put together. Using the Navigator pane, you can
	drag and drop databases into the groups you have created, and they will show up in
	the Map pane. 
<HR>


</BLOCKQUOTE>

<H3><FONT COLOR="#000077"><B>Using the Job Pane</B></FONT></H3>
<P>The Job pane allows you to create and monitor jobs you have scheduled for one
or more systems. This pane can be very useful in scheduling regular activities such
as coalescing tablespaces, gathering statistics, or any other type of job that you
would like to schedule.</P>
<P>The Job pane allows you to schedule all types of jobs, including

<UL>
	<LI>SQL scripts
	<P>
	<LI>SQL commands
	<P>
	<LI>DBA commands, such as DDL statements
	<P>
	<LI>OS commands and scripts
	<P>
	<LI>Administrative tasks
	<P>
	<LI>Software distribution
</UL>

<P>The Job pane is described in much more detail on Day 15, &quot;Managing Job Queues
and Using Oracle Auditing.&quot;</P>
<H3><FONT COLOR="#000077"><B>Using the Event Pane</B></FONT></H3>
<P>The Event pane is used for monitoring events anywhere under the administration
of Enterprise Manager. Enterprise Manager uses SNMP (Simple Network Management Protocol)
to allow the intelligent agents to signal the console if an event has occurred.</P>
<P>Enterprise Manager allows you to configure the system to monitor whatever you
want, and to alert you if anything it is monitoring has passed a threshold. Enterprise
Manager can be configured to alert you via the console itself, e-mail, pager, and
so on.</P>
<P>This allows you to set up Enterprise Manager to monitor your installation even
when you are not there.</P>
<H2><FONT COLOR="#000077"><B>Using Server Manager</B></FONT></H2>
<P>Server Manager provides a character-based interface into the Oracle instance.
Invoke Server Manager by running it directly from the NT command line or by clicking
the executable from NT Explorer. Server Manager is available under all operating
systems in one form or another.</P>
<P>You can invoke Server Manager from the command prompt by typing the program name
as shown here:</P>
<PRE><FONT COLOR="#0066FF">D&gt; Svrmgr30
</FONT></PRE>
<P>After Server Manager has been invoked, you will see the initial connection information,
as shown in Figure 5.13.</P>
<P><A NAME="13"></A><A HREF="13.htm"><B>Figure 5.13.</B></A></P>
<P><I>Server Manager.</I></P>
<P>As you can see, Server Manager provides a command-line interface that can be used
to directly input SQL statements. Because Server Manager is designed as an administrative
tool, it supports a superset of the SQL commands that are accepted through other
SQL interfaces such as SQL*Plus. An example of some of these additional commands
is the <TT>show parameter</TT> command, which can be used to show the current value
of the Oracle initialization parameter that is requested. Listing 5.1 contains an
example of this.</P>
<P><B>INPUT:</B></P>
<P><FONT COLOR="#000077"><B>Listing 5.1. Using Enterprise Manager to display some
tunable parameters.</B></FONT></P>
<PRE><FONT COLOR="#0066FF">D:\&gt;svrmgr30

Oracle Server Manager Release 3.0.3.0.0 - Production

(c) Copyright 1997, Oracle Corporation.  All Rights Reserved.

Oracle8 Enterprise Edition Release 8.0.3.0.0 - Production
With the Partitioning and Objects options
PL/SQL Release 8.0.3.0.0 - Production 

SVRMGR&gt; connect internal
Password:
Connected.
<TT>SVRMGR&gt; show parameter block</TT></FONT></PRE>
<P><B>OUTPUT:</B></P>
<PRE><FONT COLOR="#0066FF">NAME                                TYPE    VALUE
----------------------------------  ------  -----------------------------
db_block_buffers                    integer 100
db_block_checkpoint_batch           integer 8
db_block_checksum                   boolean FALSE
db_block_lru_extended_statistics    integer 0
db_block_lru_latches                integer 1
db_block_lru_statistics             boolean FALSE
db_block_size                       integer 2048