4 Database Tools on Windows

Database Tools and Operating System Compatibility

Table 4-1 through Table 4-6 list database tools and the operating systems on which each can be used.

Table 4-1 Application Development Tools and Operating System Compatibility

Table 4-2 Migration Utilities and Operating System Compatibility

Table 4-3 Database Administration Tools and Operating System Compatibility

Table 4-4 Oracle Command Line Utilities and Operating System Compatibility

Table 4-5 Network Administration Tools and Operating System Compatibility

Table 4-6 Windows Tools and Operating System Compatibility

D:\> exp system/manager full=y volsize=100m;
LRM-00101: unknown parameter name 'volsize'
EXP-00019: failed to process parameters, type 'EXP HELP=Y' for help
EXP-00000: Export terminated unsuccessfully

Preferred Database Tools

Table 4-7 lists various database tools you can use to perform common database administration tasks. Oracle Corporation recommends you use tools listed in the "Preferred Database Tool" column of the table. After choosing a tool to perform a task, go to Table 4-8, "Starting Database Tools from the Start Menu", for instructions on how to start the tool.

Table 4-7 Preferred Database Tools

Starting Database Tools in Multiple Oracle Homes

If you have multiple Oracle homes on your computer from previous releases, then see Chapter 3, " Multiple Oracle Homes and Optimal Flexible Architecture" for a description of differences between Oracle homes before and after Oracle9i release 2 (9.2).

Starting Database Tools from the Start Menu

Table 4-8 describes how to start assistants and other tools from the Start Menu. It also tells where to go for further information on using these products. All Start Menu paths begin with Start > Programs > Oracle - HOME_NAME >.

Table 4-8 Starting Database Tools from the Start Menu

Starting Database Tools from the Command Line

Table 4-9 describes how to start Oracle database tools from the command line, and where to go for further information on using these products.

Table 4-9 Starting Database Tools from the Command Line

Starting Oracle Enterprise Manager Console

Oracle Enterprise Manager Console can be started:

• From the Start Menu or Command Line

• From a Web Browser

From the Start Menu or Command Line

• Choose Start > Programs > Oracle - HOME_NAME > Enterprise Manager Console.

• At the command line, enter: C:\> oemapp console

You are prompted to choose between logging in to a Management Server or starting in standalone mode.

Description of the illustration doemlogn.gif

Choose standalone when you want to connect directly to your database(s) to perform administrative tasks. The first time Enterprise Manager is started in standalone mode, the Add Database To Tree dialog appears, allowing you to add your database(s) to Enterprise Manager's navigation tree. For more information, see "Standalone" in Oracle Enterprise Manager Configuration Guide.

In Standalone mode you will not have access to functionality typically available through Management Server and Intelligent Agent, however, because they are not required in standalone mode. These unavailable features include:

• Management of several different target types

• Sharing data among several administrators

• Advance warning of potential problems

• Automation of repetitive tasks

• Backup and data management tools

• Reports customization, scheduling, and publishing

• Running the client from a Web browser

These features are all available when you choose to log in to a Management Server, which is automatically installed and configured during standard Oracle9i database installation types. If you performed a custom database installation, however, you may need to install and configure a Management Server. For installation instructions, see your Oracle9i Database Installation Guide for Windows. For configuration instructions, see "Configuring and Controlling the Management Server" in Oracle Enterprise Manager Configuration Guide.

If this is your first login to a Management Server, you must enter the default Enterprise Manager administrator name sysman and its password oem_temp. The Management Server on the node you select or enter must already be configured with the repository you want to access. For more information, see "Configuring the Console When Connected to a Management Server" in Oracle Enterprise Manager Configuration Guide.

From a Web Browser

Enterprise Manager Web site is installed in the ORACLE_HOME\oem_webstage directory by default. In addition, Enterprise Manager Web site automatically installs a preconfigured Oracle HTTP server to act as its Web server.

Additional supported Web servers include:

• Oracle Internet Application Server, release 1.0 and higher

• Apache, release 1.3.9 and higher

• Microsoft Internet Information Server (IIS), release 4.0 and higher

If you want to use a Web server other than the default preconfigured Oracle HTTP server, you must install and manually configure it:

1. Start your Web browser and enter the following URL regardless of which Web server you have installed.

   http://webserver_hostname:port number/
   
   

   where webserver_hostname is the name of the Web server computer, and port number is whatever the Web server is configured for. The port number of the default preconfigured Oracle HTTP Server is 3339.

   The Enterprise Manager page appears, allowing you to start Oracle Enterprise Manager Console, view previously published Enterprise Manager reports, or link to other sites.

2. To start Oracle Enterprise Manager Console, enter the name of the Oracle Management Server to which you want to connect and click Launch Console.

3. If you are logging in to Oracle Enterprise Manager for the first time, then type in the default credentials (administrator name and password).

   Administrator: sysman

   Password: oem_temp

   These credentials are for the default super administrator account. The first time you start Enterprise Manager, you must log in as the super administrator. After other administrator accounts have been created using the super administrator account, you can log in as a different administrator.

   
   

   Note: Enterprise Manager must be configured before the reports access feature will work. See Oracle Enterprise Manager Configuration Guide for information on: Configuration tasks How to connect to an Oracle database Installing Oracle Enterprise Manager Web Site Installing the Web server

   
   

Description of the illustration website.gif

Starting Windows Tools

Table 4-10 describes how to start each Windows tool and where to go for more information on using these products.

Table 4-10 Starting Windows Tools

