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