0165-0168

Previous Table of Contents Next

Page 165

• Sun Solaris 2.4 or 2.5 (SunOS 5.4 or 5.5)
  HP-UX 10.x
  IBM AIX 3.2.5 or 4.1.2
  Windows NT 3.51 or 4
  Novell NetWare 3.12 or 4.1

NOTE

Before installing Oracle7 Server, you must install the required operating system patches or packages documented in your Oracle7 Server Getting Started manual or Oracle7 Server Installation Guide. You can follow these steps to verify whether the required patches or packages are installed.
For Sun SPARC Solaris, to find out whether you have installed the Solaris 2.x packages, enter the following command as root:

 # pkginfo -I SUNWbtool SUNWtoo SUNWsprot SUNWarc SUNWlibm SUNWlibms SUNWhea SUNWmfrun 

 # cd /usr/sbin # swlist 

For Windows NT 4.0, you can determine the current installed service pack in several ways. You can follow these steps:

1. Click Start.
2. Choose Programs Administrative Tools.
3. Choose Windows NT Diagnostics.
4. Select the Version tab; it displays the Windows NT version and the service pack number.

For Novell NetWare 4.11, type the following command at the server console prompt:

 : patches 

Client System Requirements

The following system requirements are for installing the client software components of Oracle7 Server on your client machine. Additional hardware and software may be required, depending on your client machine's operating system and your network:

• At least a 386 (or higher) or Pentium-based IBM, COMPAQ, or 100 percent compatible PC
• A minimum of 8MB of available RAM

Page 166

• Enough free disk space for the selected client installation procedure or software; for example, a minimum of 110MB of free disk space is required for installing all the client products of Oracle7 Server for NetWare available with the Selective Products Install package
• A VGA video; SVGA is strongly recommended
• A compatible NIC and its networking software supported by the server and client operating system
• A CD-ROM driver attached locally or remotely as a logical drive

Oracle7 Database Tools and Utilities

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 Server Manager, SQL*Loader, Export, and Import. The graphical user interface (GUI) database tools and utilities also are included. Oracle Enterprise Manager console is currently available on Windows 95 and Windows NT.

Most of these tools and utilities are discussed in previous chapters of this book. This section introduces several new tools and utilities included in Oracle7 Server. For a complete list of the database tools and utilities included in the Oracle7 Server package, refer to your Oracle7 Server Getting Started manual or Oracle7 Installation Guide. For more information about these tools and utilities, refer to the Oracle7 Server Utilities User's Guide, the Oracle Enterprise Manager manuals, the Oracle Database Tools User's Guide, or the Oracle Server Manager User's Guide.

Instance Manager for Windows NT

Instance Manager is included in Oracle7 Server 7.2 and 7.3 for Windows NT. You can start Instance Manager from the Oracle for NT folder within the Program menu in Windows NT. This graphical tool enables you to create, modify, and delete Oracle instances. You can start or shut down an instance by using Instance Manager only while you are creating or deleting an instance. You can use Server Manager or Oracle Enterprise Manager to start or shut down a database. This Instance Manager is different from Oracle Instance Manager, which is part of Oracle Enterprise Manager.

Oracle Instance Manager

Oracle Instance Manager is a component of Oracle Enterprise Manager for Windows NT. You can start Oracle Instance Manager from the Oracle Enterprise Manager console for NT or from the Oracle Enterprise Manager folder in the Program menu. Oracle Instance Manager enables you to perform the following tasks :

• Start up and shut down a database.
• View and modify the initialization parameters.

Page 167

• Create instance startup configurations.
• Manage user sessions and in-doubt transactions.

Figure 8.2 shows the Oracle Instance Manager dialog box.

Figure 8.2.
The Oracle Instance
Manager dialog box.

Oracle Response File Generator

Oracle Enterprise Manager enables users to install products on remote machines. To install products correctly on remote machines without any user input, you need to edit response files for the installation programs by using Oracle Response File Generator. A response file contains the default response for the installation configuration of a product. By simulating the installation of the software package, Response File Generator saves your answers to the installation questions in a response file. Oracle Enterprise Manager uses the installation configuration information in response files to install each product in a software package.

Server Manager

Server Manager is a database tool that enables you to start, shut down, and administer your local and remote databases that are Oracle 7.0 or higher. Server Manager replaces SQL*DBA completely in Oracle 7.3. You can activate the line-mode interface Server Manager or the graphical interface Server Manager from a UNIX workstation. If you want to load the Server Manager line mode from the NetWare server console prompt, enter the following command:

 :LOAD SVRMGR 

Page 168

To start the Server Manager Motif version for Sun SPARC Solaris, you can issue the following command at the operating system prompt:

 $svrmgrm 

Server Manager enables you to have centralized database administration in a distributed database environment. Three primary components exist in the graphical interface of Server Manager: Administration Manager, SQL Worksheet, and System Monitor. For information on using Oracle Server Manager, refer to your Oracle Server Manager User's Guide.

Administration Manager is the main component of Server Manager. It enables you to perform the following tasks:

• 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.
• 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.

System Monitor enables you to gather and review database performance statistics. The source of the statistics in the System Monitor component is the Oracle dynamic performance tables. Users who want to use System Monitor 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.

TIP

The UTLMONTR.SQL script was not included with the 7.3 database. You may copy the script from 7.1 or 7.2 media to the $ORACLE_HOME/rdbms/admin directory. Then follow the steps below in 7.3 at the Server Manager prompt:

 SVRMGR> connect internal SVRMGR> @utlmontr.sql SVRMGR> grant select on AUDIT_ACTIONS to monitorer; 

Screen-Mode Utilities for NetWare

Oracle7 Server 7.2 and 7.3 for NetWare includes four new screen-mode utilities for NetWare:

Oracle Manager (NWDBMGR)
Export (NWEXPORT)

Previous Table of Contents Next