28/28

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, 9.4.1.1

if not using, 9.2.2

---

A

access control lists (ACLs)

described, 3.2.6.2.2

access control to database

with Oracle Connection Manager, 1.1.5.1, 10.2.1.1

with sqlnet.ora parameters, 12.4

ACTION_LIST networking parameter, 10.1, 10.2.1

ADAPTERS utility, 16.2.2

Address List Options dialog box, 13.1.2

ADDRESS networking parameter, 10.2.1

ADR

See automatic diagnostic repository

ADR_BASE log parameter, 16.6.3.1, 16.6.3.3

ADR_BASE_listener_name log parameter, 16.6.3.2

ADRCI, 16.1.1

application web servers, 1.1.1.2

application Web servers, 1.1.1.2.2

architecture

Oracle Connection Manager, 5.6

attributes

defined, 3.2.1

audit trail

described, 16.6.7.1

script for using information, 16.6.7.1

automatic diagnostic repository, 16.1

auto-starting listeners, 9.5.1

---

B

BACKUP networking parameter, 13.3.3

Bequeath protocol, 2.4.2

BEQUEATH_DETACH networking parameter, 12.5

buffer flushing, described, 1.1.4.3

---

C

centralized naming, 3

establishing a connection with, 3

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

client configuration

connect-time failover, 2.6.1

default domains, 12.3.1

load balancing requests among listeners, 2.6.3, 13.1.2

local naming, 8.2.2

log files, 16.6.3.1

network service names, 6.6

Oracle Connection Manager address, 10.2.2

Oracle Rdb connections, 13.6.3

shared server, 11.3

sqlnet.log file, 16.6.3.1

trace files, 16.7.2.3

Transparent Application Failover (TAF), 2.6.2

client connections

syntax, 2.5.3.1

client load balancing

configuring, 13.1.2

described, 2.6.3

Client Registration ID field in Oracle Net Manager, 12.5

client troubleshooting, 16.2.2

Clients allowed to access field in Oracle Net Manager, 12.4

Clients excluded from access field in Oracle Net Manager, 12.4

CMADMIN (Connection Manager Administration), 5.6, 5.6

CMAN DISPATCHERS parameter

See also DISPATCHERS parameter, 10.2.3.2

cman.ora file

log parameters

ADR_BASE, 16.6.3.3

DIAG_ADR_ENABLED, 16.6.3.3

EVENT_GROUP, 16.6.3.3

LOG_DIRECTORY, 16.6.3.3

LOG_LEVEL, 16.6.3.3

parameters

ACTION_LIST, 10.1, 10.2.1

ADDRESS, 10.2.1

RULE_LIST, 10.2.1.1

setting up, 10.1, 10.2.1

trace parameters

TRACE_DIRECTORY, 16.7.2.1

TRACE_FILELEN, 16.7.2.1

TRACE_FILENO, 16.7.2.1

TRACE_LEVEL, 16.7.2.1

TRACE_TIMESTAMP, 16.7.2.1

CMGW (Connection Manager Gateway), 5.6, 5.6, 5.6

configuring

access control, 10.2.1.1, 12.4

clients

client load balancing, 13.1.2

connect-time failover, 2.6.1, 13.1.2, 13.1.2

default domains, 12.3.1

local naming, 8.2.2

naming methods in profile, 12.3.2

network service names, 6.6

Transparent Application Failover (TAF), 2.6.2

connection load balancing, 13.2

connection requests in a profile, 12.3.3

connect-request timeouts, 14.6

database servers

access control, 12.4

connect-request timeouts, 14.6

session data unit (SDU), 14.5.2, 14.5.3

shared server, 11.1

directory naming, 8.3

Easy Connect naming, 8.1

external naming, 8.7

external procedure connections, 13.6.1

Heterogeneous Services connections, 13.6.2, 13.6.2.1

instance role, 13.4

listeners, 9

connect-request timeouts, 14.6

directory naming, 8.3

external procedures, 13.6.1.1.1

local naming, 8.2.2

queue size, 9.4.2

service information, 13.5

local naming, 8.2

localized management, 3

multiple protocol addresses, 13.1.1

naming methods, 8

network domain, default, 12.3.1

network service aliases, 8.3

network service names

directory naming, 8.3

external naming, 8.7

local naming, 8.2.2

Oracle Advanced Security, 12.7

Oracle Rdb database connections, 13.6.3

primary and secondary instances, 13.4

protocol addresses, 9.4.1

quick reference, 7.4

SDP protocol, 14.5

servers

connect-request timeouts, 14.6

session data unit (SDU), 14.5.2, 14.5.3

shared server, 11.1

service registration, 10.2.3.1

session data unit (SDU) size, 13.1.3

session multiplexing, 10.2.3.2

connect identifiers, 2.5.3.1

connection broker, 2.4.3

connection load balancing, 13.2

configuring

dedicated server, 13.2.2

shared server, 13.2.1

described, 2.6.4

service registration, 9.1

Connection Time Out field in Oracle Net Manager, 12.5

connections, 2.3.3.2

adjusting listener queue size to avoid errors, 1.1.4.1, 9.4.2

bequeath, 2.4.2

concurrent, increasing number of, 9.4.2

connect strings, entering, 2.5.3

dedicated servers, 12.3.3

directory naming, 8.3

external procedures, 13.6.1

Heterogeneous Services, 13.6.2

local naming, 8.2.2

NIS external naming, 8.7, 8.7

Oracle Connection Manager, 12.3.3

Oracle Rdb databases, 13.6.3

