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-28, 12-7

if not using, 12-15

1575 port, 3-37, 9-33

1630 port, 4-17, 13-15

A

absolute naming

Java Database Connectivity (JDBC)

OCI drivers, 3-14, 16-9

Thin drivers, 16-9

with directory naming, 3-16

access control lists (ACLs)

described, 3-18

access control to database

with Oracle Connection Manager, 1-20, 13-14

with sqlnet.ora parameters, 11-8

ADAPTERS utility, 17-5

ADDRESS (ADD or ADDR) attribute, 14-2

Address List Options dialog box, 15-6

administrative regions

defined, 9-24

delegated, 3-32

delegated, under root, 3-34

delegating domains, 9-53

described, 3-25

domain hints to remote, 9-55

in Oracle Names, 3-25

root, 3-32

alert log

ORA-3113 error message, 17-17

aliases

configuring, 9-52

described, 9-52

exporting to net service aliases in a directory, 10-12

migrating to net service aliases in a directory, 10-12

Always Use Dedicated Server option in Oracle Net Manager, 11-7

application layer, 4-3

application Web servers, 1-6 to 1-8

architecture

listener, 4-10

Oracle Connection Manager, 4-16

Oracle Names, 3-22

Oracle Net Services stack communication layers, 4-2

A.SMD Oracle Names record, 12-21

Attempts Per Names Server field in Oracle Net Manager, 9-41

attributes

defined, 3-7

audit trail

described, 17-33

script for using information, 17-34

authentication

with Oracle Advanced Security, 1-23, 1-24

B

BACKGROUND_DUMP_DEST initialization parameter, 17-17

BACKUP networking parameter, 15-21

BASE networking parameter, 10-21

Bequeath protocol, 2-13

BEQUEATH_DETACH networking parameter, 11-10

buffer flushing, described, 7-13

C

CDS. See Cell Directory Service (CDS)

Cell Directory Services (CDS) external naming, 2-17, 11-6

configuring, 9-64

Cell Name field in Oracle Net Manager, 11-12

centralized naming, 3-2

advantages and disadvantages, 7-11

described, 2-17

establishing a connection with, 3-2

recommended for, 7-11

CHANGE_PASSWORD command, 12-13

Check TCP/IP client access rights option in Oracle Net Manager, 11-8

ckpcch.ora file, 9-25

ckpcfg.ora file, 9-25

ckpdom.ora file, 9-25

ckptop.ora file, 9-25, 10-18

client cache process, 9-42

client configuration

connect-time failover, 2-8

default domains, 11-3

discovering Oracle Names servers, 9-38

load balancing requests among listeners, 2-9, 15-4

local naming, 9-11

log files, 17-28

net service names, 6-5 to 6-7

Oracle Connection Manager address, 13-5

Oracle Rdb connections, 15-41

overriding shared server configuration, 14-10

preferred Oracle Names servers, 11-11

shared server, 14-9

sqlnet.log file, 17-28

trace files, 17-44

Transparent Application Failover (TAF), 2-8

client connections

methods, 16-13

syntax, 16-9

client load balancing

configuring, 15-4

described, 2-9

Client Registration ID field in Oracle Net Manager, 11-9

client testing

connectivity, 16-17

from 3GL, 16-14

from applications, 16-13

from Oracle Net Manager, 16-23

from SQL, 16-14

from the operating system, 16-13

client troubleshooting, 17-4

Clients allowed to access field in Oracle Net Manager, 11-8

Clients excluded from access field in Oracle Net Manager, 11-8

cmadm_pid.log file, 17-27

cmadm_pid.trc file, 17-43

CMADMIN process, 4-17

cmadmpid.log file, 17-27

cmadmpid.trc file, 17-43

CMAN networking parameter, 13-4

CMAN_ADMIN networking parameter, 13-4

cman_pid.log file, 17-27, 17-38

cman_pid.trc file, 17-43

CMAN_PROFILE networking parameter, 13-4

CMAN_RULES networking parameter, 13-4

cman.ora file

parameters

CMAN, 13-4, 13-15

CMAN_ADMIN, 13-4

CMAN_PROFILE, 13-4

CMAN_RULES, 13-4, 13-14

LOG_LEVEL, 17-30

TRACE_DIRECTORY, 17-51

TRACE_FILELEN, 17-51

TRACE_FILENO, 17-51

TRACE_LEVEL, 17-51

TRACE_TIMESTAMP, 17-51

setting up, 13-3

cmanpid.log file, 17-27

cmanpid.trc file, 17-43

CMGW process, 4-17

configuring

access control, 11-8, 13-14

aliases, 9-52

clients

client load balancing, 15-4

connect-time failover, 2-8, 15-4

default domains, 11-3

local naming, 9-11

naming methods in profile, 11-5

net service names, 6-5 to 6-7

Oracle Names, 9-38

session data unit (SDU), 15-28

Transparent Application Failover (TAF), 2-8

connection load balancing, 15-10 to 15-17

connection pooling, 14-8

connection requests in a profile, 11-7

database servers

session data unit (SDU), 15-29

shared server, 14-2

directory naming, 9-12 to 9-18

domains, default, 11-11

external naming, 9-64 to 9-67

external procedure connections, 15-30

Heterogeneous Services connections, 15-37

host naming, 9-60 to 9-63

instance role, 15-25

listeners, 12-1 to 12-27

directory naming, 9-17

external procedures, 15-32

Heterogeneous Services, 15-38

host naming, 9-61

local naming, 9-11

Oracle JServer, 12-8

Oracle Names, 9-45

queue size, 12-9

service information, 12-10

session data unit (SDU), 15-29

local naming, 9-5 to 9-11

localized management, 3-2

multiple domains in Oracle Names, 9-31, 9-36

multiple protocol addresses, 15-2

naming methods, 9-1 to 9-67

net service aliases, 9-20

net service names

directory naming, 9-14

external naming, 9-64

local naming, 9-6

Oracle Names, 9-46

network domain, default, 11-3

Oracle Advanced Security, 11-13

Oracle Names, 9-23 to 9-57

Oracle Names servers, 9-28

Oracle Rdb database connections, 15-40

primary and secondary instances, 15-25

protocol addresses, 12-6

protocol conversion support, 13-15

quick reference, 5-19 to 5-22

region database for Oracle Names, 9-27, 9-32

replicated data among Oracle Names servers, 9-33

servers

session data unit (SDU), 15-29

shared server, 14-2

session data unit (SDU), 15-28

session multiplexing, 13-13

connect identifiers, 16-9

connect strings, 16-2

connection load balancing, 15-10

configuring

dedicated server, 15-15

shared server, 15-12

described, 2-9

service registration, 12-3

connection pooling

advantages relative to session multiplexing, 7-4

configuring, 14-8

defined, 1-14

using with shared server, 14-8

connections, 2-7

adjusting listener queue size to avoid errors, 7-7, 7-12, 12-9

bequeath, 2-13

concurrent, increasing number of, 12-9

connect strings, entering, 16-2, 16-8

dedicated servers, 11-7

directory naming, 9-18

external procedures, 15-30

Heterogeneous Services, 15-37

host naming, 9-63

local naming, 9-11

methods, 16-13

Network Information Service (NIS) external naming, 9-64

Network Information Service external naming, 9-64

Oracle Connection Manager, 11-7

Oracle Names, 9-57

Oracle Rdb databases, 15-40

startup of components, 16-2

CONNECTIONS (CON or CONN) attribute, 14-3

connect-time failover

configuring, 15-4

GLOBAL_DBNAME networking parameter in listener.oa, 12-10, 15-4

service registration, 12-3

Create additional or upgrade existing Oracle Context option in Oracle Net Configuration Assistant, 8-9

