Wednesday, July 2, 2008

Oracle Networking Dictionary

Oracle Networking Dictionary

A

access control list (ACL)
The group of access directives that you define. The directives grant levels of access to specific data for specific clients or groups of clients.

access control
A feature of Oracle Connection Manager that sets rules for denying or allowing certain clients to access designated servers.

administrative region
An organizational entity for administering Oracle Network Services' components. Each administrative region includes:
-One or more domains
-One or more Oracle Names servers
-One or more databases and listeners

alias
An alternative name for a network object in an Oracle Names server. An alias stores the name of the object is referencing. When a client requests a lookup of an alias, Oracle Names completes the lookup as if it is the referenced object.

application gateway
A host computer that runs the Oracle Net Firewall Proxy. An application gateway looks and acts like a real server from the client's point of view, and a real client from the server's point of view. An application gateway sits between the Internet and company's internal network and provides middleman services (or proxy services) to users on either side.

ASCII character set
American Standard Code for Information Interchange character set, a convention for representing alphanumeric information using digital data. The collation sequence used by most computers with the exception of IBM and IBM-compatible computers.

attribute
A piece of information that describes some aspect of a directory entry. An entry comprises a set of attributes, each of which belongs to an object class. Moreover, each attribute has both a type--which describes the kind of information in the attribute--and a value--which contains the actual data.

authentication method
A security method that enables you to have high confidence in the identity of users, clients, and servers in distributed environments. Network authentication methods can also provide the benefit of single sign-on for users. The following authentication methods are supported in Oracle9i, depending on whether or not Oracle Advanced Security is installed:
-CyberSafe
-RADIUS
-Kerberos
-SSL
-Windows NT native authentication

C

cache
Memory that stores recently-accessed data to so that subsequent requests to access the same data can be processed quickly.

Cell Directory Services (CDS)
An external naming method that enables users to use Oracle tools transparently and applications to access Oracle databases in a Distributed Computing Environment (DCE) environment.

central administration
An Oracle Names network where network management consists of one administrative region for the entire network. All Oracle Names servers know about one another and about all the services in the network. Contrast with delegated administration.

client
A user, software application, or computer that requests the services, data, or processing of another application or computer. The client is the user process. In a network environment, the client is the local user process and the server may be local or remote.

client load balancing
Load balancing, whereby if more than one listener services a single database, a client can randomly choose between the listeners for its connect requests. This randomization enables all listeners to share the burden of servicing incoming connect requests.

client profile
The properties of a client, which may include the preferred order of naming methods, client and server logging and tracing, the domain from which to request names, and other client options for Oracle Names and Oracle Advanced Security.

client/server architecture
Software architecture based on a separation of processing between two CPUs. One CPU acts as the client in the transaction, requesting and receiving services. The other acts as the server that provides the requests.

cman.ora file
A configuration file that specifies protocol addresses for incoming requests and administrative commands, as well as Oracle Connection Manager parameters and access control rules.

CMADMIN process
An Oracle Connection Manager administrative process responsible for all administrative functions of Oracle Connection Manager.

CMGW process
An Oracle Connection Manager gateway process that receives client connections and evaluates against a set of rules whether to deny or allow access. If access is allowed, the gateway process forwards the requests to the next hop, typically the database server. In addition to allowing or denying access, the CMGW process can also multiplex or funnel multiple client connections through a single protocol connection.

configuration files
Files that are used to identify and characterize the components of a network. Configuration is largely a process of naming network components and identifying relationships among those components.

connect data
A portion of the connect descriptor that defines the destination database service name or Oracle System Identifier (SID). In the following example, SERVICE_NAME defines a database service called sales.us.acme.com:
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=sales-server)(PORT=1521)
(CONNECT_DATA=
(SERVICE_NAME=sales.us.acme.com)))

connect descriptor
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 Oracle9i or Oracle8i databases or its Oracle System Identifier (SID) for Oracle release 8.0 databases. The network route provides, at a minimum, the location of the listener through use of a network address.

connect identifier
A connect descriptor or a name that maps to a connect descriptor. A connect identifier can be a net service name, database service name, alias, or net service alias. 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 wish to connect:
CONNECT username/password@connect_identifier

connect string
Information the user passes to a service to connect, such as username, password, and connect identifier:
CONNECT username/password@net_service_name