CONNECTIONS (CON or CONN) attribute, 11.1

connect-time failover

and GLOBAL_DNAME parameter, 13.5.1

configuring, 13.1.2

service registration, 9.1

---

D

data transfer, maximizing, 1.1.4.2

database resident connection pooling, 2.4.3

database server configuration

access control, 12.4

allocating resources with shared server, 11.1.1

connect-request timeouts, 14.6

local naming, 8.2.2

log files, 16.6.3.1

loopback tests, 16.2.1

shared server, 11.1

trace files, 16.7.2.3

database server connections

syntax, 2.5.3.1

dedicated connection, 2.4.3

dedicated server

configuring, 11.3

dedicated servers

bequeathed sessions, 2.4.2

connect descriptor configuration, 2.3.3.2

defined, 1.1.3

described, 2.4.2, 2.4.2, 5.5

difference with shared server, 1.1.3

routing connections, 12.3.3

denial-of-service attacks, 14.6

deprecated features, Preface

desupported features, Preface

DIAG_ADR_ENABLED log parameter, 16.6.3.1, 16.6.3.3

DIAG_ADR_ENABLED_listener_name log parameter, 16.6.3.2

diagnosing

See troubleshooting

direct hand-off

described, 2.4.1

events in listener.log, 16.6.7.3

directory configuration

adding users to the OracleNetAdmins group, 7.2.1

exporting

network service names from a tnsnames.ora file, 8.5

migrating

network service names from a tnsnames.ora file, 8.5

directory information tree (DIT), defined, 3.2.1

directory naming, 16.3.14

advantages and disadvantages, 2.5.1

architecture, 3.2.1

authentication methods

native, 3.2.6.2.1

simple, 3.2.6.2.1

SSL, 3.2.6.2.1

strong, 3.2.6.2.1

configuring, 8.3

connecting to database services, 3.2.5

connecting with, 8.3

connections

using an entry’s fully-qualified name, 3.2.1.4

using an entry’s relative name, 3.2.1.3

establishing a connection with, 8.3

exporting

network service names from a tnsnames.ora file, 8.5

fully-qualified naming, 3.2.1.4

Java Database Connectivity (JDBC)

OCI drivers, 3.2.1.3, 3.2.1.4

Thin drivers, 3.2.1.3, 3.2.1.4

Java Database Connectivity (JDBC) Thin drivers, 3.2, 3.2.1.4

ldapwrite tool, 16.3.14

listener configuration for, 8.3

migrating

network service names from a tnsnames.ora file, 8.5

object classes, 3.2.6.3

objects

database services, 3.2.1

network service aliases, 3.2.3

network service names, 3.2.1

Oracle Context, 3.2.2

Oracle Net Manager, 3.2.4

Oracle schema, 3.2.6.3

OracleContextAdmins group, 3.2.4, 3.2.6.2.2

OracleDBCreators group, 3.2.4, 3.2.6.2.2

OracleNetAdmins group, 3.2.6.2.2, 7.2.1, 8.3, 8.3, 8.3

overview, 3.2

recommended for, 2.5.1

security, 3.2.6.2

troubleshooting, 16.3.14

with relative naming, 3.2.1.3

Directory Server Migration Wizard, 7.1.2.3.2, 8.5

directory servers

attributes, 3.2.1

directory information tree (DIT), 3.2.1

distinguished name (DN), 3.2.1

entry, 3.2.1

ldapwrite tool, 16.3.14

Microsoft Active Directory, 3.2.7

Oracle Context, 3.2.2

overview, 1.1.2.2

performance, 3.2.6.1

relative distinguished name (RDN), 3.2.1

security, 3.2.6.2

Directory Usage configuration option in Oracle Net Configuration Assistant, 7.1.4

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

DISABLE_OOB networking parameter, 12.5

dispatchers, 1.1.3, 5.5.1

described, 1.1.3, 2.4.1, 5.5.1

DISPATCHERS (DIS or DISP) attribute, 11.1

DISPATCHERS initialization parameter, 11.1

CONNECTIONS attribute, 11.1

DISPATCHERS attribute, 11.1

LISTENER attribute, 9.2.2, 9.2.3, 11.1

MULTIPLEX attribute, 11.1

SESSIONS attribute, 11.1

DISPATCHERS parameter

MULTIPLEX attribute, 10.2.3.2

PROTOCOL attribute, 10.2.3.2

distinguished name (DN), defined, 3.2.1

duties of a network administrator, 7.4

dynamic registration, 2.4.3

---

E

easy connect naming

advantages and disadvantages, 2.5.1

recommended for, 2.5.1

syntax examples, 8.1.1

Easy Connect naming

configuring, 8.1

entry, defined, 3.2.1

Environment field in Oracle Net Manager, 13.6.1

ENVS networking parameter, 13.6.1

error messages

contacting Oracle Support Services, 16.8

in trace file, 16.7.4.3

ORA-1017, 16.2.1

ORA-1034, 16.2.1

ORA-12154, 16.3.2

ORA-12170, 14.6, 16.3.3

ORA-12203

sample error stack, 16.6.1.1

ORA-12514, 16.3.5

ORA-12520, 16.3.6

ORA-12521, 16.3.7

ORA-12525, 14.6, 16.3.8

ORA-12526, 5.4

ORA-12527, 5.4

ORA-12528, 5.4

ORA-12533, 16.3.9

ORA-12535, 12.5

ORA-12547, 14.6

ORA-12608, 12.5, 12.5

ORA-12637, 14.6

