Skip Headers

Oracle9i Database Installation Guide
Release 2 (9.2.0.2.1) for 64-Bit Windows
Part Number B10546-01
Go To Table Of Contents
Contents		 Go To Index
Index

Go to previous page Go to next page

3
Selecting Database Creation and Oracle Net Services Configuration Methods

This chapter describes Oracle9i database creation and Oracle Net Services configuration methods available during installation. Oracle Corporation recommends that you should understand the creation and networking methods before performing an installation.

This chapter contains these topics:

About Database Creation and Network Configuration Methods

Oracle Universal Installer provides several methods for creating an Oracle9i database and configuring your Oracle Net Services networking environment during installation.

The method to select during installation depends upon:

By reviewing the information in this chapter, you can ensure that you create and configure a database and network environment that best matches your needs from the beginning.

Oracle9i and Oracle Net Services components are installed through several installation types. Review the installation types in Table 3-1 to identify how much user input is required for database creation and network configuration during installation. See the remaining sections of this chapter for specific details on what information is automatically created, and what information you must provide.

Selecting the Custom installation type offers several database creation choices, from a complete custom creation requiring extensive user input to a creation requiring minimal user input. See "Selecting a Database Creation Method" for more information.

Table 3-1 User Input Required for Installation Types  
Installation Types User Input Required for Database Creation User Input Required for Oracle Net Services Configuration

Oracle9i Database

  • Enterprise Edition

Minimal

None
  • Standard Edition

Minimal

None
  • Personal Edition

Minimal

None
  • Custom

-

-

    Custom > Oracle Net Services

    or

    Custom > Oracle9i

Not applicable

Extensive

None or Extensive

Not applicable

Oracle9i ClientFoot 1
  • Administrator

Not applicable

Minimal
  • Runtime

Not applicable

Minimal
  • Custom

-

-

    Custom > Oracle Net Services

    or

    Custom > Oracle9i

Not applicable

Extensive

None or Extensive

Not applicable

Oracle9i Management and Integration
  • Oracle Internet Directory

Minimal

Minimal
  • Custom

    Custom > Oracle Net Services

    or

    Custom > Oracle Net Services

Extensive

Not applicable

Not applicable

Minimal or Extensive
1 You cannot install a database from the Oracle9i Client top-level component.

Note:

If you select the Oracle Internet Directory installation type described in Table 3-1, then an Oracle9i database is automatically installed if one is not currently installed in the same Oracle home. Use this database only for storing Oracle Internet Directory information.

Types of Database Environments

Oracle Universal Installer enables you to create an Oracle9i database that operates in one of the environments shown in Table 3-2. Identify the environment appropriate for your Oracle9i database.

Table 3-2 Database Configuration Types  
Environment Description

General Purpose

Users perform a variety of database tasks, ranging from simple transactions to complex queries. Select this database environment for general purpose usage.

Transaction Processing

Users perform large numbers of concurrent transactions, where each transaction is a relatively simple operation processing a small amount of data. Transactions consist of reading, writing, and deleting data in database tables.

Billing databases, such as those commonly found on internet commerce sites, are the most common example of this database configuration. These are also known as online transaction processing (OLTP) databases.

Data Warehouse

Users perform numerous complex queries that process large volumes of data. Response time, accuracy, and availability are key issues.

These queries (typically read-only) range from a simple fetch of a few records to complex queries that sort thousands of records from many different tables. Data warehousing environments are also known as Decision Support System (DSS) environments.

Customized

Allows you to create a customized database configuration or a custom installation of Oracle components that meets specialized requirements.

Select this configuration method only if you are prepared to provide detailed component and database environment information. Choosing this option requires a longer installation session than choosing a preconfigured database.

Software Only

Allows you to install Oracle components without creating a database.

Select this method only if you are prepared to provide extensive database configuration information when you create a database. Oracle Corporation recommends that you install at least one seed database to serve as a template for database configuration.

See Also:

Database Configuration Assistant Online Help for information on the initialization file parameters affected by your database selection

Selecting a Database Creation Method

Database Configuration Assistant enables you to create a database for Transaction Processing, Data Warehouse, or General Purpose environments. Database Configuration Assistant is automatically started by Oracle Universal Installer when you select to create a database as part of the installation process or it can run as a standalone tool after installation.

When you run Oracle Universal Installer and select Oracle9i Database in the Available Products window, the Installation Types window appears and presents you with the installation types. Each installation type enables you to create the database configuration types listed in Table 3-2.

See Also:

  • "Postinstallation Database Creation" of Oracle9i Database Platform Guide for Windows for information on running Database Configuration Assistant in standalone mode

  • "Database Tools Overview" of Oracle9i Database Platform Guide for Windows for instructions on starting this tool in standalone mode

The database configurations types (General Purpose, Transaction Processing, Data Warehouse, Customized, and Software Only) created with the Enterprise Edition, Standard Edition, Personal Edition, and Custom installation types and the amount of user input required are described in Table 3-3, Table 3-4, and Table 3-5. Review these selections and identify the database that best matches your database requirements and database creation expertise.