connect-time failover
A client connect request is forwarded to a another listener if a listener is not responding. Connect-time failover is enabled by service registration, because the listener knows if an instance is running to attempting a connection.

connection
An interaction between two processes on a network. Connections are originated by an initiator (client) that requests a connection with a destination (server).

connection load balancing
Load balancing, whereby the number of active connections among various instances and dispatchers for the same service are balanced. This enables listeners to make their routing decisions based on how many connections each dispatcher has and on how loaded the nodes that the instances run.

connection pooling
A resource utilization and user scalability feature that enables you to maximize the number of sessions over a limited number of protocol connections to a shared server.

connection request
A notification sent by an initiator and received by a listener that indicates that the initiator wants to start a connection.

D

database administrator (DBA)
(1) A person responsible for operating and maintaining an Oracle Server or a database application. (2) An Oracle username that has been given DBA privileges and can perform database administration functions. Usually the two meanings coincide. Many sites have multiple DBAs.

Database Configuration Assistant
A tool that enables you to create, delete, and modify a database.

database link
A pointer that defines a one-way communication path from an Oracle database server to another database server. The link pointer is actually defined as an entry in a data dictionary table. To access the link, you must be connected to the local database that contains the data dictionary entry.
A database link connection is one-way in the sense that a client connected to local database A can use a link stored in database A to access information in remote database B, but users connected to database B cannot use the same link to access data in database A. If local users on database B want to access data on database A, then they must define a link that is stored in the data dictionary of database B.
The following database links types are supported:
-A private database link in a specific schema of a database. Only the owner of a private database link can use it.
-A public database link for a database. All users in the database can use it.
-A global database link defined in an Oracle Names server. Anyone in the network can use it.


dedicated server
A server process that is dedicated to one client connection. Contrast with shared server process.

default domain
The domain within which most client requests take place. It could be the domain where the client resides, or it could be a domain from which the client requests network services often. Default domain is also the client configuration parameter that determines what domain should be appended to unqualified network name requests. A name request is unqualified if it does not have a "." character within it.

delegated administration
A network where network management is delegated to one or more administrative regions under the root administrative region. Also referred to as distributed or decentralized administration. Contrast with central administration.

delegated administrative region
A region hierarchically under the root administrative region. Any region other than the root administrative region.

destination
The client that is the endpoint of a connection. The initiator of the connection requires some data or service of the destination.

directory information tree (DIT)
A hierarchical tree-like structure in a directory server of the distinguished names (DNs) of the entries.

directory naming
A naming method that resolves a database service, net service name, or net service alias to a connect descriptor stored in a central directory server. A directory server provides central administration of directory naming objects, reducing the work effort associated with adding or relocating services.

directory server
A directory server that is accessed with the Lightweight Directory Access Protocol (LDAP). Support of LDAP-compliant directory servers provides a centralized vehicle for managing and configuring a distributed Oracle network. The directory server can replace clientside and serverside localized tnsnames.ora files.

dispatcher
A process that enables many clients to connect to the same server without the need for a dedicated server process for each client. A dispatcher handles and directs multiple incoming network session requests to shared server processes.

distinguished name (DN)
Name of entry in a directory server. The DN specifies where the entry resides in the LDAP directory hierarchy, much the way a directory path specifies the exact location of a file.

distributed processing
Division of front-end and back-end processing to different computers. Oracle Network Services support distributed processing by transparently connecting applications to remote databases.

domain
Any tree or subtree within the Domain Name System (DNS) namespace. Domain most commonly refers to a group of computers whose host names share a common suffix, the domain name.

domain hint
A NAMES.DOMAIN_HINTS parameter in the names.ora file that contains the name of the domain and at least one address of an Oracle Names server in that domain. This enables an Oracle Names server to forward the client requests to a specific address, reducing network traffic.

Domain Name System (DNS)
A system for naming computers and network services that is organized into a hierarchy of domains. DNS is used in TCP/IP networks to locate computers through user-friendly names. DNS resolves a friendly name into an IP address, which is understood by computers.
For Oracle Network Services, DNS translates the host name in a TCP/IP address into an IP address.

domestic domains
The set of domains that are managed within a given administrative region. Domains are domestic only in relation to a region; they are never domestic in any absolute sense. Also referred to as local domains.

E

error message
A message from a computer program informing you of a potential problem or condition preventing program or command execution.

