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