Table 3-3 Database Configuration--Enterprise Edition and Personal Edition
If You Perform This Step... Then...

Select the Enterprise Edition or Personal Edition installation type.

Database Configuration Assistant automatically starts at the end of installation and configures the database according to the selected database configuration type:

  • Default initialization parameters

  • Automatic installation and configuration of various database options, such as Oracle JVM and Oracle Spatial components Foot 1

  • Advanced replication capabilities

  • Database configured in dedicated server mode Foot 2

  • Archiving mode set to NOARCHIVELOG

No user input is required other than the global database name and SID you are prompted to enter prior to Database Configuration Assistant startup. At the end of the database creation process, you are required to change the SYS and SYSTEM passwords.

Note: Personal Edition does not offer Oracle Real Application Clusters.
1 Database Configuration Assistant configures only components installed through Oracle Universal Installer.

2 See "Postinstallation Database Creation" of Oracle9i Database Platform Guide for Windows for descriptions of dedicated server mode and shared server mode.

Note:

The Oracle9i database created through the Enterprise Edition installation type is also created if you select the Oracle Internet Directory installation type and no Oracle9i database is currently installed in the specified Oracle home.

Table 3-4 Database Configuration--Standard Edition
If You Perform This Step... Then...

Select the Standard Edition installation type.

Database Configuration Assistant automatically starts at the end of installation and configures the database according to the selected database configuration type. At the end of the database creation process, you are required to change the SYS and SYSTEM passwords.

Refer to "Oracle9i Options Requiring a License" or Appendix A, "Individual Components Available for Installation" for a list of components that are not part of the Standard Edition installation type.
Table 3-5 Database Configuration--Custom
If You Perform These Steps... Then...
  1. Select the Custom installation type.

  2. Select Oracle9i and additional products in the Available Product Components window.

  3. Select Yes when prompted to create a starter database.

    Database Configuration Assistant prompts you to select a database environment:

    Transaction Processing

    Data Warehouse

    General Purpose

Database Configuration Assistant guides you in the creation of a database customized to match the environment (Transaction Processing, Data Warehouse, or General Purpose) and configuration mode (dedicated server or shared server) you select. Database options such as Oracle JVM, Oracle Spatial, and advanced replication (if installed) are automatically configured. Select this option only if you are experienced with advanced database creation procedures, such as customizing:

  • Data, control, and undo log file settings

  • Tablespace and extent sizes

  • Database memory parameters

  • Archiving modes, formats, and destinations

  • Trace file destinations

  • Character set values

At the end of the database creation process, you are required to change the SYS and SYSTEM passwords.

Configuring Your Network

Oracle Net Configuration Assistant enables you to configure the Oracle Net Services environment to enable Oracle clients to connect to an Oracle9i database. Oracle Net Configuration Assistant is automatically started from Oracle Universal Installer through most installation types, or it can run as a standalone tool.

Depending on the installation type selected, Oracle Net Configuration Assistant configures your network in one of the following ways:

Configuration consists of creating and modifying network configuration files located in the default ORACLE_BASE\ORACLE_HOME\network\admin directory.

See Also:

  • Oracle9i Net Services Administrator's Guide or the Oracle Net Configuration Assistant online help for information on running Oracle Net Configuration Assistant in standalone mode

  • "Database Tools Overview" of Oracle9i Database Platform Guide for Windows for instructions on starting Oracle Net Configuration Assistant in standalone mode

Configuring the Server Network

The type of network configuration created with the server installation types and the amount of user input required are described in subsequent sections. Review Table 3-6 and Table 3-7 and identify the network configuration that best matches your requirements and network configuration expertise.

Table 3-6 Net Services Configuration--Enterprise Edition, Standard Edition, or Personal Edition
If You Perform These Steps... Then...
  1. Select Oracle9i Database.

  2. Select the Enterprise Edition, Standard Edition, or Personal Edition installation type.

Oracle Net Configuration Assistant automatically creates your Oracle Net Services environment by configuring information in the following files:

  • listener.ora

    Configures a listener named LISTENER with protocol addresses for both the Oracle9i database (using the preferred protocol for your operating system, which is typically TCP/IP on port 1521) and for external procedures (using the IPC protocol)

    Configures service information for external procedures

  • sqlnet.ora

    Configures the database to accept operating system authenticated connections (through the NTS adapter). Refer to "Windows Native Authentication Overview" of Oracle9i Database Platform Guide for Windows for more details.

    Configures the server's network domain as the default domain (the TCP/IP domain in which your computer is located). This domain is automatically appended to any unqualified net service name given in the connect string

    Configures the naming methods the server uses to resolve a name to a connect descriptor

  • tnsnames.ora

    Creates a net service name file to use for external procedure connections

Note: You cannot configure access to a lightweight directory access protocol (LDAP)-compliant directory server through the Enterprise Edition, Standard Edition, and Personal Edition installation types. Directory server configuration is available only through the Custom installation type.

