Index

A B C D E F G H I J L M N O P Q R S T U V W Y

Numerics

1521 port, 10.3.1

if not using, 10.4.2

A

absolute naming

Java Database Connectivity (JDBC)

OCI drivers, 4.3.6, 15.1.2.2

Thin drivers, 15.1.2.2

with directory naming, 4.3.6.2

access control lists (ACLs)

described, 4.3.7.2.2

access control to database

with Oracle Connection Manager, 1.2.5.1, 11.3.2

with sqlnet.ora parameters, 9.4

ACTION_LIST networking parameter, 11.2.1.2, 11.2.1.3

ADAPTERS utility, 16.1.2

Address List Options dialog box, 13.1.2

ADDRESS networking parameter, 11.2.1.1

application layer, 5.1.1

application Web servers, 1.2.1.2

architecture

listener, 5.2

Oracle Connection Manager, 5.4

Oracle Net Services stack communication layers, 5.1

attributes

defined, 4.3.2

audit trail

described, 16.6.6.1

script for using information, 16.6.6.1

auto-starting listeners, 10.5.1

B

BACKUP networking parameter, 13.3.4

Bequeath protocol, 3.4.2

BEQUEATH_DETACH networking parameter, 9.5

buffer flushing, described, 7.4.3

C

CDS. See Cell Directory Service (CDS)

Cell Directory Services (CDS) external naming, 3.5, 9.3.2

configuring, 8.6

Cell Name field in Oracle Net Manager, 9.6

centralized naming, 4.1

establishing a connection with, 4.1

CHANGE_PASSWORD command, 10.3.5

Check TCP/IP client access rights option in Oracle Net Manager, 9.4

client configuration

connect-time failover, 3.3.1

default domains, 9.3.1

load balancing requests among listeners, 3.3.3, 13.1.2

local naming, 8.3.2.3

log files, 16.6.3.1

net service names, 2.4

Oracle Connection Manager address, 11.2.2

Oracle Rdb connections, 13.5.3

shared server, 12.5

sqlnet.log file, 16.6.3.1

trace files, 16.7.2.1

Transparent Application Failover (TAF), 3.3.2

client connections

methods, 15.1.3

syntax, 15.1.2.1

client load balancing

configuring, 13.1.2

described, 3.3.3

Client Registration ID field in Oracle Net Manager, 9.5

client testing

connectivity, 15.2.4

from 3GL, 15.1.3.3

from applications, 15.1.3.2

from Oracle Net Manager, 15.2.4.3

from SQL, 15.1.3.4

from the operating system, 15.1.3.1

client troubleshooting, 16.1.2

Clients allowed to access field in Oracle Net Manager, 9.4

Clients excluded from access field in Oracle Net Manager, 9.4

CMADMIN (Connection Manager Administration), 5.4, 5.4, 11.2.3.1

CMAN DISPATCHERS parameter

see also DISPATCHERS parameter, 11.2.3.2

cman.ora file

parameters

ACTION_LIST, 11.2.1.2, 11.2.1.3

ADDRESS, 11.2.1.1

EVENT_GROUP, 16.6.3.3

LOG_DIRECTORY, 16.6.3.3

LOG_LEVEL, 16.6.3.3

PARAMETER_LIST, 11.2.1.3

RULE_LIST, 11.2.1.2, 11.3.2

TRACE_DIRECTORY, 16.7.2.3

TRACE_FILELEN, 16.7.2.3

TRACE_FILENO, 16.7.2.3

TRACE_LEVEL, 16.7.2.3

TRACE_TIMESTAMP, 16.7.2.3

setting up, 11.2.1, 11.2.1.1

CMGW (Connection Manager Gateway), 5.4, 5.4, 5.4

configuring

access control, 9.4, 11.3.2

clients

client load balancing, 13.1.2

connect-time failover, 3.3.1, 13.1.2, 13.1.2

default domains, 9.3.1

local naming, 8.3.2.3

naming methods in profile, 9.3.2

net service names, 2.4

session data unit (SDU), 14.1

Transparent Application Failover (TAF), 3.3.2

connection load balancing, 13.2

connection pooling, 12.2

connection requests in a profile, 9.3.3

connect-request timeouts, 14.4

database servers

access control, 9.4

connect-request timeouts, 14.4

session data unit (SDU), 14.1, 14.3, 14.3

shared server, 12.1

directory naming, 8.4

easy connect naming, 8.5

external naming, 8.6

external procedure connections, 13.5.1

Heterogeneous Services connections, 13.5.2, 13.5.2

instance role, 13.4

listeners, 10

connect-request timeouts, 14.4

directory naming, 8.4.1.4

external procedures, 13.5.1.2

host naming, 8.5

local naming, 8.3.2.4

Oracle JServer, 10.3.2

queue size, 10.3.3

service information, 10.3.4

session data unit (SDU), 14.1

local naming, 8.3

localized management, 4.1

multiple protocol addresses, 13.1.1

naming methods, 8

net service aliases, 8.4.1.2

net service names

directory naming, 8.4.1.2

external naming, 8.6

local naming, 8.3.2.1

network domain, default, 9.3.1

Oracle Advanced Security, 9.7

Oracle Rdb database connections, 13.5.3

primary and secondary instances, 13.4

protocol addresses, 10.3.1

quick reference, 6.3

SDP protocol, 14.3

servers

connect-request timeouts, 14.4

session data unit (SDU), 14.1, 14.3, 14.3

shared server, 12.1

service registration, 11.2.3.1

session data unit (SDU), 14.1

session data unit (SDU) size, 13.1.3

session multiplexing, 11.3.1

connect identifiers, 15.1.2.1

connect strings, 15.1

connection load balancing, 13.2

configuring

dedicated server, 13.2.2

shared server, 13.2.1

described, 3.3.4

service registration, 10.1

connection pooling

advantages relative to session multiplexing, 7.1.1.3

configuring, 12.2

defined, 1.2.3.2

using with shared server, 12.2

Connection Time Out field in Oracle Net Manager, 9.5

connections, 3.2, 3.2

adjusting listener queue size to avoid errors, 7.1.6.1, 7.4.1, 10.3.3

