|Oracle9i Database Installation Guide
Release 2 (184.108.40.206.1) for 64-Bit Windows
Part Number B10546-01
A mode of the database in which undo data is stored in a dedicated undo tablespace. Unlike in manual undo management mode, the only undo management that you must perform is the creation of the undo tablespace. All other undo management is performed automatically.
A cluster generally comprises two or more computers, or nodes. Oracle Real Application Clusters software and a collection of hardware, known as a cluster, unite the processing power of each component to become a single, computing environment. Oracle Real Application Clusters harnesses the processing power of multiple, interconnected computers.
A specially formatted description of the destination for a network connection. A connect descriptor contains destination service and network route information.
The destination service is indicated by using its service name for the Oracle9i database. The network route provides, at a minimum, the location of the listener through use of a network address.
A name, net service name, or service name that resolves to a connect descriptor. Users initiate a connect request by passing a username and password along with a connect identifier in a connect string for the service to which they want to connect, for example:
The network domain within which most client requests take place. It can be the domain where the client resides, or a domain from which the client often requests network services. The default domain is also the client configuration parameter that determines what domain to append to unqualified network name requests. A name request is unqualified if it does not have a "." character within it.
A hierarchical tree-like structure in a directory server of the Distinguished Names (DNs) of the entries.
A naming method that specifies a directory server to resolve a net service name into a connect descriptor. The net service name is stored centrally in a directory server.
A subtree that is of significance within a directory server. It is usually the top of some organizational subtree. Some directories only allow one such context that is fixed; others allow none to many to be configured by the directory administrator.
A Lightweight Directory Access Protocol (LDAP)-compliant directory server. A directory can provide centralized storage and retrieval of database network components, user and corporate policies preferences, user authentication, and security information, replacing client-side and server-side localized files.
The complete database installation type.
A PL/SQL routine executing on an Oracle server can call an external procedure or function that is written in the C programming language and stored in a shared library. In order for the Oracle9i database to connect to external procedures, the server must be configured with a net service name and the listener must be configured with protocol address and service information.
The full database name that uniquely distinguishes it from any other database in your network domain. For example:
sales is the name you want to call your database and
us.acme.com is the network domain in which the database is located.
An installation type is a predefined component set that automatically selects which components to install. See "Oracle9i Products for Installation" for a list of installation types available with each top-level component.
A protocol used by client applications that resides on the same node as the listener to communicate with the database. IPC can provide a faster local connection than TCP/IP.
A file created by the Oracle Net Configuration Assistant that contains the following directory access information:
ldap.ora file resides in
A process that resides on the server and whose responsibility is to listen for incoming client connection requests and manage the traffic to the server.
When a client requests a network session with a database server, a listener receives the actual request. If the client information matches the listener information, then the listener grants a connection to the database server.
A configuration file for the listener that identifies the:
listener.ora file resides in
An Oracle9i database does not require identification of the database service because of service registration.
A resolution method used by a client application to resolve a connect identifier to a network address when attempting to connect to a database service. Oracle Net Services supports the following naming methods:
A simple name for a service that resolves to a connect descriptor. Users initiate a connect request by passing a username and password along with a net service name in a connect string for the service to which they want to connect:
Depending on your needs, net service names can be stored in a variety of places, including:
tnsnames.ora, on each client
Windows login credentials can be used to authenticate users connecting to an Oracle9i database. The benefits of Windows native authentication include:
The Oracle Cluster File System (OCFS) is a shared file system designed specifically for Oracle9i. OCFS eliminates the requirement of linking Oracle datafiles to logical drives and enables all nodes to share a single Oracle home instead of requiring each node to have its own local copy. OCFS volumes can span one shared disk or multiple shared disks for redundancy and performance enhancements.
Oracle Cluster File System:
The Oracle Cluster Setup Wizard performs the following tasks on all nodes:
OracleClusterFileSystemservice and creates one or two shared file systems.
Serviceon all nodes. This tool creates persistent symbolic links to logical drives. The service updates all nodes when symbolic links are modified, and is set to Automatic, so that it starts whenever you shut down and restart your computer.
The root of a directory subtree with a relative distinguished name of
cn=OracleContext, under which all Oracle software information is kept. There may be one (or more than one) Oracle Context in a directory. An Oracle Context can be associated with a directory naming context.
The Oracle Context can contain the following Oracle entries:
The directory path in which to install Oracle components (for example,
D:\oracle\ora92). You are prompted to enter an Oracle home in the Path field of the Oracle Universal Installer's File Locations window.
The name of the current Oracle home. Each Oracle home has a home name that distinguishes it from all other Oracle homes on your computer. During installation, you are prompted to enter an Oracle home name in the Name field of the Oracle Universal Installer's File Locations window.
A set of rules that determine what can be stored in an LDAP-compliant directory server. Oracle has its own schema that is applied to many types of Oracle entries, including Oracle Net Services entries. The Oracle schema for Oracle Net Services entries includes the attributes the entries may contain.
A networking communication layer that is responsible for establishing and maintaining the connection between the client application and server, as well as exchanging messages between them.
One of the available database installation types. Personal Edition for Windows does not include Oracle Real Application Clusters.
An address that identifies the network address of a network object.
When a connection is made, the client and the receiver of the request, such as the listener, or Oracle Connection Manager, are configured with identical protocol addresses. The client uses this address to send the connection request to a particular network object location, and the recipient "listens" for requests on this address. It is important to install the same protocols for the client and the connection recipient, as well as configure the same addresses.
A feature by which the PMON process (an instance background process) automatically registers information with a listener. Because this information is registered with the listener, the listener.ora file does not need to be configured with this static information.
Service registration provides the listener with the following information:
This allows the listener to direct a client's request appropriately.
This allows the listener to determine which dispatcher can best handle a client connection's request. If all dispatchers are blocked, the listener can spawn a dedicated server for the connection.
This information allows the listener to determine how best to service a client connection request.
The Oracle system identifier that distinguishes the database from all other database on your computer. The SID automatically defaults to the database name portion of the global database name (
sales in the example
sales.us.acme.com) until you reach eight characters or enter a period. You can accept or change the default value.
A configuration file for the client or server that specifies the:
sqlnet.ora file resides in
One of the available database installation types. Standard Edition does not include Oracle Advanced Security, Oracle COM Automation Feature, Oracle OLAP, Oracle Partitioning, Oracle Real Application Clusters, or Oracle Spatial.
Microsoft Windows Terminal Server is a Windows thin-client terminal server, a product that adds support for multiple, simultaneous client sessions on the Windows Server. Windows Terminal Server provides an operating system graphical user interface (GUI) to users of Oracle9i databases.
A configuration file that contains net service names mapped to connect descriptors. This file is used for the local naming method. The
tnsnames.ora file resides in
When you run Oracle Universal Installer from the component CD, you are prompted in the Available Products window to install a top-level component. Each top-level component contains several installation types from which to choose. Each installation type contains a predefined set of individual components. See "Oracle9i Products for Installation" for a list of installation types available with each top-level component.
A dedicated tablespace that stores only undo information when the database is run in automatic undo management mode. An undo tablespace contains one or more undo segments. The creation of any other types of segment (for example, tables, indexes) in undo tablespaces is not allowed.
In the automatic mode, each Oracle instance is assigned one and only one undo tablespace. Each undo tablespace is composed of a set of undo files. Undo blocks are grouped in extents. At any point in time, an extent is either allocated to (and used by) a transaction table, or is free.
Blocks in undo tablespaces are grouped into the following categories:
A net service name that does not contain a network domain.
The Universal Naming Convention provides a means to access files on a network without mapping the network drive to a drive letter. UNC names are constructed in the following manner:
Virtual Interface Architecture is an industry-standard architecture for intercluster communications. VIA's rapid server-to-server communication enhances an application's scalability and performance. VIA does this by allowing a single application to run efficiently across dozens of clustered nodes and by accelerating the data exchange among distributed application modules running on different application servers.