resolving, 16

using log file to track, 16.6.6

error stack

described, 16.6.1

entries in log files, 16.6.6

sample, 16.6.1.1

typical layers in, 16.6.1

EVENT_GROUP log parameter, 16.6.3.3

exporting

network service names from a tnsnames.ora file to a directory, 8.5

external naming

advantages and disadvantages, 2.5.1

configuring, 8.7

network information service, 2.5.1

NIS, 12.3.2

recommended for, 2.5.1

external procedures

configuring connections to, 13.6.1

described, 13.6.1, 13.6.1

extproc agent, 13.6.1

extproc agent, 13.6.1

EXTPROC_DLLS environment variable, 13.6.1

---

F

failover

connect-time, 2.6.1, 13.1.2

Transparent Application Failover (TAF), 2.6.2, 13.3

FAILOVER networking parameter, 13.1.2, 13.2.1, 13.2.2

FAILOVER_MODE networking parameter, 13.3, 13.3.3

FTP presentation, 4.3

dedicated server configuration, 5.5.2

shared server configuration, 5.5.1

FTP protocol, 1.1.1.2.2

fully-qualified naming

Java Database Connectivity (JDBC)

OCI drivers, 3.2.1.3, 3.2.1.4

Thin drivers, 3.2.1.4

with directory naming, 3.2.1.4

---

G

global database name

configuring on the listener, 9.2.1

defined, 2.3.1

described, 9.2.1

Global Database Name field in Oracle Net Manager, 13.1.3, 13.5, 13.6.3

GLOBAL_DBNAME parameter, 13.5, 13.5

GLOBAL_NAME networking parameter, 13.1.3, 13.6.3

---

H

Heterogeneous Services

configuring connections to, 13.6.2

described, 13.6.2

host naming

requirements, 8.1.2

HS networking parameter, 13.1.3

HTTP presentation, 4.3

dedicated server configuration, 5.5.2

shared server configuration, 5.5.1

HTTP protocol, 1.1.1.2

---

I

INBOUND_CONNECT_TIMEPUT_listener_name networking parameter, 14.6

InfiniBand network communication

configuring SDP protocol support, 14.5

initialization parameter file

DISPATCHERS parameter, 11.1

INSTANCE_NAME parameter, 2.1

LOCAL_LISTENER parameter, 9.2.2, 9.4.1.1

REMOTE_LISTENER parameter, 9.2.3, 9.2.4

SERVICE_NAMES parameter, 2.2, 2.3.1

installation

default configuration

listeners, 9.3

local naming, 8.2.1

profiles, 12.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, 2.1, 2.3.1, 13.1.3, 13.4

IPv6

addresses, 4.4.1.1, 4.4.1.1.2

configurations, 4.4.1.2

connect descriptors, 2.3.1.1

network protocol, 4.1.1.4

Oracle Database components, 4.4.1.4

TCP/IP protocol, 4.4.1

---

J

Java Database Connectivity (JDBC)

drivers, 1.1.1.1.1

OCI drivers, 4.2

fully-qualified naming support, 3.2.1.3, 3.2.1.4

relative naming support, 3.2.1.3

Thin drivers, 4.2

directory naming support, 3.2, 3.2.1.4

fully-qualified naming support, 3.2.1.4

relative naming support, 3.2.1.3

JavaNet, 4.2

JavaNet layer, 1.1.1.2.2

JavaTTC, 4.2

JDBC

See Java Database Connectivity (JDBC)

---

L

ldapwrite tool, 16.3.14

LISTENER (LIS or LIST) attribute, 9.2.2, 9.2.3, 11.1

Listener configuration option in Oracle Net Configuration Assistant, 7.1.4

Listener Control utility

commands

SERVICES, 6.3, 9.5.4

START, 6.3

STATUS, 9.5.3.1

starting a listener, 9.5.1.1

stopping a listener, 9.5.1.1

using, 7.3

listener.log file, 16.6.2, 16.6.2

listener.ora file

described, 3.1

log parameters

ADR_BASE_listener_name, 16.6.3.2

DIAG_ADR_ENABLED_listener_name, 16.6.3.2

LOG_DIRECTORY_listener_name, 16.6.3.2

LOG_FILE_listener_name, 16.6.3.2

parameters

ENVS, 13.6.1

GLOBAL_DBNAME, 13.5

INBOUND_CONNECT_TIMEOUT_listener_name, 14.6

ORACLE_HOME, 13.5, 13.6.1, 13.6.2.1

PROGRAM, 13.6.1, 13.6.2.1

SID_NAME, 13.5, 13.6.1, 13.6.2.1

trace parameters

TRACE_DIRECTORY_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

TRACE_LEVEL_listener_name, 16.7.2.2

TRACE_TIMESTAMP_listener_name, 16.7.2.2

listeners, 2.3.2, 13.6.2.1

adjusting queue size for, 9.4.2

auto-starting, 9.5.1

client load balancing, 2.6.3

configuring, 9

address list, 13.1.1

directory naming method, 8.3

external procedures, 13.6.1.1.1

global database name, 9.2.1

local naming method, 8.2.2

nondefault address, 9.2.2

Oracle System Identifier, 13.5

protocol addresses, 9.4.1

service information, 13.5

SID, 13.5

connection load balancing, 2.6.4, 13.2

connect-time failover, 2.6.1

default address, 9.2.2

default configuration, 9.3

direct hand-off, 2.4.1

handling concurrent connections, 9.4.2

increasing queue size, 9.4.2