Create Alias dialog box, 9-21

Create or upgrade the Oracle Schema option in Oracle Net Configuration Assistant, 8-9

D

data link layer, 4-2

data transfer, maximizing, 7-13

Database Configuration Assistant

directory naming, 3-12

shared server configuration, 14-2

database links, 3-28, 9-49

global database link, 3-28

private database, 3-28

public database, 3-28

database server configuration

allocating resources with shared server, 14-9

creating a repository for Oracle Names, 3-26

discovering Oracle Names servers, 9-38

local naming, 9-6

log files, 17-28

loopback tests, 17-4

region database for Oracle Names, 9-27

shared server, 14-2

starting the database, 6-4, 16-6

trace files, 17-44

database server connections

methods, 16-13

syntax, 16-9

database server testing, 16-16

Database Services tab in Oracle Net Manager, 12-11

dead connection timeout. See terminated connection timeout, 11-9

dedicated servers

architecture, 1-13

bequeathed sessions, 2-13

connect descriptor configuration, 2-7

defined, 1-12

described, 2-13 to 2-15

difference with shared server, 1-12

routing connections, 11-7

Default Domain field in Oracle Net Manager, 9-41

DELAY networking parameter, 15-21

DELEGATE_DOMAIN command, 9-54

delegated administrative regions

diagram, 3-33

domains to, 9-53

in Oracle Names, 3-32

under root, 3-34

DESCRIPTION parameter, 9-5

diagnosing. See troubleshooting

direct hand-off

described, 2-10

events in listener.log, 17-37

directory configuration

adding users to the OracleNetAdmins group, 8-12

after installation, 8-6

choosing a directory server, 8-7

default configuration, 8-2

exporting

aliases in Oracle Names to net service aliases in a directory, 10-12

net service names from a tnsnames.ora file, 10-2

objects from Oracle Names, 10-6

for clients and servers, 9-13

migrating

aliases in Oracle Names to net service aliases in a directory, 10-12

net service names from a tnsnames.ora file, 10-2

objects from Oracle Names, 10-6

Oracle Context creation, 8-9

Oracle schema creation, 8-9

setting up for first-time usage, 8-8

directory information tree (DIT), defined, 3-7

directory naming, 17-18

absolute naming, 3-16

advantages and disadvantages, 7-10

architecture, 3-7

authentication methods

native, 3-18

simple, 3-18

SSL, 3-18

strong, 3-18

configuring, 9-12 to 9-18

connecting to database services, 3-14

connecting with, 9-18

connections

using an entry's absolute name, 3-16

using an entry's relative name, 3-15

Database Configuration Assistant, 3-12

establishing a connection with, 9-18

exporting

aliases in Oracle Names to net service aliases in a directory, 10-12

net service names from a tnsnames.ora file, 10-2

objects from Oracle Names, 10-6 to 10-16

Java Database Connectivity (JDBC)

OCI drivers, 3-14, 16-9

Thin drivers, 3-14, 16-9

Java Database Connectivity (JDBC) Thin drivers, 3-6, 3-16

ldap_search limitations, 17-19

ldap.ora file

creating, 8-3

described, 3-14

ldapwrite tool, 17-18

listener configuration for, 9-17

migrating

net service names from a tnsnames.ora file, 10-2

objects from Oracle Names, 10-6 to 10-16

object classes, 3-21

objects

database services, 3-7

global database links, 10-6

net service aliases, 3-9

net service names, 3-7

Oracle Context, 3-8

Oracle Names LDAP Proxy servers, 10-17

Oracle Net Configuration Assistant, 3-13

Oracle Net Manager, 3-12

Oracle schema, 3-21

OracleContextAdmins group, 3-13, 3-19, 8-8, 8-9

OracleDBCreators group, 3-13, 3-20, 8-8, 8-9

OracleNetAdmins group, 3-20, 8-8, 8-9, 8-12, 9-14, 9-19, 9-20

overview, 3-4

recommended for, 7-10

security, 3-17

troubleshooting, 17-18

with relative naming, 3-15

Directory Server Migration Wizard, 5-12, 10-5

directory servers

attributes, 3-7

directory information tree (DIT), 3-7

distinguished name (DN), 3-7

entry, 3-7

ldap_search tool, 17-19

ldapwrite tool, 17-18

Microsoft Active Directory, 3-6

Oracle Context, 3-8

Oracle Internet Directory, 3-6

overview, 1-11

performance, 3-17

relative distinguished name (RDN), 3-7

security, 3-17

Directory Usage configuration option in Oracle Net Configuration Assistant, 5-15

Directory Usage Configuration page in Oracle Net Configuration Assistant, 8-7

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

DISABLE_OOB networking parameter, 11-10

discovering Oracle Names servers

described, 3-37

procedure, 9-37

dispatchers, 1-12, 4-13

described, 1-12, 2-10 to 2-12, 4-13

number to start, 14-6

setting the number of, 14-6

DISPATCHERS (DIS or DISP) attribute, 14-3

DISPATCHERS initialization parameter, 14-2

ADDRESS attribute, 14-2

configuring connection pooling, 14-8

CONNECTIONS attribute, 14-3

DISPATCHERS attribute, 14-3

LISTENER attribute, 12-15, 12-17, 14-4

MULTIPLEX attribute, 14-4

POOL attribute, 14-5

PROTOCOL attribute, 14-2

SERVICE attribute, 14-5

SESSIONS attribute, 14-5

setting initially, 14-6

TICKS attribute, 14-6

DISPATCHERS parameter

MULTIPLEX attribute, 13-13

PROTOCOL attribute, 13-13

distinguished name (DN), defined, 3-7

DLCR.RDBMS.OMD Oracle Names record, 16-25

domain hints, 9-55

domains

default network, 3-30

delegating, 9-53

described, 3-25, 9-24

multiple hierarchically, 9-31, 9-36

multiple hierarchically related, 3-31

required by root administrative regions, 3-32

with a single domain naming structure, diagram, 3-29

duties of a network administrator, 5-19 to 5-22

Dynamic Discovery Option, 3-35

E

enterprise user security, 3-8

entry, defined, 3-7

Environment field in Oracle Net Manager, 15-34

ENVS networking parameter, 15-34

error messages

contacting Oracle Support Services, 17-82

in trace file, 17-56

NNL-00018, 9-32

NNL-00024, 9-32

NNO-00062, 17-19, 17-20

NNO-00850, 17-19, 17-20

ORA-00508, 17-13

ORA-1017, 17-3

ORA-1034, 17-3

ORA-12154, 17-10

ORA-12198, 17-11

ORA-12203, 17-11, 17-12, 17-13, 17-21

sample error stack, 17-25

ORA-12224, 17-14

ORA-12514, 17-14

ORA-12520, 17-15

ORA-12521, 17-15

ORA-12533, 17-14

ORA-12535, 17-21

ORA-12538, 17-13

ORA-12545, 17-16

ORA-12547, 17-21

ORA-12560, 17-16

ORA-3113, 17-17

ORA-3121, 17-17

resolving, 17-1 to 17-82

using log file to track, 17-32

error stack

described, 17-24

entries in log files, 17-32

sample, 17-25

typical layers in, 17-24

establishing a session

using centralized naming, 2-17

exporting

net service names from a tnsnames.ora file to a directory, 10-2

objects from Oracle Names to a directory, 10-6 to 10-16

external naming

advantages and disadvantages, 7-12

Cell Directory Services (CDS), 2-17, 9-64, 11-6

configuring, 9-64 to 9-67

Network Information Service (NIS), 2-17, 9-64, 11-6

recommended for, 7-12

external procedures

configuring connections to, 15-30

described, 15-30

extproc agent, 15-30

