ch03.htm

Teach yourself Oracle8 in 21 day

	<P>
	<LI>Custom--Checking this option invokes the Oracle Database Assistant, which helps
	you create a custom Oracle database. Choose this option if you will be using this
	database as a replication system, if you want to install other options, or if you
	want to choose the name of your database. This option provides the most flexibility.
	Creating a custom database with the Database Assistant is described in detail on
	Day 6, &quot;Administering Databases and Datafiles.&quot;
	<P>
	<LI>None--If you are planning to immediately build a new database on this system,
	consider not building a starter database. This will save on space and time.
</UL>

<P>The final question that you will be asked is the location of the online documentation.
You can either access the documentation via CD-ROM or install it on your local hard
drive, as shown in Figure 3.8.</P>
<P><A NAME="08"></A><A HREF="08.htm"><B>Figure 3.8.</B></A></P>
<P><I>Installing the documentation.</I></P>
<P>Installing the documentation on the hard disk requires approximately 66MB of disk
space, but it's well worth the space (if available). There is nothing worse than
not having the documentation immediately available when you need it. The Oracle8
documentation set is available in HTML format with hyperlinks, which makes it very
convenient.</P>
<P>As the installation proceeds, you can watch its progress on the status bar. As
the installation gets further along, the bar on the bottom increases in length. When
the installation is complete, you will be so notified.</P>
<H3><FONT COLOR="#000077"><B>What Has Been Installed?</B></FONT></H3>
<P>The installation of the Oracle8 server has instated the following components:

<UL>
	<LI>The Oracle8 RDBMS
	<P>
	<LI>Oracle Enterprise Manager
	<P>
	<LI>Oracle intelligent agents
	<P>
	<LI>The Oracle Administrators toolbar
	<P>
	<LI>Online documentation
	<P>
	<LI>Networking components
	<P>
	<LI>Oracle utilities, including SQL*Plus
</UL>

<P>A few specifics should be mentioned here. The Oracle8 installation processes has
registered Oracle as a service. Specifically, seven services have been registered
(see Figure 3.9):

<UL>
	<LI>OracleAgent--This service is the Oracle intelligent agent for the Oracle Enterprise
	Manager. This agent can communicate with multiple Oracle instances on the same system;
	therefore, only one agent service exists.
	<P>
	<LI>OracleClientCache80--This service is manual. Once started, it stores in cache
	all information received from an Oracle names server.
	<P>
	<LI>OracleNamesService80--Use this service, which is also manual, if you configure
	this system as a names server.
	<P>
	<LI>OracleServiceORCL--This service is associated with the instance for Oracle SID=ORCL
	(default). This is not the actual Oracle instance, but a bootstrap instance. The
	service starting up does not start up the Oracle instance at boot time.
	<P>
	<LI>If new databases are created with a different SID, a new service must be created
	with the new SID in the name. This is described in detail on Day 5, &quot;Managing
	the Oracle RDBMS.&quot;
	<P>
	<LI>OracleStartORCL--The OracleStartORCL service starts the Oracle service named
	ORCL (default) each time the system is rebooted.
	<P>
	<LI>OracleTNSListener30--This is the TNS listener service. There is a TNS listener
	service for each network listener that you define. Typically, there is one listener
	per defined protocol.
	<P>
	<LI>OracleWebAssistant. This service enables queries from the Oracle database to
	be published to a Web page.
</UL>

<P><A NAME="09"></A><A HREF="09.htm"><B>Figure 3.9.</B></A></P>
<P><I>These are the installed Oracle services.</I></P>
<P>If you decide you don't want a particular service to automatically start each
time the system is booted, you can change this by modifying the Oracle service properties
(see Figure 3.10). By changing the service startup from automatic to manual, the
service will only start manually (you must modify the service through NT).</P>
<P><A NAME="10"></A><A HREF="10.htm"><B>Figure 3.10.</B></A></P>
<P><I>Use this dialog to modify the Oracle service properties.</I></P>


<BLOCKQUOTE>
	<P>
<HR>
<FONT COLOR="#000077"><B>TIP: </B></FONT>This can be useful on a development machine
	where you do not always need the ability to start up Oracle and want to save on system
	resources. 
<HR>


</BLOCKQUOTE>

<P>Also as part of the installation process, new program groups have been created
and appear as part of the taskbar. The first of these groups is the Enterprise Manager
group. This group contains icons for the following Oracle products:

