Oracle7 Server Distributed Systems Volume I: Distributed Data
Index
Index
- abort message
- access, remote integrity constraints and objects
- adapters
- addresses
- administration, database
- advanced replication option
- aggregates
- alerts, event
- ALL
- ALTER SYSTEM command, ENABLE DISTRIBUTED RECOVERY option
- ALTER SESSION command
- ALTER SESSION, system privilege
- ALTER SYSTEM command, DISABLE DISTRIBUTED RECOVERY option
- ANALYZE command, distributed transactions
- ANSI/ISO SQL standard
- API [2]
- application development
- application program interface (API) [2]
- application transparency, definition
- application, independence
- applications
- architecture
- array interface
- ASYNC
- asynchronous operations
- asynchronous table replication
- Asynchronous Transfer Mode
- ATM
- authentication, adapters [2] [3]
- 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
- client applications
- client profiles, definition of
- client types
- client-server model
- client-server
- client-side applications
- clients
- CLOSE DATABASE LINK option
- code, transportability, SQL*Net
- command-line connections to a database
- comments, in COMMIT statements
- COMMIT command, COMMENT parameter [2]
- Commit phase [2] [3]
- commit point site
- COMMIT_POINT_STRENGTH parameter, setting
- commit, forcing
- committing transactions
- communication protocols
- communications protocols [2]
- communities
- concurrency control
- concurrent access, networks
- configuration files
- configuration, network, testing errors
- configuring a network, using Network Manager [2]
- CONNECT command, within SQL*Plus
- connect descriptors, usage
- connect operations
- connect strings, SQL*Net version 1
- CONNECT TO clause
- connecting to a server
- connecting
- connection process, distributed systems
- connection qualifiers
- connection requests
- connection termination, abnormal
- connections
- connectivity issues
- constraints
- Cooperative Development Environment (CDE)
- 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
- data link transmissions, low-level
- data location
- Data Manipulation Language (DML), recovery management
- Data Manipulation Statements (DMLs), in distributed transactions
- data operations
- data processing, client-server model
- data query
- data security
- data-stream encryption
- database administrator, responsibilities, XA Library application
- database links
- database server
- databases
- database, servers, configuring, Network Manager
- databases
- database, string
- data
- 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
- 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
- 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
- distributed applications, distributing data
- distributed databases
- distributed name service, Oracle Names
- distributed processing
- distributed queries
- distributed systems
- distributed transactions
- distributed updates
- 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]
- distributing configuration files, Network Manager
- DML
- DNS
- domain name
- Domain Name System (DNS)
- domain name, WORLD as default
- domains
- dropping, database links
- DTP
- enabling, recoverer process
- encryption digests, Transparent Network Substrate (TNS)
- encryption
- errors
- establishing a session
- Ethernet, SQL*Net support
- event alerts
- examples, manual transaction override
- exception handler
- exception operations
- EXCEPTION, PL/SQL keyword
- exceptions
- 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
- gateway data definition language (GDDL)
- gateway servers
- gateways
- GDDL
- generating configuration files, Network Manager
- global coordinator [2]
- global database links
- 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
- 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
- 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]
- keys
- keywords
- line mode, about
- linking filenames, XA Library
- links, database
- Listener Control Utility
- listener process [2]
- LISTENER.ORA file, errors
- LISTENER.ORA, parameters
- listener
- listing database links
- local coordinator
- location transparency [2]
- LOCK TABLE command, in distributed transactions
- locking
- locks
- logon screen, using
- logon, SQL routine
- LONG
- low-level data link transmissions
- LSNRCTL
- LU6.2 transport protocol
- 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
- MIB
- modes
- 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]
- multistage protocol conversion
- multiuser systems, locking mechanisms
- name lookup files
- name resolution
- 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
- National Language Support (NLS)
- National Language Support
- Native Naming Adapters, SQL*Net
- NetFetch
- NETFETCH utility
- network authentication
- network definition, role in configuration process
- network domains, global database names
- Network Information Services (NIS) [2]
- network listener
- Network Manager
- network naming service
- network objects, global naming issues
- network transparency
- networks
- NIS
- NLS
- NLS_LANG parameter
- NO_DATA_FOUND, PL/SQL keyword
- nodes
- non-Oracle data, access via gateways [2]
- Novell's NetWare Management System [2]
- objects
- 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
- 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
- ORA-12203, listener process testing error
- Oracle Call Interface (OCI), interfacing with XA Library [2]
- Oracle Names [2]
- Oracle Program Interface (OPI), role in distributed processing
- Oracle Server
- Oracle version 6, and newer versions
- Oracle XA library
- Oracle's Network Products [2]
- Oracle7 Server
- 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]
- peer-to-peer system, definition
- pending transaction tables
- pending transactions table, categories
- performance, distributed systems [2]
- PL/SQL datatypes, remote procedure calls
- PL/SQL
- POOL_SIZE, LISTENER.ORA parameter
- PRAGMA_EXCEPTION_INIT, assigning exception names
- precompilers, interfacing with XA Library
- prepare phase
- prepare/commit phases
- PRESPAWN_MAX, LISTENER.ORA parameter
- prespawned dedicated server
- prespawned shadow processes
- primary, key
- private database links [2]
- privileges
- Pro*C/C++, using with XA Library
- procedural gateway server
- procedural gateways, in a distributed system
- procedure calls
- procedures
- process-to-process communication, remote [2]
- processes
- processing
- program interface
- protocol adapter
- protocol adapters
- protocol stacks, MultiProtocol Interchange
- protocol-specific keywords
- PROTOCOL.ORA, network configuration file
- protocols
- proxy authentication
- proxy logins
- public database links [2]
- public database link
- public
- queries
- 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)
- recovery management
- recovery
- referential integrity
- region
- relinking, distributed systems
- relocating tables
- remote communication
- remote data
- remote internal connections
- remote procedure calls
- remote procedure calls (RPCs) [2]
- remote procedure calls
- remote procedures, error handling, application development
- remote process-to-process communication
- remote queries
- remote transactions
- REMOTE_OS_AUTHENT, initialization parameter
- replay attacks
- replication [2]
- 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
- 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
- schema objects
- secure database links
- secure message digests
- Secure Network Services [2] [3]
- security
- 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
- servers
- service names
- services, back-end, definition
- sessions
- shared SQL
- shared SQL areas, distributed statements
- SID
- Simple Network Management Protocol (SNMP) support
- single-process systems, enabling distributed recovery
- single-task mode
- site autonomy
- Smart Cards [2]
- snapshots [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
- SQL statement optimization
- SQL statements
- SQL*Forms, invoking
- SQL*Net
- SQL*Net connections, from the command line
- SQL*Net Listener, monitoring
- SQL*Net operations
- SQL*Net version 1 connect strings
- SQL*Net
- SQL*Plus
- SQLNET.ORA
- SQL
- stacks
- standards, communication
- START command, Listener Control Utility
- statements, SQL, execution in a distributed system
- storage
- stored procedures
- subqueries
- subroutines, XA Library interface
- SunSoft's SunNet Manager
- SunSoft's SunNet Manager
- symmetric implementation
- symmetric replication facility [2]
- synchronous operations
- synonyms
- 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
- TCP/IP transport protocol
- TELNET
- terminal emulation protocols, security
- testing, clients [2]
- third generation language (3GL), applications
- TIMEOUT, LISTENER.ORA parameter
- timer initiated disconnect [2]
- tip, setting for distributed transactions
- TNS
- TNSNAMES.ORA [2]
- 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
- transaction processing
- transaction processing monitors (TPMs) [2]
- transaction recovery management
- transaction recovery management
- transaction, in client-server architecture
- Transactions folder
- transactions
- translating, communication protocols, MultiProtocol Interchange
- transparency
- transparent gateways
- Transparent Network Substrate (TNS) [2]
- transport protocols
- transportability, code, SQL*Net
- Tree View
- triggers
- troubleshooting, distributed updates
- two-phase commit, commit phase [2]
- two-task mode
- 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
- UPI
- UPI/OPI
- USER function, distributed systems
- user process
- user processes, dedicated server processes
- User Program Interface (UPI)
- user-defined exceptions, PL/SQL
- user-initiated disconnect
- USER, data dictionary view
- USERENV function, distributed systems
- users
- 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
- 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
- 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