enterprise role
An enterprise role is analogous to a regular database role, except that it spans authorization on multiple databases. An enterprise role is a category of roles that define privileges on a particular database. An enterprise role is created the database administrator of a particular database. An enterprise role can be granted to or revoked to one or more enterprise users. The information for granting and revoking these roles is stored in the directory server.

enterprise user
A user that has a unique identity across an enterprise. Enterprise users connect to individual databases through a schema. Enterprise users are assigned enterprise roles that determine their access privileges on databases.

entry
The building block of a directory server, it contains information about an object of interest to directory users.

external naming
A naming method that uses a third-party naming service, such as NIS or CDS.

external procedure
Function or procedure written in a third-generation language (3GL) that can be called from PL/SQL code. Only C is supported for external procedures.

F

flat naming model
An Oracle Names infrastructure in which there is only one domain. All names must be unique within that domain.

foreign domains
The set of domains not managed within a given administrative region. Domains are foreign only in relation to a region; they are not foreign in any absolute sense. A network administrator typically defines foreign domains relative to a particular region to optimize Names Server caching performance.

FTP protocol
File Transfer Protocol. A client/server protocol which allows a user on one computer to transfer files to and from another computer over a TCP/IP network.

G

global database link
A database link that is centrally stored in an Oracle Names server. A global database link that is the same as the global database name is automatically registered with an Oracle Names server. You can use a global database link to access an object in the database. For example, if the global database name is sales.us.acme.com, a global database link of sales.us.acme.com is created and registered with an Oracle Names server. You can then use sales.us.acme.com to perform a SELECT statement on a table, for example:
SQL> SELECT * FROM emp@sales.us.acme.com

global database name
The full name of the database which uniquely identifies it from any other database. The global database name is of the form "database_name.database_domain," for example, sales.us.acme.com.
The database name portion, sales, is a simple name you wish to call your database. The database domain portion, us.acme.com, specifies the database domain in which the database is located, making the global database name unique. When possible, Oracle Corporation recommends that your database domain mirror the network domain.
The global database name is the default service name of the database, as specified by the SERVICE_NAMES parameter in the initialization parameter file.

H

Heterogeneous Services
An integrated component that provides the generic technology for accessing non-Oracle systems from the Oracle database server. Heterogeneous Services enables you to:
- Use Oracle SQL to transparently access data stored in non-Oracle systems as if the data resides within an Oracle server.
- Use Oracle procedure calls to transparently access non-Oracle systems, services, or application programming interfaces (APIs), from your Oracle distributed environment.

hierarchical naming model
An infrastructure in which names are divided into multiple hierarchically-related domains. For Oracle Names, hierarchical naming model can be used with either central or delegated administration.

host naming
A naming method resolution that enables users in a TCP/IP environment to resolve names through their existing name resolution service. This name resolution service might be Domain Name System (DNS), Network Information Service (NIS), or simply a centrally-maintained set of /etc/hosts files. Host Naming enables users to connect to an Oracle database server by simply providing the server computer's host name or host name alias. No client configuration is required to take advantage of this feature. This method is recommended for simple TCP/IP environments.

HTTP protocol
Hypertext Transfer Protocol. A protocol that provides the language that enables Web browsers and application Web servers to communicate.

I

initialization parameter file
File that contains information to initialize the database and instances.

instance
The combination of the System Global Area (SGA) and the Oracle background processes. When a database is started on a database server (regardless of the type of computer), Oracle allocates a memory area called the SGA and starts one or more Oracle processes. The memory and processes of an instance efficiently manage the associated database's data and serve the database users. You can connect to any instance to access information within a cluster database.

instance name
A name of an Oracle database instance. The instance name is identified by the INSTANCE_NAME parameter in the database initialization parameter file. INSTANCE_NAME corresponds to the Oracle System Identifier (SID) of the instance. Clients can connect to a specific instance by specifying the INSTANCE_NAME parameter in the connect descriptor.
The instance name is included in the connect data part of the connect descriptor.

Interprocess Communication
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.

IP address
Used to identify a node on a network. Each computer on the network is assigned a unique IP address, which is made up of the network ID, and a unique host ID. This address is typically represented in dotted-decimal notation, with the decimal value of each octet separated by a period, for example 144.45.9.22.

J