<UL>
	<LI>Enterprise Manager
	<P>
	<LI>Backup Manager
	<P>
	<LI>Instance Manager
	<P>
	<LI>Network Topology Generator
	<P>
	<LI>Schema Manager
	<P>
	<LI>Security Manager
	<P>
	<LI>Storage Manager
</UL>

<P>The second of these program groups is the Oracle for NT group. This group contains
icons for the following Oracle products:

<UL>
	<LI>Oracle ODBC Administrator
	<P>
	<LI>Oracle Instance Manager
	<P>
	<LI>Oracle Installer
	<P>
	<LI>Oracle Network Configuration wizard
	<P>
	<LI>SQL*Plus
</UL>

<P>The third program group created is the Oracle Replication Manager program group.
One other feature of the Oracle Server installation is the Oracle Administrators
toolbar. This toolbar is installed as part of the server installation as well as
the administrators installation, and is shown in Figure 3.11.</P>
<P><A NAME="11"></A><A HREF="11.htm"><B>Figure 3.11.</B></A></P>
<P><I>The Oracle Administrators toolbar.</I></P>
<P>This toolbar allows instant access to many of the applications that are part of
the Oracle Enterprise Manager system.</P>
<H2><FONT COLOR="#000077"><B>Installing the Oracle8 Client Products</B></FONT></H2>
<P>The following is split into two sections. The first section describes the actual
process of installing the software. The second section provides a description of
the system after the installation has occurred. Specifically, this section provides
information on what products have been installed, what services have been installed,
and how the Registry has been modified.</P>
<H3><FONT COLOR="#000077"><B>The Installation Process</B></FONT></H3>
<P>You can choose to install the Oracle8 client products by clicking the Oracle8
Client Products button and then clicking the OK button. The client installation process
immediately asks whether you want to proceed with the database administrator or application
user installation. To install the database administrator client, click OK (see Figure
3.12).</P>
<P><A NAME="12"></A><A HREF="12.htm"><B>Figure 3.12.</B></A></P>
<P><I>Installing the database administrator client.</I></P>
<P>Oracle immediately begins installing the database administrator client components.
As with the server installation, 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.</P>
<P>If your installation is for an end-user system, you will choose the application
user installation. To install the application user client, click the Application
User button, then click OK.</P>
<P>Oracle immediately begins installing the application user client components. As
with the server installation, 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.</P>
<H4><FONT COLOR="#000077"><B>What Has Been Installed?</B></FONT></H4>
<P>The database administrator client installation instates the following components:

<UL>
	<LI>Oracle Enterprise Manager
	<P>
	<LI>The Oracle Administrators toolbar
	<P>
	<LI>Online documentation
	<P>
	<LI>Networking components
	<P>
	<LI>Oracle utilities, including SQL*Plus
	<P>
	<LI>OCI
</UL>

<P>The application user client installation instates the following components:

<UL>
	<LI>Networking components
	<P>
	<LI>SQL*Plus
	<P>
	<LI>Online documentation
</UL>

<P>At the end of today's lesson is an in-depth description of each of the products
installed and how they are used.</P>
<H3><FONT COLOR="#000077"><B>Installing the Programmer/2000 System</B></FONT></H3>
<P>The following is split into two sections. The first section describes the actual
process of installing the software. The second section provides a description of
the system after the installation has occurred. Specifically, this section provides
information on what products and services have been installed, and how the Registry
has been modified.</P>
<H3><FONT COLOR="#000077"><B>Installing the Oracle8 Custom Configuration</B></FONT></H3>
<P>The following is split into two sections. The first section describes the actual
process of installing the software. The second section provides a description of
the system after the installation has occurred. Specifically, this section provides
information on what products and services have been installed, and how the Registry
has been modified.</P>
<P><FONT COLOR="#000077"><B>The Installation Process</B></FONT></P>
<P>You can choose to install the custom installation path by clicking the Custom
button and then clicking OK. This begins the custom installation procedure. The custom
system is for those users who do not fit into the other catagories. You will be presented
with the Software Asset Manager screen, where you select any components available
on the Oracle8 CD-ROM (see Figure 3.13).</P>
<P><A NAME="13"></A><A HREF="13.htm"><B>Figure 3.13.</B></A></P>
<P><I>The Software Asset Manager screen.</I></P>
<P>Simply choose any components you want by either selecting an entire group (Shift+click)
or clicking a number of individual components (Ctrl+click) and then clicking the