bequeath, 3.4.2

concurrent, increasing number of, 10.3.3

connect strings, entering, 15.1, 15.1.2

dedicated servers, 9.3.3

directory naming, 8.4.1.5

external procedures, 13.5.1

Heterogeneous Services, 13.5.2

host naming, 8.5

local naming, 8.3.2.5

methods, 15.1.3

Network Information Service (NIS) external naming, 8.6.1

Network Information Service external naming, 8.6.1

Oracle Connection Manager, 9.3.3

Oracle Rdb databases, 13.5.3

startup of components, 15.1.1

CONNECTIONS (CON or CONN) attribute, 12.1, 12.2

connect-time failover

and GLOBAL_DNAME parameter, 10.3.4

configuring, 13.1.2

service registration, 10.1

D

data link layer, 5.1.1

data transfer, maximizing, 7.4.2

Database Configuration Assistant

directory naming, 4.3.5

shared server configuration, 12.1

database server configuration

access control, 9.4

allocating resources with shared server, 12.4

connect-request timeouts, 14.4

local naming, 8.3.2.1

log files, 16.6.3.1

loopback tests, 16.1.1.2

shared server, 12.1

starting the database, 2.3, 15.1.1.2

trace files, 16.7.2.1

database server connections

methods, 15.1.3

syntax, 15.1.2.1

database server testing, 15.2.3

dead connection timeout. See terminated connection timeout, 9.5

dedicated servers

bequeathed sessions, 3.4.2

connect descriptor configuration, 3.2, 3.2

defined, 1.2.3.1

described, 3.4.2

difference with shared server, 1.2.3.1

routing connections, 9.3.3

denial-of-service attacks, 14.4

DESCRIPTION parameter, 8.3

diagnosing. See troubleshooting

direct hand-off

described, 3.4.1

events in listener.log, 16.6.6.3

directory configuration

adding users to the OracleNetAdmins group, 8.4.2

exporting

net service names from a tnsnames.ora file, 8.4.3.1

migrating

net service names from a tnsnames.ora file, 8.4.3.1

directory information tree (DIT), defined, 4.3.2

directory naming, 16.2.1

absolute naming, 4.3.6.2

advantages and disadvantages, 7.3

architecture, 4.3.2

authentication methods

native, 4.3.7.2.1

simple, 4.3.7.2.1

SSL, 4.3.7.2.1

strong, 4.3.7.2.1

configuring, 8.4

connecting to database services, 4.3.6

connecting with, 8.4.1.5

connections

using an entry's absolute name, 4.3.6.2

using an entry's relative name, 4.3.6.1

Database Configuration Assistant, 4.3.5

establishing a connection with, 8.4.1.5

exporting

net service names from a tnsnames.ora file, 8.4.3.1

Java Database Connectivity (JDBC)

OCI drivers, 4.3.6, 15.1.2.2

Thin drivers, 4.3.6, 15.1.2.2

Java Database Connectivity (JDBC) Thin drivers, 4.3.1, 4.3.6.2

ldapwrite tool, 16.2.1

listener configuration for, 8.4.1.4

migrating

net service names from a tnsnames.ora file, 8.4.3.1

object classes, 4.3.7.3

objects

database services, 4.3.2

net service aliases, 4.3.3

net service names, 4.3.2

Oracle Context, 4.3.2

Oracle Net Manager, 4.3.5

Oracle schema, 4.3.7.3

OracleContextAdmins group, 4.3.5, 4.3.7.2.2

OracleDBCreators group, 4.3.5, 4.3.7.2.2

OracleNetAdmins group, 4.3.7.2.2, 8.4.1.2, 8.4.1.2, 8.4.1.2, 8.4.2

overview, 4.3

recommended for, 7.3

security, 4.3.7.2

troubleshooting, 16.2.1

with relative naming, 4.3.6.1

Directory Server Migration Wizard, 6.1.2, 8.4.3.1

directory servers

attributes, 4.3.2

directory information tree (DIT), 4.3.2

distinguished name (DN), 4.3.2

entry, 4.3.2

ldapwrite tool, 16.2.1

Microsoft Active Directory, 4.3.8

Oracle Context, 4.3.2

overview, 1.2.2.2

performance, 4.3.7.1

relative distinguished name (RDN), 4.3.2

security, 4.3.7.2

Directory Usage configuration option in Oracle Net Configuration Assistant, 6.1.4

Disable Out-of-Band Break option in Oracle Net Manager, 9.5

DISABLE_OOB networking parameter, 9.5

dispatchers, 1.2.3.1, 5.3.1

described, 1.2.3.1, 3.4.1, 5.3.1

DISPATCHERS (DIS or DISP) attribute, 12.1

DISPATCHERS initialization parameter, 12.1

configuring connection pooling, 12.2

CONNECTIONS attribute, 12.1, 12.2

DISPATCHERS attribute, 12.1

LISTENER attribute, 10.4.3, 10.4.4, 12.1

MULTIPLEX attribute, 12.1

POOL attribute, 12.1

SERVICE attribute, 12.1

SESSIONS attribute, 12.1, 12.2

TICKS attribute, 12.1, 12.2

DISPATCHERS parameter

MULTIPLEX attribute, 11.3.1

PROTOCOL attribute, 11.3.1

distinguished name (DN), defined, 4.3.2

duties of a network administrator, 6.3

E

easy connect naming

advantages and disadvantages, 7.3

configuring, 8.5

recommended for, 7.3

entry, defined, 4.3.2

Environment field in Oracle Net Manager, 13.5.1.2

ENVS networking parameter, 13.5.1.2

error messages

contacting Oracle Support Services, 16.8

in trace file, 16.7.4.3

ORA-1017, 16.1.1.1

ORA-1034, 16.1.1.1

ORA-12154, 16.2

ORA-12170, 14.4, 16.2

ORA-12203

sample error stack, 16.6.1.1

ORA-12514, 16.2

ORA-12520, 16.2

ORA-12521, 16.2

ORA-12525, 14.4, 16.2

ORA-12526, 5.2

ORA-12527, 5.2

ORA-12528, 5.2

ORA-12533, 16.2