EXTPROC_DLLS environment variable, 15-34

F

failover

connect-time, 2-8, 15-4

Transparent Application Failover (TAF), 2-8, 15-18

FAILOVER networking parameter, 15-4, 15-14, 15-17

FAILOVER_MODE networking parameter, 15-18, 15-21

features, new

client load balancing, xl

connection load balancing, xli

connection load balancing for dedicated server configurations, xxxvii

connect-time failover, xl

creating multiple Oracle Contexts, xxxvii

direct hand-off, xli

directory naming, xl

directory naming access control, xxxv

dynamic update of LOCAL_LISTENER parameter, xxxv

dynamic update of REMOTE_LISTENER parameter, xxxv

global database link support in directory server, xxxiv

instance role specification for primary/secondary configurations, xli

name changes

CIRCUITS initialization parameter, xxxvi

DISPATCHERS initialization parameter, xxxvi

MAX_DISPATCHERS initialization parameter, xxxvi

MAX_SHARED_SERVERS initialization parameter, xxxvi

Oracle Net, xxxvi

Oracle Net Configuration Assistant, xxxvi

Oracle Net foundation layer, xxxvi

Oracle Net Manager, xxxvi

shared server, xxxvi

SHARED_SERVER_SESSIONS initialization parameter, xxxvii

SHARED_SERVERS initialization parameter, xxxvi

V$SHARED_SERVER_MONITOR view, xxxvii

net service alias support in directory server, xxxiv

Oracle Names LDAP Proxy servers, xxxvii

Oracle Net Configuration Assistant, xli

service naming, xli

service registration, xli

SERVICE_NAME parameter, xlii

TCP/IP with SSL, xlii

Trace Assistant, xxxv

FILE networking parameter, 10-22

FTP presentation, 4-9

dedicated server configuration, 4-15

shared server configuration, 4-14

FTP protocol, 1-8

G

global database links, 3-28, 9-49

adding link qualifiers, 9-50

directory naming limitation, 10-6

Oracle Names, 9-49

global database name

configuring on the listener, 12-10, 12-15

defined, 9-3

described, 12-10, 12-15

Global Database Name field in Oracle Net Manager, 12-10, 15-8, 15-40

GLOBAL_DBNAME networking parameter, 12-10

GLOBAL_NAME networking parameter, 15-8, 15-40

H

Heterogeneous Services

configuring connections to, 15-37

described, 15-37

hierarchical naming model

described, 3-30

diagram, 3-30

host naming

advantages and disadvantages, 7-11

configuring, 9-60 to 9-63

connecting with, 9-63

establishing a connection with, 9-63

listener configuration for, 9-61

recommended for, 7-11

requirements, 9-60

HOST networking parameter, 10-21

hosts file, 3-35

HS networking parameter, 15-8

HTTP presentation, 4-9

dedicated server configuration, 4-15

shared server configuration, 4-14

HTTP protocol, 1-6

I

Identix authentication, xxxviii

Initial Preallocated Requests field in Oracle Net Manager, 9-41

initialization parameter file

BACKGROUND_DUMP_DEST parameter, 17-17

DISPATCHERS parameter, 14-2

INSTANCE_NAME parameter, 2-4

LOCAL_LISTENER parameter, 12-7, 12-16

REMOTE_LISTENER parameter, 12-17

SERVICE_NAMES parameter, 2-2, 9-3, 14-5

installation

default configuration

directory naming, 8-2

listeners, 12-4

local naming, 9-6

profiles, 11-2

Oracle Names, 9-24

Instance Name field in Oracle Net Manager, 15-8

instance role configuration, 15-25

connections in TAF, 15-27

connections to primary and secondary instances, 15-25

connections to specific instances, 15-26

INSTANCE_NAME networking parameter, 2-4, 9-3, 15-8, 15-25

J

Java Database Connectivity (JDBC)

described, 1-5

drivers, 1-5

OCI drivers, 4-8

absolute naming support, 3-14, 16-9

relative naming support, 3-14

Thin drivers, 4-8

absolute naming support, 16-9

directory naming support, 3-6, 3-16

relative naming support, 3-14

JavaNet, 4-8

JavaNet layer, 1-8

JavaTTC, 4-8

JDBC. See Java Database Connectivity (JDBC)

L

ldap_search tool limitations, 17-19

ldap.ora file

creating, 3-14, 8-3

described, 3-2

ldapwrite tool, 17-18

LISTENER (LIS or LIST) attribute, 12-15, 12-17, 14-4

Listener configuration option in Oracle Net Configuration Assistant, 5-15

Listener Control utility

commands

SERVICES, 6-5, 12-25

SET PASSWORD, 16-5

START, 6-4, 16-5

STATUS, 12-22, 16-5

STOP, 16-5

starting a listener, 12-22

stopping a listener, 12-22

using, 5-16

listener.log file, 17-27

listener.ora file

described, 3-2

parameters

ENVS, 15-34

GLOBAL_DBNAME, 12-10

LOG_DIRECTORY_listener_name, 17-29

LOG_FILE_listener_name, 17-29

ORACLE_HOME, 12-10, 15-35, 15-37

PASSWORDS_listener_name, 12-13

PROGRAM, 15-34, 15-37

SID_NAME, 12-10, 15-35, 15-37

STARTUP_WAITTIME_listener_name, 17-48

TRACE_FILE_listener_name, 17-48

TRACE_FILELEN_listener_name, 17-48

TRACE_FILENO_listener_name, 17-49

TRACE_LEVEL_listener_name, 17-48

listeners, 2-6, 15-37

adjusting queue size for, 12-9

client load balancing, 2-9

configuring, 12-1 to 12-27

address for Oracle Connection Manager, 13-7

address list, 15-2

directory naming method, 9-17

external procedures, 15-32

global database name, 12-10, 12-15

Heterogeneous Services, 15-38

Heterogeneous Services connections, 15-37

host naming method, 9-61

local naming method, 9-11

multihomed hosts, 12-7

nondefault address, 12-15

Oracle Enterprise Manager, 12-10

Oracle JServer access, 12-8

Oracle Names, 9-45

Oracle System Identifier, 12-10

protocol addresses, 12-6

service information, 12-10

session data unit (SDU), 15-29

SID, 12-10

connection load balancing, 2-9, 15-10

connect-time failover, 2-8

default address, 12-15

default configuration, 12-4

described, 1-28

direct hand-off, 2-10

handling concurrent connections, 12-9

increasing queue size, 12-9

log files, 12-27, 17-29, 17-33

audit trail, 17-33

direct hand-off event information, 17-37

service registration event information, 17-34

monitoring, 12-22, 12-25, 12-27

multihomed hosts, 12-7

multiple, 12-5

multiple addresses, 15-2

passwords, setting, 12-13

queue size, 7-7, 7-12

redirect connections, 2-10

security, 12-13

starting, 6-4, 16-5, 16-6

testing configuration, 16-16

trace files, 17-48

Transparent Application Failover (TAF), 2-8

listener.trc file, 17-43

load balancing

client, 2-9

connection, 2-9, 15-10

LOAD_BALANCE networking parameter, 15-4

LOAD_TNSNAMES command, 9-48

LOCAL environment variable, 16-8

local naming

advantages and disadvantages, 7-10

client configuration, 9-11

configuring, 9-5 to 9-11

connecting with, 9-11

database server configuration, 9-6

default configuration, 9-6

establishing a connection with, 9-11

listener configuration for, 9-11

recommended for, 7-10

Local Net Service Name configuration option in Oracle Net Configuration Assistant, 5-15

LOCAL registry entry, 16-8

LOCAL_LISTENER initialization parameter, 12-7, 12-16, 14-4

log files, 12-27, 17-28, 17-33