Java Database Connectivity (JDBC) Driver
A driver that provides Java applications and applets access to an Oracle database.

JDBC OCI Driver
A Type II driver for use with client/server Java applications. This driver requires an Oracle client installation.

JDBC Thin Driver
A Type IV driver for Oracle JDBC applets and applications. Because it is written entirely in Java, this driver is platform-independent. It does not require any additional Oracle software on the client side. The Thin driver communicates with the server using Two-Task Common (TTC), a protocol developed by Oracle to access the database server.

K

keyword-value pair
The combination of a keyword and a value, used as the standard unit of information in connect descriptors and many configuration files. Keyword-value pairs may be nested; that is, a keyword may have another keyword-value pair as its value.

L

latency
Networking round-trip time.

Lightweight Directory Access Protocol (LDAP)
A standard, extensible directory access protocol. It is a common language that LDAP clients and servers use to communicate. The framework of design conventions supporting industry-standard directory servers.

LDAP Data Interchange Format (LDIF)
The set of standards for formatting an input file for any of the LDAP command line utilities.

ldap.ora file
A file created by Oracle Net Configuration Assistant that contains the following directory server access information:
- Type of directory server
- Location of the directory server
- Default directory entry that the client or server will use to look up or configure connect identifiers for connections to database services
The ldap.ora file resides in $ORACLE_HOME/network/admin on UNIX and ORACLE_HOME\network\admin on Windows operating systems.

link qualifier
A qualifier appended to a global database link to provide alternate settings for the database username and password credentials. For example, a link qualifier of fieldrep can be appended to a global database link of sales.us.acme.com.
SQL> SELECT * FROM emp@sales.us.acme.com@fieldrep

listener
A process that resides on the server 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.

listener.ora file
A configuration file for the listener that identifies the following for a listener:
Unique name
Protocol addresses that it is accepting connection requests on
Services it is listening for
The listener.ora file typically resides in $ORACLE_HOME/network/admin on UNIX platforms and ORACLE_HOME\network\admin on Windows NT.
Oracle9i does not require identification of the database service because of service registration. However, static service configuration is required for if you plan to use Oracle Enterprise Manager.

Listener Control utility
A utility included with Oracle Network Services to control various listener functions, such as to starting, stopping, and getting the status of the listener.

load balancing
A feature by which client connections are distributed evenly among multiple listeners, dispatchers, instances, and nodes so that no single component is overloaded.
Oracle Network Services support client load balancing and connection load balancing.

local naming
A naming method that locates network addresses by using information configured and stored on each individual client's tnsnames.ora file. Local naming is most appropriate for simple distributed networks with a small number of services that change infrequently.

location transparency
A distributed database characteristic that enables applications to access data tables without knowing where they reside. All data tables appear to be in a single database, and the system determines the actual data location based on the table name. The user can reference data on multiple nodes in a single statement, and the system automatically and transparently routes (parts of) SQL statements to remote nodes for execution if needed. The data can move among nodes with no impact on the user or application.

logging
A feature in which errors, service activity, and statistics are written to a log file. The log file provides additional information for an administrator when the error message on the screen is inadequate to understand the failure. The log file, by way of the error stack, shows the state of the software at various layers.

loopback test
A connection from the server back to itself. Performing a successful loopback verifies that Oracle Net is functioning on the database server.

M

map
Files used by the Network Information Service (NIS) ypserv program to handle name requests.

Microsoft Active Directory
An LDAP-compliant directory server included with the Windows 2000 Server. It stores information about objects on the network, and makes this information available to users and network administrators. Active Directory also provides access to resources on the network using a single logon process.
Active Directory can be configured as a directory naming method to store service information that clients can access.

N

names.ora file
A configuration file that contains parameter settings for an Oracle Names server.

Named Pipes protocol
A high-level interface protocol providing interprocess communications between clients and servers using distributed applications. Named Pipes enables client/server conversation over a network using Named Pipes.

naming context
A subtree that resides entirely on one directory server. It is a contiguous subtree, that is, it must begin at an entry that serves as the top of the subtree, and extend downward to either leaf entries or references to subordinate naming contexts. It can range in size from a single entry to the entire directory information tree (DIT).
An Oracle Context can be created under a naming context.