log files, 9.5.5, 16.6.3.2, 16.6.7

audit trail, 16.6.7.1

direct hand-off event information, 16.6.7.3

service registration event information, 16.6.7.2

monitoring, 9.5.3.1, 9.5.4, 9.5.5

multiple addresses, 13.1.1

Oracle Net Listener

queue size, 1.1.4.1

redirect connections, 2.4.1

security

connect-request timeouts, 14.6

trace files, 16.7.2.2

Transparent Application Failover (TAF), 2.6.2

listener.trc file, 16.7.1, 16.7.1

load balancing

client, 2.6.3

connection, 2.6.4, 13.2

LOAD_BALANCE networking parameter, 13.1.2

LOCAL environment variable, 2.5.3

local naming

advantages and disadvantages, 2.5.1

client configuration, 8.2.2

configuring, 8.2

connecting with, 8.2.2

database server configuration, 8.2.2

default configuration, 8.2.1

establishing a connection with, 8.2.2

listener configuration for, 8.2.2

recommended for, 2.5.1

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

LOCAL registry entry, 2.5.3

LOCAL_LISTENER initialization parameter, 9.2.2, 9.4.1.1, 11.1

log files, 9.5.5, 16.6.3.1, 16.6.7

default names for, 16.6.2

listener.log, 16.6.2, 16.6.3.2

Oracle Connection Manager, 16.6.8

sqlnet.log, 16.6.2

sqlnet.log for clients and database servers, 16.6.3.1

using to track errors, 16.6.6

log parameters

cman.ora

ADR_BASE, 16.6.3.3

DIAG_ADR_ENABLED, 16.6.3.3

EVENT_GROUP, 16.6.3.3

LOG_DIRECTORY, 16.6.3.3

LOG_LEVEL, 16.6.3.3

listener.ora

ADR_BASE_listener_name, 16.6.3.2

DIAG_ADR_ENABLED_listener_name, 16.6.3.2

LOG_DIRECTORY_listener_name, 16.6.3.2

LOG_FILE_listener_name, 16.6.3.2

sqlnet.ora

ADR_BASE, 16.6.3.1

DIAG_ADR_ENABLED, 16.6.3.1

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

LOG_DIRECTORY log parameter, 16.6.3.3

LOG_DIRECTORY_CLIENT log parameter, 16.6.3.1

LOG_DIRECTORY_listener_name log parameter, 16.6.3.2

LOG_DIRECTORY_SERVER log parameter, 16.6.3.1

LOG_FILE_CLIENT log parameter, 16.6.3.1

LOG_FILE_listener_name log parameter, 16.6.3.2

LOG_FILE_SERVER log parameter, 16.6.3.1

LOG_LEVEL log parameter, 16.6.3.3

Logon Authentication Protocol Version field in Oracle Net Manager, 12.5

loopback test, 16.2.1

LREG process, 9.1, 10.2.3.1, 16.6.7.2

---

M

maximizing data transfer, by adjusting SDU size, 1.1.4.2

METHOD networking parameter, 13.3.3

Microsoft Active Directory, 3.2.7

migrating

network service names from a tnsnames.ora file to a directory, 8.5

multiple addresses, 13.1.2

configuring client load balancing, 13.1.2

configuring connect-time failover, 13.1.2

multiple protocol addresses, 13.1.1

MULTIPLEX (MUL or MULT) attribute, 10.2.3.2, 11.1

---

N

Named Pipes protocol

described, 4.4.3

NAMES.DEFAULT_DOMAIN networking parameter, 12.3.1.1

NAMES.DIRECTORY_PATH networking parameter, 12.3.2

ezconnect, 12.3.2

hostname, 12.3.2

ldap, 12.3.2

nis, 12.3.2

tnsnames, 12.3.2

naming method, 12.3.2

naming methods, 2.5.1

described, 2.5.1

directory naming, 8.3

Easy Connect naming, 8.1

external naming, 8.7

local naming, 8.2

localized, 3

overview, 1.1.2.2

Naming Methods configuration option in Oracle Net Configuration Assistant, 7.1.4

Net Service Name Wizard, 7.1.2.3.1, 8.2.2, 10.2.2

net service names

testing with TNSPING, 15.2

network administrator duties, 7.4

Network Authentication (NA)

layer in error stacks, 16.6.1

network availability, determining, 6.2, 6.2, 6.2

network configuration

centralized management, 3

localized management, 3

network domain, default configuring, 12.3.1

network information service

See NIS

Network Interface (NI)

layer in error stacks, 16.6.1, 16.6.1

network performance, improving

by adjusting SDU size, 1.1.4.2

client load balancing, 2.6.3

listener queue size, 1.1.4.1

network planning

session data unit (SDU) size, 1.1.4.2

network service aliases

configuring, 8.3

described, 3.2.3

directory naming, 3.2.3

uses of, 3.2.3

network service names

configuring, 6.6

directory naming, 8.3

external naming, 8.7

local naming, 8.2.2

multiple addresses, 13.1.1, 13.1.2

prioritizing naming methods, 12.3.2

testing with TNSPING, 15.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, 3.1

listener.ora file, 3.1

sqlnet.ora file, 3.1

tnsnames.ora file, 3.1

networking planning

internal networks

availability, 1.1.4.5

client load balancing, 1.1.4.5, 1.1.4.5

connect-time failover, 1.1.4.5

networkservice names

adding an address, 13.1.1

new features, Preface

NIS external naming, 2.5.1, 12.3.2

configuring, 8.7

connecting with, 8.7, 8.7