cmadm_pid.log, 17-27, 17-30

cmadmpid.log, 17-27, 17-30

cman_pid.log, 17-27, 17-30, 17-38

cmanpid.log, 17-27, 17-30

default names for, 17-27

listener.log, 17-27, 17-29

names.log, 17-27, 17-29

sqlnet.log, 17-27

sqlnet.log for clients and database servers, 17-28

using to track errors, 17-32

LOG_DIRECTORY_CLIENT networking parameter, 17-28

LOG_DIRECTORY_listener_name networking parameter, 17-29

LOG_DIRECTORY_SERVER networking parameter, 17-28

LOG_FILE_CLIENT networking parameter, 17-28

LOG_FILE_listener_name networking parameter, 17-29

LOG_FILE_SERVER networking parameter, 17-28

LOG_LEVEL networking parameter, 17-30

loopback test, 17-4

LU6.2 protocol, xl

M

maximizing data transfer, by adjusting SDU size, 7-13

Maximum Open Connections field in Oracle Net Manager, 9-41

Maximum Wait Each Attempt field in Oracle Net Manager, 9-41

Meta Map field in Oracle Net Manager, 11-12

METHOD networking parameter, 15-21

Microsoft Active Directory, 3-6

migrating

net service names from a tnsnames.ora file to a directory, 10-2

objects from Oracle Names to a directory server, 10-6 to 10-16

multihomed hosts, 12-7

multiple addresses, 15-4

configuring client load balancing, 15-6

configuring connect-time failover, 15-6

multiple listeners, 12-5

multiple protocol addresses, 15-2

MULTIPLEX (MUL or MULT) attribute, 13-13, 14-4

N

Named Pipes protocol

described, 4-6

Names Wizard, 5-13, 9-28, 9-33

NAMES.ADDRESSES networking parameter, 9-29, 9-34

NAMES.ADMIN_REGION networking parameter, 10-20

NAMES.ADMIN_REGION parameter, 9-29

NAMESCTL utility

discovering Oracle Names servers, 9-39

NAMES.DCE.PREFIX networking parameter, 11-12

NAMES.DEFAULT_DOMAIN networking parameter, 9-41, 11-2, 11-4

NAMES.DIRECTORY_PATH networking parameter, 11-6

cds, 11-6

hostname, 11-5

ldap, 11-5

nis, 11-6

onames, 11-5

tnsnames, 11-5

NAMES.DOMAIN_HINTS networking parameter, 9-29, 9-34, 9-55

NAMES.DOMAINS networking parameter, 9-29, 9-31, 9-34, 9-36

NAMES.DOMAINS parameter, 9-31, 9-36

namesini.sql script, 9-27

NAMES.INITIAL_RETRY_TIMEOUT networking parameter, 9-41

names.log file, 17-27

NAMES.LOG_DIRECTORY networking parameter, 17-29

NAMES.LOG_FILE networking parameter, 17-29

NAMES.MAX_OPEN_ CONNECTIONS networking parameter, 9-41

NAMES.MESSAGE_POOL_ START_SIZE networking parameter, 9-41

NAMES.NIS.META_MAP networking parameter, 11-12

names.ora file

described, 3-2

parameters

BASE, 10-21

FILE, 10-22

HOST, 10-21

NAMES.ADMIN_REGION, 10-20

NAMES.LOG_DIRECTORY, 17-29

NAMES.LOG_FILE, 17-29

NAMES.TRACE_DIRECTORY, 17-50

NAMES.TRACE_FILE, 17-50

NAMES.TRACE_LEVEL, 17-50

NAMES.TRACE_UNIQUE, 17-50

PASSWORD, 10-21

PORT, 10-21

SCOPE, 10-21

SUBTREE, 10-21

SUBTREE_LIST, 10-21

TIMEOUT, 10-21

TYPE, 10-21, 10-22

USERID, 10-21

namespid.trc file, 17-50

NAMES.PREFERRED_SERVERS networking parameter, 11-11, 11-12

NAMES.REQUEST_RETRIES networking parameter, 9-41

NAMES.SERVER_NAME networking parameter, 9-29, 9-34

NAMES.TRACE_DIRECTORY networking parameter, 17-50

NAMES.TRACE_FILE networking parameter, 17-50

NAMES.TRACE_LEVEL networking parameter, 17-50

NAMES.TRACE_UNIQUE networking parameter, 17-50

names.trc file, 17-43

namesupg.sql script, 9-27

naming methods

Cell Directory Services (CDS), 2-17, 9-64

centralized, 3-2

choosing, 7-6, 7-10

described, 2-16

directory naming, 9-12 to 9-18

external naming, 9-64 to 9-67

host naming, 9-60 to 9-63

local naming, 9-5 to 9-11

localized, 3-2

Network Information Service (NIS), 2-17, 9-64

Oracle Names, 2-17, 9-23 to 9-57

overview, 1-11

prioritizing order, 11-5

Naming Methods configuration option in Oracle Net Configuration Assistant, 5-15

naming models

hierarchical, 3-30

single domain, 3-29

native authentication for directory naming, 3-18

NDS. See Novell Directory Services (NDS)

net service aliases

configuring, 9-20

described, 3-9

directory naming, 3-9

exporting aliases from Oracle Names, 10-12

migrating aliases from Oracle Names, 10-12

uses of, 3-9

Net Service Name Wizard, 5-11, 9-7, 9-14, 13-5

net service names

adding an address, 15-2

configure an Oracle Connection Manager address, 13-5

configuring, 6-5 to 6-7

creating in Oracle Names, 9-47

directory naming, 9-14

external naming, 9-64

local naming, 9-6

multiple addresses, 15-2, 15-4

Oracle Names, 9-46

prioritizing naming methods, 11-5

testing with TNSPING, 16-19

Net8 OPEN, xxxix

network administrator duties, 5-19 to 5-22

Network Authentication (NA)

layer in error stacks, 17-25

network availability, determining, 6-3

network configuration

centralized management, 3-2

localized management, 3-2

network domain, default

in Oracle Names, 3-30

network domain, default configuring, 11-3

Network Information Service (NIS) external naming, 2-17, 11-6

configuring, 9-64

connecting with, 9-64

establishing a connection with, 9-64

maps, 9-65

Network Interface (NI)

layer in error stacks, 17-24

network layer, 4-2

Network Naming (NN)

layer in error stacks, 17-24

network performance, improving

by adjusting SDU size, 7-13

client load balancing, 2-9

listener queue size, 7-7, 7-12

network planning

session data unit (SDU) size, 7-13

Network Routing (NR)

layer in error stacks, 17-25

Network Session (NS), layer in error stacks, 17-25

Network Transport (NT), layer in error stacks, 17-25

networking configuration files

ldap.ora file, 3-2

listener.ora file, 3-2

names.ora file, 3-2

sqlnet.ora file, 3-3

tnsnames.ora file, 3-3

networking planning

internal networks

availability, 7-5

client load balancing, 7-5

connection pooling, 7-3

connect-time failover, 7-5

JDBC drivers, 7-6

listener queue size, 7-7

naming methods, 7-6

protocol conversion, 7-7

scalability, 7-3

security, 7-6

session data unit (SDU) size, 7-7

session multiplexing, 7-3

tuning and performance, 7-7

Internet networks

access control, 7-9

availability, 7-9

JDBC drivers, 7-9

naming methods, 7-9

scalability, 7-9

security, 7-9

tuning and performance, 7-10

new features

client load balancing, xl

connection load balancing, xli

connection load balancing for dedicated server configurations, xxxvii

connect-time failover, xl

creating multiple Oracle Contexts, xxxvii

direct hand-off, xli

directory naming, xl