naming method
The resolution method used by a client application to resolve a connect identifier to a connect descriptor when attempting to connect to a database service. Oracle Net provides five naming methods:
- local naming
- directory naming
- Oracle Names
- host naming
- external naming

naming model
The set and structure of domains within which names can be allocated.
In a flat naming model, there is a single domain.
In a hierarchical naming model, the highest level is the root domain, and all other domains are hierarchically related.

net service alias
An alternative name for a directory naming object in a directory server. A directory server stores net service aliases for any defined net service name or database service. A net service alias entry does not have connect descriptor information. Instead, it only references the location of the object for which it is an alias. When a client requests a directory lookup of a net service alias, the directory determines that the entry is a net service alias and completes the lookup as if it was actually the entry it is referencing.

net service name
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 wish to connect:
CONNECT username/password@net_service_name
Depending on your needs, net service names can be stored in a variety of places, including:
Local configuration file, tnsnames.ora, on each client
Directory server
Oracle Names server
External naming service, such as NIS or CDS

network
A group of two or more computers linked together through hardware and software to allow the sharing of data and peripherals.

network administrator
The person who performs network management tasks such as installing, configuring, and testing network components. The administrator typically maintains the configuration files, connect descriptors and service names, aliases, and public and global database links.

network character set
As defined by Oracle, the set of characters acceptable for use as values in keyword-value pairs (that is, in connect descriptors and configuration files). The set includes alphanumeric upper- and lowercase, and some special characters.

Network Information Service (NIS)
Sun Microsystems' Yellow Pages (yp) client/server protocol for distributing system configuration data such as user and host names between computers on a network.

Network Interface (NI)
A network layer that provides a generic interface for Oracle clients, servers, or external processes to access Oracle Net functions. The NI layer handles the "break" and "reset" requests for a connection.

network object
Any service that can be directly addressed on a network; for example, a listener or a Oracle Names server.

Network Program Interface (NPI)
An interface for server-to-server interactions that performs all of the functions that the OCI does for clients, allowing a coordinating server to construct SQL requests for additional servers.

Network Session (NS)
A session layer that is used in typical Oracle Net connections to establish and maintain the connection between a client application and a database server.

node
A computer or terminal that is part of a network

O

object class
In a directory server, a named group of attributes. When you want to assign attributes to an entry, you do so by assigning to that entry the object classes that hold those attributes.
All objects associated with the same object class share the attributes of that object class.

Open Systems Interconnection (OSI)
A model of network architecture developed by ISO as a framework for international standards in heterogeneous computer network architecture.
The OSI architecture is split between seven layers, from lowest to highest:
1. Physical layer
2. Data link layer
3. Network layer
4. Transport layer
5. Session layer
6. Presentation layer
7. Application layer
Each layer uses the layer immediately following it and provides a service to the layer preceding.

Oracle Advanced Security
A product that provides a comprehensive suite of security features to protect enterprise networks and securely extend corporate networks to the Internet. Oracle Advanced Security provides a single source of integration with network encryption and authentication solutions, single sign-on services, and security protocols. By integrating industry standards, it delivers unparalleled security to the network.

Oracle Call Interface (OCI)
An application programming interface (API) that enables you to create applications that use the native procedures or function calls of a third-generation language to access an Oracle database server and control all phases of SQL statement execution. OCI supports the datatypes, calling conventions, syntax, and semantics of a number of third-generation languages including C, C++, COBOL and FORTRAN.

Oracle Connection Manager
A router through which a client connection request may be sent either to its next hop or directly to the database server. Clients who route their connection requests through an Oracle Connection Manager can then take advantage of the session multiplexing, access control, or protocol conversion features configured on that Oracle Connection Manager.

Oracle Connection Manager Control utility
A utility included with Oracle Network Services to control various functions, such as starting, stopping, and getting the status of the Oracle Connection Manager.

Oracle Context
A RDN of cn=OracleContext in a directory information tree (DIT) that is located under a naming context or an unpublished directory entry. An Oracle Context contains entries for use with Oracle features, such as Oracle Net directory naming and Oracle Advanced Security enterprise user security. There can be one or more Oracle Contexts in a directory server. Oracle Internet Directory automatically creates an Oracle Context at the root of the DIT structure. This root Oracle Context has a DN of dn:cn=OracleContext.