ORA-12535, 9.5

ORA-12547, 14.4

ORA-12608, 9.5, 9.5

ORA-12637, 14.4

resolving, 16

using log file to track, 16.6.5

error stack

described, 16.6.1

entries in log files, 16.6.5

sample, 16.6.1.1

typical layers in, 16.6.1

EVENT_GROUP networking parameter, 16.6.3.3

exporting

net service names from a tnsnames.ora file to a directory, 8.4.3.1

external naming

advantages and disadvantages, 7.3

Cell Directory Services (CDS), 3.5, 8.6, 9.3.2

configuring, 8.6

Network Information Service (NIS), 3.5, 8.6, 9.3.2

recommended for, 7.3

external procedures

configuring connections to, 13.5.1

described, 13.5.1, 13.5.1

extproc agent, 13.5.1

EXTPROC_DLLS environment variable, 13.5.1.2

F

failover

connect-time, 3.3.1, 13.1.2

Transparent Application Failover (TAF), 3.3.2, 13.3

FAILOVER networking parameter, 13.1.2, 13.2.1, 13.2.2

FAILOVER_MODE networking parameter, 13.3, 13.3.4

FTP presentation, 5.1.3

dedicated server configuration, 5.3.2

shared server configuration, 5.3.1

FTP protocol, 1.2.1.3

G

global database name

configuring on the listener, 10.4.1

defined, 8.2

described, 10.4.1

Global Database Name field in Oracle Net Manager, 10.3.4, 13.1.3, 13.5.3

GLOBAL_DBNAME networking parameter, 10.3.4

GLOBAL_NAME networking parameter, 13.1.3, 13.5.3

H

Heterogeneous Services

configuring connections to, 13.5.2

described, 13.5.2

host naming

connecting with, 8.5

establishing a connection with, 8.5

listener configuration for, 8.5

requirements, 8.5

HS networking parameter, 13.1.3

HTTP presentation, 5.1.3

dedicated server configuration, 5.3.2

shared server configuration, 5.3.1

HTTP protocol, 1.2.1.2

I

INBOUND_CONNECT_TIMEPUT_listener_name networking parameter, 14.4

initialization parameter file

DISPATCHERS parameter, 12.1

INSTANCE_NAME parameter, 3.1.2

LOCAL_LISTENER parameter, 10.3.1, 10.4.3

REMOTE_LISTENER parameter, 10.4.4

SERVICE_NAMES parameter, 3.1.1, 8.2

installation

default configuration

listeners, 10.2

local naming, 8.3.1

profiles, 9.2

Instance Name field in Oracle Net Manager, 13.1.3

instance role configuration, 13.4

connections in TAF, 13.4

connections to primary and secondary instances, 13.4

connections to specific instances, 13.4

INSTANCE_NAME networking parameter, 3.1.2, 8.2, 13.1.3, 13.4

J

Java Database Connectivity (JDBC)

drivers, 1.2.1.1

OCI drivers, 5.1.2

absolute naming support, 4.3.6, 15.1.2.2

relative naming support, 4.3.6

Thin drivers, 5.1.2

absolute naming support, 15.1.2.2

directory naming support, 4.3.1, 4.3.6.2

relative naming support, 4.3.6

JavaNet, 5.1.2

JavaNet layer, 1.2.1.3

JavaTTC, 5.1.2

JDBC. See Java Database Connectivity (JDBC)

L

ldapwrite tool, 16.2.1

listener

version requirements for database, 10.1

LISTENER (LIS or LIST) attribute, 10.4.3, 10.4.4, 12.1

Listener configuration option in Oracle Net Configuration Assistant, 6.1.4

Listener Control utility

commands

SERVICES, 2.3, 10.5.3

SET PASSWORD, 15.1.1.1

START, 2.3, 15.1.1.1

STATUS, 10.5.2, 15.1.1.1

STOP, 15.1.1.1

starting a listener, 10.5.1

stopping a listener, 10.5.1

using, 6.2.1

listener.log file, 16.6.2, 16.6.2

listener.ora file

described, 4.2

parameters

ENVS, 13.5.1.2

GLOBAL_DBNAME, 10.3.4

INBOUND_CONNECT_TIMEOUT_listener_name, 14.4

LOG_DIRECTORY_listener_name, 16.6.3.2

ORACLE_HOME, 10.3.4, 13.5.1.2, 13.5.2

PASSWORDS_listener_name, 10.3.5

PROGRAM, 13.5.1.2, 13.5.2

SID_NAME, 10.3.4, 13.5.1.2, 13.5.2

STARTUP_WAITTIME_listener_name, 16.7.2.2

TRACE_FILE_listener_name, 16.7.2.2

TRACE_FILELEN_listener_name, 16.7.2.2

TRACE_FILENO_listener_name, 16.7.2.2, 16.7.2.2

TRACE_LEVEL_listener_name, 16.7.2.2

listeners, 3.2, 13.5.2

adjusting queue size for, 10.3.3

auto-starting, 10.5.1

client load balancing, 3.3.3

configuring, 10

address list, 13.1.1

directory naming method, 8.4.1.4

external procedures, 13.5.1.2

global database name, 10.4.1

host naming method, 8.5

local naming method, 8.3.2.4

multihomed hosts, 10.3.1

nondefault address, 10.4.2

Oracle JServer access, 10.3.2

Oracle System Identifier, 10.3.4

protocol addresses, 10.3.1

service information, 10.3.4

session data unit (SDU), 14.1

SID, 10.3.4

connection load balancing, 3.3.4, 13.2

connect-time failover, 3.3.1

default address, 10.4.2

default configuration, 10.2

described, 1.3.2

direct hand-off, 3.4.1

handling concurrent connections, 10.3.3

increasing queue size, 10.3.3

log files, 10.5.4, 16.6.3.2, 16.6.6

audit trail, 16.6.6.1

direct hand-off event information, 16.6.6.3

service registration event information, 16.6.6.2

monitoring, 10.5.2, 10.5.3, 10.5.4

multihomed hosts, 10.3.1

multiple, 10.2

multiple addresses, 13.1.1

passwords, setting, 10.3.5

queue size, 7.1.6.1, 7.4.1