directory naming access control, xxxv

dynamic update of LOCAL_LISTENER parameter, xxxv

dynamic update of REMOTE_LISTENER parameter, xxxv

global database link support in directory server, xxxiv

instance role specification for primary/secondary configurations, xli

name changes

CIRCUITS initialization parameter, xxxvi

DISPATCHERS initialization parameter, xxxvi

MAX_DISPATCHERS initialization parameter, xxxvi

MAX_SHARED_SERVERS initialization parameter, xxxvi

Oracle Net, xxxvi

Oracle Net Configuration Assistant, xxxvi

Oracle Net foundation layer, xxxvi

Oracle Net Manager, xxxvi

shared server, xxxvi

SHARED_SERVER_SESSIONS initialization parameter, xxxvii

SHARED_SERVERS initialization parameter, xxxvi

V$SHARED_SERVER_MONITOR view, xxxvii

net service alias support in directory server, xxxiv

Oracle Names LDAP Proxy servers, xxxvii

Oracle Net Configuration Assistant, xli

service naming, xli

service registration, xli

SERVICE_NAME parameter, xlii

TCP/IP with SSL, xlii

Trace Assistant, xxxv

NIS. See Network Information Service (NIS)

NNL-00018 error message, 9-32

NNL-00024 error message, 9-32

NNO-00062 error message, 17-19, 17-20

NNO-00850 error message, 17-19, 17-20

nodes, described, 4-4

Novell Directory Services (NDS) authentication, xxxviii

Novell Directory Services (NDS) external naming, xxxviii

NS.SMD Oracle Names record, 16-25

O

object classes

described, 3-21

orclDBServer, 3-21

orclNetAddress, 3-21

orclNetAddressList, 3-21

orclNetDescription, 3-21

orclNetDescriptionList, 3-21

orclNetService, 3-21

orclNetServiceAlias, 3-21

ONRS_CONFIG table, 9-25

Open Systems Interconnection (OSI)

application layer, 4-3

data link layer, 4-2

described, 4-2

network layer, 4-2

Oracle Net foundation layer, 4-4

physical layer, 4-2

presentation layer, 4-3

session layer, 4-3

transport layer, 4-3

ORA-00508 error message, 17-13

ORA-1017 error messages, 17-3

ORA-1034 error messages, 17-3

ORA-12154 error message, 17-10

ORA-12198 error message, 17-11

ORA-12203 error message, 17-11, 17-12, 17-13, 17-21

sample error stack, 17-25

ORA-12224 error message, 17-14

ORA-12514 error message, 17-14

ORA-12520 error message, 17-15

ORA-12521 error message, 17-15

ORA-12533 error message, 17-14

ORA-12535 error message, 17-21

ORA-12538 error message, 17-13

ORA-12545 error message, 17-16

ORA-12547 error message, 17-21

ORA-12560 error message, 17-16

ORA-3113 error message, 17-17

ORA-3121 error message, 17-17

Oracle Advanced Security

authentication, 1-23, 1-24

configuring with Oracle Net Manager, 11-13

overview, 1-31

single sign-on, 1-23

Oracle Call Interface (OCI) layer, described, 4-4

Oracle Connection Manager

CMADMIN process, 4-17

CMGW process, 4-17

configuring

access control, 13-14

clients, 13-5, 13-6

database server, 13-12

Oracle Connection Manager computer, 13-3 to 13-4

protocol address for listener, 13-7

protocol address for Oracle Connection Manager, 13-5

protocol conversion support, 13-15

session multiplexing, 13-13

log files, 17-30

cmadm_pid.log, 17-27

cmadmpid.log, 17-27

cman_pid.log, 17-27

cmanpid.log, 17-27

understanding, 17-38

overview, 1-29

processes, 4-16

routing connections, 11-7

shared server, 13-2

starting, 16-7

testing, 16-16

trace files, 17-51

cmadm_pid.trc, 17-43

cmadmpid.trc, 17-43

cman_pid.trc, 17-43

cmanpid.trc, 17-43

configuring, 17-52

Oracle Connection Manager Control utility

commands

START, 16-7

using, 5-17

Oracle Context

creating, 8-4, 8-9

defined, 3-8

Oracle Enterprise Manager

SID_LIST_listener_name networking parameter in listener.ora, 12-10

Oracle Home Directory field in Oracle Net Manager, 12-10, 15-35, 15-37

Oracle Internet Directory, 3-6

Oracle JServer connections, 12-8

Oracle Names, 2-17

administrative regions, 3-25

advantages and disadvantages, 7-11

architecture, 3-22

client cache, 9-42, 16-4

configuring, 9-23 to 9-57

clients and servers, 9-38

region database, 9-27

connecting with, 9-57

creating Oracle Names servers, 9-25

database as a repository for information, 3-26

delegated

administrative regions, 3-34

described, 3-23

differences between versions, 3-34

discovering Oracle Names servers, 9-37, 9-38

discovery, 3-37

domains, 3-25

administering multiple, 9-31, 9-36

delegated, 9-53

hints to remote, 9-55

Dynamic Discovery Option, 3-35

establishing a connection with, 9-57

exporting

aliases to net service aliases in a directory, 10-12

objects to a directory server, 10-6 to 10-16

hierarchical naming model, 3-30

installing, 9-24

listener configuration for, 9-45

log files, 17-29

migrating

aliases to net service aliases in a directory, 10-12

objects to a directory server, 10-6 to 10-16

multiple domains, 3-31

multiple regions, 3-31

namesini.sql script, 9-27

namesupg.sql script, 9-27

naming network components, 3-29

network domain, default, 3-30

querying objects, 16-25

recommended for, 7-11

region database, 3-26

regions, 3-25

registering

aliases, 9-52

global database links, 9-49

net service names, 9-46

objects, 9-46

replicated data, 3-26, 9-33

root administrative region, 3-32

.sdns.ora file, 3-37

sdns.ora file, 3-37

single domain naming mode, 3-29

starting

from Oracle Net Manager, 16-25

from the command line, 16-25

starting from the command line, 16-25

storing

aliases, 3-28

database global database names and addresses, 3-27

database links, 3-28

net service names, 3-27

other Oracle Names server names and addresses, 3-27

trace files, 17-50

version 1, 3-34

version 2, 3-35

version 8, 3-36

Oracle Names Control utility

commands

QUERY, 9-37, 16-25

START, 9-37

START_CLIENT_CACHE, 9-43, 16-4

delegating domains, 9-54

discovering Oracle Names servers, 9-37, 9-39

loading tnsnames.ora file into Oracle Names, 9-48

net service names, 9-47

querying objects, 16-25

REORDER_NS, 9-37

starting an Oracle Names server, 16-3

testing network objects with, 16-25

using, 5-18

Oracle Names LDAP Proxy servers

configuring, 10-17

described, 10-7

error reporting, 17-19

generating topology for, 10-18

NAMES.ADMIN_REGION networking parameter, 10-20

starting, 9-58, 10-20

Oracle Names servers

ckpcch.ora file, 9-25

ckpcfg.ora file, 9-25

ckpdom.ora file, 9-25

ckptop.ora file, 9-25, 10-18

client cache, 9-42, 16-4

configuring

multiple domains, 9-31, 9-36

creating, 9-25

region database, 9-28

replicated data, 9-33

data stored in, 3-27

default configuration, 9-26

delegated administrative regions, 3-32

delegated domains, 9-53

deleting, 9-58

described, 3-23

discovery, 9-37

domain hints, 9-55

log files, 17-29

preferred, 3-34, 11-11

registering

aliases, 9-52

global database link qualifiers, 9-50

global database links, 9-49

net service names, 9-46

objects, 9-46

removing, 9-58

replicated data, 9-33

