ch03.htm

Teach yourself Oracle8 in 21 day

Install button. These components will be installed as requested.</P>
<P>If you choose the Oracle Documentation option, you will be asked whether you want
to install the Oracle documentation on hard disk or whether you want to access the
documentation via CD-ROM.


<BLOCKQUOTE>
	<P>
<HR>
<FONT COLOR="#000077"><B>WARNING: </B></FONT>The custom installation procedure should
	only be used after you've used the installation procedure several times, and only
	if you need specific components. It is much better to run both server and Programmer/2000
	if you need components of both. 
<HR>


</BLOCKQUOTE>

<P><FONT COLOR="#000077"><B>What Has Been Installed?</B></FONT></P>
<P>With the custom installation procedure, you will have installed whatever components
you requested. The installation procedure will check for dependencies and some additional
components might have been installed.</P>
<P>I do not recommend using the custom installation procedure in most cases. The
other installation methods are usually perfectly adequate. In the next section, you
will see how to remove unneeded components.</P>
<H2><FONT COLOR="#000077"><B>Removing Components</B></FONT></H2>
<P>To remove any unnecessary or unwanted components, simply invoke the Oracle Installer
through the Oracle for Windows NT group. Select any components you want to remove,
as shown in Figure 3.14, and then click the Remove button. These components will
be removed from the system.</P>
<P><A NAME="14"></A><A HREF="14.htm"><B>Figure 3.14.</B></A></P>
<P><I>The Software Asset Manager screen with components selected for removal.</I></P>
<P>When you finish removing components, simply click the Exit button to exit the
Oracle Installer.</P>
<H2><FONT COLOR="#000077"><B>Product Descriptions</B></FONT></H2>
<P>The various products and components installed based on your selections were shown
pre-viously. Following is a brief description of what these products and components
actually are.</P>
<H3><FONT COLOR="#000077"><B>Oracle8 Server</B></FONT></H3>
<P>The Oracle8 server is the RDBMS itself. Within the RDBMS package are all the standard
Oracle features, including the following options:

<UL>
	<LI>Distributed--This allows the database to be distributed across different systems.
	<P>
	<LI>Replication--This allows for the replication or copying of data to multiple different
	systems. This can be used for the performance increase provided by having local copies,
	or for protection in the event of a system failure.
	<P>
	<LI>Parallel Query--This option is my favorite, and allows for several different
	types of operations to be split into many individual operations, thus improving performance
	of long-running tasks.
	<P>
	<LI>PL/SQL--The Oracle procedural language option allows for procedural SQL commands
	to be written.
</UL>

<H3><FONT COLOR="#000077"><B>Enterprise Manager</B></FONT></H3>
<P>Oracle Enterprise Manager is the graphical administration tool recently introduced
by Oracle. The Enterprise Manager helps the DBA by simplifying some of the necessary
tasks. The Enterprise Manager comes with a suite of tools, including

<UL>
	<LI>Backup Manager--This option assists the administrator in backup and recovery
	operations.
	<P>
	<LI>Instance Manager--This handles startup, shutdown, configuration, and so on.
	<P>
	<LI>Schema Manager--This is used to view and modify tables, views, clusters, and
	so on.
	<P>
	<LI>Security Manager--This is used to manage the user community. It allows you to
	add users, assign roles, and so on.
	<P>
	<LI>Storage Manager--This is used to view and modify tablespaces, datafiles, and
	so on.
</UL>

<H3><FONT COLOR="#000077"><B>Intelligent Agents</B></FONT></H3>
<P>Oracle intelligent agents are the programs that allow the Oracle Enterprise Manager
to communicate with the Oracle8 server and utilities. The Oracle intelligent agents
use SMTP (Simple Management Transport Protocol) to allow this communication to occur.
The Oracle intelligent agents are implemented as a service under Windows NT and are
started and stopped by the NT Service Manager.</P>
<H3><FONT COLOR="#000077"><B>Oracle Installer</B></FONT></H3>
<P>The Oracle Installer is the application that is used to install and remove Oracle
software. The Installer itself is installed on the system and can be used to install
and remove additional components even after the initial installation.</P>
<H3><FONT COLOR="#000077"><B>Networking Components</B></FONT></H3>
<P>The Oracle8 networking components consist of the programs and utilities necessary
to connect to the Oracle8 server via a network. The networking components consist
of the network server and network protocol adapters. These protocol adapters support
various network protocols, such as

<UL>
	<LI>TCP/IP
	<P>
	<LI>SPX/IPX
	<P>
	<LI>Named pipes
	<P>
	<LI>DECNet
	<P>
	<LI>Various other networking protocols, depending on your operating system
</UL>

<P>The networking components also include the administrative tools necessary to administer
the Oracle networking components.</P>
<H3><FONT COLOR="#000077"><B>SQL*Plus</B></FONT></H3>
<P>SQL*Plus is the ad-hoc user interface tool for the Oracle RDBMS. With SQL*Plus,
you can connect into the RDBMS and run SQL commands and PL/SQL programs. This is
the primary nonapplication interface into the Oracle RDBMS.</P>
<H3><FONT COLOR="#000077"><B>Utilities</B></FONT></H3>
<P>These are miscellaneous utilities that are used to administer and modify the Oracle
RDBMS. These Oracle utilities include