redirect connections, 3.4.1

security

connect-request timeouts, 14.4

password usage, 10.3.5

starting, 2.3, 2.3, 15.1.1.1, 15.1.1.2

testing configuration, 15.2.1

trace files, 16.7.2.2

Transparent Application Failover (TAF), 3.3.2

listener.trc file, 16.7.1, 16.7.1

load balancing

client, 3.3.3

connection, 3.3.4, 13.2

LOAD_BALANCE networking parameter, 13.1.2

LOCAL environment variable, 15.1.2

local naming

advantages and disadvantages, 7.3

client configuration, 8.3.2.3

configuring, 8.3

connecting with, 8.3.2.5

database server configuration, 8.3.2.1

default configuration, 8.3.1

establishing a connection with, 8.3.2.5

listener configuration for, 8.3.2.4

recommended for, 7.3

Local Net Service Name configuration option in Oracle Net Configuration Assistant, 6.1.4

LOCAL registry entry, 15.1.2

LOCAL_LISTENER initialization parameter, 10.3.1, 10.4.3, 12.1

log files, 10.5.4, 16.6.3.1, 16.6.6

default names for, 16.6.2

listener.log, 16.6.2, 16.6.3.2

Oracle Connection Manager, 16.6.3.3, 16.6.7

sqlnet.log, 16.6.2

sqlnet.log for clients and database servers, 16.6.3.1

using to track errors, 16.6.5

LOG_DIRECTORY networking parameter, 16.6.3.3

LOG_DIRECTORY_CLIENT networking parameter, 16.6.3.1

LOG_DIRECTORY_listener_name networking parameter, 16.6.3.2

LOG_DIRECTORY_SERVER networking parameter, 16.6.3.1

LOG_FILE_CLIENT networking parameter, 16.6.3.1

LOG_FILE_listener_name networking parameter, 16.6.3.2

LOG_FILE_SERVER networking parameter, 16.6.3.1

LOG_LEVEL networking parameter, 16.6.3.3

Logon Authentication Protocol Version field in Oracle Net Manager, 9.5

loopback test, 16.1.1.2

M

maximizing data transfer, by adjusting SDU size, 7.4.2

Meta Map field in Oracle Net Manager, 9.6

METHOD networking parameter, 13.3.4

Microsoft Active Directory, 4.3.8

migrating

net service names from a tnsnames.ora file to a directory, 8.4.3.1

multihomed hosts, 10.3.1

multiple addresses, 13.1.2

configuring client load balancing, 13.1.2

configuring connect-time failover, 13.1.2

multiple listeners, 10.2

multiple protocol addresses, 13.1.1

MULTIPLEX (MUL or MULT) attribute, 11.3.1, 12.1

N

Named Pipes protocol

described, 5.1.1

NAMES.DCE.PREFIX networking parameter, 9.6

NAMES.DEFAULT_DOMAIN networking parameter, 9.3.1

NAMES.DIRECTORY_PATH networking parameter, 9.3.2

cds, 9.3.2

ezconnect, 9.3.2

hostname, 9.3.2

ldap, 9.3.2

nis, 9.3.2

tnsnames, 9.3.2

names.log file, 16.6.2

NAMES.NIS.META_MAP networking parameter, 9.6

names.trc file, 16.7.1

naming metho, 9.3.2

naming methods

Cell Directory Services (CDS), 3.5, 8.6

centralized, 4.1

choosing, 7.1.3, 7.3

described, 3.5

directory naming, 8.4

easy connect naming, 8.5

external naming, 8.6

local naming, 8.3

localized, 4.1

Network Information Service (NIS), 3.5, 8.6

overview, 1.2.2.2

Naming Methods configuration option in Oracle Net Configuration Assistant, 6.1.4

net service aliases

configuring, 8.4.1.2

described, 4.3.3

directory naming, 4.3.3

uses of, 4.3.3

Net Service Name Wizard, 6.1.2, 8.3.2.1, 11.2.2

net service names

adding an address, 13.1.1

configuring, 2.4

directory naming, 8.4.1.2

external naming, 8.6

local naming, 8.3.2.1

multiple addresses, 13.1.1, 13.1.2

prioritizing naming methods, 9.3.2

testing with TNSPING, 15.2.4.1.3, 15.2.4.1.4

network administrator duties, 6.3

Network Authentication (NA)

layer in error stacks, 16.6.1

network availability, determining, 2.2, 2.2, 2.2

network configuration

centralized management, 4.1

localized management, 4.1

network domain, default configuring, 9.3.1

Network Information Service (NIS) external naming, 3.5, 9.3.2

configuring, 8.6, 8.6.1

connecting with, 8.6.1, 8.6.1

establishing a connection with, 8.6.1, 8.6.1

maps, 8.6.1.1.1

Network Interface (NI)

layer in error stacks, 16.6.1, 16.6.1

network layer, 5.1.1

network performance, improving

by adjusting SDU size, 7.4.2

client load balancing, 3.3.3

listener queue size, 7.1.6.1, 7.4.1

network planning

session data unit (SDU) size, 7.4.2

Network Session (NS), layer in error stacks, 16.6.1

Network Transport (NT), layer in error stacks, 16.6.1

networking configuration files

cman.ora file, 4.2

listener.ora file, 4.2

sqlnet.ora file, 4.2

tnsnames.ora file, 4.2

networking planning

internal networks

availability, 7.1.2

client load balancing, 7.1.2.2, 7.1.2.2

connection pooling, 7.1.1.2

connect-time failover, 7.1.2.1

JDBC drivers, 7.1.4

listener queue size, 7.1.6.1

naming methods, 7.1.3

protocol conversion, 7.1.6.3

scalability, 7.1.1

security, 7.1.5, 7.1.5

session data unit (SDU) size, 7.1.6.2

session multiplexing, 7.1.1.3

tuning and performance, 7.1.6

Internet networks

access control, 7.2.5.1

availability, 7.2.2

connect-request timeouts, 7.2.5.2

JDBC drivers, 7.2.4

naming methods, 7.2.3

scalability, 7.2.1

security, 7.2.5

tuning and performance, 7.2.5.3