root administrative regions, 3-32

starting, 9-32, 16-3

client cache, 9-42, 16-4

from Oracle Net Manager, 16-25

from the command line, 16-25

storing

aliases, 3-28

database global database names and addresses, 3-27

database links, 3-28

net service names, 3-27

other Oracle Names server names and addresses, 3-27

testing, 16-24

QUERY command, 16-25

TNSPING utility, 16-20

trace files, 17-50

well-known, 3-35

Oracle Net

buffers, 7-13

components, 1-28

defined, 1-26, 1-28

Oracle Net foundation layer, 1-26

Oracle protocol support, 1-27

overview, 1-3 to 1-31

scalability features, 1-12

understanding, 1-3 to 1-31

Oracle Net Configuration Assistant

described, 5-14

directory usage configuration

Choose a directory server and complete setup for first time usage of that directory option, 8-8

Create additional or upgrade existing Oracle Context option, 8-9

Create or upgrade Oracle Schema option, 8-9

Select the directory server you want to use option, 8-7

Directory Usage configuration option, 5-15

Directory Usage Configuration page, 8-7

listener configuration, 12-4

Listener configuration option, 5-15

local naming method, 9-10

Local Net Service Name configuration option, 5-15

Naming Methods configuration option, 5-15

net service names, 9-10

OracleContextAdmins group, 3-19, 8-8, 8-9

OracleDBCreators group, 3-13, 3-20, 8-8, 8-9

OracleNetAdmins group, 3-20, 8-8, 8-9

servers

listener configuration, 5-15

Oracle Context creation, 3-13

starting, 5-14

Welcome page, 5-14

Oracle Net foundation layer, 1-26, 4-4

Oracle Net listener. See listeners

Oracle Net Manager

adding addresses, 15-2

Address List Options dialog box, 15-6

clients

client load balancing, 15-4

connect-time failover, 15-4

default network domains, 11-3

local naming method, 9-7

Oracle Connection Manager, 13-5

Create Alias dialog box, 9-21

Default Domain field, 9-41

delegating domains to administrative regions, 9-54, 9-58

described, 5-2

directory naming, 3-12

Directory Server Migration Wizard, 10-5

discovering Oracle Names servers, 9-39

external procedure connections, 15-30

Heterogeneous Services connections, 15-37

Instance Name field, 15-8

listeners

Database Services tab, 12-11

Environment field, 15-34

Global Database Name field, 12-10, 15-8

nondefault through Oracle Names, 12-20

Oracle Home Directory field, 12-10, 15-35, 15-37

Program Name field, 15-34, 15-37

protocol addresses, 12-6

SID field, 12-10, 15-35, 15-37

static service information, 12-10

local naming method, 9-7

menus

Command, 5-9

Edit, 5-8

File, 5-8

Help, 5-10

multiple address options, 15-4

Names Wizard, 9-28, 9-33

navigating, 5-4 to 5-10

navigator pane, 5-5

net service aliases, 9-20, 9-21

Net Service Name Wizard, 9-7, 9-14, 13-5

net service names, 9-7

Oracle Names

Attempts Per Names Server field, 9-41

Default Domain field, 9-41

discovering, 9-39

global database link qualifiers, 9-50

global database links, 9-49

Initial Preallocated Requests field, 9-41

Maximum Open Connections field, 9-41

Maximum Wait Each Attempt field, 9-41

net service names, 9-47

nondefault listener, 12-20

preferred Oracle Names servers, 11-11

querying network objects, 16-25

region database, 9-28

starting, 16-3

Oracle Rdb Database field, 15-8

Oracle Rdb databases, 15-41

Global Database Name field, 15-40

Rdb Database field, 15-40

Type of Service field, 15-40

profiles, 11-13

advanced options, 11-9

Always Use Dedicated Server option, 11-7

Cell Name field, 11-12

Check TCP/IP client access rights option, 11-8

Client Registration ID field, 11-9

Clients allowed to access field, 11-8

Clients excluded from access field, 11-8

Disable Out-of-Band Break option, 11-10

Meta Map field, 11-12

Prefer Connection Manager Routing option, 11-7

preferred Oracle Names servers, 11-11

TNS Time Out Value option, 11-9

Turn Off UNIX Signal Handling option, 11-10

right pane, 5-6

routing connection requests, 11-7

Session Data Unit (SDU) field in Oracle Net Manager, 15-8

specifying naming methods, 11-5

starting, 5-3

starting Oracle Names servers, 9-37, 16-25

testing

client configuration, 16-23

server configuration, 16-16

toolbar, 5-7

Type of Service field, 15-8

Use for Heterogeneous Services option, 15-8, 15-39

Use Oracle8i Release 8.0 Compatible Identification option, 15-8

wizards, 5-10 to 5-13

Oracle Net Services

components

listener, 1-28

Oracle Connection Manager, 1-29

Oracle Net, 1-26

described, 1-26

Oracle protocol support

described, 1-27, 4-6

Named Pipes, 4-6

TCP/IP, 4-6

TCP/IP with SSL, 4-6

Oracle Rdb database

configuring for connection to, 15-40

described, 15-40

Oracle Rdb Database field in Oracle Net Manager, 15-8

Oracle schema

creating, 8-9

described, 3-21

Oracle Support Services, contacting, 17-82

Oracle System Identifier, configuring on the listener, 12-10

ORACLE_HOME networking parameter, 12-10, 15-35, 15-37

Oracle9i Real Application Clusters

connect-time failover, 2-8, 15-4

FAILOVER networking parameter, 15-4

FAILOVER_MODE networking parameter, 15-21

Transparent Application Failover (TAF), 15-18

OracleContextAdmins group, 3-13, 3-19, 8-8, 8-9

OracleDBCreators group, 3-13, 3-20, 8-8, 8-9

OracleHOME_NAMEClientCache service, 16-4

OracleHOME_NAMECMAdmin service, 4-16, 16-7

OracleHOME_NAMECMan service, 4-16, 16-7

OracleHOME_NAMENamesonames_server service, 16-3

OracleHOME_NAMETNSListener service, 16-5

OracleNetAdmins group, 3-20, 8-8, 8-9, 8-12, 9-14, 9-19, 9-20

orclDBServer object class, 3-21

orclNetAddress object class, 3-21

orclNetAddressList object class, 3-21

orclNetDescription object class, 3-21

orclNetDescriptionList object class, 3-21

orclNetService object class, 3-21

orclNetServiceAlias object class, 3-21

OSI. See Open Systems Interconnect (OSI)

P

packets

examining trace data, 17-65, 17-77

types of, 17-55

PASSWORD networking parameter, 10-21

PASSWORDS_listener_name parameter, 12-13

physical layer, 4-2

PING utility, 16-24

testing Oracle Names servers with, 16-24

planning

internal networks

availability, 7-5

connection pooling, 7-3

connect-time failover, 7-5

JDBC drivers, 7-6

listener queue size, 7-7

naming methods, 7-6

protocol conversion, 7-7

scalability, 7-3

security, 7-6

session data unit (SDU) size, 7-7

session multiplexing, 7-3

tuning and performance, 7-7

Internet networks

access control, 7-9

availability, 7-9

JDBC drivers, 7-9

naming methods, 7-9

scalability, 7-9

security, 7-9

tuning and performance, 7-10

session data unit (SDU) size, 7-13

PMON process, 12-2

POOL (POO) attribute, 14-5

port 1521

if not using, 12-15

port 1575, 3-37, 9-33

port 1630, 4-17, 13-15

PORT networking parameter, 10-21

ports

privileged, 12-7

Prefer Connection Manager Routing option in Oracle Net Manager, 11-7

preferred Oracle Names servers, 3-34