establishing a connection with, 8.7

maps, 8.7

---

O

object classes

described, 3.2.6.3

orclDBServer, 3.2.6.3

orclNetAddress, 3.2.6.3

orclNetAddressList, 3.2.6.3

orclNetDescription, 3.2.6.3

orclNetDescriptionList, 3.2.6.3

orclNetService, 3.2.6.3

orclNetServiceAlias, 3.2.6.3

Open Systems Interconnection (OSI)

described, 4.1

ORA-1017 error messages, 16.2.1

ORA-1034 error messages, 16.2.1

ORA-12154 error message, 16.3.2

ORA-12170 error message, 14.6, 16.3.3

ORA-12203 error message

sample error stack, 16.6.1.1

ORA-12514 error message, 16.3.5

ORA-12520 error message, 16.3.6

ORA-12521 error message, 16.3.7

ORA-12525 error message, 14.6, 16.3.8

ORA-12526 error messages, 5.4

ORA-12527 error messages, 5.4

ORA-12528 error messages, 5.4

ORA-12533 error message, 16.3.9

ORA-12535 error message, 12.5, 12.5, 12.5

ORA-12547 error message, 14.6

ORA-12637 error message, 14.6

Oracle Advanced Security

configuring with Oracle Net Manager, 12.7

overview, 1.2.5

Oracle Call Interface (OCI) layer, described, 4.1.1.1

Oracle Clusterware

notification information, 16.6.7.5

Oracle Connection Manager

architecture, 5.6

CMADMIN process, 5.6, 5.6

configuring

access control, 10.2.1.1

clients, 10.2.2, 10.2.2

database server, 10.2.3, 10.2.3.2

Oracle Connection Manager computer, 10.2.1

protocol address for Oracle Connection Manager, 10.2.2

service registration, 10.2.3.1

session multiplexing, 10.2.3.2, 10.2.3.2

gateway process, 5.6, 5.6

listener, 5.6, 5.6

log files, 16.6.3.3

names, 16.6.2

understanding, 16.6.8

overview, 1.2.3

routing connections, 12.3.3

session multiplexing, 5.6

trace files, 16.7.2.1

configuring, 16.7.2.4

names, 16.7.1

Oracle Connection Manager Control utility

commands

ADMINISTER, 6.4

EXIT, 6.4

STARTUP, 6.4

using, 10.4

Oracle Context

defined, 3.2.2

Oracle Home Directory field in Oracle Net Manager, 13.5, 13.6.1

Oracle Net

buffers, 1.1.4.2, 1.1.4.3

defined, 1.2.1, 1.2.1

Oracle Net foundation layer, 1.2.1.1

Oracle protocol support, 1.2.1.2

overview, 1.1

scalability features, 1.1.3

shared server, 1.1.3

understanding, 1.1

Oracle Net Configuration Assistant

described, 7.1.4, 7.1.4

Directory Usage configuration option, 7.1.4

listener configuration, 9.3

Listener configuration option, 7.1.4

local naming method, 8.2.2

Local Net Service Name configuration option, 7.1.4

Naming Methods configuration option, 7.1.4

network service names, 8.2.2

OracleContextAdmins group, 3.2.6.2.2

OracleDBCreators group, 3.2.4, 3.2.6.2.2

OracleNetAdmins group, 3.2.6.2.2

servers

listener configuration, 7.1.4

starting, 7.1.4, 7.1.4

Oracle Net foundation layer, 1.2.1.1, 4.1.1.3

Oracle Net Listener

described, 1.2.2

See listeners

starting, 6.3

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, 12.3.1

local naming method, 8.2.2, 8.2.2

Oracle Connection Manager, 10.2.2

described, 7.1.2

directory naming, 3.2.4

Directory Server Migration Wizard, 8.5

external procedure connections, 13.6.1

Heterogeneous Services connections, 13.6.2

Instance Name field, 13.1.3

listeners

Environment field, 13.6.1

Global Database Name field, 13.1.3, 13.5

Oracle Home Directory field, 13.5, 13.6.1

Oracle System Identifier field, 13.6.1

Program Name field, 13.6.1

protocol addresses, 9.4.1

SID field, 13.5

static service information, 13.5

local naming method, 8.2.2, 8.2.2

multiple address options, 13.1.2

navigating, 7.1.2.2

Net Service Name Wizard, 8.2.2, 10.2.2

network service aliases, 8.3

network service names, 8.2.2, 8.2.2

Oracle Rdb Database field, 13.1.3

Oracle Rdb databases, 13.6.3

Global Database Name field, 13.6.3

Rdb Database field, 13.6.3

Type of Service field, 13.6.3

profiles, 12.7

advanced options, 12.5

Check TCP/IP client access rights option, 12.4

Client Registration ID field, 12.5

Clients allowed to access field, 12.4

Clients excluded from access field, 12.4

Connection Time Out field, 12.5

Disable Out-of-Band Break option, 12.5

Logon Authentication Protocol Version field, 12.5

Receive operation Time Out field, 12.5

Send operation Time Out field, 12.5

TNS Time Out Value option, 12.5

Total Receive Buffer field, 12.5

Total Send Buffer field, 12.5

Turn Off UNIX Signal Handling option, 12.5

routing connection requests, 12.3.3

session data unit (SDU) field in Oracle Net Manager, 13.1.3

specifying naming methods, 12.3.2

starting, 7.1.2.1

Type of Service field, 13.1.3

Use for Heterogeneous Services option, 13.1.3, 13.6.2.1