Oracle Internet Directory
A directory server implemented as an application on the Oracle database. It enables retrieval of information about dispersed users and network resources. It combines Lightweight Directory Access Protocol (LDAP) Version 3, the open Internet standard directory server access protocol, with the high performance, scalability, robustness, and availability of the Oracle database.

Oracle Names
An Oracle directory service made up of a system of Oracle Names servers that provide name-to-address resolution for each service on the network.

Oracle Names Control utility
A utility included with Oracle Names to control various functions for Oracle Names servers, such as starting, stopping, and getting the status of an Oracle Names server.

Oracle Names LDAP Proxy server
Oracle Names servers that have been configured to proxy for directory servers. Upon startup, Oracle Names LDAP Proxy servers obtain network object information from a directory server. This provides a single point of definition for all data in a directory server and does not require that both Oracle Names servers and directory servers be maintained separately and simultaneously.

Oracle Names server
A computer that uses Oracle Names software to store network address information for a service along with its simple name so that client applications can request connections with simple names rather than lengthy addresses.

Oracle Net
Communication software that enables a network session from a client application to an Oracle database server. Once a network session is established, Oracle Net acts as a data courier for the client application and the database server. It is responsible for establishing and maintaining the connection between the client application and database server, as well as exchanging messages between them. Oracle Net is able to perform these jobs because it is located on each computer in the network.

Oracle Net Configuration Assistant
A post-installation tool that configures basic network components after installation, including:
- Listener names and protocol addresses
- Naming methods the client will use to resolve connect identifiers
- Net service names in a tnsnames.ora file
- Directory server usage

Oracle Net Firewall Proxy
Product offered by some firewall vendors that supplies Oracle Connection Manager functionality.

Oracle Net foundation layer
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.

Oracle Net Manager
A graphical user interface tool that combines configuration abilities with component control to provide an integrated environment for configuring and managing Oracle Net Services.
You can use Oracle Net Manager to configure the following network components:
Naming
Define connect identifiers and map them to connect descriptors to identify the network location and identification of a service. Oracle Net Manager supports configuration of connect descriptors in a local tnsnames.ora file, centralized LDAP-compliant directory server, or an Oracle Names server.
Naming Methods
Configure the different ways in which connect identifiers are resolved into connect descriptors.
Listeners
Create and configure listeners to receive client connections.

Oracle Net Services
A suite of networking components that provide enterprise-wide connectivity solutions in distributed, heterogeneous computing environments. Oracle Net Services is comprised of Oracle Net, listener, Oracle Connection Manager, Oracle Net Configuration Assistant, and Oracle Net Manager.

Oracle Program Interface (OPI)
A networking layer responsible for responding to each of the possible messages sent by OCI. For example, an OCI request to fetch 25 rows would have an OPI response to return the 25 rows once they have been fetched.

Oracle protocol support
A software layer responsible for mapping Transparent Network Substrate (TNS) functionality to industry-standard protocols used in the client/server connection.

Oracle Rdb
A database for Digital's 64-bit platforms. Because Oracle Rdb has its own listener, the client interacts with Rdb in the same manner as it does with an Oracle database.

Oracle schema
A set of rules that determine what can be stored in a 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.

Oracle System Identifier (SID)
A name that identifies a specific instance of a running pre-release 8.1 Oracle database. For any database, there is at least one instance referencing the database.
For pre-release 8.1 databases, SID is used to identify the database. The SID is included in the connect descriptor of a tnsnames.ora file and in the definition of the listener in the listener.ora file.

Oracle XML DB
A high-performance XML storage and retrieval technology provided with Oracle database server. It is based on the W3C XML data model.

Oracle9i Real Application Clusters
An architecture that allows multiple instances to access a shared database of datafiles. Real Application Clusters is also a software component that provides the necessary cluster database scripts, initialization files, and datafiles needed for the Oracle Enterprise Edition and Real Application Clusters.

Oracle9i Real Application Clusters Guard
A failover protection feature. Oracle Real Application Clusters Guard is an integral component of Real Application Clusters. Oracle Real Application Clusters Guard provides the following functions:
- Automated, fast recovery and bounded recovery time from failures that fail the Oracle instance
- Automatic capture of diagnostic data when certain types of failures occur
- Enforced primary/secondary configuration. Clients connecting through Oracle Net Services are properly routed to the primary node even if connected to another node in the cluster
- Elimination of delays that clients experience when reestablishing connections after a failure