presentation layer, 4-3

FTP, 4-9

HTTP, 4-9

JavaTTC, 4-8

Two-Task Common (TTC), 4-4

WebDAV, 4-9

prespawned dedicated servers, xxxix

primary and secondary instances, 15-25

private database links, 3-28

privileged ports, 12-7

profiles (sqlnet.ora)

configuring

advanced options, 11-9

default domains, 11-3

configuring preferred Oracle Names servers, 11-11

default configuration, 11-2

naming methods, specifying, 11-5

prioritizing naming methods, 11-5

routing connection requests, 11-7

Program Name field in Oracle Net Manager, 15-34, 15-37

PROGRAM networking parameter, 15-34, 15-37

PROTOCOL (PRO or PROT) attribute, 13-13, 14-2

protocol address, 2-6

protocol conversion support

configuring, 13-15

described, 1-29

protocol.ora file, xxxix

protocols

FTP, 1-8

HTTP, 1-6, 1-8

Named Pipes, 4-6

Oracle support for, 1-27

TCP/IP, 4-6

TCP/IP with SSL, 4-6

WebDAV, 1-8

proxy server, 13-2

public database links, 3-28

Q

QUERY command, 9-37, 16-25

A.SMD Oracle Names record, 12-21

DLCR.TDBMS.OMD Oracle Names record, 16-25

NS.SMD Oracle Names record, 16-25

V1ADD.NPO.OMD Oracle Names record, 16-25

queue size, 7-7, 7-12, 12-9

QUEUESIZE parameter, 12-9

for adjusting listener queue size, 7-7, 7-12, 12-9

R

randomizing requests among listeners, 2-9

Rdb Database field, 15-40

RDB_DATABASE networking parameter, 15-8, 15-40

redirect connection, 2-10

region database

configure database server, 9-27, 9-32

create Oracle Names server, 9-28

defined, 3-26

regions

delegated administrative, 3-32

delegated administrative under root, 3-34

delegated administrative, diagram, 3-33

in Oracle Names, 3-25, 3-31

organizing multiple administrative network, 3-31

root administrative, 3-32

registering

aliases with Oracle Names, 9-52

global database links with Oracle Names, 9-49

net service names with Oracle Names, 9-46

objects with Oracle Names, 9-46

relative distinguished name (RDN), 3-7

relative naming

directory naming, 3-15

Java Database Connectivity (JDBC)

OCI drivers, 3-14

Thin drivers, 3-14

REORDER_NS command, 9-37, 9-39, 11-11

replicated data in Oracle Names, 3-26

replication of data in Oracle Names, 9-33

resolving

errors. See troubleshooting

RETRIES networking parameter, 15-21

root administrative regions

described, 3-32

domain requirements, 3-32

requirements, 3-32

root administrative regions, described, 3-32

root domains, described, 3-32

routing connections, 11-7

S

SAVE_CONFIG command, 12-13

scalability, of networks, 7-3

SCOPE networking parameter, 10-21

.sdns.ora file, 3-37

sdns.ora file, 3-37

SDU networking parameter, 15-8, 15-28

SDU. See session data unit (SDU)

SecurID authentication, xxxviii

security

internal networks, 7-6

Internet networks, 7-9

listeners, 12-13

Select the directory server you want to use option in Oracle Net Configuration Assistant, 8-7

Select the directory server you want to use, and configure the directory server for Oracle usage option in Oracle Net Configuration Assistant, 8-8

server configuration

allocating resources with shared server, 14-9

creating a repository for Oracle Names, 3-26

discovering Oracle Names servers, 9-38

local naming, 9-6

log files, 17-28

loopback tests, 17-4

region database for Oracle Names, 9-27

shared server, 14-2

starting, 6-4

starting the database, 16-6

trace files, 17-44

server connections

methods, 16-13

syntax, 16-9

SERVER networking parameter, 2-7

server testing, 16-16

server troubleshooting, 17-3

SERVICE (SER or SERV) attribute, 14-5

service handlers

dedicated servers, 2-13 to 2-15

dispatchers, 2-10 to 2-12

service name

described, 2-2, 2-3, 9-2

service registration

benefits, 12-3

configuring, 12-3

connection load balancing, 2-9, 12-3, 15-10

connect-time failover, 12-3

defined, 2-6

events in listener.log, 17-34

service_died listener log event, 17-35

service_register listener log event, 17-35

service_update listener log event, 17-35

service_died listener log event, 17-35

SERVICE_NAME networking parameter, 9-3

SERVICE_NAMES initialization parameter, 2-2, 9-3, 14-5

service_register listener log event, 17-35

service_update listener log event, 17-35

SERVICES command, 12-25

of Listener Control utility, 6-5

session data unit (SDU), 7-13

adjusting to improve network performance, 7-13

configuring, 15-28

Session Data Unit (SDU) Size field in Oracle Net Manager, 15-8

session layer, 4-3

session multiplexing, 1-16, 13-13

advantages relative to connection pooling, 7-4

overview, 1-17

SESSIONS (SES or SESS) attribute, 14-5

SET PASSWORD command

of Listener Control utility, 16-5

shared server

allocating resources, 14-9

architecture, 1-13

compared with dedicated server, 1-12

configuring dispatchers, 14-6

connect descriptor configuration parameters, 2-7

connection load balancing, 2-9, 15-10

defined, 1-12

described, 4-13

dispatchers, 1-12, 2-10 to 2-12, 4-13

using with connection pooling, 14-8

using with Oracle Connection Manager, 13-2

virtual circuits, 4-13

SID field in Oracle Net Manager, 12-10, 15-35, 15-37

SID, configuring on the listener, 12-10

SID_LIST_listener_name parameter

external procedures, 15-33

Heterogeneous Services, 15-37

Oracle Enterprise Manager requirements, 12-10

SID_NAME networking parameter, 12-10, 15-35, 15-37

simple authentication for directory naming, 3-18

single domain naming model, 3-29

single sign-on

Oracle Advanced Security, 1-23

SOURCE_ROUTE networking parameter, 13-5, 13-10, 15-4, 15-6

SPX protocol, xl

SQLNET.CLIENT_REGISTRATION networking parameter, 11-9

SQLNET.EXPIRE_TIME networking parameter, 11-9

sqlnet.log file, 17-27

sqlnet.ora file

described, 3-3

parameters

LOG_DIRECTORY_CLIENT, 17-28

LOG_DIRECTORY_SERVER, 17-28

LOG_FILE_CLIENT, 17-28

LOG_FILE_SERVER, 17-28

NAMES.DCE.PREFIX, 11-12

NAMES.DEFAULT_DOMAIN, 11-3

NAMES.DIRECTORY_PATH, 11-5

NAMES.NIS.META_MAP, 11-12

NAMES.PREFERRED_SERVERS, 11-11

TCP.EXCLUDED_NODES, 11-8

TCP.INVITED_NODES, 11-8

TCP.VALIDNODE_CHECKING, 11-8

TNSPING.TRACE_LEVEL, 17-47

TRACE_DIRECTORY_CLIENT, 17-44

TRACE_DIRECTORY_SERVER, 17-44

TRACE_FILE_CLIENT, 17-44

TRACE_FILE_SERVER, 17-44

TRACE_FILELEN_CLIENT, 17-44

TRACE_FILENO_SERVER, 17-45

TRACE_LEVEL_CLIENT, 17-45

TRACE_TIMESTAMP_CLIENT, 17-46

TRACE_UNIQUE_CLIENT, 17-46

USE_CMAN, 11-7, 13-5

USE_DEDICATED_SERVER, 11-7

parameters TNSPING.TRACE_DIRECTORY, 17-47

sqlnet.trc file, 17-43

SSL authentication for directory naming, 3-18