NIS. See Network Information Service (NIS)

nodes, described, 5.1.1

O

object classes

described, 4.3.7.3

orclDBServer, 4.3.7.3

orclNetAddress, 4.3.7.3

orclNetAddressList, 4.3.7.3

orclNetDescription, 4.3.7.3

orclNetDescriptionList, 4.3.7.3

orclNetService, 4.3.7.3

orclNetServiceAlias, 4.3.7.3

Open Systems Interconnection (OSI)

application layer, 5.1.1

data link layer, 5.1.1

described, 5.1.1

network layer, 5.1.1

Oracle Net foundation layer, 5.1.1

physical layer, 5.1.1

presentation layer, 5.1.1

session layer, 5.1.1

transport layer, 5.1.1

ORA-1017 error messages, 16.1.1.1

ORA-1034 error messages, 16.1.1.1

ORA-12154 error message, 16.2

ORA-12170 error message, 14.4, 16.2

ORA-12203 error message

sample error stack, 16.6.1.1

ORA-12514 error message, 16.2

ORA-12520 error message, 16.2

ORA-12521 error message, 16.2

ORA-12525 error message, 14.4, 16.2

ORA-12526 error messages, 5.2

ORA-12527 error messages, 5.2

ORA-12528 error messages, 5.2

ORA-12533 error message, 16.2

ORA-12535 error message, 9.5, 9.5, 9.5

ORA-12547 error message, 14.4

ORA-12637 error message, 14.4

Oracle Advanced Security

configuring with Oracle Net Manager, 9.7

overview, 1.3.5

Oracle Call Interface (OCI) layer, described, 5.1.1

Oracle Connection Manager

architecture, 5.4

CMADMIN process, 5.4, 5.4

configuring

access control, 11.3.2

clients, 11.2.2, 11.2.2

database server, 11.2.3, 11.2.3.2

Oracle Connection Manager computer, 11.2.1

protocol address for Oracle Connection Manager, 11.2.2

service registration, 11.2.3.1

session multiplexing, 11.3.1, 11.3.1

gateway process, 5.4, 5.4

listener, 5.4, 5.4

log files, 16.6.3.3, 16.6.3.3

names, 16.6.2

understanding, 16.6.7

overview, 1.3.3

protocol address, 11.2.1.1

routing connections, 9.3.3

session multiplexing, 5.4

starting, 15.1.1.3

testing, 15.2.2

trace files, 16.7.2.3

configuring, 16.7.2.4

names, 16.7.1

Oracle Connection Manager Control utility

commands

ADMINISTER, 15.1.1.3

EXIT, 15.1.1.3

STARTUP, 15.1.1.3

using, 6.2.2

Oracle Context

defined, 4.3.2

Oracle Home Directory field in Oracle Net Manager, 10.3.4, 13.5.1.2, 13.5.2

Oracle JServer connections, 10.3.2

Oracle Net

buffers, 7.4.2, 7.4.3

components, 1.3.2

defined, 1.3.1, 1.3.1, 1.3.2

Oracle Net foundation layer, 1.3.1.1

Oracle protocol support, 1.3.1.2

overview, 1.2

scalability features, 1.2.3

understanding, 1.2

Oracle Net Configuration Assistant

described, 6.1.4, 6.1.4

Directory Usage configuration option, 6.1.4

listener configuration, 10.2

Listener configuration option, 6.1.4

local naming method, 8.3.2.1

Local Net Service Name configuration option, 6.1.4

Naming Methods configuration option, 6.1.4

net service names, 8.3.2.1

OracleContextAdmins group, 4.3.7.2.2

OracleDBCreators group, 4.3.5, 4.3.7.2.2

OracleNetAdmins group, 4.3.7.2.2

servers

listener configuration, 6.1.4

starting, 6.1.4, 6.1.4

Oracle Net foundation layer, 1.3.1.1, 5.1.1

Oracle Net listener. See listeners

Oracle Net Manager

adding addresses, 13.1.1

Address List Options dialog box, 13.1.2

clients

client load balancing, 13.1.2

connect-time failover, 13.1.2

default network domains, 9.3.1

local naming method, 8.3.2.1, 8.3.2.1

Oracle Connection Manager, 11.2.2

described, 6.1.2

directory naming, 4.3.5

Directory Server Migration Wizard, 8.4.3.1

external procedure connections, 13.5.1

Heterogeneous Services connections, 13.5.2

Instance Name field, 13.1.3

listeners

Environment field, 13.5.1.2

Global Database Name field, 10.3.4, 13.1.3

Oracle Home Directory field, 10.3.4, 13.5.1.2, 13.5.2

Program Name field, 13.5.1.2, 13.5.2

protocol addresses, 10.3.1

SID field, 10.3.4, 13.5.1.2, 13.5.2

static service information, 10.3.4

local naming method, 8.3.2.1, 8.3.2.1

menus

Command, 6.1.2

Edit, 6.1.2

File, 6.1.2

Help, 6.1.2

multiple address options, 13.1.2

navigating, 6.1.2

navigator pane, 6.1.2, 6.1.2

net service aliases, 8.4.1.2

Net Service Name Wizard, 8.3.2.1, 11.2.2

net service names, 8.3.2.1, 8.3.2.1

Oracle Rdb Database field, 13.1.3

Oracle Rdb databases, 13.5.3

Global Database Name field, 13.5.3

Rdb Database field, 13.5.3

Type of Service field, 13.5.3

profiles, 9.7

advanced options, 9.5

Cell Name field, 9.6

Check TCP/IP client access rights option, 9.4

Client Registration ID field, 9.5

Clients allowed to access field, 9.4

Clients excluded from access field, 9.4

Connection Time Out field, 9.5

Disable Out-of-Band Break option, 9.5

Logon Authentication Protocol Version field, 9.5

Meta Map field, 9.6

Receive operation Time Out field, 9.5

Send operation Time Out field, 9.5

TNS Time Out Value option, 9.5

Total Receive Buffer field, 9.5

Total Send Buffer field, 9.5

Turn Off UNIX Signal Handling option, 9.5

right pane, 6.1.2

routing connection requests, 9.3.3