<UL>
	<LI>SQL*Loader--This is used to load the database from input files. There are various
	methods of using the SQL*Loader, which are covered on Day 9, &quot;Managing Data.&quot;
	<P>
	<LI>Export--This program stores Oracle data and table definitions externally in an
	Oracle-specific binary format. Export is covered in depth on Day 9.
	<P>
	<LI>Import--This program loads data into the database from an Oracle export file.
</UL>

<P><FONT COLOR="#000077"><B>Server Manager</B></FONT></P>
<P>Server Manager is a character-based utility that can be used to perform administrative
tasks on the Oracle RDBMS. Server Manager provides an interface for performing ad-hoc
or scripted administrative tasks.</P>
<P><FONT COLOR="#000077"><B>Instance Manager</B></FONT></P>
<P>The Oracle Instance Manager is part of the Enterprise Manager toolset and is used
to graphically perform tasks such as starting and stopping the Oracle instance.</P>
<P><FONT COLOR="#000077"><B>Recovery Manager</B></FONT></P>
<P>Recovery Manager is used to back up and restore the Oracle database. Recovery
Manager not only performs the backup but also maintains backup and recovery information.</P>
<H2><FONT COLOR="#000077"><B>Summary</B></FONT></H2>
<P>Today you learned how to install Oracle8 software. The various types of installations
include

<UL>
	<LI>Server installation
	<P>
	<LI>Administrative client installation
	<P>
	<LI>Application user client installation
	<P>
	<LI>Programmer/2000 installation
	<P>
	<LI>Custom installation
</UL>

<P>You were also presented with an overview of what was installed. As you can see,
the new Oracle installation procedure is quite straightforward in most cases. This
is quite an improvement from the Oracle6 and early Oracle7 installation procedures.</P>
<H2><FONT COLOR="#000077"><B>What's Next?</B></FONT></H2>
<P>Tomorrow you will see how to properly size an Oracle system and how to plan for
future growth. This is a very exciting area of Oracle administration and can be extremely
important to the operation of the system. By anticipating growth and determining
when your system will run out of resources, you can plan ahead, thus avoiding costly
downtime and quick hardware purchases.</P>
<H3><FONT COLOR="#000077"><B>Q&amp;A</B></FONT></H3>

<DL>
	<DD><FONT COLOR="#000000"><B>Q What is the Oracle Enterprise Manager?</B></FONT>
	<P><FONT COLOR="#000000"><B>A</B></FONT> The Oracle Enterprise Manager is the new
	graphical administration tool designed to help the DBA manage one or more Oracle
	systems.</P>
	<P><FONT COLOR="#000000"><B>Q What is SQL*Net?</B></FONT></P>
	<P><FONT COLOR="#000000"><B>A</B> </FONT>SQL*Net is Oracle's communication protocol.
	SQL*Net uses various network communication protocols such as TCP/IP, DECNet, and
	SPX/IPX, and provides a common programming layer for the Oracle developer.</P>
	<P><FONT COLOR="#000000"><B>Q What kind of user needs the Programmer/2000 installation?</B></FONT></P>
	<P><FONT COLOR="#000000"><B>A</B></FONT> A software developer would use the development
	tools that come with the Programmer/2000 installation.</P>
	<P><FONT COLOR="#000000"><B>Q What is the Recovery Manager used for?</B></FONT></P>
	<P><FONT COLOR="#000000"><B>A</B> </FONT>The Recovery Manager is used for backup
	and recovery. This product performs these operations and maintains a catalog of previous
	backups.
</DL>

<H2><FONT COLOR="#000077"><B>Workshop</B></FONT></H2>
<P>The workshop provides quiz questions to help you solidify your understanding of
the material covered. See Appendix A, &quot;Answers,&quot; for answers to the quiz
questions you see here.</P>
<H3><FONT COLOR="#000077"><B>Quiz</B></FONT></H3>

<DL>
	<DD><B>1.</B> What is the main component of an Oracle8 server?
	<P><B>2.</B> What do the intelligent agents do?</P>
	<P><B>3. </B>Name three Oracle utilities.</P>
	<P><B>4.</B> Name several network protocols supported by Oracle SQL*Net.
</DL>

<CENTER>
<P>
<HR>
<A HREF="../ch02/ch02.htm"><IMG SRC="../buttonart/previous.gif" WIDTH="128" HEIGHT="28"
ALIGN="BOTTOM" ALT="Previous chapter" BORDER="0"></A><A HREF="../ch04/ch04.htm"><IMG
SRC="../buttonart/next.gif" WIDTH="128" HEIGHT="28" ALIGN="BOTTOM" ALT="Next chapter"
BORDER="0"></A><A HREF="../index.htm"><IMG SRC="../buttonart/contents.gif" WIDTH="128"
HEIGHT="28" ALIGN="BOTTOM" ALT="Contents" BORDER="0"></A> <BR>
<BR>
<BR>
<IMG SRC="../buttonart/corp.gif" WIDTH="284" HEIGHT="45" ALIGN="BOTTOM" ALT="Macmillan Computer Publishing USA"
BORDER="0"></P>

<P>&#169; <A HREF="../copy.htm">Copyright</A>, Macmillan Computer Publishing. All
rights reserved.
</CENTER>


</BODY>

</HTML>