Understanding SQL*Net
Library
Product
Contents
Index
Index
@
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y
Z
@
.cdf files
.dat files
.trc files
.WORLD, default domain
3GL applications
making a connection to a server from
relinking
abnormal connection termination
access list, for Validnode Verification
additional connection request
ADDRESS keyword
[
2
]
example of
ADDRESS_LIST keyword
addresses
defining
non-global
protocol specific information in
administration, centralized vs. distributed
Advanced Networking Option, compatibility with SQL*Net OPEN
alias, defined
applications
peer-to-peer connectivity
use of Transparent Network Substrate
architecture
peer-to-peer
SQL*Net version 2
asynchronous operations
Audit Trail
authentication services
in Oracle Advanced Networking Option
network identity
network roles
purpose of
benefits, primary, of SNMP support
case sensitivity
in keyword-value pairs
in service names
catsnmp.sql script
character set, for service names
character sets, conversion, Two-Task Common
[
2
]
SQL*Net support
character set, used in network configuration files
client application, role in distributed processing
client profiles, definition of
client registration
Client Status Monitor
[
2
]
client types
client-server, multi-community connections
CMANAGER keyword
CMANAGER_LIST keyword
CMANAGER_NAME keyword
command line connections to a database
comments, in connect descriptors
COMMUNITY keyword
community, definition of
[
2
]
complete refresh, of snapshots
concurrent connections, increasing number of
configuration files, generating
configuring, SNMP support
CONNECT command, within SQL*Plus
connect descriptors
[
2
]
character set for
identified by service names
maximum length
usage
connect operations
disconnect
CONNECT_DATA keyword
[
2
]
definition of
[
2
]
example of
[
2
]
connecting to a server
connecting to a server from a 3GL program
connecting to the server with special tools
connection access, restricting
Connection Manager
connection process, distributed systems
connection qualifiers, for database links
[
2
]
connection requests, simultaneous, enabling larger number of
connection requests
adjusting queue size
extending size of backlog
connections
establishing with multi-threaded server
routing
to a multi-threaded server
controlling SNMP support, for network services
COPY command, in SQL*Plus
copying data, between databases
CREATE SESSION
CREATE SNAPSHOT command
creating, table snapshots
cross environment resolution, using Oracle Names for
data operations
asynchronous
SQL*Net
synchronous
database link
connection qualifiers for
[
2
]
CREATE command
[
2
] [
3
] [
4
] [
5
]
creating
database object
definition/creation of
DROP command
dropping links
finding available links
global with Oracle Names
maintaining location transparency
PUBLIC option
public with default connection
public with specific connection
database links
database link
using an alias and Oracle Names
using the data dictionary
database MIB variables
polling
values of
database parameter file
database servers, connecting to
database service names
database subagent, controlling
data
sent/received asynchronously
sent/received synchronously
datatype, internal representation
[
2
]
DBA_DBLINKS, data dictionary view
dead connection detection
[
2
]
dead man's handle
dedicated server
configuring an alias for
parameter for in SQLNET.ORA
prespawned
default domain
definition of
listed in the SQLNET.ORA file
when initiating a SQL*Net connection
[
2
]
diagnostic tools
[
2
]
directory location, example for SNMP.ORA
DISABLE_OOB=ON, parameter
disconnect
abnormal termination
additional connect request
user initiated
distinguishing SQL*Net verson1 from version 2
distributed database
distributed processing
client-side actions
protocol adapter's role
protocol's role
server's role
software components
SQL*Net
SQL*Net's role
Transparent Network Substrate's role
distributed queries, sample with an Interchange
distributed systems
connection process
prespawned servers
distributed transactions, SQL*Net's role
domain name, WORLD as default
domains, use in network names
domain, used in linkname
dropping table snapshots
Dynamic Discovery Option
[
2
]
creation of LISTENER.ORA
definition of
encrypted passwords
encryption digests, Transparent Network Substrate (TNS)
errors, in configuration
establishing a session
exception operations
interrupts
SQL*Net
execute, SQL routine
external authentication
connecting using
secure logins
externally authenticated logins, enabling
fast refresh, of snapshots
FAST variables
retrieving
fetch, SQL routine
global database links
[
2
]
global database name
[
2
]
defined in INIT.ORA
global name service, designating
heterogeneous networking
definition of
index numbers, assigning unique
INIT.ORA
initiating SQL*Net connections
installation options
Interchange
Interchange Control Utility, to start the Interchange
Interchange listener, increasing queue size
internal datatype representations
interrupts
IP addresses, specifying
IPC addresses
[
2
] [
3
]
turning off
keep alive
keyword-value pairs
keywords
for protocol adapters
hierarchy of
Listener Control Utility
[
2
]
sample STATUS
START command
starting the listener
[
2
] [
3
]
status of a listener
stopping the listener
[
2
]
syntax of use
use of
listener load balancing
[
2
] [
3
]
listener name, use in Listener Control Utility
listener process
wild-card listen
LISTENER.ORA
[
2
] [
3
] [
4
]
parameters for
[
2
]
sample file
specifying queue size
syntax of
listener, ADDRESS
[
2
]
concurrent connections for
controlling
default alias
[
2
]
expanding queue size
general syntax of address
[
2
]
multiple for a service
network vs native
prespawned servers
role in distributed processing
single address syntax
starting the
testing the
used with SQL*Net
using a non default alias
local name service, designating
LOCAL_COMMUNTIES keyword, sample entries
LOCAL_LOOKUP, as pointer to PROTOCOL.ORA
location transparency
[
2
]
definition of
logon screen, using the
logon, SQL routine
logs, table snapshots
LSNRCTL
RELOAD command
SERVICES command
SET PASSWORD command
START command
[
2
]
STATUS command
STOP command
TRACE command
[
2
]
VERSION command
[
2
] [
3
] [
4
]
media/topology independence
definition of
memory, reducing required
MIB variables
polling database
retrieved by database subagent
migration, from SQL*Net V2.0 to V2.1
MTS_LISTEN_ADDRESS, initialization parameter
multi-threaded server
[
2
]
and listener load balancing
connecting to a
establishing connections
multicommunity connections, limits with version 1
multicommunity network
multiple servers, testing
MultiProtocol Interchange
compatibility with SQL*Net OPEN
description
function of
limits with version 1
sample of use
testing the
to connect communities
use for client/server
used by TNS
used for server-server
name service, definition of
name services, advantages vs. disadvantages
[
2
]
benefits of
choosing for your environment
comparison of advantages
connecting to databases
Names server, starting
Names servers
testing
choosing nodes as
function of
NAMES.PREFERRED.SERVERS, listed in SQLNET.ORA file
NAMESCTL program
using the PING command
using the STARTUP command
naming model, two-tier
naming solutions
finding appropriate
Oracle Names and TNSNAMES.ORA as
National Language Support (NLS)
character set conversion
supported in SQL*Net
native naming adapters
connecting using
description of
supported
using
native naming services
connecting to databases
disadvantages of
loading service names into
using NATIVE.ORA to load service names
NATIVE.ORA, function of
NetFetch
network authentication adapters
network character set
[
2
]
network listener
role in distributed processing
Network Manager
choosing a node for
importance of using
planning required to use
preparing to use
network privileges
network roles
network transparency
definition of
network, naming
networks
addresses
SQL*Net operations
new user, role, grants, creating with catsnmp.sql
operating system authorized logins
OPI
Oracle Advanced Networking Option
description of
native naming adapters in
Oracle Card
Oracle Names
[
2
] [
3
]
advantages of using
as local or global service
choosing nodes as Names servers
functions of
Oracle Network Manager
Oracle Program Interface (OPI), role in distributed processing
Oracle Server, password
[
2
]
username
[
2
]
Oracle SID
[
2
] [
3
] [
4
] [
5
] [
6
]
Oracle Trace
description of
Oracle Worldwide Customer Support, the good folks at
Oracle7 Server
Oracle7, multi-threaded server
OTRCREP tool for formatting Oracle Trace files
out of band breaks, disabling
parse, SQL routine
passwords
encrypted
for the network listener
setting for LSNRCTL
peer-to-peer system, definition
performance tuning
adjusting SDU size
using listener load balancing
using prestarted processes
performance, measuring
PING command, using
PING, time to contact server
polling intervals
for database MIB variables
polling, database MIB variables
POOL_SIZE
LISTENER.ORA parameter
PREFERRED_CMANAGERS in TNSNAV.ORA
general form
keywords used in
PRESPAWN_LIST parameter, in LISTENER.ORA
PRESPAWN_MAX parameter, in LISTENER.ORA
[
2
] [
3
]
prespawned dedicated server
[
2
]
prespawned dedicated server processes
prespawned dedicated server, establishing a connection
privileges
creating snapshot logs
creating table snapshots
processing
distributed
protocol adapter's role
protocol's role
server's role
SQL*Net
SQL*Net's role
Transparent Network Substrate's role
protocol adapters
description
example of use
keywords for
role in distributed processing
used by TNS
[
2
]
protocol independence
PROTOCOL parameter
protocol specific address parameters
protocol specific keywords
PROTOCOL.ORA
protocols, role in distributed processing
proxy authentication, definition
proxy logons
Oracle recommendation
role of
warning against
queue size
adjusting for connection requests
increasing
increasing for Interchange listener
increasing for listener
increasing for Names Server
QUEUESIZE default, OS-specific
QUEUESIZE parameter
refreshing snapshots
complete
fast
relinking applications
REMOTE_OS_AUTHENT
setting
setting for external authentication
reserved symbols
resources, reducing rquired
response time, measuring
SDU
definition of
how to configure non-default size
how to determine optimal size
secure database links, definition of
Secure Network Services
secure protocol, using with externally-authenticated logins
security services, in Oracle Advanced Networking Option
security
during command line entries
using synonyms
sequenced cryptographic message digests, Transparent Network Substrate (TNS)
server ID (SID)
server-server
architecture
in multi-community network
server, connected to multiple communities
servers
connecting to
role in distributed processing
service name
character set for
relation to global database name
selecting
short name for connect descriptor
short name for connect descriptor
service names, more than one for an SID
service name
use in database links
use on command line
user vs. system
using on connect screen
Session Data Unit
sessions, establishing
SID
[
2
]
SID_DESC
[
2
]
SID_LIST
SID_NAME
[
2
]
SID, as part of CONNECT_DATA
[
2
]
definition of
[
2
]
SLOW variables
SMD, type
snapshot logs
[
2
]
naming
privileges to create
snapshots
creating
defining
DML statements and
dropping
logs
logs in master tables
mechanisms
naming logs
privileges to create
queries and
refreshing
simple and complex
view and synonyms based on
SNMP database subagent, starting and stopping
SNMP parameters
configuring
SNMP subagent, configuring
SNMP support
benefits of
configuration file
[
2
]
configuring
description
[
2
]
using
SNMP.ORA
configuration file
function
parameters
SNMP, purpose of
special tools, making a connection
SQL*Forms
SQL*Menu
[
2
]
SQL*Net connections
distinguishing between
from the command line
to a multi-threaded server
SQL*Net DCE Integration, description of
SQL*Net OPEN
compatibility with other Oracle products
definition of
error messages
uses for
SQL*Net operations
connect
data
exception
SQL*Net V1 connect strings
SQL*Net V1
support for proxy logons
updating connect strings
SQL*Net
architecture
communications role
[
2
]
distributed database related features
functional benefits
in distributed processing
initiating a connection
new features in release 2.3
reasons for migration to version 2
role in distributed processing
[
2
]
Two-Task Common
types of installations
use of network listener
SQL*Plus
[
2
]
COPY command in
SQLNET.EXPIRE_TIME, parameter for dead connection detection feature
SQLNET.ORA Editor
[
2
] [
3
]
SQLNET.ORA
default domains listed in
optional parameters for
optional tracing parameters for
purpose of
sample
SQL
routines
fetch
logon
parse
starting a server
starting the listener
STARTUP command, using
startup programs
STATUS command
sample output
STOP command
example of use
stopping the network listener
synchronous operations
synonym
CREATE command
database object
definition and creation of
syntax rules
tables, snapshots of
tasks enabled, by SNMP support
testing multiple servers
testing Names servers
testing the configuration
time, transaction
TIMEOUT parameter
TIMEOUT, LISTENER.ORA parameter
timer initiated disconnect
[
2
]
TNS
TNS connect descriptors, vs version 1 connect strings
TNS, interrupt handling
TNSNAMES.ORA
[
2
] [
3
]
and listener load balancing
components of
Interchange names in
purpose of
replacing V1 connect strings with V2 connect descriptors in
sample entry
syntax of
user and system versions
TNSNAV.ORA
format of
syntax for
TNSNET.ORA, sample file
[
2
]
TNSPING
[
2
]
TNS
tracing feature
underlying SQL*Net
tool logon screen, making a connection
Trace Route utility
transaction time, measuring
transaction, SQL*Net's role in distributed transactions
transparent network substrate
Transparent Network Substrate (TNS)
benefits
encryption digests
functions
open
receive
send
role in distributed processing
sequenced cryptograhic message digests
TRCFMT script to format Oracle Trace files
TrcRoute
Two-Task Common
character set conversion in distributed processing
type
database links
database service names
upgrading to SQL*Net V2
upgrading to SQL*Net V2.1, adding a default domain
upgrading to SQL*Net V2
checklist
relinking applications
UPI
UPI/OPI
USE_DEDICATED_SERVER, optional parameter in SQLNET.ORA
User Program Interface (UPI)
operations performed by
role in distributed processing
user-initiated disconnect
USER_DBLINKS, data dictionary view
Validnode verification
wild-card listen
WORLD domain, assigned by Network Manager
Copyright © 1996 Oracle Corporation.
All Rights Reserved.
Library
Product
Contents
Index