wizards, 7.1.2.3

Oracle Net Services

components

Oracle Connection Manager, 1.2.3

Oracle Net, 1.2.1, 1.2.1

Oracle Net Listener, 1.2.2

described, 1.2

Oracle protocol support

described, 1.2.1.2, 4.1.1.4

Named Pipes, 4.4.3

TCP/IP, 4.4.1

TCP/IP with SSL, 4.4.2

Oracle Rdb database

configuring for connection to, 13.6.3

described, 13.6.3

Oracle Rdb Database field in Oracle Net Manager, 13.1.3

Oracle Real Application Clusters

connect-time failover, 2.6.1

Oracle schema

described, 3.2.6.3

Oracle Support Services

contacting, 16.8

Oracle System Identifier (SID) field in Oracle Net Manager, 13.6.1

Oracle System Identifier, configuring on the listener, 13.5

ORACLE_HOME networking parameter, 13.5, 13.6.1, 13.6.2.1

Oracle9i Real Application Clusters

connect-time failover, 13.1.2

FAILOVER networking parameter, 13.1.2

FAILOVER_MODE networking parameter, 13.3.3

Transparent Application Failover (TAF), 13.3

OracleContextAdmins group, 3.2.4, 3.2.6.2.2

OracleDBCreators group, 3.2.4, 3.2.6.2.2

OracleHOME_NAMECMan service, 6.4

OracleNetAdmins group, 3.2.6.2.2, 7.2.1, 8.3, 8.3, 8.3

orclDBServer object class, 3.2.6.3

orclNetAddress object class, 3.2.6.3

orclNetAddressList object class, 3.2.6.3

orclNetDescription object class, 3.2.6.3

orclNetDescriptionList object class, 3.2.6.3

orclNetService object class, 3.2.6.3

orclNetServiceAlias object class, 3.2.6.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

planning

internal networks

availability, 1.1.4.5

connect-time failover, 1.1.4.5

session data unit (SDU) size, 1.1.4.2

pooled servers, 2.4.3

port 1521

if not using, 9.2.2

ports

privileged, 9.4.1.1

presentation layer

FTP, 4.3

HTTP, 4.3

JavaTTC, 4.2

Two-Task Common (TTC), 4.1.1.2

WebDAV, 4.3

primary and secondary instances, 13.4

privileged ports, 9.4.1.1

profiles (sqlnet.ora)

configuring

advanced options, 12.5

default domains, 12.3.1

default configuration, 12.2

naming methods, specifying, 12.3.2

routing connection requests, 12.3.3

Program Name field in Oracle Net Manager, 13.6.1

PROGRAM networking parameter, 13.6.1, 13.6.2.1

PROTOCOL (PRO or PROT) attribute, 10.2.3.2

protocol address, 2.3.2

protocols

FTP, 1.1.1.2.2

HTTP, 1.1.1.2, 1.1.1.2.2

Named Pipes, 4.4.3

Oracle support for, 1.2.1.2

TCP/IP, 4.4.1

TCP/IP with SSL, 4.4.2

WebDAV, 1.1.1.2.2

proxy server, 10

---

Q

queue size, 1.1.4.1, 9.4.2

QUEUESIZE parameter, 9.4.2

for adjusting listener queue size, 1.1.4.1, 9.4.2

---

R

randomizing requests among listeners, 2.6.3

Rdb Database field, 13.6.3

RDB_DATABASE networking parameter, 13.1.3, 13.6.3

Receive operation Time field in Oracle Net Manager, 12.5

redirect connection, 2.4.1

relative distinguished name (RDN), 3.2.1

relative naming

directory naming, 3.2.1.3

Java Database Connectivity (JDBC)

OCI drivers, 3.2.1.3

Thin drivers, 3.2.1.3

request queue, 5.5.1

resolving

errors

See troubleshooting

response queue, 5.5.1

routing connections, 12.3.3

RULE_LIST networking parameter, 10.2.1.1

---

S

SDP protocol

configuring, 14.5

SEC_CASE_SENSITIVE_LOGON initialization parameter, 12.5

security

database server

access control configuration, 12.4

connect-request timeouts, 14.6

listeners

connect-request timeouts, 14.6

Send operation Time field in Oracle Net Manager, 12.5

server configuration

access control, 12.4

allocating resources with shared server, 11.1.1

connect-request timeouts, 14.6

local naming, 8.2.2

log files, 16.6.3.1

loopback tests, 16.2.1

shared server, 11.1

trace files, 16.7.2.3

server connections

syntax, 2.5.3.1

SERVER networking parameter, 2.3.3.2

server troubleshooting, 16.2.1

servers

access control, 12.4

service handlers

dedicated servers, 2.4.2, 5.5

dispatchers, 2.4.1

service name

configuring, 2.3.1

described, 2.2, 2.2

service registration

benefits, 9.1

configuring, 10.2.3.1

connection load balancing, 2.6.4, 9.1, 13.2

connect-time failover, 9.1

defined, 2.3.3

events in listener.log, 16.6.7.2

service_died listener log event, 16.6.7.2

service_register listener log event, 16.6.7.2

service_update listener log event, 16.6.7.2

service_died listener log event, 16.6.7.2

SERVICE_NAME networking parameter, 2.3.1, 2.3.1

SERVICE_NAMES initialization parameter, 2.2, 2.3.1

service_register listener log event, 16.6.7.2

service_update listener log event, 16.6.7.2

SERVICES command, 9.5.4

of Listener Control utility, 6.3, 9.5.4