Session Data Unit (SDU) field in Oracle Net Manager, 13.1.3

specifying naming methods, 9.3.2

starting, 6.1.2

testing

client configuration, 15.2.4.3

server configuration, 15.2.3

toolbar, 6.1.2

Type of Service field, 13.1.3

Use for Heterogeneous Services option, 13.1.3, 13.5.2

Use Oracle8i Release 8.0 Compatible Identification option, 13.1.3

wizards, 6.1.2

Oracle Net Services

components

listener, 1.3.2

Oracle Connection Manager, 1.3.3

Oracle Net, 1.3.1, 1.3.1

described, 1.3

Oracle protocol support

described, 1.3.1.2, 5.1.1

Named Pipes, 5.1.1

TCP/IP, 5.1.1

TCP/IP with SSL, 5.1.1

Oracle Rdb database

configuring for connection to, 13.5.3

described, 13.5.3

Oracle Rdb Database field in Oracle Net Manager, 13.1.3

Oracle schema

described, 4.3.7.3

Oracle Support Services, contacting, 16.8

Oracle System Identifier, configuring on the listener, 10.3.4

ORACLE_HOME networking parameter, 10.3.4, 13.5.1.2, 13.5.2

Oracle9i Real Application Clusters

connect-time failover, 3.3.1, 13.1.2

FAILOVER networking parameter, 13.1.2

FAILOVER_MODE networking parameter, 13.3.4

Transparent Application Failover (TAF), 13.3

OracleContextAdmins group, 4.3.5, 4.3.7.2.2

OracleDBCreators group, 4.3.5, 4.3.7.2.2

OracleHOME_NAMECMan service, 15.1.1.3

OracleHOME_NAMETNSListener service, 15.1.1.1

OracleNetAdmins group, 4.3.7.2.2, 8.4.1.2, 8.4.1.2, 8.4.1.2, 8.4.2

orclDBServer object class, 4.3.7.3

orclNetAddress object class, 4.3.7.3

orclNetAddressList object class, 4.3.7.3

orclNetDescription object class, 4.3.7.3

orclNetDescriptionList object class, 4.3.7.3

orclNetService object class, 4.3.7.3

orclNetServiceAlias object class, 4.3.7.3

OSI. See Open Systems Interconnect (OSI)

P

packets

examining trace data, 16.7.5.2, 16.7.5.4

types of, 16.7.4.2

PARAMETER_LIST networking parameter, 11.2.1.3

PASSWORDS_listener_name parameter, 10.3.5

physical layer, 5.1.1

planning

internal networks

availability, 7.1.2

connection pooling, 7.1.1.2

connect-time failover, 7.1.2.1

JDBC drivers, 7.1.4

listener queue size, 7.1.6.1

naming methods, 7.1.3

protocol conversion, 7.1.6.3

scalability, 7.1.1

security, 7.1.5, 7.1.5

session data unit (SDU) size, 7.1.6.2

session multiplexing, 7.1.1.3

tuning and performance, 7.1.6

Internet networks

access control, 7.2.5.1

availability, 7.2.2

connect-request timeouts, 7.2.5.2

JDBC drivers, 7.2.4

naming methods, 7.2.3

scalability, 7.2.1

security, 7.2.5

tuning and performance, 7.2.5.3

session data unit (SDU) size, 7.4.2

PMON process, 10.1, 11.2.3.1

POOL (POO) attribute, 12.1

port 1521

if not using, 10.4.2

ports

privileged, 10.3.1

presentation layer, 5.1.1

FTP, 5.1.3

HTTP, 5.1.3

JavaTTC, 5.1.2

Two-Task Common (TTC), 5.1.1

WebDAV, 5.1.3

primary and secondary instances, 13.4

privileged ports, 10.3.1

profiles (sqlnet.ora)

configuring

advanced options, 9.5

default domains, 9.3.1

default configuration, 9.2

naming methods, specifying, 9.3.2

routing connection requests, 9.3.3

Program Name field in Oracle Net Manager, 13.5.1.2, 13.5.2

PROGRAM networking parameter, 13.5.1.2, 13.5.2

PROTOCOL (PRO or PROT) attribute, 11.3.1

protocol address, 3.2

protocols

FTP, 1.2.1.3

HTTP, 1.2.1.2, 1.2.1.3

Named Pipes, 5.1.1

Oracle support for, 1.3.1.2

TCP/IP, 5.1.1

TCP/IP with SSL, 5.1.1

WebDAV, 1.2.1.3

proxy server, 11.1

Q

queue size, 7.1.6.1, 7.4.1, 10.3.3

QUEUESIZE parameter, 10.3.3

for adjusting listener queue size, 7.1.6.1, 7.4.1, 10.3.3

R

randomizing requests among listeners, 3.3.3

Rdb Database field, 13.5.3

RDB_DATABASE networking parameter, 13.1.3, 13.5.3

Receive operation Time field in Oracle Net Manager, 9.5

redirect connection, 3.4.1

relative distinguished name (RDN), 4.3.2

relative naming

directory naming, 4.3.6.1

Java Database Connectivity (JDBC)

OCI drivers, 4.3.6

Thin drivers, 4.3.6

resolving

errors. See troubleshooting

routing connections, 9.3.3

RULE_LIST networking parameter, 11.2.1.2, 11.3.2

S

scalability, of networks, 7.1.1

SDP protocol

configuring, 14.3

SDU. See session data unit (SDU)

security

database server

access control configuration, 9.4

connect-request timeouts, 14.4

internal networks, 7.1.5

Internet networks, 7.2.5

listeners

connect-request timeouts, 14.4

password usage, 10.3.5

Send operation Time field in Oracle Net Manager, 9.5

server configuration

access control, 9.4

allocating resources with shared server, 12.4

connect-request timeouts, 14.4

local naming, 8.3.2.1

log files, 16.6.3.1

loopback tests, 16.1.1.2

shared server, 12.1

starting, 2.3

starting the database, 15.1.1.2

trace files, 16.7.2.1

server connections

methods, 15.1.3

syntax, 15.1.2.1

SERVER networking parameter, 3.2, 3.2

server testing, 15.2.3

