Oracle7 Server Distributed Systems Manual, Vol. 1
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
@
abort message
access, remote integrity constraints and objects
adapters
communication protocol
security authentication
addresses
defining
name resolution
protocol-specific information
administration, database
advanced replication option
aggregates
alerts, event
ALL
data dictionary view
ALTER SYSTEM command, ENABLE DISTRIBUTED RECOVERY option
ALTER SESSION command
ADVISE option
CLOSE DATABASE LINK option
ALTER SESSION, system privilege
ALTER SYSTEM command, DISABLE DISTRIBUTED RECOVERY option
ANALYZE command, distributed transactions
ANSI/ISO SQL standard
API
[
2
]
application development
in a distributed environment
networks
application program interface (API)
[
2
]
application transparency, definition
application, independence
applications
3GL
connecting to a server
4GL
database links
developing
naming considerations
development
database links
database names
distributing data
object names
referential integrity
remote connections
tools
errors
front-end
definition
moving between systems
network communication
network transparency
peer-to-peer connectivity
protocol independence
sharing resources using XA Library
use of the Transparent Network Substrate
XA Library
architecture
client-server
client-server model
network products
peer-to-peer
SQL*Net
SQL*Net version 2
array interface
ASYNC
asynchronous operations
asynchronous table replication
Asynchronous Transfer Mode
ATM
authentication, adapters
[
2
] [
3
]
external
[
2
]
operating system
proxy
back-end applications
back-end services, definition
backups, strategies, in a distributed system
basic replication
biometric identification devices
bridges, SQL*Net
calls, remote procedure
CASE
CASE*Designer
CASE*Dictionary
CASE*Generator
CDE
character sets
across database links
conversion
[
2
]
SQL*Net support
client applications
data processing
role in a client-server model
role in distributed processing
client profiles, definition of
client types
client-server model
application program interface (API)
applications
architecture
back-end services
SQL
benefits
client applications
clients
components
concepts
configurations
data location
definition
MultiProtocol Interchange
multitasking
network issues
networks
server
servers
client-server
architecture
direct and indirect connections
multi-community connections
client-side applications
clients
processes
role in distributed transactions
role in prepare/commit phases
testing
[
2
]
CLOSE DATABASE LINK option
code, transportability, SQL*Net
command-line connections to a database
comments, in COMMIT statements
COMMIT command, COMMENT parameter
[
2
]
FORCE option
FORCE option
forcing
Commit phase
[
2
] [
3
]
commit point site
commit point strength and
determining
setting commit point strength
COMMIT_POINT_STRENGTH parameter, setting
commit, forcing
committing transactions
distributed
prepare/commit phases
communication protocols
adaptors
translating
communications protocols
[
2
]
communities
definition
planning
vs. domains
concurrency control
concurrent access, networks
configuration files
distributing over network
network
PROTOCOL.ORA
SQLNET.ORA
testing
configuration, network, testing errors
configuring a network, using Network Manager
[
2
]
CONNECT command, within SQL*Plus
connect descriptors, usage
connect operations
disconnect
connect strings, SQL*Net version 1
CONNECT TO clause
connecting to a server
connecting
across protocols
application to server
through database links
connection process, distributed systems
connection qualifiers
defining with Network Manager
for database links
[
2
]
connection requests
connection termination, abnormal
connections
changing hold time
establishing with a Multi-Threaded Server
indirect vs. direct
initiating network
methods of establishing
remote internal
remote
routing
testing
TNSPING utility
connectivity issues
constraints
application development issues
ORA-02055
Cooperative Development Environment (CDE)
tool set
CREATE DATABASE LINK statement
CREATE SESSION
cron jobs, distributing network configuration files
cross-protocol data security
crypto-algorithm negotiation
cryptographic message digests
cursors, and closing database links
Cybersafe Challenger
[
2
] [
3
]
Data Definition Language (DDL), distributed transactions
data dictionary
database links
private database links
public database links
storing global database links
views
DBA_DB_LINKS
USER
data link transmissions, low-level
data location
Data Manipulation Language (DML), recovery management
Data Manipulation Statements (DMLs), in distributed transactions
data operations
asynchronous
SQL*Net
synchronous
data processing, client-server model
data query
data security
data-stream encryption
database administrator, responsibilities, XA Library application
database links
advantages by type
aliasing
and location transparency
basics
character sets
closing
connection qualifiers
[
2
] [
3
]
controlling connections
creating manually
data dictionary views
DBA_DB_LINKS
USER
default username/password for global
definition
domains in
DROP command
dropping
editing global with Network Manager
finding available links
global
automatic creation
creating with Network Manager
storage
in SQL statements
limiting number
listing
multiple links to the same database
National Language Support
Network Manager
Oracle Names
[
2
]
resolution
overview
paths to remote databases
[
2
]
private
[
2
]
security enhanced by
proxy authentication
public
[
2
]
restricting use
remote session creation
secure
security
security issues
service names in
transparent gateways
types
USING clause
database server
databases
administration
connecting through database links
distributed
database, servers, configuring, Network Manager
databases
evaluating purpose
files
implementing
locking mechanisms
management tools
managing
monitoring
multiple database links
names
naming uniquely
planning logical layout
planning physical layout
scaled
size
database, string
data
concurrency
cross-protocol security
integrity
location
low-level data-link transmission
non-ORACLE
[
2
]
objects
replication transparency
receiving over a network
replication
transparency
sent/received asynchronously
sent/received synchronously
transmitting over a network
datatype, internal representation
[
2
]
datatypes, PL/SQL datatypes and RPCs
DBA role
DBA_2PC_PENDING view
DBA_DB_LINKS, data dictionary view
DCE authentication
dead connection detection
dead man's handle
deadlocks
distributed transactions
global
local
decision support
decision support database
declarative referential integrity constraints
DECnet transport protocol, SQL*Net support
[
2
]
dedicated server processes
dedicated server, prespawned, establishing a connection
default domain
definition of
when initiating a SQL*Net connection
[
2
]
DES encryption
development tools
Digital's POLYCENTER Manager on NetView
[
2
]
direct network connections
disabling, recoverer process
disconnect, user initiated
dispatcher process
distributed systems, remote object security
distributed transactions
manually overriding in-doubt
recovery in single-process systems
distributed applications, distributing data
distributed databases
and network domains
commit point strength
testing features
versus distributed processing
distributed name service, Oracle Names
distributed processing
client-side actions
protocol adapter's role
protocol's role
server's role
software components
SQL*Net
SQL*Net's role
[
2
]
Transparent Network Substrate's role
versus distributed databases
distributed queries
application development issues
example with an Interchange
distributed systems
backup strategies
basics
[
2
]
concepts
connection process
database links
security
databases
planning physical layout
planning size
distributed processing versus distributed databases
distributed queries
distributed updates
distributing an application's data
environmentally-dependent SQL functions
gateway servers
global database names
global object names
implementing databases
initialization parameters
introduction
limiting active connections per user
location transparency
location transparency using synonyms
managing databases
memory requirements
monitoring databases
name resolution
name resolution
network domains
nodes
Open Gateway Technology
optimization of SQL statements
Oracle Network Products
performance
[
2
]
planning databases
planning the network
prepare/commit phases
prespawned servers
procedural gateways
[
2
]
referential integrity
relinking
remote queries
[
2
]
remote transactions
remote updates
replication transparency
replication
security
security issues
shared SQL
site autonomy
SQL functions
SQL statement execution
SQL*Net
tables
terminology
transaction recovery management
transparency
queries
updates
transparent gateways
distributed transactions
commit point site
commit point strength
coordinating using XA Library
database server role
failure during
[
2
]
forcing to fail
global coordinator
hold time
limiting number
limiting number of
local coordinator
locked resources
pending
prepare/commit phases
read-only
recovery management
requests
resource managers
restrictions
session tree
setting advice for
SQL*Net's role
transaction recovery management
two-phase commit
when committed
X/Open Distributed Transaction Processing
XA Library interface subroutines
distributed updates
clients role
coordinating
recovery management
[
2
]
recovery mechanism
troubleshooting
DISTRIBUTED_LOCK_TIMEOUT parameter, controlling time-outs with
DISTRIBUTED_RECOVERY_CONNECTION_HOLD_TIME parameter, setting
DISTRIBUTED_TRANSACTIONS parameter, recoverer process (RECO)
DISTRIBUTED_TRANSACTIONS parameter, setting
[
2
]
when to alter
distributing configuration files, Network Manager
DML
DNS
domain name
Domain Name System (DNS)
domain name, WORLD as default
domains
in database links
vs. communities
dropping, database links
DTP
enabling, recoverer process
encryption digests, Transparent Network Substrate (TNS)
encryption
data-stream
module
network
password
passwords
errors
application development
distributed transactions
in network configuration test
listener process
messages
name resolution
ORA-00900
ORA-01591
ORA-02015
ORA-02047
ORA-02049
ORA-02050
ORA-02051
ORA-02054
ORA-02055
ORA-02067
ORA-06510
ORA-1034
ORA-12154
ORA-12203
remote procedures
establishing a session
Ethernet, SQL*Net support
event alerts
examples, manual transaction override
exception handler
local
exception operations
interrupts
SQL*Net
EXCEPTION, PL/SQL keyword
exceptions
assigning names
remote procedures
user-defined
execute, SQL routine
external authentication
[
2
]
failures, returning to a consistent state, XA Library
FDDI
fetch, SQL routine
Fiber Distributed Data Interface
files, planning location, in a distributed system
forcing, COMMIT or ROLLBACK
[
2
]
foreign key
fourth generation language (4GL), applications
front-end applications
definition
gateway data definition language (GDDL)
gateway servers
gateways
in a distributed system
SQL*Net support
transparent
GDDL
generating configuration files, Network Manager
global coordinator
[
2
]
global database links
automatic creation
creating
editing with Network Manager
Oracle Names
global database name
global deadlocks, concurrency control
global naming, basics
global object name
[
2
]
hardware support, SQL*Net
heterogeneous networking, definition
hierarchical domain name
hierarchical naming strategies, example
hierarchical view, Network Manager
hold time, changing
horizontal scaling
HP's OpenView
[
2
]
IBM's NetView/6000
[
2
]
in client-server architecture
in-doubt transactions
after a system failure
committing manually
forcing a commit
forcing a rollback
intentionally creating
overriding manually
pending transactions table
recoverer process
rollback segments
rolling back
[
2
]
indirect network connections
INIT.ORA
initialization parameters, in a distributed system
initiating SQL*Net connections
installing applications, using the XA Library
INTCHG.ORA, errors, Network Manager configuration file
INTCTL
integrating existing systems
integrating server
integrity checking, network security
integrity constraints
ORA-02055
recovery management
Interchange Control Utility, starts a Multiprotocol Interchange
interface subroutines, XA Library
internal datatype representations
Internet, naming conventions
interrupts
invalid name error, listener process
joins
keep alive
Kerberos V5
[
2
] [
3
]
network security
keys
primary
unique
keywords
for protocol adapters
protocol-specific
line mode, about
linking filenames, XA Library
links, database
Listener Control Utility
START command
[
2
]
starts listener process
listener process
[
2
]
errors
starting
testing
wild-card listen
LISTENER.ORA file, errors
LISTENER.ORA, parameters
listener
network vs native
prespawned shadows
role in distributed processing
used with SQL*Net
listing database links
local coordinator
location transparency
[
2
]
basics
database links
definition
Oracle Names
service names
synonyms
using procedures
LOCK TABLE command, in distributed transactions
locking
locks
in distributed transactions
in distributed transactions
logon screen, using
logon, SQL routine
LONG
low-level data link transmissions
LSNRCTL
LU6.2 transport protocol
IBM
Management Information Base (MIBs)
map view, Network Manager
master table, snapshots
media independence, definition
Media Server, MIBs
memory requirements, distributed systems
memory, reducing required
message digests
[
2
]
messages
error
ORA-12154
MIB
modes
single-task
two-task
MTS_LISTEN_ADDRESS, initialization parameter
multi-threaded server
multi-threaded server (MTS)
Multi-Threaded Server, establishing connections
multicommunity network, planning
multiple database links, to one database
MultiProtocol Interchange, description
[
2
]
example of use
in client-server configuration
MIBs
monitoring
planning
starting
testing
[
2
]
used by TNS
used with server-to-server connections
multistage protocol conversion
multiuser systems, locking mechanisms
name lookup files
name resolution
in a distributed system
location transparency
name servers, Oracle Names server
name service, Oracle Names
Names servers, choosing nodes as
names, resolving to addresses
naming environment, Native Naming adapters
naming hierarchical
naming service, Oracle Names
naming
application development considerations
choosing a standard
domains
example of hierarchical strategy
global names
local objects
resolution
Oracle Names servers
schema objects
National Language Support (NLS)
across database links
character set conversion
National Language Support
changing parameters during a session
SQL*Net character set supporT
Native Naming Adapters, SQL*Net
NetFetch
NETFETCH utility
distribute network configuration files
where to use
network authentication
network definition, role in configuration process
network domains, global database names
Network Information Services (NIS)
[
2
]
network listener
MIBs
role in distributed processing
Network Manager
choosing a node for
configuration steps
configuring the network
creating global database links
creating network configuration files
defining connection qualifiers
enforcing unique names
generating configuration files
global database links
NETFETCH utility
network hierarchical view
network Map View
network topological view
network Tree View
planning before using
PROTOCOL.ORA
SQLNET.ORA
testing network configuration
viewing a network
network naming service
network objects, global naming issues
network transparency
definition
protocol adapters
networks
addresses
resolving
administration
administration utilities
administration
and distributed systems
APIs
[
2
]
architecture
Oracle's Network Products
Asynchronous Transfer Mode
authentication adapters
basics
bridges
choosing a node for Network Manager
client-server model
communication protocols
[
2
]
communities
concurrent access
configuration files
Network Manager
PROTOCOL.ORA
SQLNET.ORA
configuration
configuring
configuring with Network Manager
connections
data-stream encryption
database links
private
public
database servers
DECnet
direct versus indirect connections
domains
encryption
Ethernet
example of hierarchical naming strategy
Fiber Distributed Data Interface (FDDI)
gateways
generating configuration files
hardware support
heterogeneous
IBM's LU6.2 transport protocol
independence from in distributed system
initiating connections
kerberos V5
media independence
monitoring with SNMP support
MultiProtocol Interchange
[
2
]
name servers
naming environment
Native Naming Adapters
Network Manager
Network Manager map view
Network Manager topological view
Network Manager tree view
Network Manager
nodes
Novell's SPX/IX transport protocol
object naming strategies
Oracle Names
[
2
]
OSI transport protocol
packet switches
packets
planning communities
planning for a distributed system
planning MultiProtocol Interchanges
planning the layout
prepare/commit phases
process-to-process communication
protocol independence
protocol
stacks
proxy authentication
queries
routers
security
introduction
password encryption
Secure Network Services
using roles
server-to-server
services
specifying name servers
SQL*Net
SQL*Net operations
TCP/IP transport protocol
testing configuration
testing
listener process
MultiProtocol Interchange
TNSPING utility
Token-Ring
topology independence
traffic
two-task mode
[
2
]
viewing from Network Manager
wireless
NIS
NLS
NLS_LANG parameter
NO_DATA_FOUND, PL/SQL keyword
nodes
definition
valid
non-Oracle data, access via gateways
[
2
]
accessing via gateways
Novell's NetWare Management System
[
2
]
objects
local
naming strategies
naming
referencing with synonyms
replication transparency
replication
OCI
OFA
OLTP
online transaction processing (OLTP), in a distributed system
Open Gateway Technology, in a distributed system
open gateways, access to non-Oracle data
open string, XA Library, syntax
OPEN_LINKS parameter, setting
operating system dependencies
operating-system authorized login
operating-system dependencies, README file
OPI
OPS$ login
Optimal Flexible Architecture (OFA)
optimization
distributed systems
transparency of distributed
optional fields, XA Library, open string
ORA-00900, SQL error
ORA-02015, SQL error
ORA-02055, integrity constraint violation
ORA-02067, rollback required
ORA-06510, PL/SQL error
ORA-1034, database not running error
ORA-12154
name resolution error
service name error
ORA-12203, listener process testing error
Oracle Call Interface (OCI), interfacing with XA Library
[
2
]
Oracle Names
[
2
]
advantages
and location transparency
choosing nodes as Names servers
creating global database links with Network Manager
database link resolution
database links
description
MIBs
monitoring
name resolution
servers
testing
Oracle Program Interface (OPI), role in distributed processing
Oracle Server
password
username
Oracle version 6, and newer versions
Oracle XA library
application developer
reference
required libraries
Oracle's Network Products
[
2
]
architecture
Oracle7 Server
client-server support
connecting to previous versions
monitoring
scalability
Oracle7, multi-threaded server
OS_AUTHENT_PREFIX, initialization parameter
OSI transport protocol, SQL*Net support
packet switches, SQL*Net support
packets, integrity checks
parallel query
parallel server, and XA Library
parameters, initialization, in a distributed system
parent/child table relationships, maintaining
parse, SQL routine
passwords, encryption
[
2
]
security
peer-to-peer system, definition
pending transaction tables
pending transactions table, categories
performance, distributed systems
[
2
]
PL/SQL datatypes, remote procedure calls
PL/SQL
error
procedural gateways
procedures
user-defined exceptions
POOL_SIZE, LISTENER.ORA parameter
PRAGMA_EXCEPTION_INIT, assigning exception names
precompilers, interfacing with XA Library
prepare phase
recognizing read-only nodes
prepare/commit phases
abort response
effects of failure
failures during
forcing to fail
locked resources
overview
pending transaction table
prepared response
read-only response
testing recovery
when used
PRESPAWN_MAX, LISTENER.ORA parameter
prespawned dedicated server
establishing a connection
prespawned shadow processes
primary, key
private database links
[
2
]
security
privileges
closing a database link
committing in-doubt transactions
database links
managing with procedures
managing with synonyms
managing with views
rolling back in-doubt transactions
security
SYSDBA/SYSOPER
Pro*C/C++, using with XA Library
procedural gateway server
procedural gateways, in a distributed system
procedure calls
remote
recovery management
procedures
location transparency using
PL/SQL
[
2
]
remote
SQL
[
2
]
process-to-process communication, remote
[
2
]
processes
client
combined user/server
dedicated server
server
[
2
]
shadow
user
processing
distributed
client-side actions
protocol adapter's role
protocol's role
server's role
SQL*Net
SQL*Net's role
[
2
]
Transparent Network Substrate's role
program interface
single-task mode
two-task mode
protocol adapter
example of use
role in distributed processing
protocol adapters
keywords
used by TNS
[
2
]
protocol stacks, MultiProtocol Interchange
protocol-specific keywords
PROTOCOL.ORA, network configuration file
protocols
adapters
communication
communities
conversion
multistage
independence
MultiProtocol Interchange
overview
role in distributed processing
SQL*Net support
stacks
SQL*Net support
translation
transport
IBM's LU6.2
Novell's SPX/IX
OSI
TCP/IP
proxy authentication
proxy logins
public database links
[
2
]
restricting use
public database link
with default connection
with specified connection
public
default connection
specific connection
users group
queries
data
distributed
[
2
]
application development issues
during prepare phase
example with an Interchange
location transparency
network transparency
parallel
post-processing
remote
[
2
]
remote execution
transparency
RAISE_APPLICATION_ERROR procedure, remote procedures
read-only snapshots
[
2
] [
3
]
read-only transactions, distributed
README.doc, Oracle XA library
Recover In-Doubt Transaction dialog
recoverer process (RECO)
disabling
distributed database recovery
distributed transaction recovery
DISTRIBUTED_TRANSACTIONS parameter
enabling
in-doubt distributed transactions
network failure
pending transaction table
recovery management
Data Manipulation Language (DML) statements
integrity constraints
overview
remote procedure calls
triggers
recovery
distributed updates
testing distributed transactions
referential integrity
distributed systems
using triggers to enforce
region
relinking, distributed systems
relocating tables
remote communication
remote data
querying
updating
remote internal connections
remote procedure calls
remote procedure calls (RPCs)
[
2
]
remote procedure calls
procedural gateways
recovery management
remote procedures, error handling, application development
remote process-to-process communication
remote queries
execution
post-processing
remote transactions
REMOTE_OS_AUTHENT, initialization parameter
replay attacks
replication
[
2
]
advanced option
basic
basics
transparency
report writers
required fields, XA Library, open string
resource managers (RM)
resource managers, and Oracle7 Server
resources, reducing required
restriction, distributed transactions
restrictions, XA Library
Roles
backward compatibility
DBA role
pre-defined
security
[
2
]
ROLLBACK command, forcing
ROLLBACK command, FORCE option
rollback segments, in-doubt distributed transactions
rollback, forcing
rollbacks, ORA-02067 error
routers, SQL*Net support
RPC
RSA Data Security RC4 encryption algorithm
savepoints, in-doubt transactions
scaling
horizontal
vertical
schema objects
global names
local names
name resolution
names
remote name resolution
secure database links
secure message digests
Secure Network Services
[
2
] [
3
]
security
cross-protocol
database links
distributed systems
during connection establishment
for remote objects
gateways
location transparency
network
Secure Network Services
password
password encryption
private database links enhance
proxy authentication
public database links
remote usernames
using roles
using synonyms
SELECT ... FOR UPDATE
semantic errors, configuration files, Network Manager
sequenced cryptographic message digests, Transparent Network Substrate (TNS)
server ID (SID)
Server Manager
Server Manager, portability
server security groups, XA Library
server-server, architecture
server-to-server communications
[
2
]
server-to-server, in multi-community network
server
configurations
definition
servers
accessing non-Oracle data
connected to multiple communities
connecting to
connections
database
dedicated processes
gateway
process
role in distributed processing
role in two-phase commit
status
service names
and location transparency
errors
in database links
resolution
short name for connect descriptor
use on command line
using on connect screen
services, back-end, definition
sessions
database links and remote
establishing
session tree in distributed transactions
setting advice for transactions
shared SQL
shared SQL areas, distributed statements
SID
Simple Network Management Protocol (SNMP) support
database management
monitoring Multiprotocol Interchange
monitoring Oracle Names
monitoring Oracle7 Server
monitoring SQL*Net listener
single-process systems, enabling distributed recovery
single-task mode
site autonomy
Smart Cards
[
2
]
snapshots
[
2
]
master table
read-only
[
2
]
symmetric replication facility
updatable
[
2
]
SNMP support
SNMP-based management systems
software support, SQL*Net
SPX/IPX transport protocol, Novell, SQL*Net support
SQL distributed language requests
SQL errors
ORA-00900
ORA-02015
SQL statement optimization
SQL statements
distributed
execution
optimization
SQL*Forms, invoking
SQL*Net
SQL*Net connections, from the command line
SQL*Net Listener, monitoring
SQL*Net operations
connect
data
exception
SQL*Net version 1 connect strings
SQL*Net
applications
architecture
[
2
]
Asynchronous Transfer Mode
basics
bridges support
communications role
[
2
]
DECnet
distributed processing
domains vs. communities
drivers
ethernet networks
Fiber Distributed Data Interface (FDDI)
gateway support
IBM's LU6.2 transport protocol
in distributed processing
initiating a connection
media independence
MultiProtocol Interchange
network independence
Novell's SPX/IX transport protocol
OSI transport protocol
packet switch support
protocol independence
role in distributed processing
router support
TCP/IP transport protocol
third-party software support
Token-Ring networks
topology independence
Two-Task Common
use of network listener
wireless networks
SQL*Plus
internal connect command
invoking
SQLNET.ORA
default domains listed in
network configuration file
SQL
procedures
query language
routines
fetch
logon
parse
shared
statements
stacks
protocol stacks and MutiProtocol Interchange
protocol
standards, communication
START command, Listener Control Utility
statements, SQL, execution in a distributed system
storage
database links
global database links
stored procedures
distributed query creation
managing privileges
remote object security
subqueries
in remote updates
subroutines, XA Library interface
SunSoft's SunNet Manager
SunSoft's SunNet Manager
symmetric implementation
symmetric replication facility
[
2
]
synchronous operations
synonyms
and location transparency
CREATE command
definition and creation
examples
location transparency using
managing privileges
remote object security
tables
syntax errors, configuration files, Network Manager
SYSDATE function, distributed systems
SYSDBA/SYSOPER privilege
System Change Number (SCN), in-doubt transactions
system change numbers (SCN), coordination in a distributed system
tables, location transparency
tablespaces, in a distributed system
tables
parent/child relationships
relocating
replication
splitting among tablespaces
TCP/IP transport protocol
SQL*net support
TELNET
terminal emulation protocols, security
testing, clients
[
2
]
listener process
MultiProtocol Interchange
[
2
]
network configuration
Oracle Names
third generation language (3GL), applications
TIMEOUT, LISTENER.ORA parameter
timer initiated disconnect
[
2
]
tip, setting for distributed transactions
TNS
benefits
interrupt handling
TNSNAMES.ORA
[
2
]
network configuration file
TNSNAV.ORA, errors, Network Manager configuration file
TNSNET.ORA, errors, Network Manager configuration file
TNSPING utility, test server connections
Token-Ring networks, SQL*Net support
tools, for developing applications
topological view, Network Manager
topology independence, definition
transaction managers
and Oracle7 Server
XA Library
transaction processing
transaction processing monitors (TPMs)
[
2
]
transaction recovery management
transaction recovery management
basics
XA Library
transaction, in client-server architecture
Transactions folder
forcing a commit
forcing a rollback
transactions
closing database links
communication
control
coordinating using XA Library
distributed
deadlocks
read-only
restrictions
transaction recovery management
in client-server architecture
[
2
]
in-doubt
[
2
]
after a system failure
pending transactions table
recoverer process (RECO) and
resolving automatically
initiating
manual overriding in-doubt
read-only
recovery management
remote
requests
resource managers
SQL*Nets role in distributed transactions
translating, communication protocols, MultiProtocol Interchange
transparency
application
definition
location
definition
using procedures
name resolution
network
protocol adapters
queries over a network
query
replication
transaction
update
transparent gateways
database link behavior
in a distributed system
security
server
Transparent Network Substrate (TNS)
[
2
]
encryption digests
functions
open
receive
send
role in distributed processing
sequenced cryptographic message digests
transport protocols
DECnet
IBM's LU6.2
Novell's SPX/IP
OSI
TCP/IP
transportability, code, SQL*Net
Tree View
Network Manager
triggers
distributed query creation
enforcing referential integrity
maintaining parent/child table relationships across nodes
recovery management
replication
troubleshooting, distributed updates
two-phase commit, commit phase
[
2
]
example of
prepare phase of
recognizing read-only nodes
two-task mode
network communication
program interface
tx_begin
tx_close
tx_commit
tx_open
tx_rollback
UID function, distributed systems
unique database names, insuring
unique key
unique names, insuring
unique schemas, insuring
updatable snapshots
[
2
] [
3
]
updates
distributed
location transparency
transparency
UPI
UPI/OPI
USER function, distributed systems
user process
user processes, dedicated server processes
User Program Interface (UPI)
operations performed by
role in distributed processing
user-defined exceptions, PL/SQL
user-initiated disconnect
USER, data dictionary view
USERENV function, distributed systems
users
database access
database links
dedicated servers
group PUBLIC
private database links
public database links
USING clause, database links
utility logon screen, making a connection
V$XATRANS$ view, XA Library requirement
valid node, security feature
validating network connections
versions, communicating with older versions
vertical scaling
views
location transparency using
managing privileges with
remote object security
visualizing a network
[
2
]
wild-card listen
wireless networks
WORLD domain, assigned by Network Manager
WORLD, default domain
X/Open Distributed Transaction Processing (DTP)
XA Library
architecture
association migration
asynchronous calls
DDL statements
definition
dynamic registration
global transactions
installing applications
interface subroutines
xa_close
xa_commit
xa_complete
xa_end
xa_forget
xa_open
xa_prepare
xa_recover
xa_start
interfacing to OCI
interfacing to precompilers
linking filenames
local transactions
open string
required fields
syntax
parallel server
read-only optimization
README.doc file location
reference
required public information
restrictions
server security groups
transaction branches
transaction control
transaction recovery management
tx_begin
tx_close
tx_commit
tx_open
tx_rollback
using Pro*C
using with OCI
V$ATRANS$ view
xa_switch_t resource manager
xa_switch_t structure
xa_close, XA Library interface subroutine
xa_commit, XA Library interface subroutine
xa_complete, XA Library interface subroutine
xa_end, XA Library interface subroutine
xa_forget, XA Library interface subroutine
xa_open, XA Library interface subroutine
xa_prepare, XA Library interface subroutine
xa_recover, XA Library interface subroutine
xa_rollback, XA Library interface subroutine
xa_start, XA Library interface subroutine
xa_switch_t resource manager, XA Library
xa_switch_t structure, XA Library
XAVIEW.SQL script