session data unit (SDU), 1.1.4.2, 1.1.4.3, 13.1.3

adjusting to improve network performance, 1.1.4.2

configuring, 14.2

field in Oracle Net Manager, 13.1.3

session multiplexing, 1.1.3, 5.6, 10.2.3.2

SESSIONS (SES or SESS) attribute, 11.1

shared server

allocating resources, 11.1.1

compared with dedicated server, 1.1.3

configuring, 11.3

connect descriptor configuration parameters, 2.3.3.2

connection load balancing, 2.6.4, 13.2

defined, 1.1.3

described, 5.5.1, 5.5.1

dispatchers, 1.1.3, 1.1.3, 2.4.1, 5.5.1, 5.5.1

request queue, 5.5.1

response queue, 5.5.1

virtual circuits, 5.5.1

SID field in Oracle Net Manager, 13.5

SID, configuring on the listener, 13.5

SID_LIST_listener_name parameter, 13.5

external procedures, 13.6.1.1.2

SID_NAME networking parameter, 13.5, 13.6.1, 13.6.2.1

simple authentication for directory naming, 3.2.6.2.1

SOURCE_ROUTE networking parameter, 13.1.2, 13.1.2

SQLNET.ALLOWED_LOGON_VERSION_CLIENT networking parameter, 12.5

SQLNET.ALLOWED_LOGON_VERSION_SERVER networking parameter, 12.5

SQLNET.CLIENT_REGISTRATION networking parameter, 12.5

SQLNET.EXPIRE_TIME networking parameter, 12.5

SQLNET.INBOUND_CONNECT_TIMEOUT networking parameter, 12.5, 14.6

sqlnet.log file, 16.6.2, 16.6.2

sqlnet.ora file

described, 3.1

log parameters

ADR_BASE, 16.6.3.1

DIAG_ADR_ENABLED, 16.6.3.1

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

parameters

NAMES.DEFAULT_DOMAIN, 12.3.1

NAMES.DIRECTORY_PATH, 12.3.2

SQLNET.ALLOWED_LOGON_VERSION_CLIENT, 12.5

SQLNET.ALLOWED_LOGON_VERSION_SERVER, 12.5

SQLNET.INBOUND_CONNECT_TIMEOUT, 14.6

TCP.EXCLUDED_NODES, 12.4

TCP.INVITED_NODES, 12.4

TCP.VALIDNODE_CHECKING, 12.4

trace parameters

TNSPING.TRACE_DIRECTORY, 16.7.2.3

TNSPING.TRACE_LEVEL, 16.7.2.3

TRACE_DIRECTORY_CLIENT, 16.7.2.3

TRACE_DIRECTORY_SERVER, 16.7.2.3

TRACE_FILE_CLIENT, 16.7.2.3

TRACE_FILE_SERVER, 16.7.2.3

TRACE_FILELEN_CLIENT, 16.7.2.3

TRACE_FILELEN_SERVER, 16.7.2.3

TRACE_FILEN0_CLIENT, 16.7.2.3

TRACE_FILENO_SERVER, 16.7.2.3

TRACE_LEVEL_CLIENT, 16.7.2.3

TRACE_LEVEL_SERVER, 16.7.2.3

TRACE_TIMESTAMP_CLIENT, 16.7.2.3

TRACE_TIMESTAMP_SERVER, 16.7.2.3

TRACE_UNIQUE_CLIENT, 16.7.2.3

SQLNET.RECV_BUF_SIZE networking parameter, 12.5

SQLNET.RECV_TIMEOUT networking parameter, 12.5

SQLNET.SEND_BUF_SIZE networking parameter, 12.5

SQLNET.SEND_TIMEOUT networking parameter, 12.5

sqlnet.trc file, 16.7.1, 16.7.1, 16.7.1

SSL authentication for directory naming, 3.2.6.2.1

START command

of Listener Control utility, 6.3, 9.5.1.1

starting

databases, 6.3

Oracle Net Configuration Assistant, 7.1.4, 7.1.4

Oracle Net Listener, 6.3

Oracle Net Manager, 7.1.2.1

static service registration, 13.5

STATUS command

of Listener Control utility, 9.5.3.1, 9.5.3.1

STOP command

of Listener Control utility, 9.5.1.1

strong authentication for directory naming, 3.2.6.2.1

svr_pid.trc file, 16.7.1, 16.7.1

syntax

for connect identifiers, 2.5.3.1

for Listener Control utility, 7.3

for Oracle Connection Manager Control utility, 10.4

---

T

TAF

See Transparent Application Failover (TAF)

TCP.EXCLUDED_NODES networking parameter, 12.4

TCP.INVITED_NODES networking parameter, 12.4

TCP/IP protocol

described, 4.4.1

TCP/IP with SSL protocol

described, 4.4.2

TCP.VALIDNODE_CHECKING networking parameter, 12.4

terminated connection detection

configuring, 12.5

limitations, 12.5

terminated connection timeout

See terminated connection timeout, 12.5

testing

client configuration

with TCROUTE, 15.3

with TNSPING, 15.2

with control utilities, 7.3

TNS

See Transparent Network Substrate (TNS)

TNS Time Out Value option in Oracle Net Manager, 12.5

TNS_ADMIN environment variable, 3.1

tnsnames.ora file

described, 3.1

exporting entries to directory server, 8.5

migrating entries to directory server, 8.5

parameters

BACKUP parameter, 13.3.3

FAILOVER, 13.1.2

FAILOVER_MODE, 13.3.3

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.3