START command

of Listener Control utility, 6-4, 12-22, 16-5

of Oracle Connection Manager Control utility, 16-7

of Oracle Names Control utility, 9-32, 9-37, 10-18, 10-24, 16-3

START_CLIENT_CACHE command, 9-43, 16-4

starting

an instance with dispatchers, 14-6

database server, 6-4

database servers, 16-6

databases, 6-4, 16-6

listeners, 6-4, 16-5, 16-6

Oracle Connection Manager, 16-7

Oracle Names client cache, 9-42, 16-4

Oracle Names LDAP Proxy servers, 9-58, 10-20

Oracle Names servers, 9-32, 16-3

Oracle Net Configuration Assistant, 5-14

Oracle Net Manager, 5-3

Oracle Net Services components, 16-2

STARTUP_WAITTIME_listener_name networking parameter, 17-48

STATUS command

of Listener Control utility, 12-22, 16-5

STOP command

of Listener Control utility, 12-22, 16-5

of Oracle Names Control utility, 10-20

strong authentication for directory naming, 3-18

SUBTREE networking parameter, 10-21

SUBTREE_LIST networking parameter, 10-21

svr_pid.trc file, 17-43

syntax

for connect identifiers, 16-9

for Listener Control utility, 5-16

for Oracle Connection Manager Control utility, 5-17

for Oracle Names Control utility, 5-18

T

TAF. See Transparent Application Failover (TAF)

TCP.EXCLUDED_NODES networking parameter, 11-8

TCP.INVITED_NODES networking parameter, 11-8

TCP/IP protocol

described, 4-6

TCP/IP with SSL protocol

described, 4-6

TCP.VALIDNODE_CHECKING networking parameter, 11-8

terminated connection detection

configuring, 11-9

limitations, 11-9

testing

client configuration

from 3GL, 16-14

from applications, 16-13

from Oracle Net Manager, 16-23

from SQL, 16-14

from the operating system, 16-13

with TCROUTE, 16-20

with TNSPING, 16-17

listener configuration, 16-16

network connectivity, 16-17

network objects, 16-25

Oracle Connection Manager, 16-16

Oracle Names servers, 16-24

server configuration, 16-16

with control utilities, 5-16

TICKS (TIC or TICK) attribute, 14-6

TIMEOUT networking parameter, 10-21

TNS. See Transparent Network Substrate (TNS)

TNS Time Out Value option in Oracle Net Manager, 11-9

TNS_ADMIN environment variable, 3-3

TNS_ADMIN registry entry, 3-3

tnsnames.ora file

described, 3-3

exporting entries to directory server, 10-2

migrating entries to directory server, 10-2

parameters

BACKUP parameter, 15-21

DELAY, 15-21

FAILOVER, 15-4

FAILOVER_MODE, 15-21

GLOBAL_NAME, 15-8

HS, 15-8

INSTANCE_NAME, 15-8, 15-25

LOAD_BALANCE, 15-4

METHOD, 15-21

RDB_DATABASE, 15-8

RETRIES, 15-21

SDU, 15-8, 15-28

SOURCE_ROUTE, 13-5, 13-10, 15-4, 15-6

TYPE, 15-21

TYPE_OF_SERVICE, 15-8

TNSPING utility, 16-17

compared to TRCROUTE utility, 16-20

TNSPING.TRACE_DIRECTORY networking parameter, 17-47

TNSPING.TRACE_LEVEL networking parameter, 17-47

Trace Assistant

examining trace files with, 17-60

functions of, 17-60

option reference, 17-61

trace data for IDs, 17-77

trace data for packets, 17-65

trace data statistics, 17-81

trace files

analyzing with Trace Assistant, 17-60

cmadm_pid.trc, 17-43

cmadmpid.trc, 17-43

cman_pid.trc, 17-43

cmanpid.trc, 17-43

default names for, 17-43

error message information, 17-56

examining with Trace Assistant, 17-60

listener.trc, 17-43, 17-48

namespid.trc, 17-50

names.trc, 17-43, 17-50

sqlnet.trc, 17-43

sqlnet.trc for clients, 17-44

svr_pid.trc, 17-43

svr_pid.trc for servers, 17-44

TRACE_DIRECTORY networking parameter, 17-51

TRACE_DIRECTORY_CLIENT networking parameter, 17-44

TRACE_DIRECTORY_SERVER networking parameter, 17-44

TRACE_FILE_CLIENT networking parameter, 17-44

TRACE_FILE_listener_name networking parameter, 17-48

TRACE_FILE_SERVER networking parameter, 17-44

TRACE_FILELEN networking parameter, 17-51

TRACE_FILELEN_CLIENT networking parameter, 17-44

TRACE_FILELEN_listener_name networking parameter, 17-48

TRACE_FILENO networking parameter, 17-51

TRACE_FILENO_listener_name networking parameter, 17-49

TRACE_FILENO_SERVER networking parameter, 17-45

TRACE_LEVEL networking parameter, 17-51

TRACE_LEVEL_CLIENT networking parameter, 17-45

TRACE_LEVEL_listener_name networking parameter, 17-48

TRACE_LEVEL_SERVER networking parameter, 17-46

TRACE_TIMESTAMP networking parameter, 17-51

TRACE_TIMESTAMP_CLIENT networking parameter, 17-46

TRACE_UNIQUE_CLIENT networking parameter, 17-46

Transparent Application Failover (TAF)

configuring, 15-18

GLOBAL_DBNAME networking parameter in listener.ora, 12-10, 15-22

overview, 2-8

with instance role, 15-27

Transparent Network Substrate (TNS)

benefits, 4-4

described, 4-4

transport layer, 4-3

TRCROUTE utility

described, 16-20

troubleshooting, 17-1 to 17-82

client, 17-4

contacting Oracle Support Services, 17-82

log files, 17-23

loopback tests, 17-4

questions, 17-22

server, 17-3

trace files, 17-23

using log file, 17-32

TTC. See Two-Task Common (TTC)

Turn Off UNIX Signal Handling option in Oracle Net Manager, 11-10

TWO_TASK environment variable, 16-8

Two-Task Common (TTC) presentation

dedicated server configurations, 4-15

described, 4-4

shared server configurations, 4-14

TYPE networking parameter, 10-21, 10-22, 15-21

Type of Service field in Oracle Net Manager, 15-8, 15-40

TYPE_OF_SERVICE networking parameter, 15-8, 15-40

U

UNREGISTER command, 9-58

Use for Heterogeneous Services option in Oracle Net Manager, 15-8, 15-39

Use Options Compatible with Net8 8.0 Clients option, 15-6

Use Oracle8i Release 8.0 Compatible Identification option, 15-8

USE_CMAN networking parameter, 11-7, 13-5

USE_DEDICATED_SERVER networking parameter, 11-7

USERID networking parameter, 10-21

V

V$SESSION table, 15-25

V1ADD.NPO.OMD Oracle Names record, 16-25

virtual circuits, 4-13

W

WebDAV presentation, 4-9

dedicated server configurations, 4-15

shared server configurations, 4-14

WebDAV protocol, 1-8

Welcome page in Oracle Net Configuration Assistant, 5-14

well-known Oracle Names servers, 3-35

Windows NT services

OracleHOME_NAMEClientCache service, 16-4

OracleHOME_NAMECMAdmin service, 4-16, 16-7

OracleHOME_NAMECMan service, 4-16, 16-7

OracleHOME_NAMENamesonames_server service, 16-3

OracleHOME_NAMETNSListener service, 16-5

wizards

Directory Server Migration, 5-12

Names, 5-13

Net Service Name, 5-11

Oracle Net Manager, 5-10 to 5-13

Y

ypserv program, 9-64