ORACLE_HOME
An alternate name for the top directory in the Oracle directory hierarchy on some directory-based operating systems.

P

packet
A block of information sent over the network each time a connection or data transfer is requested. The information contained in packets depends on the type of packet: connect, accept, redirect, data, and so on. Packet information can be useful in troubleshooting.

PMON process
A process monitor database process that performs process recovery when a user process fails. PMON is responsible for cleaning up the cache and freeing resources that the process was using. PMON also checks on dispatcher and server processes and restarts them if they have failed. As a part of service registration, PMON registers instance information with the listener.

preferred Oracle Names server
The Oracle Names servers preferred by a client for names resolution; usually the Oracle Names Server that is physically closest to the client, or available over the least expensive network link.

presentation layer
A networking communication layer that manages the representation of information that application layer entities either communicate or reference in their communication. Two-Task Common (TTC) is an example of presentation layer.

private database link
A database link created by one user for his or her exclusive use.

profile
A collection of parameters that specifies preferences for enabling and configuring Oracle Net Services' features on the client or server. A profile is stored and implemented through the sqlnet.ora file.

protocol
A set of rules that defines how data is transported across the network.

protocol address
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, Oracle Connection Manager, or Oracle Names server, 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 to configure the same addresses.

protocol conversion
A feature of Oracle Connection Manager that enables a client and server with different networking protocols to communicate with each other. This feature replaces functionality previously provided by the Oracle Multi-Protocol Interchange with SQL*Net version 2.

protocol stack
Designates a particular presentation layer and session layer combination.

proxy server
A server that substitutes for the real server, forwarding client connection requests to the real server or to other proxy servers. Proxy servers provide access control, data and system security, monitoring, and caching.

public database link
A database link created by a DBA on a local database that is accessible to all users on that database.

R

relative distinguished name (RDN)
The local, most granular level entry name. It has no other qualifying entry names that would serve to address the entry uniquely. In the example, cn=sales,dc=us,dc=acme,dc=com, cn=sales is the RDN.

region database
Tables in an Oracle database that store Oracle Names information.

root administrative region
The highest level administrative region in a distributed installation. The root administrative region contains the root domain.

root domain
The highest level domain in a hierarchical naming model.

RPC
Remote Procedure Call

S

Secure Sockets Layer (SSL)
An industry standard protocol designed by Netscape Communications Corporation for securing network connections. SSL provides authentication, encryption, and data integrity using public key infrastructure (PKI).

server process
Database processes that handle a client request on behalf of a database.

service
Work done for others. The database is a service that stores and retrieves data for clients.

service handler
A process that acts a connection point from the listener to the database server. A service handler can be a dispatcher or dedicated server.

service name
A logical representation of a database, which is the way a database is presented to clients. A database can be presented as multiple services and a service can be implemented as multiple database instances. The service name is a string that is the global database name, that is, a name comprised of the database name and domain name, entered during installation or database creation. If you are not sure what the global database name is, you can obtain it from the value of the SERVICE_NAMES parameter in the initialization parameter file.
The service name is included in the connect data part of the connect descriptor.

service registration
A feature by which the PMON 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 information about:
- Service names for each running instance of the database
- Instance names of the database
- Service handlers (dispatchers and dedicated servers) available for each instance
These enable the listener to direct a client request appropriately.
Dispatcher, instance, and node load information
This load information enables the listener to determine which dispatcher can best handle a client connection request. If all dispatchers are blocked, the listener can spawn a dedicated server for the connection.

service replication
A process that fully replicates a directory system on the network. New services need to register with only one Oracle Names server. The service replication process automatically distributes the new registration to all other active Oracle Names servers on the network.

session data unit (SDU)
A buffer that Oracle Net uses to place data before transmitting it across the network. Oracle Net sends the data in the buffer either when requested or when it is full.

session layer
A network layer that provides the services needed by the protocol address entities that enable them to organize and synchronize their dialogue and manage their data exchange. This layer establishes, manages, and terminates network sessions between the client and server. An example of a session layer is Network Session (NS).

session multiplexing
Combining multiple sessions for transmission over a single network connection in order to conserve the operating system's resources.

