The Oracle7 Server is one of the Oracle packages; it includes the Oracle7 database and client/server tools and utilities. Currently, it is available in the following editions:
This chapter presents the overview of Oracle7 Server and its major components. The Oracle7 Server is different from the Personal Oracle7 and the Oracle7 Workgroup Server. This chapter compares these three Oracle packages and discusses how Oracle7 Server
differs from the other two Oracle packages. Each of the Oracle packages is tailored to meet specific client/server application development and deployment needs. This chapter explains when it is appropriate to use the Oracle7 Server and how it meets your
business and technical needs.
The Oracle7 Server is a full-function Oracle7 database with integrated client/server tools and utilities. This section gives an overview of the Oracle7 Server and how it differs from other Oracle packages. It also discusses what components are included
in the Oracle7 Server.
The Oracle7 Server includes the multiuser Oracle7 database with the distributed options, Oracle database utilities, graphical tools, SQL products, SQL*Net, Secure Network Services, Oracle Objects for OLE, Oracle7 ODBC driver, and online documentation.
The Oracle7 Server components are categorized into the server or client software. Table 58.1 summarizes the primary components of server software of the Oracle7 Server. For a complete list of all components and the detailed description, refer to your
Oracle7 Server User's Guide.
Oracle7 Server version 7.2 for
Components |
Windows NT |
NetWare |
OS/2 | |
Server Software |
|
|
|
|
Oracle7 Server |
Yes |
Yes |
|
Yes |
PL/SQL |
Yes |
Yes |
|
Yes |
Server Options (purchased separately) |
|
|
|
|
Distributed Option |
Yes |
Yes |
|
Yes |
Parallel Query Option |
Yes |
Yes |
|
Yes |
|
(for NetWare 4.1) |
|
|
|
Symmetric Replication Option or |
Yes |
Yes |
|
Yes |
Advanced Replication Option |
(for NetWare 4.1) |
|
|
|
SQL*Plus |
Yes |
Yes |
|
Yes |
SQL*DBA |
Yes |
Yes |
|
Yes |
SQL*Loader |
Yes |
Yes |
|
Yes |
Export |
Yes |
Yes |
|
Yes |
Import |
Yes |
Yes |
|
Yes |
SQL*Net V1 and/or V2 |
|
|
|
|
Named Pipes |
Yes |
N/A |
|
Yes |
SPX |
Yes |
Yes |
|
Yes |
TCP/IP |
Yes |
Yes |
|
Yes |
LU6.2 (V2) |
N/A |
Yes |
|
N/A |
AppleTalk |
N/A |
Yes |
|
N/A |
NetBIOS |
N/A |
N/A |
|
Yes |
Oracle Names |
Yes |
Yes |
|
Yes |
Server Manager |
N/A |
Yes |
|
N/A |
Instance Manager |
Yes |
N/A |
|
N/A |
Oracle Manager |
N/A |
Yes |
|
N/A |
Oracle Performance Monitor |
Yes |
N/A |
|
N/A |
Event Viewer |
Yes |
N/A |
|
N/A |
Oracle Database Tools |
|
|
|
|
Database Password Manager |
Yes |
Yes |
|
N/A |
Backup Manager |
Yes |
N/A |
|
Yes |
Recovery Manager |
Yes |
N/A |
|
Yes |
Database Expander |
Yes |
N/A |
|
Yes |
Oracle guide Online Documentation |
Yes |
N/A |
|
Yes |
The client software of the Oracle7 Server is basically the same as that of the Oracle7 Workgroup Server and is summarized in Table 58.2. In the Oracle7 Server Version 7.2 for NetWare, three of the additional client software are Oracle Snap-In for
NetWare Administrator, SQL*Plus for Windows NT, and SQL*Plus for OS/2. The important new tools and utilities are explained later in this chapter.
This section specifies the minimum hardware and software requirements for installing the Oracle7 Server software. The hardware and software requirements depend on a number of major factors, such as the size of the Oracle database system global area
(SGA), the number of concurrent client connections, and the applications installed on the system. You need to refer to your Oracle7 Server User's Guide for detailed information on how to determine your system requirements. This section also
provides several tips on installing and using the Oracle7 Server.
This section describes the minimum hardware requirements for installing and running the Oracle7 Server.
This section describes the minimum server operating system requirements for installing and running the Oracle7 Server.
The following system requirements are for installing the client software components of the Oracle7 Server on your client machine. Additional hardware and software might be required depending on your client machine's operating system and your network.
The Oracle7 Server includes a suite of client and server tools and utilities for administering and maintaining your Oracle7 database. They include the server-based Oracle7 utilities, such as SQL*DBA, SQL*Loader, Export, and Import. The graphical user
interface database tools and utilities are also included. Most of them are discussed in the previous chapters. This section introduces a number of new tools and utilities included in the Oracle7 Server version 7.2. For a complete list of the database tools
and utilities included in the Oracle7 Server package, refer to your Oracle7 Server User's Guide. For more information about these tools and utilities, refer to the Oracle7 Server Utilities User's Guide, the Oracle7 Server User's Guide,
the Oracle Database Tools User's Guide, and the Oracle Server Manager User's Guide.
The Instance Manager is included in the Oracle7 Server version 7.2 for Windows NT. This graphical tool enables you to create, modify, and delete Oracle instances. You can only start or shut down an instance using Instance Manager while you are creating
or deleting an instance. You can use SQL*DBA or Database Manager to start or shut down a database.
The Oracle Performance Monitor is included in the Oracle7 Server version 7.2 for Windows NT. It is a useful tool in helping you to monitor the performance of your distributed databases. You can select one or more variables to monitor from the
Performance Monitor. Figure 58.1 shows a Performance Monitor dialog box.
Figure 58.1. An Oracle Performance Monitor dialog box.
The Oracle7 Server Version 7.2 for Windows NT also includes an Event Viewer. When errors and alert conditions appear on your databases, the Event Viewer will notify you. After you view a list of errors and alert conditions from the Event Viewer, you can
print the list or save it to a file.
The Server Manager is a database tool that enables you to start, shut down, and administer your local and remote databases which are Oracle7 Version 7.0 or higher. In Oracle7 Server Version 7.2 for NetWare, you can activate the line mode interface
Server Manager from the file server console or the graphical interface Server Manager from a Windows workstation. If you want to load the Server Manager from the NetWare server console prompt, enter the following command:
:LOAD SVRMGR
The Server Manager enables you to have centralized database administration in a distributed database environment. There are three primary components in the graphical interface of the Server Manager: Administration Manager, SQL Worksheet, and System
Monitors. Figure 58.2 shows the Oracle Server Manager for Windows dialog box. For descriptions on how to use Oracle Server Manager, refer to your Oracle Server Manager User's Guide.
Figure 58.2. The Oracle Server Manager for Windows dialog box.
The Administration Manager component enables you to manage the database storage (tablespace, data files, and rollback segments), manage database security (users, roles, and profiles), manage instances and sessions, back up and recover a database, and
view database schema objects, such as constraints, triggers, and snapshots.
The SQL Worksheet enables you to enter, edit, and execute SQL and PL/SQL statements and scripts. Its Command History dialog box stores the last 20 commands you have executed. You can retrieve an entire command or part of a command from the Command
History dialog box.
The System Monitors enable you to gather and review database performance statistics. The source of the statistics in the System Monitors component is the Oracle dynamic performance tables. Users who want to use the System Monitors need to have access to
these dynamic performance tables. By running the UTLMONTR.SQL script, you can grant access to these tables to all users.
The Oracle7 Server Version 7.2 for NetWare includes four new screen mode utilities for NetWare: Oracle Manager (NWDBMGR), Export (NWEXPORT), Import (NWIMPORT), and SQL*Loader (NWLOADER). Although the functions of the screen mode utilities and the line
mode utilities are basically the same, the screen mode utilities are menu-driven and they provide online help and directory browsing in the native NetWare server environment.
The Oracle Manager for NetWare allows you to administer the current database instance, alter a tablespace to be offline or online, configure the Oracle7 Server, and to create a new database instance.
The Export utility for NetWare in screen mode enables you to select the export mode, browse and select a user or tables from a list of available objects to export, enable or disable the export of grants, rows, constraints, and indexes options, and to
set other parameters, such as record length, buffer size, commit after each array, and generate log file. Figure 58.3 shows the screen mode export utility.
Figure 58.3. The export utility for NetWare in screen mode.
The SQL*Net Easy Configuration utility for NetWare allows you to configure the listener and database alias for the Oracle SPX Protocol Adapter, Oracle TCP/IP Protocol Adapter, and Oracle AppleTalk Protocol Adapter.
Finally, SQL*Plus, an SQL-based language interface and end-user reporting tool, is available for NetWare. SQL*Plus for NetWare is included with the Oracle7 Server Version 7.2 for NetWare. You can start SQL*Plus for NetWare by entering the following
command at the server console prompt:
:LOAD SQLPLUS
SQL*Plus for Windows NT is a 32-bit application that enables you to run SQL and PL/SQL scripts in the Windows NT environment. SQL*Plus for Windows NT is included with the Oracle7 Server Version 7.2 for Windows NT.
The Oracle7 Server is designed for developers and organizations that require distributed database systems to develop and deploy client/server applications in an enterprise-wide environment. This section highlights the differences between Oracle7 Server
and other Oracle packages, including Personal Oracle7 and Oracle7 Workgroup Server.
The primary difference between the Oracle7 Server and Personal Oracle7 is that the Oracle7 Server is a multiuser database system, whereas the Personal Oracle7 is a single-user/developer database system. Although the Oracle7 Server and the Oracle7
Workgroup Server share many similarities, the Oracle7 Server is targeted at users who require real-time data access across distributed databases, whereas the Oracle7 Workgroup Server is targeted at users who need data to reside on a single server in a
workgroup or small-to-medium sized business environment.
Similar to the Oracle7 Workgroup Server, the Oracle7 Server is also tightly integrated with the server operating system. However, the Oracle7 Server can function beyond a local area network environment because it supports the enterprise network
environment. Table 58.2 shows three of the operating system integration support.
Oracle7 Server version 7.2 for | |||
|
Windows NT |
NetWare 4.1 |
OS/2 |
Symmetric Multiprocessing (SMP) |
Yes |
Yes |
Yes |
NetWare Directory Services (NDS) |
N/A |
Yes |
N/A |
Windows NT Services (Registry) |
Yes |
N/A |
N/A |
In Oracle7 Server for NetWare, the Symmetric Multiprocessing (SMP) support and NetWare Directory Services (NDS) support are available only with NetWare 4.1. Both SMP and NDS are not available in NetWare 3.12. The SMP support enables the
processes and login threads to be distributed among the available CPUs to avoid high utilization on a single CPU. The Parallel Query Option requires the SMP support in NetWare 4.1.
The Oracle7 Server Version 7.2 for NetWare supports NetWare Directory Services (NDS), which enables you to have central access to your network resources, including NetWare servers, users, printers, and databases in a distributed
environment. Using the NetWare NWADMIN for Windows utility, the NDS support enables you as an Oracle database administrator to create an Oracle database instance as a new object in the directory tree. If you want to allow the NetWare
4.1 users and groups to be able to connect to the Oracle database instance through a single database user account, you can map the NetWare 4.1 users and groups to a database user account using NWADMIN. You can also allow a NDS group
to inherit the privileges of a database role by mapping the NDS group to a database role.
The NDS support has the following requirements:
The Oracle7 Server is different from other Oracle packages in terms of the Oracle7 database features. Certain Oracle7 features are available for the Oracle7 Server, but they are not available for other Oracle7 packages, such as the parallel query
option. Table 58.3 summarizes some of the Oracle7 features currently available for each Oracle package.
Personal |
Oracle7 |
Oracle7 | |
Oracle7 Features |
Oracle7 |
Workgroup Server |
Server |
Distributed Option |
Yes |
N/A |
Yes |
Parallel Query Option |
N/A |
N/A |
Yes |
SQL*Net |
Yes |
Yes |
Yes |
Parallel Server |
N/A |
N/A |
N/A |
To select an Oracle package that meets your business needs and technical needs is not an easy task. You might need more than one Oracle package for your organization or business to develop and deploy your client/server applications. This section
discusses when using the Oracle7 Server is appropriate and how it meets your business and technical needs.
This chapter compared the Oracle7 Server with the Personal Oracle7 and Oracle7 Workgroup Server. It also discussed the system requirements and the major features of the Oracle7 Server. In summary, the Oracle7 Server for the desktop platforms is the same as the Oracle7 Server that runs on UNIX, MVS, and other platforms, except for certain operating system specific features, such as the parallel server option.