server troubleshooting, 16.1.1

servers

access control, 9.4

SERVICE (SER or SERV) attribute, 12.1

service handlers

dedicated servers, 3.4.2

dispatchers, 3.4.1

service name

configuring, 8.2

described, 3.1.1, 3.1.1

service registration

benefits, 10.1

configuring, 10.1, 11.2.3.1

connection load balancing, 3.3.4, 10.1, 13.2

connect-time failover, 10.1

defined, 3.2

events in listener.log, 16.6.6.2

service_died listener log event, 16.6.6.2

service_register listener log event, 16.6.6.2

service_update listener log event, 16.6.6.2

service_died listener log event, 16.6.6.2

SERVICE_NAME networking parameter, 8.2

SERVICE_NAMES initialization parameter, 3.1.1, 8.2

service_register listener log event, 16.6.6.2

service_update listener log event, 16.6.6.2

SERVICES command, 10.5.3

of Listener Control utility, 2.3

session data unit (SDU), 7.4.2, 7.4.3, 13.1.3

adjusting to improve network performance, 7.4.2

configuring, 14.1

Session Data Unit (SDU) Size field in Oracle Net Manager, 13.1.3

session layer, 5.1.1

session multiplexing, 1.2.3.2, 5.4, 11.3.1

advantages relative to connection pooling, 7.1.1.3

SESSIONS (SES or SESS) attribute, 12.1, 12.2

SET PASSWORD command

of Listener Control utility, 15.1.1.1

shared server

allocating resources, 12.4

compared with dedicated server, 1.2.3.1

connect descriptor configuration parameters, 3.2, 3.2

connection load balancing, 3.3.4, 13.2

defined, 1.2.3.1

described, 5.3.1, 5.3.1

dispatchers, 1.2.3.1, 1.2.3.1, 3.4.1, 5.3.1, 5.3.1

using with connection pooling, 12.2

virtual circuits, 5.3.1

SID field in Oracle Net Manager, 10.3.4, 13.5.1.2, 13.5.2

SID, configuring on the listener, 10.3.4

SID_LIST_listener_name parameter

external procedures, 13.5.1.2

Heterogeneous Services, 13.5.2

Oracle Enterprise Manager requirements, 10.3.4

SID_NAME networking parameter, 10.3.4, 13.5.1.2, 13.5.2

simple authentication for directory naming, 4.3.7.2.1

SOURCE_ROUTE networking parameter, 13.1.2, 13.1.2

SQLNET_ALLOWED_LOGON_VERSIONS networking parameter, 9.5

SQLNET.CLIENT_REGISTRATION networking parameter, 9.5

SQLNET.EXPIRE_TIME networking parameter, 9.5

SQLNET.INBOUND_CONNECT_TIMEOUT networking parameter, 9.5, 14.4

sqlnet.log file, 16.6.2, 16.6.2

sqlnet.ora file

described, 4.2

parameters

LOG_DIRECTORY_CLIENT, 16.6.3.1

LOG_DIRECTORY_SERVER, 16.6.3.1

LOG_FILE_CLIENT, 16.6.3.1

LOG_FILE_SERVER, 16.6.3.1

NAMES.DCE.PREFIX, 9.6

NAMES.DEFAULT_DOMAIN, 9.3.1

NAMES.DIRECTORY_PATH, 9.3.2

NAMES.NIS.META_MAP, 9.6

SQLNET.INBOUND_CONNECT_TIMEOUT, 14.4

TCP.EXCLUDED_NODES, 9.4

TCP.INVITED_NODES, 9.4

TCP.VALIDNODE_CHECKING, 9.4

TNSPING.TRACE_LEVEL, 16.7.2.1

TRACE_DIRECTORY_CLIENT, 16.7.2.1

TRACE_DIRECTORY_SERVER, 16.7.2.1

TRACE_FILE_CLIENT, 16.7.2.1

TRACE_FILE_SERVER, 16.7.2.1

TRACE_FILELEN_CLIENT, 16.7.2.1, 16.7.2.1

TRACE_FILENO_SERVER, 16.7.2.1, 16.7.2.1

TRACE_LEVEL_CLIENT, 16.7.2.1

TRACE_TIMESTAMP_CLIENT, 16.7.2.1, 16.7.2.1

TRACE_UNIQUE_CLIENT, 16.7.2.1, 16.7.2.1

parameters TNSPING.TRACE_DIRECTORY, 16.7.2.1

SQLNET.RECV_BUF_SIZE networking parameter, 9.5

SQLNET.RECV_TIMEOUT networking parameter, 9.5

SQLNET.SEND_BUF_SIZE networking parameter, 9.5

SQLNET.SEND_TIMEOUT networking parameter, 9.5

sqlnet.trc file, 16.7.1, 16.7.1, 16.7.1

SSL authentication for directory naming, 4.3.7.2.1

START command

of Listener Control utility, 2.3, 10.5.1, 15.1.1.1

starting

database server, 2.3

database servers, 15.1.1.2

databases, 2.3, 15.1.1.2

listeners, 2.3, 2.3, 15.1.1.1, 15.1.1.2

Oracle Connection Manager, 15.1.1.3

Oracle Net Configuration Assistant, 6.1.4, 6.1.4

Oracle Net Manager, 6.1.2

Oracle Net Services components, 15.1.1

STARTUP_WAITTIME_listener_name networking parameter, 16.7.2.2

STATUS command

of Listener Control utility, 10.5.2, 15.1.1.1

STOP command

of Listener Control utility, 10.5.1, 10.5.2, 15.1.1.1

strong authentication for directory naming, 4.3.7.2.1

svr_pid.trc file, 16.7.1, 16.7.1

syntax

for connect identifiers, 15.1.2.1

for Listener Control utility, 6.2.1

for Oracle Connection Manager Control utility, 6.2.2

T

TAF. See Transparent Application Failover (TAF)

TCP.EXCLUDED_NODES networking parameter, 9.4

TCP.INVITED_NODES networking parameter, 9.4

TCP/IP protocol

described, 5.1.1

TCP/IP with SSL protocol

described, 5.1.1

TCP.VALIDNODE_CHECKING networking parameter, 9.4

