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-36, 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-31

delegated, under root, 3-33

delegating domains, 9-53

described, 3-25

domain hints to remote, 9-55

in Oracle Names, 3-25

root, 3-31

alert log

ORA-3113 error message, 17-19

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

script for using information, 17-35

authentication

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

B

BACKGROUND_DUMP_DEST initialization parameter, 17-19

BACKUP networking parameter, 15-21

BASE networking parameter, 10-21

Bequeath protocol, 2-13

BEQUEATH_DETACH networking parameter, 11-9

buffer flushing, described, 7-16

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

described, 2-17

establishing a connection with, 3-2

recommended for, 7-13

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

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

trace files, 17-46

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

cmadm_pid.trc file, 17-45

CMADMIN process, 4-17

cmadmpid.log file, 17-29

cmadmpid.trc file, 17-45

CMAN networking parameter, 13-4

CMAN_ADMIN networking parameter, 13-4

cman_pid.log file, 17-29, 17-40

cman_pid.trc file, 17-45

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

TRACE_DIRECTORY, 17-55

TRACE_FILELEN, 17-55

TRACE_FILENO, 17-55

TRACE_TIMESTAMP, 17-55

TRACING, 17-55

setting up, 13-3

cmanpid.log file, 17-29

cmanpid.trc file, 17-45

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

connect-request timeouts, 15-43

database servers

access control, 11-8

connect-request timeouts, 15-43

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

connect-request timeouts, 15-43

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

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

connect-request timeouts, 15-43

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-8, 7-15, 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, 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-15

Database Configuration Assistant

directory naming, 3-12

shared server configuration, 14-2

database links, 3-27, 9-49

global database link, 3-27

private database, 3-27

public database, 3-27

database server configuration

access control, 11-8

allocating resources with shared server, 14-9

connect-request timeouts, 15-43

creating a repository for Oracle Names, 3-26

discovering Oracle Names servers, 9-38

local naming, 9-6

log files, 17-30

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

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

domains to, 9-53

in Oracle Names, 3-31

under root, 3-33

denial-of-service attacks, 15-43

DESCRIPTION parameter, 9-5

diagnosing. See troubleshooting

direct hand-off

described, 2-10

events in listener.log, 17-39

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

absolute naming, 3-16

advantages and disadvantages, 7-12

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

ldap.ora file

creating, 8-3

described, 3-14

ldapwrite tool, 17-20

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

security, 3-17

troubleshooting, 17-20

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

ldapwrite tool, 17-20

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

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

required by root administrative regions, 3-31

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

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

Dynamic Discovery Option, 3-34

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

in trace file, 17-60

NNL-00018, 9-32

NNL-00024, 9-32

NNO-00062, 17-21, 17-22

NNO-00850, 17-21, 17-22

ORA-00508, 17-14

ORA-1017, 17-3

ORA-1034, 17-3

ORA-12154, 17-10

ORA-12170, 15-43, 17-11

ORA-12198, 17-12

ORA-12203, 17-12, 17-13, 17-14, 17-23

sample error stack, 17-27

ORA-12224, 17-15

ORA-12514, 17-15

ORA-12520, 17-16

ORA-12521, 17-16

ORA-12525, 15-43, 17-17

ORA-12533, 17-15

ORA-12535, 17-23

ORA-12538, 17-14

ORA-12545, 17-18

ORA-12547, 15-43, 17-23

ORA-12560, 17-18

ORA-12637, 15-43

ORA-3113, 17-19

ORA-3121, 17-19

resolving, 17-1 to 17-86

using log file to track, 17-34

error stack

described, 17-26

entries in log files, 17-34

sample, 17-27

typical layers in, 17-26

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

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

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-request timeouts, xxxv

connect-time failover, xl

creating multiple Oracle Contexts, xxxvii

direct hand-off, xli

directory naming, xl

directory naming access control, xxxiv

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

password requirement for Listener Control utility STATUS command, xxxv

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-27, 9-49

adding link qualifiers, 9-50

directory naming limitation, 10-6

Oracle Names, 9-49

global database name