C:\> regedit

C:\> regedt32

Windows Processing Options

This section discusses possible values for the Operating System Dependent (OSD) file processing specifications string option, referred to in "SQL*Loader Control File Reference" in Oracle9i Database Utilities.

INFILE mydata.dat "str '\n'"

INFILE mydata.dat "str x'0a'"

RECORDS DELIMITED BY '\n'

RECORDS DELIMITED BY 0x'0a'

INFILE "mydata.dat" "var n"

Case Study Files

The distribution media for SQL*Loader contains case study files for control files, datafiles, and setup files in ulcase1,...ulcase11 in the following directory: Oracle_Home\rdbms\demo.

Specifying the Bad File

When SQL*Loader executes, it can create a file called a bad file or reject file in which it places records that were rejected because of formatting errors or because they caused Oracle errors. If you have specified that a bad file is to be created, it overwrites any existing file with the same name; ensure that you do not overwrite a file you wish to retain.

Control File Conventions

When preparing SQL*Loader control files (.ctl), you must follow certain syntax and notational conventions.

In full path descriptions, backslashes do not require escape characters or other special treatment. When embedding a single or double quotation mark inside a string delimited by double quotation marks, place a backslash escape character before the embedded quotation mark.

When specifying datatypes in the SQL*Loader control file, note that the default sizes of native datatypes shown in Table 4-11 are specific to Windows. These datatypes can be loaded with correct results only between systems where they have the same length in bytes. You cannot override these defaults in the control file. If the byte order is different between the systems, you can indicate the byte order of the data with the BYTEORDER parameter, or you can place a byte-order mark (BOM) in the file.

Table 4-11 Default Sizes of Native Datatypes

Using Event Viewer to Monitor a Database

Event Viewer lets you monitor events in your system. An event is an important occurrence in the system or application (such as your Oracle database) that requires user notification. While messages for major events can appear on-screen as you work at your computer, events not requiring your immediate attention are recorded by Windows in the Event Viewer log file. You can then view this information at your convenience.

Event Viewer can be used to monitor Oracle database events, such as:

• Initialization of System Global Area for active instance

• Initialization of Program Global Area (PGA) for background processes of active instance

• Connection to Oracle9i database using AS SYSDBA

In addition, the operating system audit trail is logged to Event Viewer.

Using Microsoft Management Console to Administer a Database

Microsoft Management Console provides a central location for network administration. Microsoft Management Console hosts applications (called snap-ins) that administrators can use to manage their networks. Oracle snap-ins enable database administrators to:

• Configure Oracle database administrators, operators, users, and roles so the Windows operating system can authenticate them

• Configure OracleServiceSID

• Modify registry parameters for all Oracle homes on the computer

• Modify the computer hostname, username, and password for the database being monitored by Oracle Counters for Windows Performance Monitor

• View and terminate an Oracle thread

Using Oracle Counters for Windows Performance Monitor

Oracle Counters for Windows Performance Monitor is integrated into Windows Performance Monitor. This tool enables you to view performance of processors, memory, cache, threads, and processes. Performance information provided includes device usage, queue lengths, delays, throughput measurements, and internal congestion measurements. This information is provided as charts, alerts, and reports.

You can use Oracle Counters for Windows Performance Monitor to monitor key Oracle database information, such as:

• Library cache

• Buffer cache

• Data dictionary cache

• Redo log buffer cache

• Thread activity

You can use your findings to improve database performance.

Using Registry Editor to Modify Configuration Information

Oracle9i database stores its configuration information in a structure known as the registry. You can view and modify this configuration information through Registry Editor. The registry contains configuration information for your computer and must not be accessible for editing by inexperienced users. Only experienced administrators should view and change this information.

Registry Editor displays configuration information in a format similar to Windows Explorer. In the left-hand window is a tree-like format consisting of keys (or folders). When one of these keys is highlighted, parameters and values assigned to that key are displayed in the right-hand window.

When you install products from your CD-ROM, configuration parameters are automatically entered in the registry. These parameters are read each time your Windows computer is started and whenever an Oracle product is started. These parameters include settings for:

• Oracle home directory

• Language

• Company name

• Oracle home subdirectories for individual products

• Individual products such as SQL*Plus

• Services

  
  

  See Also: Chapter 18, " Configuration Parameters and the Registry" for definitions of Oracle database configuration parameters and specific instructions on using the registry to modify Oracle9i database configuration parameters

  
  

Using Task Manager to Monitor Applications and Processes

Task Manager has three tabs:

• Applications tab displays what applications are running. This is useful for identifying and ending unresponsive tasks. (Oracle does not appear as an application because it runs as a service.)

• Processes tab displays details of currently running processes and their resource usage. Columns are customizable.

• Performance tab graphically displays real-time CPU and memory usage, which is useful for spotting sudden changes.

Using Local Users and Groups to Manage Users and Groups

Local Users and Groups enables you to manage users and groups on Windows 2000 and Windows XP. Specifically, you can:

• Create and modify local user accounts

• Create and modify user profiles

• Create, add, and delete local groups

Using User Manager to Manage Users

User Manager enables you to manage Windows computer security and create user accounts on Windows NT. With User Manager, you can:

• Grant Oracle database roles

• Use operating system authentication for user accounts (For example, you can grant DBA access to a Windows user.)

• Create a Windows user account that enables you to make secure client connections to Oracle9i database without a password

  
  

  See Also: "Manually Administering External Users and Roles" for specific instructions on using User Manager to perform Oracle database administration