Oracle8
i
Generic Documentation Master Index
Release 2 (8.1.6)
A76991-01
Library
Product
Contents
Oracle8
i
Generic Documentation Master Index
N
N variable in SQLDA
how value is set, PC_ 15-7
purpose of, PC_ 15-7
name attribute, server resource, LEG 2-26
NAME column
SYS.INCEXP table, SUT 1-52
Name must be specified - error, ADQ D-6
name registration, DCI 2-10
name resolution, ADG 2-38,
LEG B-9,
PLS 2-37,
PLS D-1
distributed databases, DDS 1-22
impact of global name changes, DDS 1-42
schema objects, DDS 1-38
when global database name is complete, DDS 1-37
when global database name is partial, DDS 1-37
when no global database name is specified, DDS 1-37
in distributed databases, SCN 392
name resolution for procedures, SCN 62
name translation
for RMAN commands, RMN 1-7
Name, Object, ADQ 2-2
NAMED clause
of CREATE JAVA, SQL 7-313
named datatypes
binding, OCI 5-10,
OCI 12-2
binding and defining, OCI 12-6
defining, OCI 5-21,
OCI 12-4
definition, OCI 3-18
external datatypes, OCI 3-18
indicator variable for, OCI 2-32
indicator variables, OCI 2-33
named notation, PLS 7-13
Named Pipes protocol
described, NET 4-3
parameters for addresses, NET B-3
PIPE parameter, NET B-3
SERVER parameter, NET B-3
named user licensing, SCN 300
named user limits, SAD 22-5
setting initially, SAD 2-24
names
cursor, PLS 5-7
qualified, PLS 2-36
savepoint, PLS 5-45
variable, PLS 2-37
Names Wizard, NET 6-51,
NET 6-55
names, LSM administrators, LEG 2-28
names, of object classes, OID 6-7
NAMES_DID table, MIG F-18
NAMES_DOM table for Oracle Names, MIG F-18
NAMES.ADDRESSES parameter, NET 6-52,
NET 6-56,
NET C-59
NAMES.ADMIN_REGION parameter, MIG F-19,
MIG F-20,
NET 6-52,
NET C-59
NAMES.AUTHORITY_REQUIRED parameter, NET C-60
NAMES.AUTO_REFRESH_EXPIRE parameter, NET C-60
NAMES.AUTO_REFRESH_RETRY parameter, NET C-60
NAMES.CACHE_CHECKPOINT_FILE parameter, NET C-61
NAMES.CACHE_CHECKPOINT_INTERVAL parameter, NET C-61
NAMES.CONFIG_CHECKPOINT_FILE parameter, NET C-61
NAMES.CONNECT_TIMEOUT parameter, NET C-62
NAMESCTL utility, NET A-26
command reference, NET A-28 to
NET A-79
commands
DELEGATE_DOMAIN, NET A-28
DOMAIN_HINT, NET A-29
DUMP_LDAP, NET A-30
DUMP_TNSNAMES, NET A-33
EXIT, NET A-34
FLUSH, NET A-34
FLUSH_NAME, NET A-35
HELP, NET A-36
LIST_DELEGATED, NET A-37
LIST_DOMAINS, NET A-37
LIST_OBJECTS, NET A-38
LOAD_TNSNAMES, NET A-39
LOG_STATS, NET A-40
PASSWORD, NET A-40
PING, NET A-41
QUERY, NET 11-14,
NET A-42
QUIT, NET A-44
REGISTER, NET A-44
RELOAD, NET A-45
REORDER_NS, NET A-46
REPEAT, NET A-47
RESET_STATS, NET A-48
RESTART, NET A-48
SET, NET A-26,
NET A-49
SET CACHE_CHECKPOINT_INTERVAL, NET A-50
SET DEFAULT_DOMAIN, NET A-51
SET FORWARDING_AVAILABLE, NET A-51
SET LOG_FILE_NAME, NET A-52
SET LOG_STATS_INTERVAL, NET A-53
SET NAMESCTL_TRACE_LEVEL, NET A-54
SET PASSWORD, NET A-55
SET REQUESTS_ENABLED, NET A-56
SET RESET_STATS_INTERVAL, NET A-56
SET SAVE_CONFIG_INTERVAL, NET A-57
SET SAVE_CONFIG_ON_STOP, NET A-58
SET SERVER, NET A-59
SET TRACE_FILE_NAME, NET A-60
SET TRACE_LEVEL, NET A-60
SHOW, NET A-26,
NET A-61
SHOW CACHE CHECKPOINT_INTERVAL, NET A-62
SHOW DEFAULT_DOMAIN, NET A-63
SHOW FORWARDING_AVAILABLE, NET A-64
SHOW LOG_FILE_NAME, NET A-65
SHOW LOG_STATS_INTERVALE, NET A-65
SHOW NAMESCTL_TRACE_LEVEL, NET A-66
SHOW REQUEST_ENABLED, NET A-67
SHOW RESETS_STATS_INTERVAL, NET A-67
SHOW SAVE_CONFIG_INTERVAL, NET A-68
SHOW SAVE_CONFIG_ON_STOP, NET A-68
SHOW SERVER, NET A-69
SHOW STATS, NET A-69
SHOW SYSTEM_QUERIES, NET A-70
SHOW TRACE_FILE_NAME, NET A-70
SHOW TRACE_LEVEL, NET A-71
SHOW VERSION, NET A-72
SHUTDOWN, NET A-72
START, NET A-73
START_CLIENT_CACHE, NET 11-6,
NET A-75
STARTUP, NET A-75
STATUS, NET A-76
STOP, NET A-76
TIMED_QUERY, NET A-77
UNREGISTER, NET A-78
VERSION, NET A-79
confirmation mode, NET A-27
delegating domains, NET 6-73
described, NET 4-30
discovering Oracle Names servers, NET 6-59,
NET 6-61
distributed operation, NET A-27
function of and syntax format
global database links, NET 6-69
loading tnsnames.ora file into Oracle Names, NET 6-67
modes of operation, NET A-2
net service names, NET 6-66
querying objects, NET 11-14
starting an Oracle Names server, NET 11-5
testing network objects with, NET 11-14
testing the network, NET 11-3
NAMESCTL.INTERNAL_ENCRYPT_PASSWORD parameter, NET C-10
NAMESCTL.INTERNAL_USE parameter, NET C-11
NAMESCTL.NO_INITIAL_SERVER parameter, NET C-11
NAMESCTL.NOCONFIRM parameter, NET C-11
NAMESCTL.SERVER_PASSWORD parameter, NET C-11
NAMESCTL.TRACE_DIRECTORY parameter, NET C-12
NAMESCTL.TRACE_FILE parameter, NET C-12
NAMESCTL.TRACE_LEVEL parameter, NET C-12
NAMESCTL.TRACE_UNIQUE parameter, NET C-12
NAMES.DCE.PREFIX parameter, NET C-7
NAMES.DEFAULT_DOMAIN parameter, MIG F-4,
NET 6-7,
NET 6-63,
NET 8-18
NAMES.DEFAULT_FORWARDERS parameter, NET C-62
NAMES.DEFAULT_FORWARDERS_ONLY parameter, NET C-62
NAMES.DEFAULT_ZONE parameter, MIG F-4
NAMES.DEFAULT.DOMAIN parameter, NET C-8
NAMES.DIRECTORY_PATH parameter, OAS 14-19,
NET 8-20,
NET C-8
CDS, NET 8-20
HOSTNAME, NET 8-20
LDAP, NET 8-20
NDS, NET 8-20
NIS, NET 8-20
ONAMES, NET 8-20
TNSNAMES, NET 8-20
NAMES.DOMAIN_CHECKPOINT FILE parameter, NET C-80
NAMES.DOMAIN_HINTS parameter, NET C-62
NAMES.DOMAINS parameter, MIG F-18,
NET 6-53,
NET 6-54,
NET 6-58,
NET C-63
NAMES.FORWARDING_AVAILABLE parameter, NET C-63
NAMES.FORWARDING_DESIRED parameter, NET C-63
namesini.sql script, NET 6-51
namesini.sql script for Oracle Names, MIG F-25
NAMES.INITIAL_RETRY_TIMEOUT parameter, NET 6-63,
NET C-8
NAMES.KEEP_DB_OPEN parameter, NET C-64
names.log file
, NET 12-19
NAMES.LOG_DIRECTORY parameter, NET 12-21,
NET C-64
NAMES.LOG_FILE parameter, NET 12-21,
NET C-64
NAMES.LOG_STATS_INTERVAL parameter, NET C-64
NAMES.LOG_UNIQUE parameter, NET C-65
NAMES.MAX_OPEN_ CONNECTIONS parameter, NET 6-63
NAMES.MAX_OPEN_CONNECTIONS parameter, NET C-9,
NET C-65
NAMES.MAX_REFORWARDS parameter, NET C-65
NAMES.MESSAGE_POOL_ START_SIZE parameter, NET 6-63
NAMES.MESSAGE_POOL_START_SIZE parameter, NET C-9,
NET C-66
NAMES.NDS.NAME_CONTEXT parameter, NET 6-86
NAMES.NDS.NAME.CONTEXT parameter, NET C-9
NAMES.NIS.META_MAP parameter, NET C-9
NAMES.NO_MODIFY_RESPONSE parameter, NET C-66
NAMES.NO_REGION_DATABASE parameter, NET C-66
names.ora file
configuration parameter reference, NET C-59 to
NET C-69
obsolete parameters, NET C-80
parameters
NAMES.ADDRESSES, NET C-59
NAMES.ADMIN_REGION, NET C-59
NAMES.AUTHORITY_REQUIRED, NET C-60
NAMES.AUTO_REFRESH_EXPIRE, NET C-60
NAMES.AUTO_REFRESH_RETRY, NET C-60
NAMES.CACHE_CHECKPOINT_FILE, NET C-61
NAMES.CACHE_CHECKPOINT_INTERVAL, NET C-61
NAMES.CONFIG_CHECKPOINT_FILE, NET C-61
NAMES.CONNECT_TIMEOUT, NET C-62
NAMES.DEFAULT_FORWARDERS, NET C-62
NAMES.DEFAULT_FORWARDERS_ONLY, NET C-62
NAMES.DOMAIN_CHECKPOINT FILE, NET C-80
NAMES.DOMAIN_HINTS, NET C-62
NAMES.DOMAINS, NET C-63
NAMES.FORWARDING_AVAILABLE, NET C-63
NAMES.FORWARDING_DESIRED, NET C-63
NAMES.KEEP_DB_OPEN, NET C-64
NAMES.LOG_DIRECTORY, NET C-64
NAMES.LOG_FILE, NET C-64
NAMES.LOG_STATS_INTERVAL, NET C-64
NAMES.LOG_UNIQUE, NET C-65
NAMES.MAX_OPEN_CONNECTIONS, NET C-65
NAMES.MAX_REFORWARDS, NET C-65
NAMES.MESSAGE_POOL_START_SIZE, NET C-66
NAMES.NO_MODIFY_REQUESTS, NET C-66
NAMES.NO_REGION_DATABASE, NET C-66
NAMES.PASSWORD, NET C-66
NAMES.REGION_CHECKPOINT_FILE, NET C-67
NAMES.RESET_STATS_INTERVAL, NET C-67
NAMES.SAVE_CONFIG_ON_STOP, NET C-67
NAMES.SERVER_NAME, NET C-68
NAMES.TOPOLOGY_CHECKPOINT_FILE, NET C-80
NAMES.TRACE_DIRECTORY, NET C-68
NAMES.TRACE_FILE, NET C-68
NAMES.TRACE_FUNC, NET C-68
NAMES.TRACE_LEVEL, NET C-69
NAMES.TRACE_UNIQUE, NET C-69
NAMES.USE_PLUG_AND_PLAY, NET C-80
NAMESPACE column
V$LIBRARYCACHE table, STU 19-14
namespaces
and object naming rules, SQL 2-73
for nonschema objects, SQL 2-74
for schema objects, SQL 2-73
reserved by Oracle, PCO C-5
NAMES.PASSWORDS parameter, NET C-66
names
pid
.trc file, NET 12-39
NAMES.PREFERRED_SERVERS parameter, MIG F-4,
NET 8-26,
NET 8-27,
NET C-10
NAMES.REGION_CHECKPOINT_FILE parameter, NET C-67
NAMES.REQUEST_RETRIES parameter, NET 6-63,
NET C-10
NAMES.RESET_STATS_INTERVAL parameter, NET C-67
NAMES.SAVE_CONFIG_ON_STOP parameter, NET C-67
NAMES.SERVER_NAME parameter, NET 6-52,
NET 6-56
NAMES.SERVER_NAMES parameter, NET C-68
NAMES.TOPOLOGY_CHECKPOINT_FILE parameter, NET C-80
NAMES.TRACE_DIRECTORY parameter, NET 12-39,
NET C-68
NAMES.TRACE_FILE parameter, NET 12-39,
NET C-68
NAMES.TRACE_FUNC parameter, NET C-68
NAMES.TRACE_LEVEL parameter, NET 12-39,
NET C-69
NAMES.TRACE_UNIQUE parameter, NET 12-39,
NET C-69
names.trc file, NET 12-34
namesupg.sql script, NET 6-51
namesupg.sql script for Oracle Names, MIG F-18,
MIG F-20,
MIG F-23,
MIG F-25
NAMES.USE_PLUG_AND_PLAY parameter, NET C-80
naming
host variables, PCO 2-16
of cursors, PC_ 6-12
of database objects, PC_ F-11,
PCO F-10
of select-list items, PC_ 15-5
of SQL*Forms user exits, PC_ 20-13
select-list items, PCO 11-4
naming backup sets, RMN 1-35
naming contexts
and distributed directories, OAS 17-4,
OID 2-10
in partitioned directories, OID 2-18
in replication, OID 2-13,
OID 10-2
subordinate, OID 2-19
naming conventions, DCI 2-8,
PLS 2-36
configuration files, DCI 2-7
cursor, PCO 5-13
default database, PCO 3-5
error messages, DCI 2-6
globals, DCI 2-5
host variable, PCO 2-8
installation directory, DCI 2-6
message files, DCI 2-6
name format, DCI 2-9
need for, DCI 2-8
registering a name with Oracle, DCI 2-10
schema, DCI 2-5
shared libraries, DCI 2-7
naming database objects, NLS 3-16
naming directory entries, OAS 17-3,
OID 2-2
naming methods
CDS, NET 2-37,
NET 6-79
Cell Directory Services, NET 2-37,
NET 6-79
centralized, NET 6-4
choosing, NET 5-3
described, NET 2-34
directory naming, NET 2-35,
NET 6-16 to
NET 6-46
external naming, NET 2-37,
NET 4-24,
NET 6-79 to
NET 6-88
host naming, NET 2-36,
NET 6-74 to
NET 6-78
local naming, NET 2-35,
NET 6-5 to
NET 6-15
localized, NET 6-4
NDS, NET 2-37,
NET 6-79
Network Information Service, NET 2-37,
NET 6-79
NIS, NET 2-37,
NET 6-79
Novell Directory Services, NET 2-37,
NET 6-79
Oracle Names, NET 2-36,
NET 6-47 to
NET 6-74
prioritizing order, NET 8-19
naming model
hierarchical, NET 4-17
single domain, NET 4-16
namingContexts, OID 5-18
NATIONAL CHAR datatype (ANSI), SQL 2-28
NATIONAL CHAR VARYING datatype (ANSI), SQL 2-28
NATIONAL CHARACTER datatype (ANSI), SQL 2-28
national character datatypes, PLS 2-20
national character set, PLS 2-20
fixed vs. variable width, SQL 2-15,
SQL 2-16
in Oracle8
i
, MIG 9-28
multibyte character data, SQL 2-26
multibyte character sets, SQL 2-15,
SQL 2-16
parameter, NLS 2-34
variable-length strings, SQL 2-16
NATIONAL CHARACTER SET clause
of CREATE DATABASE, SQL 7-271
NATIONAL CHARACTER SET parameter
of ALTER DATABASE, SQL 7-16
NATIONAL CHARACTER VARYING datatype
ANSI, SQL 2-28
national language support, GTK 3-43
NCLOBs, ADL 2-2,
SPR 18-3
National Language Support (NLS), PC_ 4-48,
PCO 4-35,
PLS 2-20
architecture, NLS 1-2
bulkdelete, OID 11-9
bulkload, OID 11-8
bulkmodify, OID 11-9
character sets for, SCN 12-6
CHECK constraints and, SCN 271
clients and servers may diverge, SCN 417
client/server architectures, DDS 1-48
command line tools, OID 11-5
DATE datatype and partitions, SCN 11-12,
SCN 11-21
distributed databases
clients and servers may diverge, DDS 1-47
heterogeneous systems, DDS 1-49
homogeneous systems, DDS 1-48
Export, SUT 1-54
Heterogeneous Services, DDS A-6
character set of non-Oracle source, DDS A-8
date format, DDS A-7
languages in character date values, DDS A-7
Import, SUT 2-52
Java clients
ldapadd, OID 11-6
ldapaddmt, OID 11-6
ldapbind, OID 11-6
ldapcompare, OID 11-6
ldapdelete, OID 11-6
ldapmoddn, OID 11-7
ldapmodify, OID 11-6
ldapmodifymt, OID 11-6
ldapsearch, OID 11-6
ldifwrite, OID 11-8
NCHAR and NVARCHAR2 datatypes, SCN 12-7
NCLOB datatype, SCN 12-14
NLS_LANGUAGE parameter, NLS 4-4
parameters, SCN 5-5
settings for Oracle Internet Directory, OID 11-2
SQL*Loader, SUT 5-30
views and, SCN 10-15
national language support (NLS), DCI 2-12
national language support.
See
NLS
NATIVE
value of DBMS option, PC_ 10-16
native authentication for directory naming, NET 2-51
native authentication on Windows NT, GTK 3-77
native datatypes
and SQL*Loader, SUT 5-59
conflicting length specifications
SQL*Loader, SUT 5-68
native dynamic SQL
advantages of, ADG 8-13
compatibility, MIG 9-13
differences with DBMS_SQL package, ADG 8-12
downgrading, MIG 13-34
fetching into records, ADG 8-16
interoperability, MIG 9-30
performance, ADG 8-15
See Also
dynamic SQL
user-defined types, ADG 8-16
native dynamic SQL. See dynamic SQL
native interface, PC_ 5-55
NATURAL subtype, PLS 2-13
NATURALN subtype, PLS 2-13
navigating Oracle Directory Manager, OID 4-7
navigation, OCI 13-17,
ADQ 2-6
navigational access sample program, PC_ 17-24
navigational functions
error codes, OCI 16-6
return values, OCI 16-5
terminology, OCI 16-4
Navigator pane, in Oracle Directory Manager, OID 4-7
Navigator window
Oracle Parallel Server folder, PSG 7-3
Oracle Parallel Server objects, PSG 7-3
Parallel Server Instances folder, PSG 7-5
right-mouse menu, PSG 7-5,
PSG 7-12
Connect, PSG 7-6
Disconnect, PSG 7-6
Edit, PSG 7-6,
PSG 7-16
Related Tools, PSG 7-6
Remove, PSG 7-6
Results, PSG 7-6
Shutdown, PSG 7-6,
PSG 7-9
Startup, PSG 7-6,
PSG 7-7
starting Oracle Parallel Server database, PSG 7-7
stopping Oracle Parallel Server database, PSG 7-9
viewing Oracle Parallel Server status, PSG 7-16
viewing shutdown results, PSG 7-12
viewing startup results, PSG 7-12
NCHAR
issues, OCI 5-31
migration, MIG 9-28
use in Oracle8
i
, MIG 9-28
NCHAR and NLS environment variables
compatibility, MIG 9-28
NCHAR data
Export, SUT 1-56
NCHAR datatype, ADG 3-2,
ADG 3-5,
GTK 4-15,
PLS 2-20,
SCN 12-7,
SQL 2-15
ANSI, SQL 2-28
NCHAR VARYING datatype (ANSI), SQL 2-28
NCLOB, DCI 6-2
datatype, OCI 3-21
NCLOB datatype, PLS 2-23,
SCN 12-14,
SQL 2-26
transactional support of, SQL 2-26
NCLOB support, REP A-7
NCLOBs
compatibility, MIG 9-26
datatype, ADL 2-2
DBMS_LOB, offset and amount parameters in characters, ADL 3-7
loading, SUT 5-98
modify via DBMS_LOB, ADL 3-8
varying-width, ADL 2-4
NCR, SMS 32-1
NDS external naming, NET 2-37,
NET 6-79,
NET 8-20
connecting with, NET 6-83
establishing a connection with, NET 6-83
negative numbers
loading, SUT 4-15
negative scale, SQL 2-18
nested column objects
loading, SUT 5-92
nested files, SRF 1-45
nested loop joins, DWG 18-35
nested loops joins, STU 4-50
cost-based optimization, STU 4-59
nested materialized views, DWG 8-23
refreshing, DWG 14-26
restrictions, DWG 8-24
NESTED precompiler option, PCO A-3
nested programs, PCO A-7
support for, PCO 2-23
nested queries, DWG 18-49
nested table
element ordering, OCI 11-21
functions for manipulating, OCI 11-20
NESTED TABLE clause
of ALTER TABLE, SQL 7-142
of CREATE TABLE, SQL 7-386,
SQL 7-400
nested table types, SQL 2-31
compared with varrays, SQL 2-35
comparison rules, SQL 2-35
creating, SQL 7-439
dropping the body of, SQL 7-508
dropping the specification of, SQL 7-506
modifying, SQL 7-145
nested tables, ADO 1-9,
ADO 6-14,
PC_ 18-2,
SCN 10-10,
SCN 13-12
changing returned value, SQL 7-145
collection locators, GTK 3-34
compatibility, MIG 9-11,
MIG 9-29
COMPRESS clause, ADO 6-16
creating, SQL 7-444
creating indexes on, ADO 6-17
creation, PC_ 18-2
data stored in indexed-organized table, GTK 3-34
defining as index-organized tables, SQL 7-142
DML operations on, ADO 6-19
exporting, SUT 1-59
consistency and, SUT 1-17
importing, SUT 2-56
in an index-organized table, ADO 6-15
indexes, ADO 2-4
index-organized tables, SCN 10-41
key compression, SCN 10-33
INSTEAD OF triggers, ADO 5-11,
SCN 14-5
manipulating, PLS 4-13
OCICollIsLocator(), GTK 3-34
querying, ADO 9-18
restrictions, SCN 186
returning as locators, ADO 6-18,
ADO 9-30
storage, ADO 6-14,
ADO 9-29
storage characteristics of, SQL 7-142,
SQL 7-400
storage parameters for, SAD 12-12
triggers on view columns, GTK 3-35
uniqueness in, ADO 9-30
updating in views, ADO 5-11,
SCN 14-5
user-specified storage clauses for, GTK 3-34
UTL _COLL package, GTK 3-34
versus index-by tables, PLS 4-3
vs VARRAY, ADO 9-18
vs varrays, ADO 9-15
NESTED_TABLE_ID, ADO 6-17,
ADO 9-29
NESTEDprecompiler option, PCO 14-31
nesting
block, PLS 1-3
FOR loop, PLS 3-14
object, PLS 9-7
record, PLS 4-43
net service name, OID 3-2,
OID 3-3
Net Service Name Wizard, NET 6-7,
NET 6-23
net service names
adding an address, NET 8-2
configure an Oracle Connection Manager address, NET 8-39
creating in Oracle Names, NET 6-66
directory naming, NET 6-23
external naming, NET 2-37,
NET 6-79
external procedures, NET 8-48
local naming, NET 2-35,
NET 6-6
multiple addresses, NET 8-2,
NET 8-4
Oracle Names, NET 2-36,
NET 6-65
prioritizing naming methods, NET 8-19
testing with TNSPING, NET 11-19
NET_CONFIG_METHOD parameter, NET C-79
Net8, OID 2-31,
OID 2-33,
GTK 3-64,
GTK 3-70,
GTK 3-75,
SCN 1-19,
SCN 1-36,
SCN 6-5,
SUT 1-53
applications and, SCN 6-5
client/server systems use of, SCN 6-5
coexistence issues, MIG F-5 to
MIG F-11
Oracle Names, MIG F-11
release 8.0 client connection to release 8.1 database, MIG F-6
release 8.1 client connection to release 8.0 database, MIG F-9
release 8.1 client connection to release 8.1 database, MIG F-5
release 8.1 client connection to version 7 database, MIG F-9
third-party Oracle7 applications, MIG F-8
using SERVICE_NAME, MIG F-7
using SID, MIG F-7
using the Net8 Assistant, MIG F-11
compared with SQL*Net, MIG F-2
concept described, NET 1-2
concurrent logons, PCO 3-3
connect operations, NET 2-3
connecting to Oracle via, PC_ 3-7
connection load balancing, MIG 9-47
connection syntax, PC_ 3-6
control utilities, NET 11-3
dynamic (connection) load balancing, GTK 3-77
exception operations, NET 2-7
FAILOVER option, REP 6-10
FAILOVER parameter, MIG F-11
for concurrent connections, PC_ 3-7
function of, PC_ 3-6
JDBC drivers, NET 3-11
listener.ora file with Oracle Enterprise Manager, MIG F-15
LOAD_BALANCE parameter, MIG F-11
migrating or upgrading to, MIG 8-13,
MIG 9-46
multi-threaded server requirement, SCN 8-14,
SCN 8-16
NAMES.DEFAULT_DOMAIN parameter, MIG F-4
NAMES.PREFERRED_SERVERS parameter, MIG F-4
native authentication on Windows NT, GTK 3-77
Net8 Assistant, GTK 3-75
Use Options Compatible with Net8 8.0 Clients option, MIG F-11
Use Oracle8
i
Release 8.0 Compatible Identification option, MIG F-11
Net8 Easy Config, GTK 3-75
obsolete parameters, MIG F-4,
MIG F-14
COMMUNITY parameter, MIG F-4
NAMES.DEFAULT_ZONE parameter, MIG F-4
operations, NET 2-7
overview, NET 1-2
overview of, SCN 6-5
preparing for replication, OID 10-4
primary functions, NET 2-7
service names in, SAD 7-15
service naming, MIG 9-47,
GTK 3-75
downgrading, MIG 13-50
SERVICE_NAME parameter, MIG F-6
SOURCE_ROUTE parameter, MIG F-11
transmitting archived logs via, SAD 7-15
upgrading
configuration files, MIG F-13
listener.ora file, MIG F-15
software on client, MIG F-13
software on server, MIG F-13
sqlnet.ora file, MIG F-14
tnsnames.ora file, MIG F-14
to Oracle Connection Manager release 8.1, MIG F-16
to Oracle Names release 8.1, MIG F-17
to release 8.1, MIG F-12 to
MIG F-15
verify service name and instance name, MIG F-12
using ROWID datatype, PCO 4-9
using to connect to Oracle, PCO 3-4
Net8 access control, NET 4-8,
NET 8-35
Net8 Assistant, NET 8-52,
STU 22-17
adding addresses, NET 8-2
clients
client load balancing, NET 8-4
connect-time failover, NET 8-4
default network domains, NET 8-17
local naming method, NET 6-7
Oracle Connection Manager, NET 8-39
Default Domain field, NET 6-63
delegating domains to administrative regions, NET 6-73
described, NET 4-28
directory naming, NET 2-43
Directory Server Migration Wizard, NET 6-32
discovering Oracle Names servers, NET 6-61
external procedure connections, NET 8-45
Heterogeneous Services connections, NET 8-49
Instance Name field, NET 8-9
listeners
Configure Prespawned Servers dialog box, NET 7-19
configuring, NET 7-5
Database Services tab, NET 7-14
Global Database Name field, NET 7-13,
NET 8-9,
NET 8-52
Maximum Prespawned Servers field, NET 7-16
non-default through Oracle Names, NET 7-11
Oracle Home Directory field, NET 8-47,
NET 8-49
Oracle Home Directory field for listeners, NET 7-13
prespawned dedicated servers, NET 7-18
Program Name field, NET 8-47,
NET 8-49
protocol addresses, NET 7-6
Register Service with Oracle Names option, NET 6-64
registering database information with Oracle Names, NET 6-64
SID field, NET 7-13
static service information, NET 7-13
local naming method, NET 6-7
log files, NET 12-22
multiple address options, NET 8-4
Names Wizard, NET 6-51,
NET 6-55
Net Service Name Wizard, NET 6-7,
NET 6-23
net service names, NET 6-7
Oracle Names
aliases, NET 6-72
Attempts Per Names Server field, NET 6-63
Default Domain field, NET 6-63
discovering, NET 6-61
global database link qualifiers, NET 6-70
global database links, NET 6-69
Initial Preallocated Requests field, NET 6-63
Maximum Open Connections field, NET 6-63
Maximum Wait Each Attempt field, NET 6-63
net service names, NET 6-66
non-default listener, NET 7-11
preferred Oracle Names servers, NET 8-26
querying network objects, NET 11-14
region database, NET 6-51
registering database information from listener, NET 6-64
starting Oracle Names servers, NET 11-14
Oracle Rdb Database, NET 8-53
Oracle RDB Database field, NET 8-9
profiles
advanced options, NET 8-23
Always Use Dedicated Server option, NET 8-21
Client Registration ID field, NET 8-23
Disable Out-of-Band Break option, NET 8-24
naming method specification, NET 8-19
Prefer Connection Manager Routing option, NET 8-21
preferred Oracle Names servers, NET 8-26
routing connections, NET 8-21
TNS Time Out Value option, NET 8-23
Turn Off UNIX Signal Handling option, NET 8-23
RDB Database field, NET 8-52
routing connection requests, NET 8-21
Session Data Unit (SDU) field in Net8 Assistant, NET 8-9
SID field for listeners, NET 8-47,
NET 8-49
specifying naming methods, NET 8-19
starting, NET 4-28
starting an Oracle Names server, NET 6-59,
NET 11-5
testing
client configuration, NET 11-22
server configuration, NET 11-15
Timeout field, NET 7-17
trace files, NET 12-40
Type of Service field, NET 8-9
Use for Heterogeneous Services option, NET 8-9,
NET 8-51
Net8 Assistant, described, MIG F-2
Net8 Client, described, NET 4-2
Net8 Configuration Assistant, GTK 2-4,
GTK 3-77
clients
administrative context selection, NET 6-19
directory access, NET 6-21
local naming method, NET 6-11
Custom installation, PSG 3-6
described, NET 4-27
listener configuration, NET 7-4
local naming method, NET 6-11
net service names, NET 6-11
OracleDBCreators group, NET 2-44,
NET 2-53,
NET 6-22
OracleNetAdmins group, NET 2-52,
NET 6-22
OracleSecurityAdmins group, NET 2-53,
NET 6-22
servers
administrative context selection, NET 6-19
directory access, NET 6-22
Oracle Context creation, NET 2-43,
NET 6-22
Oracle schema creation, NET 6-22
starting, NET 4-27
Typical installation, PSG 3-5
using during installation, PSG 3-6
Net8 Configuration Assistant, described, MIG F-2
Net8 Firewall Proxy, NET 4-8
Net8 listener, DDS 6-5,
DDS 7-2
Net8 Native Authentication, OAS 8-15
Net8 OPEN
API function calls, NET 10-3
compatibility with C language, NET 10-3
configuration requirements, NET 10-7
configuring system to use applications, NET 10-8
error messages, NET 10-9
finding API, NET 10-7
for distributed applications, NET 10-2
integrating with non-SQL information, NET 10-2
library, NET 10-7
sample applications, NET 10-9
Net8 Server, described, NET 4-2
../../network.816/a76933, SCN 383
Netscape Communications Corporation, OAS 10-2
network
array interface, STU 22-16
authentication, SAD 22-11
bandwidth, OID 12-14,
STU 16-6
capacity planning, OID 12-14
communicating over, PC_ 3-6
connectivity, in capacity planning, OID 12-2
constraints, STU 16-6
detecting performance problems, STU 22-9
prestarting processes, STU 22-6
problem solving, STU 22-11
protocols, PC_ 3-6
reducing traffic, PC_ C-4
requirements, OID 12-14
Session Data Unit, STU 22-16
tuning, STU 22-1
network authentication, SAD 22-11
Network Authentication (NA)
layer in error stacks, NET 12-17
network character set, keyword values, NET C-4
network configuration
centralized management, NET 6-4
localized management, NET 6-4
network configuration files
ldap.ora.ora, PSG 3-16
listener.ora, PSG 3-14,
PSG 3-40,
PSG 6-6
Oracle Enterprise Manager service discovery, PSG C-4
sqlnet.ora, PSG 3-21,
PSG 3-40
testing, PSG 4-3
tnsnames.ora, PSG 3-16,
PSG 3-40
Oracle Enterprise Manager service discovery, PSG C-5
network connections
minimizing, DDS 2-14
/network directory, PSG A-3
Network Encryption (NAE), layer in error stacks, NET 12-17
network files
configuring, SBY 2-27,
SBY 5-4
Network Information Service external naming, NET 2-37,
NET 4-24,
NET 8-20
configuring, NET 6-79
connecting with, NET 6-79
establishing a connection with, NET 6-79
Network Interface (NI)
described, NET 3-8
layer in error stacks, NET 12-17
Network Interface Cards (NICs), failures of, OID 14-8
network listener process, SCN 6-6
connection requests, SCN 8-14,
SCN 8-16
dedicated server example, SCN 8-26
multi-threaded server example, SCN 8-22
service names, SCN 6-6
Network Naming (NN)
layer in error stacks, NET 12-17
network performance, improving
by adjusting SDU size, NET 5-8
by client load balancing, NET 5-8
client load balancing, NET 2-20,
NET C-40
connection concentration, NET 5-7
connection pooling, NET 2-12,
NET 5-6
listener queuesize, NET 5-6
Network Program Interface (NPI), NET 3-9
Network Routing (NR)
layer in error stacks, NET 12-17
Network Security
DES_40 encryption, NET 4-26
described, NET 4-26
MD5 checksumming, NET 4-26
RC4_128 encryption, NET 4-26
RC4_40 encryption, NET 4-26
RC4_56 encryption, NET 4-26
Network Services (NA), layer in error stacks, NET 12-17
Network Session (NS)
described, NET 3-8
Network Session (NS), layer in error stacks, NET 12-17
network traffic
reducing, PLS 1-22
Network Transport (NT), layer in error stacks, NET 12-17
NetWorker
label template, using, LEG C-1
name resolution, LEG B-9
naming requirements, LEG B-5
services, LEG B-10
NetWorker server
restarting, LEG 5-15
shutting down, LEG 5-15
NetWorker User program, LEG D-1
privileges, LEG D-1
starting, LEG D-1
network-level connection redirection, OID 14-6
network-level failover, OID 14-5
networks
client/server architecture use of, SCN 6-2
communication protocols, SCN 6-5,
SCN 8-28
dispatcher processes and, SCN 8-14,
SCN 8-16
distributed databases use of, DDS 1-2,
SCN 372
drivers, SCN 8-28
Export, SUT 1-53
failure of, SBY 5-40
failures of, SCN 343
Import and, SUT 2-47
listener processes of, SCN 6-6,
SCN 8-14
Net8, SCN 6-5
network authentication service, SCN 282
transporting Export files across a network, SUT 1-53
two-task mode and, SCN 8-24,
SCN 8-25
using Oracle on, SCN 1-19,
SCN 1-36
NEVER clause, DWG 8-20
NEVER REFRESH mode
materialized views and downgrading, MIG 13-17
NEW correlation name, ADG 13-16
new features, OAS 17-1,
OCI 1-12,
SPR xcvii,
PSA iii,
PSC xv
adding after migration or upgrade, MIG 8-8
autolocate option, RMN xxiii
benefits, OCI 1-12
centralized user and privilege management, DDS xxxiv
client load balancing, NET xviii
configure compatible command, RMN xxiv
connection load balancing, NET xviii
connect-time failover, NET xviii
create catalog command, RMN xxv
crosscheck commands, RMN xxiv
data corruption protection, SBR xxiv
data subsetting and subqueries, REP A-6
direct hand-off, NET xviii
directory naming, NET xviii
drop catalog command, RMN xxv
duplexed backup sets, RMN xxv
duplicate command, RMN xxv
encryption algorithm changes, OAS 2-2
enhanced security, REP A-8
FIPS 140-1, OAS D-1
for management and use, REP A-7
generic connectivity, DDS xxxiii
Heterogeneous Services initialization parameters, DDS xxxiv
improved mass deployment support, REP A-2
improved Oracle8
i
Lite integration, REP A-5
improved security, REP A-4
introduction, OCI 1-12
Java SSL, OAS F-1
LOB support, REP A-7
LOG_ARCHIVE_DEST_
n
parameter, SBR xxv
media management API 2.0, RMN xxiv
Net8 Configuration Assistant, NET xix
Oracle Connection Manager, NET xix
Oracle Enterprise Login Assistant, OAS 19-1
Oracle Enterprise Security Manager, OAS 20-1
Oracle Replication Manager enhancements, REP A-4
Oracle Wallet Manager, OAS 18-1
parallel DML and DDL, DDS xxxiv
performance enhancements, REP A-2,
REP A-5
RADIUS authentication, OAS 4-1
remove records from recovery catalog, RMN xxiv
replication, REP A-1