shared server
A database server that is configured to allow many user processes to share very few server processes, so the number of users that can be supported is increased. With shared server configuration, many user processes connect to a dispatcher. The dispatcher directs multiple incoming network session requests to a common queue. An idle shared server process from a shared pool of server processes picks up a request from the queue. This means that a small pool of server processes can serve a large number of clients. Contrast with dedicated server.

shared server process
A process type used with shared server configuration.

SID_LIST_listener_name
A section of the listener.ora file that defines the Oracle System Identifier (SID) of the database served by the listener. This section is valid only for version 8.0 Oracle databases, as Oracle9i and Oracle8i instance information is automatically registered with the listener. Static configuration is also required for other services, such as external procedure calls and Heterogeneous Services, and some management tools, including Oracle Enterprise Manager.

single sign-on
The ability for a user to log in to different servers using a single password. This permits the user to authenticate to all servers the user is authorized to access.

sqlnet.ora file
A configuration file for the client or server that specifies:
Client domain to append to unqualified service names or net service names
Order of naming methods the client should use when resolving a name
Logging and tracing features to use
Route of connections
Preferred Oracle Names servers
External naming parameters
Oracle Advanced Security parameters
The sqlnet.ora file typically resides in $ORACLE_HOME/network/admin on UNIX platforms and ORACLE_HOME\network\admin on Windows operating systems.

System Global Area (SGA)
A group of shared memory structures that contain data and control information for an Oracle instance.

system or topology data
Data used by the Oracle Names server to control regular functioning or communicate with other Oracle Names servers. Includes interchanges, Oracle Names servers in a root region, and Oracle Names servers in any delegated region.

T

TCP/IP protocol
Transmission Control Protocol/Internet Protocol. The de facto standard communication protocol used for client/server conversation over a network.

TCP/IP with SSL protocol
A protocol that enables an Oracle application on a client to communicate with remote Oracle databases through the TCP/IP protocol and Secure Sockets Layer (SSL).

tick
The amount of time it takes for a message to be sent and processed from the client to the server or from the server to the client

Thin JDBC Driver
Thin JDBC driver is Oracle's Type 4 driver designed for Java applet and Java application developers. The JDBC driver establishes a direct connection to the Oracle database server over Java sockets. Access to the database is assisted with a lightweight implementation of Oracle Net and Two-Task Common (TTC).

tnsnames.ora file
A configuration file that contains one or more domains mapped to connect descriptors. This file is used for the local naming method. The tnsnames.ora file typically resides in $ORACLE_HOME/network/admin on UNIX platforms and ORACLE_HOME\network\admin.

tracing
A facility that writes detailed information about an operation to an output file. The trace facility produces a detailed sequence of statements that describe the events of an operation as they are executed. Administrators use the trace facility for diagnosing an abnormal condition; it is not normally turned on.

Transparent Application Failover (TAF)
A runtime failover for high-availability environments, such as Oracle9i Real Application Clusters and Oracle Fail Safe, that refers to the failover and re-establishment of application-to-service connections. It enables client applications to automatically reconnect to the database if the connection fails, and, optionally, resume a SELECT statement that was in progress. This reconnect happens automatically from within the Oracle Call Interface (OCI) library.

Transparent Network Substrate (TNS)
A foundation technology, built into the Oracle Net foundation layer that works with any standard network transport protocol.

transport
A networking layer that maintains end-to-end reliability through data flow control and error recovery methods. The Oracle Net foundation layer uses Oracle protocol support for the transport layer.

Two-Task Common (TTC)
A presentation layer type that is used in a typical Oracle Net connection to provide character set and data type conversion between different character sets or formats on the client and server.

V

virtual circuit
A piece of shared memory used by the dispatcher for client database connection requests and replies. The dispatcher places a virtual circuit on a common queue when a request arrives. An idle shared server picks up the virtual circuit from the common queue, services the request, and relinquishes the virtual circuit before attempting to retrieve another virtual circuit from the common queue.

W

WebDAV protocol
World Wide Web Distributed Authoring and Versioning. A protocol with a set of extensions to the HTTP protocol which allows users to manage files on remote Web servers.

well-known Oracle Names server
Addresses for one or more Oracle Names servers hard coded into both the Oracle Names server and its clients. Oracle Names servers then become available at these well known addresses, so that clients do not need to be told, by way of configuration files, where to find the server.

Windows NT native authentication
An authentication method that enables a client single login access to a Windows NT server and a database running on the server.

No comments:

Post a Comment