RDB_DATABASE, 13.1.3

SDU, 13.1.3

SOURCE_ROUTE, 13.1.2, 13.1.2

TYPE, 13.3.3

TYPE_OF_SERVICE, 13.1.3

TNSPING utility, 15.2

compared to TRCROUTE utility, 15.3

TNSPING.TRACE_DIRECTORY trace parameter, 16.7.2.3

TNSPING.TRACE_LEVEL trace parameter, 16.7.2.3

tnsping.trc file, 16.7.1

Total Receive Buffer field in Oracle Net Manager, 12.5

Total Send Buffer field in Oracle Net Manager, 12.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.3

svr_pid.trc, 16.7.1

svr_pid.trc for servers, 16.7.2.3

tnsping.trc, 16.7.1

trace parameters

cman.ora

TRACE_DIRECTORY, 16.7.2.1

TRACE_FILELEN, 16.7.2.1

TRACE_FILENO, 16.7.2.1

TRACE_LEVEL, 16.7.2.1

TRACE_TIMESTAMP, 16.7.2.1

listener.ora

TRACE_DIRECTORY_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

TRACE_LEVEL_listener_name, 16.7.2.2

TRACE_TIMESTAMP_listener_name, 16.7.2.2

sqlnet.ora

TNSPING.TRACE_DIRECTORY, 16.7.2.3

TNSPING.TRACE_LEVEL, 16.7.2.3

TRACE_DIRECTORY_CLIENT, 16.7.2.3

TRACE_DIRECTORY_SERVER, 16.7.2.3

TRACE_FILE_CLIENT, 16.7.2.3

TRACE_FILE_SERVER, 16.7.2.3

TRACE_FILELEN_CLIENT, 16.7.2.3

TRACE_FILELEN_SERVER, 16.7.2.3

TRACE_FILEN0_CLIENT, 16.7.2.3

TRACE_FILENO_SERVER, 16.7.2.3

TRACE_LEVEL_CLIENT, 16.7.2.3

TRACE_LEVEL_SERVER, 16.7.2.3

TRACE_TIMESTAMP_CLIENT, 16.7.2.3

TRACE_TIMESTAMP_SERVER, 16.7.2.3

TRACE_UNIQUE_CLIENT, 16.7.2.3

TRACE_DIRECTORY trace parameter, 16.7.2.1

TRACE_DIRECTORY_CLIENT trace parameter, 16.7.2.3

TRACE_DIRECTORY_listener_name trace parameter, 16.7.2.2

TRACE_DIRECTORY_SERVER trace parameter, 16.7.2.3

TRACE_FILE_CLIENT trace parameter, 16.7.2.3

TRACE_FILE_listener_name trace parameter, 16.7.2.2

TRACE_FILE_SERVER trace parameter, 16.7.2.3

TRACE_FILELEN trace parameter, 16.7.2.1

TRACE_FILELEN_CLIENT trace parameter, 16.7.2.3

TRACE_FILELEN_listener_name trace parameter, 16.7.2.2

TRACE_FILELEN_SERVER trace parameter, 16.7.2.3

TRACE_FILEN0_CLIENT trace parameter, 16.7.2.3

TRACE_FILENO trace parameter, 16.7.2.1

TRACE_FILENO_listener_name trace parameter, 16.7.2.2

TRACE_FILENO_SERVER trace parameter, 16.7.2.3

TRACE_LEVEL trace parameter, 16.7.2.1

TRACE_LEVEL_CLIENT trace parameter, 16.7.2.3

TRACE_LEVEL_listener_name trace parameter, 16.7.2.2

TRACE_LEVEL_SERVER trace parameter, 16.7.2.3

TRACE_TIMESTAMP trace parameter, 16.7.2.1

TRACE_TIMESTAMP_CLIENT trace parameter, 16.7.2.3

TRACE_TIMESTAMP_listener_name trace parameter, 16.7.2.2

TRACE_TIMESTAMP_SERVER trace parameter, 16.7.2.3

TRACE_UNIQUE_CLIENT trace parameter, 16.7.2.3

Transparent Application Failover (TAF)

and GLOBAL_DBNAME parameter, 13.5.1

configuring, 13.3

GLOBAL_DBNAME networking parameter in listener.ora, 13.3.4, 13.5, 13.5.1

overview, 2.6.2, 2.6.2

with instance role, 13.4

Transparent Network Substrate (TNS)

benefits, 4.1.1.3

described, 4.1.1.3

TRCROUTE utility

described, 15.3

troubleshooting, 16

client, 16.2.2

loopback tests, 16.2.1

questions, 16.4.1

server, 16.2.1

TTC

See Two-Task Common (TTC)

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

TWO_TASK environment variable, 2.5.3

Two-Task Common (TTC) presentation

dedicated server configurations, 5.5.2

described, 4.1.1.2

shared server configurations, 5.5.1

TYPE networking parameter, 13.3.3

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

TYPE_OF_SERVICE networking parameter, 13.1.3, 13.6.3

---

U

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

---

V

V$SESSION table, 13.3.5

virtual circuits, 5.5.1

---

W

WebDAV presentation, 4.3

dedicated server configurations, 5.5.2

shared server configurations, 5.5.1

WebDAV protocol, 1.1.1.2.2

Windows NT services

OracleHOME_NAMECMan service, 6.4

wizards

Directory Server Migration, 7.1.2.3.2

Net Service Name, 7.1.2.3.1

Oracle Net Manager, 7.1.2.3

---

Y

ypserv program, 8.7