terminated connection detection

configuring, 9.5

limitations, 9.5

testing

client configuration

from 3GL, 15.1.3.3

from applications, 15.1.3.2

from Oracle Net Manager, 15.2.4.3

from SQL, 15.1.3.4

from the operating system, 15.1.3.1

with TCROUTE, 15.2.4.2

with TNSPING, 15.2.4.1

listener configuration, 15.2.1

network connectivity, 15.2.4

Oracle Connection Manager, 15.2.2

server configuration, 15.2.3

with control utilities, 6.2

TICKS (TIC or TICK) attribute, 12.1, 12.2

TNS. See Transparent Network Substrate (TNS)

TNS Time Out Value option in Oracle Net Manager, 9.5

TNS_ADMIN environment variable, 4.2

TNS_ADMIN registry entry, 4.2

tnsnames.ora file

described, 4.2

exporting entries to directory server, 8.4.3.1

migrating entries to directory server, 8.4.3.1

parameters

BACKUP parameter, 13.3.4

FAILOVER, 13.1.2, 13.1.2

FAILOVER_MODE, 13.3.4

GLOBAL_NAME, 13.1.3

HS, 13.1.3

INSTANCE_NAME, 13.1.3, 13.4

LOAD_BALANCE, 13.1.2, 13.1.2

METHOD, 13.3.4

RDB_DATABASE, 13.1.3

SDU, 13.1.3

SOURCE_ROUTE, 13.1.2, 13.1.2

TYPE, 13.3.4

TYPE_OF_SERVICE, 13.1.3

TNSPING utility, 15.2.4.1

compared to TRCROUTE utility, 15.2.4.2

TNSPING.TRACE_DIRECTORY networking parameter, 16.7.2.1

TNSPING.TRACE_LEVEL networking parameter, 16.7.2.1

tnsping.trc file, 16.7.1

Total Receive Buffer field in Oracle Net Manager, 9.5

Total Send Buffer field in Oracle Net Manager, 9.5

Trace Assistant

examining trace files with, 16.7.5

functions of, 16.7.5

option reference, 16.7.5.1

trace data for IDs, 16.7.5.4

trace data for packets, 16.7.5.2

trace data statistics, 16.7.5.5

trace files

analyzing with Trace Assistant, 16.7.5

default names for, 16.7.1

error message information, 16.7.4.3

examining with Trace Assistant, 16.7.5

listener.trc, 16.7.1, 16.7.2.2

sqlnet.trc, 16.7.1

sqlnet.trc for clients, 16.7.2.1

svr_pid.trc, 16.7.1

svr_pid.trc for servers, 16.7.2.1

tnsping.trc, 16.7.1

TRACE_DIRECTORY networking parameter, 16.7.2.3

TRACE_DIRECTORY_CLIENT networking parameter, 16.7.2.1

TRACE_DIRECTORY_SERVER networking parameter, 16.7.2.1

TRACE_FILE_CLIENT networking parameter, 16.7.2.1

TRACE_FILE_listener_name networking parameter, 16.7.2.2

TRACE_FILE_SERVER networking parameter, 16.7.2.1

TRACE_FILELEN networking parameter, 16.7.2.3

TRACE_FILELEN_CLIENT networking parameter, 16.7.2.1, 16.7.2.1

TRACE_FILELEN_listener_name networking parameter, 16.7.2.2

TRACE_FILENO networking parameter, 16.7.2.3

TRACE_FILENO_listener_name networking parameter, 16.7.2.2, 16.7.2.2

TRACE_FILENO_SERVER networking parameter, 16.7.2.1, 16.7.2.1

TRACE_LEVEL networking parameter, 16.7.2.3

TRACE_LEVEL_CLIENT networking parameter, 16.7.2.1

TRACE_LEVEL_listener_name networking parameter, 16.7.2.2

TRACE_LEVEL_SERVER networking parameter, 16.7.2.1

TRACE_TIMESTAMP networking parameter, 16.7.2.3

TRACE_TIMESTAMP_CLIENT networking parameter, 16.7.2.1, 16.7.2.1

TRACE_UNIQUE_CLIENT networking parameter, 16.7.2.1

Transparent Application Failover (TAF)

and GLOBAL_DBNAME parameter, 10.3.4

configuring, 13.3

GLOBAL_DBNAME networking parameter in listener.ora, 10.3.4, 13.3.5

overview, 3.3.2, 3.3.2

with instance role, 13.4

Transparent Network Substrate (TNS)

benefits, 5.1.1

described, 5.1.1

transport layer, 5.1.1

TRCROUTE utility

described, 15.2.4.2

troubleshooting, 16

client, 16.1.2

contacting Oracle Support Services, 16.8

log files, 16.5

loopback tests, 16.1.1.2

questions, 16.3.1

server, 16.1.1

trace files, 16.5

TTC. See Two-Task Common (TTC)

Turn Off UNIX Signal Handling option in Oracle Net Manager, 9.5

TWO_TASK environment variable, 15.1.2

Two-Task Common (TTC) presentation

dedicated server configurations, 5.3.2

described, 5.1.1

shared server configurations, 5.3.1

TYPE networking parameter, 13.3.4

Type of Service field in Oracle Net Manager, 13.1.3, 13.5.3

TYPE_OF_SERVICE networking parameter, 13.1.3, 13.5.3

U

Use for Heterogeneous Services option in Oracle Net Manager, 13.1.3, 13.5.2

Use Options Compatible with Net8 8.0 Clients option, 13.1.2

Use Oracle8i Release 8.0 Compatible Identification option, 13.1.3

V

V$SESSION table, 13.3.5.4

virtual circuits, 5.3.1

W

WebDAV presentation, 5.1.3

dedicated server configurations, 5.3.2

shared server configurations, 5.3.1

WebDAV protocol, 1.2.1.3

Windows NT services

OracleHOME_NAMECMan service, 15.1.1.3

OracleHOME_NAMETNSListener service, 15.1.1.1

wizards

Directory Server Migration, 6.1.2

Net Service Name, 6.1.2

Oracle Net Manager, 6.1.2

Y

ypserv program, 8.6.1