configuring on the listener, 12-15

defined, 9-3

described, 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-29

diagram, 3-29

host naming

advantages and disadvantages, 7-13

configuring, 9-60 to 9-63

connecting with, 9-63

establishing a connection with, 9-63

listener configuration for, 9-61

recommended for, 7-13

requirements, 9-60

HOST networking parameter, 10-21

hosts file, 3-34

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

INBOUND_CONNECT_TIMEPUT_listener_name networking parameter, 15-43

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

initialization parameter file

BACKGROUND_DUMP_DEST parameter, 17-19

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

ldap.ora file

creating, 3-14, 8-3

described, 3-2

ldapwrite tool, 17-20

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

listener.ora file

described, 3-2

parameters

ENVS, 15-34

GLOBAL_DBNAME, 12-10

INBOUND_CONNECT_TIMEOUT_listener_name, 15-43

LOG_DIRECTORY_listener_name, 17-31

LOG_FILE_listener_name, 17-31

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

PASSWORDS_listener_name, 12-13

PROGRAM, 15-34, 15-37

SID_NAME, 12-10, 15-34, 15-37

STARTUP_WAITTIME_listener_name, 17-52

TRACE_FILE_listener_name, 17-52

TRACE_FILELEN_listener_name, 17-52

TRACE_FILENO_listener_name, 17-53

TRACE_LEVEL_listener_name, 17-52

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

Oracle JServer access, 12-8

Oracle Names, 9-45

Oracle System Identifier, 12-10

protocol addresses, 12-6

service information, 12-9

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-31, 17-35

audit trail, 17-35

direct hand-off event information, 17-39

service registration event information, 17-37

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-8, 7-15

redirect connections, 2-10

security

connect-request timeouts, 15-43

password usage, 12-13

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

testing configuration, 16-16

trace files, 17-52

Transparent Application Failover (TAF), 2-8

listener.trc file, 17-45

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

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

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-30, 17-35

cmadm_pid.log, 17-29, 17-32

cmadmpid.log, 17-29, 17-32

cman_pid.log, 17-29, 17-32, 17-40

cmanpid.log, 17-29, 17-32

default names for, 17-29

listener.log, 17-29, 17-31

names.log, 17-29, 17-31

sqlnet.log, 17-29

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

using to track errors, 17-34

LOG_DIRECTORY_CLIENT networking parameter, 17-30

LOG_DIRECTORY_listener_name networking parameter, 17-31

LOG_DIRECTORY_SERVER networking parameter, 17-30

LOG_FILE_CLIENT networking parameter, 17-30

LOG_FILE_listener_name networking parameter, 17-31

LOG_FILE_SERVER networking parameter, 17-30

LOG_LEVEL networking parameter, 17-32

loopback test, 17-4

LU6.2 protocol, xl

M

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

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

NAMESCTL.TRACE_FILE networking parameter, 17-51

NAMESCTL.TRACE_LEVEL networking parameter, 17-51

NAMESCTL.TRACE_TIMESTAMP networking parameter, 17-51

NAMESCTL.TRACE_UNIQUE networking parameter, 17-51

namesctl.trc file, 17-45

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

NAMES.LOG_DIRECTORY networking parameter, 17-31

NAMES.LOG_FILE networking parameter, 17-31

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

NAMES.LOG_FILE, 17-31

NAMES.TRACE_DIRECTORY, 17-54

NAMES.TRACE_FILE, 17-54

NAMES.TRACE_LEVEL, 17-54

NAMES.TRACE_TIMESTAMP, 17-54

NAMES.TRACE_UNIQUE, 17-54

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

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

NAMES.TRACE_FILE networking parameter, 17-54

NAMES.TRACE_LEVEL networking parameter, 17-54

NAMES.TRACE_TIMESTAMP networking parameter, 17-54

NAMES.TRACE_UNIQUE networking parameter, 17-54

names.trc file, 17-45

namesupg.sql script, 9-27

naming methods

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

centralized, 3-2

choosing, 7-6, 7-12

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

single domain, 3-28

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

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

network layer, 4-2