Database Configuration Assistant automatically configures additional Oracle Net Services information in the following files during successful creation of the Oracle9i database:

  • listener.ora

    Configures service information for the Oracle9i database

  • tnsnames.ora

    Configures a net service name for the database to connect back to itself

Note: Database Configuration Assistant configures additional information for Oracle Real Application Clusters installations. See Oracle9i Real Application Clusters Setup and Configuration
Table 3-7 Net Services Configuration--Custom Database  
If You Select These Installation Types... Then...
  1. Select Oracle9i Database.

  2. Select Custom.

  3. Select Oracle Net Services.

Oracle Net Configuration Assistant first prompts you to select a naming method to a connect descriptor for connection to an Oracle9i database:

  • Complete directory server usage configuration. This requires that you enter a directory server type and location, if you have one, and specify which Oracle Context should be used by default for this Oracle home. You are prompted for this information if you have never configured the Oracle home for directory usage.

  • Create listeners to use for database connections

  • Select the naming method to use when connecting to the local database. By default, the local naming method is selected. In most circumstances, Oracle Corporation recommends this default. You also have the option to use one of the following naming methods: directory naming if directory usage configuration was completed, local naming, host naming, or external naming.

Oracle Net Configuration Assistant then automatically creates the Oracle Net Services environment by configuring information in the following files:

  • listener.ora

    Configures a listener with a name and protocol address that you choose. In addition, a protocol address and static service information for external procedures are configured.

  • sqlnet.ora

    Configures the database to accept operating system authenticated connections (through the NTS adapter). Refer to "Windows Native Authentication Overview" of Oracle9i Database Platform Guide for Windows for more details.

    Configures the server's network domain as the default domain (the TCP/IP domain in which your computer is located). This domain is automatically appended to any unqualified net service name given in the connect string.

    Configures the naming methods the server uses to resolve a name to a connect descriptor

  • tnsnames.ora

    Creates a net service name entry for external procedure connections

  • ldap.ora

    Configures access to the directory server

Database Configuration Assistant automatically configures additional Oracle Net Services information in the following files during successful creation of the Oracle9i database:

  • listener.ora

    Configures service information for the Oracle9i database

  • tnsnames.ora

    Configures a net service name for the database to connect back to itself

Configuring the Client Network

The type of network configurations created with the client installation types and the amount of user input required are described in the following tables. Review Table 3-8 and Table 3-9 and identify the network configuration that best matches your requirements and network configuration expertise.

Table 3-8 Net Services Configuration--Administrator or Runtime  
If You Perform These Steps... Then...
  1. Select Oracle9i Client.

  2. Select Administrator or Runtime.

Oracle Net Configuration Assistant prompts you to configure the directory naming or local naming method based upon if you choose to use a directory server or not.

If you choose to use a directory server, Oracle Net Configuration Assistant prompts you to complete directory server usage. If you do not choose to use a directory server, the Oracle Net Configuration Assistant prompts you to configure a net service name in a tnsnames.ora file.

Oracle Net Configuration Assistant then automatically creates your client environment by configuring information in the following files:

  • sqlnet.ora file

    Configures the client's domain as the default domain (the TCP/IP domain in which your computer is located). This domain is automatically appended to any unqualified net service name given in the connect string.

    Configures the naming methods the client uses to resolve a name to a connect descriptor

  • tnsnames.ora file

    Configures a net service name to connect to the database, if the local naming method was selected

  • ldap.ora file

    Configures access to the directory server

Table 3-9 Net Services Configuration--Custom Client
If You Perform These Steps... Then...
  1. Select Oracle9i Client.

  2. Select Custom.

  3. Select Oracle Net Services.

Oracle Net Configuration Assistant prompts you to configure a naming method to resolve a name to a connect descriptor for a connection to an Oracle9i database. Oracle Net Configuration Assistant provides you with the option of selecting one or more naming methods (directory naming, local naming, host naming, or external naming) or using the Perform typical configuration option.

The Perform typical configuration option automatically selects the local naming or directory naming method based on your existing directory usage configuration.

Depending on your selection, you are prompted for additional information. For the local naming method, you are prompted to enter a net service name, a database service name, and a networking protocol to use. By default, the database service name is its global database name.

Oracle Net Configuration Assistant then automatically creates your Oracle Net client environment by configuring information in the following files:

  • sqlnet.ora file

    Configures the client to request operating system authenticated connections (through the NTS adapter). Refer to "Windows Native Authentication Overview" of Oracle9i Database Platform Guide for Windows for more details.

    Configures the client's domain as the default domain (the TCP/IP domain in which your computer is located). This domain is automatically appended to any unqualified net service name given in the connect string.

    Configures the naming methods the client uses to resolve a name to a connect descriptor

  • tnsnames.ora file

    Configures a net service name to connect to the database, if the local naming method was selected

Go to previous page Go to next page
Oracle
Copyright © 2003 Oracle Corporation.
All Rights Reserved.
Go To Table Of Contents
Contents		 Go To Index
Index