Network Naming (NN)

layer in error stacks, 17-26

network performance, improving

by adjusting SDU size, 7-15

client load balancing, 2-9

listener queue size, 7-8, 7-15

network planning

session data unit (SDU) size, 7-15

Network Routing (NR)

layer in error stacks, 17-27

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

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

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

client load balancing, 7-6

connection pooling, 7-3

connect-time failover, 7-6

JDBC drivers, 7-7

listener queue size, 7-8

naming methods, 7-6

protocol conversion, 7-8

scalability, 7-3

security, 7-7

session data unit (SDU) size, 7-8

session multiplexing, 7-3

tuning and performance, 7-8

Internet networks

access control, 7-11

availability, 7-10

connect-request timeouts, 7-11

JDBC drivers, 7-10

naming methods, 7-10

scalability, 7-10

security, 7-11

tuning and performance, 7-11

new features

client load balancing, xl

connection load balancing, xli

connection load balancing for dedicated server configurations, xxxvii

connect-request timeouts, xxxv

connect-time failover, xl

creating multiple Oracle Contexts, xxxvii

direct hand-off, xli

directory naming, xl

directory naming access control, xxxiv

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

password requirement for Listener Control utility STATUS command, xxxv

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-21, 17-22

NNO-00850 error message, 17-21, 17-22

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

ORA-1017 error messages, 17-3

ORA-1034 error messages, 17-3

ORA-12154 error message, 17-10

ORA-12170 error message, 15-43, 17-11

ORA-12198 error message, 17-12

ORA-12203 error message, 17-12, 17-13, 17-14, 17-23

sample error stack, 17-27

ORA-12224 error message, 17-15

ORA-12514 error message, 17-15

ORA-12520 error message, 17-16

ORA-12521 error message, 17-16

ORA-12525 error message, 15-43, 17-17

ORA-12533 error message, 17-15

ORA-12535 error message, 17-23

ORA-12538 error message, 17-14

ORA-12545 error message, 17-18

ORA-12547 error message, 15-43, 17-23

ORA-12560 error message, 17-18

ORA-12637 error message, 15-43

ORA-3113 error message, 17-19

ORA-3121 error message, 17-19

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

cmadm_pid.log, 17-29

cmadmpid.log, 17-29

cman_pid.log, 17-29

cmanpid.log, 17-29

understanding, 17-40

overview, 1-29

processes, 4-16

routing connections, 11-7

shared server, 13-2

starting, 16-7

testing, 16-16

trace files, 17-55

cmadm_pid.trc, 17-45

cmadmpid.trc, 17-45

cman_pid.trc, 17-45

cmanpid.trc, 17-45

configuring, 17-56

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

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

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

described, 3-23

differences between versions, 3-33

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

discovery, 3-36

domains, 3-25

administering multiple, 9-31, 9-36

delegated, 9-53

hints to remote, 9-55

Dynamic Discovery Option, 3-34

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

installing, 9-24

listener configuration for, 9-45

log files, 17-31

migrating

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

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

multiple domains, 3-30

multiple regions, 3-30

namesini.sql script, 9-27

namesupg.sql script, 9-27

naming network components, 3-28

network domain, default, 3-30

querying objects, 16-25

recommended for, 7-13

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

.sdns.ora file, 3-36

sdns.ora file, 3-36

single domain naming mode, 3-28

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

net service names, 3-27

other Oracle Names server names and addresses, 3-27

trace files, 17-54

version 1, 3-33

version 2, 3-34

version 8, 3-35

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

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

delegated domains, 9-53

deleting, 9-58

described, 3-23

discovery, 9-37

domain hints, 9-55

log files, 17-31

preferred, 3-33, 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-31

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

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

well-known, 3-34

Oracle Net

buffers, 7-15, 7-16

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-34, 15-37

static service information, 12-9

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

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

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-69, 17-81

types of, 17-59

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

connection pooling, 7-3

connect-time failover, 7-6

JDBC drivers, 7-7

listener queue size, 7-8

naming methods, 7-6

protocol conversion, 7-8

scalability, 7-3