Oracle8 Distributed Database Systems
Release 8.0

A58247-01

Library

Product

Contents

Prev

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 


Numerics

3GL routine names, 6-4

A

abort message, 3-4
access
remote integrity constraints and objects, 5-3
administration
distributed databases, 2-1
Agents, 6-5
Agent-specific initialization parameters, 7-4
aggregates, 2-25
ALL
data dictionary view, 2-19
ALTER SESSION
system privilege, 5-2
ALTER SESSION command
ADVISE option, 3-23
CLOSE DATABASE LINK option, 5-2
ALTER SYSTEM command
DISABLE DISTRIBUTED RECOVERY option, 3-35
ENABLE DISTRIBUTED RECOVERY option, 3-35
ANALYZE command
distributed transactions, 2-27
application development
in a distributed database environment, 5-1
using Heterogeneous Services, 8-1
Application development with Heterogeneous Services, 8-1
applications
development
constraints, 5-3
database links
controlling connections, 5-2
distributing data, 5-2
referential integrity, 5-3
remote connections
terminating, 5-2
errors
RAISE_APPLICATION_ERROR() procedure, 5-4
AUTHENTICATED BY, 2-8
authentication mechanism, 4-2

B

bind queries
executing, 8-7
BIND_INOUT_VARIABLE, 8-3
BIND_INOUT_VARIABLE procedure, 8-7
BIND_OUT_VARIABLE, 8-3
BIND_OUT_VARIABLE procedure, 8-6
BIND_VARIABLE, 8-3
buffering multiple rows, 8-8

C

calls
remote procedure, 1-11
CATHO.SQL
script to install data dictionary tables and views for HS, 7-2
certificates, 4-2
Character sets, A-5
client/server architectures
direct and indirect connections, 1-2
distributed databases and, 1-2
clients
role in distributed transactions, 3-6
CLOSE DATABASE LINK option, 5-2
CLOSE_CURSOR, 8-3
Comments
in COMMITstatements, 3-23
commit
forcing, 3-31
COMMIT command
COMMENT parameter, 3-23, 3-34
FORCE option, 3-32
forcing, 3-22
two-phase commit and, 1-12
Commit phase, 3-16
commit phase, 3-3, 3-4
Commit point site, A-2
commit point site, 3-8
commit point strength and, 3-9
determining, 3-10
COMMIT_POINT_STRENGTH parameter, A-2
committing transactions
distributed
commit point site, 3-8
connected user database link, 2-11
connections
changing hold time, 3-33
remote
terminating, 5-2
constraints
application development issues, 5-3
ORA-02055
constrain violation, 5-3
CREATE ROLE statement, 4-5
CREATE USER statement, 4-4
CREATE_INST_INIT procedure, 7-14
cursors, 8-7
and closing database links, 5-2

D

dabase links
resolution, 2-14
Data Definition Language (DDL)
distributed transactions, 2-27
Data Dictionary
installing for Heterogeneous Services, 7-2
data dictionary
views
ALL, 2-19
DBA_DB_LINKS, 2-19
USER, 2-19
data dictionary tables, 6-3
data dictionary view
TRUSTED_SERVERS, 4-7, D-1
Data Dictionary Views, 7-7
Data manipulation statements (DML)
allowed in distributed transactions, 1-10
Database link
for a foreign system, 7-4
database link
connected user, 2-11
fixed user, 2-10
database links
and Heterogeneous Services, 6-4
closing, 5-2
controlling connections, 5-2
creating shared, 2-8
data dictionary views
ALL, 2-19
DBA_DB_LINKS, 2-19
USER, 2-19
dropping, 2-19
listing, 2-19
minimizing network connections, 2-6
overview of, 1-5
shared, 2-6
configurations, 2-8
to multi-threaded (MTS) servers, 2-9
databases
administration, 2-1
controlling trust, 4-7
distributed
site autonomy of, 1-15
managing
Server Manager, 1-18
trust, 4-7
datatypes
mapping, 6-4
Date
defining format, A-6
DB_DOMAIN initialization parameter, 7-14
DB_DOMAIN parameter, A-3
DB_INTERNAL_NAME parameter, A-3
DB_NAME parameter, A-4
DBA_2PC_PENDING view, 3-30
DBA_DB_LINKS
data dictionary view, 2-19
DBMS_DISTRIBUTED_TRUST_ADMIN package, 4-7
DBMS_DISTRIBUTED_TRUST_ADMIN.ALLOW_DATABASE, D-4
DBMS_DISTRIBUTED_TRUST_ADMIN.DENY_ ALL, D-2
DBMS_DISTRIBUTED_TRUST_ADMIN.DENY_DATABASE, D-5
DBMS_HS package, 7-13
DBMS_HS_PASSTHROUGH
list of functions and procedures, 8-3
DBMS_HS_PASSTHROUGH package, 8-2
DBMS_HS_PASSTHROUGH.EXECUTE_IMMEDIATE, C-17
declarative referential integrity constraints, 5-3
digital identities, 4-2
DigitalsPOLYCENTERManageronNetView', 1-19
disabling
recoverer process, 3-35
distinguished name, 4-4
distributed applications
distributing data, 5-2
distributed database systems
assigning global roles, 4-5
distributing an application's data, 5-2
location transparency, 2-20
location transparency using synonyms, 2-22
referential integrity
application development, 5-3
security, 4-1
transparency
queries, 2-25
updates, 2-25
distributed databases
commit point strength, 3-9
database links, 1-5
diagrammed, 1-2
distributed queries, 1-10
distributed updates, 1-10
global object names, 1-6
management tools, 1-17
nodes of, 1-2
overview of, 1-2
remote queries and updates, 1-10
site autonomy of, 1-15
testing features, 3-34
transparency of, 1-13
distributed external procedure
process architecture, 6-6
Distributed external procedures
data dictionary views, 7-8
installation, 7-5
distributed external procedures, 6-4
distributed queries
application development issues, 5-3
distributed systems
remote object security, 2-22
distributed transactions
clients role, 3-6
commit point site, 3-8
commit point strength, 3-9
database server role, 3-6
defined, 1-11
failure during, 3-20, 3-21
forcing to fail, 3-34
global coordinator, 3-7
hold time, 3-33
limiting number, 3-19
limiting number of, 3-33
local coordinator, 3-7
locked resources, 3-21
management, 3-1
manually overriding in-doubt, 3-22
read-only, 3-18
recovery in single-process systems, 3-36
restrictions, 2-27
session tree, 3-5
setting advice, 3-23
troubleshooting, 3-20
two-phase commit
example, 3-11
when committed, 3-8
DISTRIBUTED_LOCK_TIMEOUT parameter
controlling time-outs with, 3-21
DISTRIBUTED_RECOVERY_CONNECTION_HOLD_TIME parameter
setting, 3-33
DISTRIBUTED_TRANSACTIONS parameter
recoverer process (RECO), 3-19
setting, 3-19, 3-33
when to alter, 3-19
dropping
database links, 2-19
dynamic linked libraries, 6-6

E

enabling
recoverer process, 3-35
enqueue procedure, 6-7
enterprise roles, 4-6
creating in Oracle Security Server, 4-6
definition, 4-6
environmentally-dependent SQL functions, 2-27
errors
application development, 5-3
distributed transactions, 3-20
messages
trapping, 5-4
ORA-00900
SQL error, 5-4
ORA-01591, 3-21
ORA-02015
SQL error, 5-4
ORA-02049, 3-21
ORA-02050, 3-20
ORA-02051, 3-20
ORA-02054, 3-20
ORA-02055
integrity constrain violation, 5-3
ORA-02067
rollback required, 5-3
ORA-06510
PL/SQL error, 5-6
remote procedures, 5-4
examples
manual transaction override, 3-23
EXCEPTION
PL/SQL keyword, 5-4
exception handler, 5-4
local, 5-6
exceptions
assigning names
PRAGMA_EXCEPTION_INIT, 5-4
remote procedures, 5-4
user-defined
PL/SQL, 5-4
EXECUTE_IMMEDIATE, 8-3
restrictions, 8-4
EXECUTE_NON_QUERY, 8-3
external_name string, 4-4

F

FETCH_ROW, 8-3
FETCH_ROW procedure, 8-7
fetching, 8-8
optimizing round-trips, 8-8
fetching rows, 8-8
forcing
COMMIT or ROLLBACK, 3-22, 3-30
foreign key, 5-3
Foreign system
global name, A-4

G

GET_VALUE, 8-3
GET_VALUE procedure, 8-6, 8-7
global coordinator, 3-7
global data inconsistency, 8-2
global database name, 2-2
global names
resolution, 2-17
global naming, 2-2
global object names, 2-2
global role, 4-2
global roles, 4-5
and external roles, 4-6
creating, 4-5
granting privileges, 4-6
naming conflicts, 4-5
global users, 4-2, 4-3
creating, 4-4
creating in the local database, 4-4
defining in the Oracle Security Server, 4-4
naming conflicts, 4-4
GLOBAL_NAMES initialization parameter, 2-2
GRANT statement
global roles, 4-6

H

Heterogeneous Services
agents, 6-5
application development issues, 8-1
concepts, 6-1
overview, 1-8
process architecture, 6-5
hold time
changing, 3-33
HPsOpenView', 1-19
HS_EXTERNAL_OBJECTS data dictionary view, 7-12

I

IBMsNetView/6000', 1-19
IN bind variables, 8-5
IN OUT bind variables, 8-7
in-doubt transactions, 3-3
after a system failure, 3-20
forcing a commit, 3-31
forcing a rollback, 3-31
intentionally creating, 3-34
overriding manually, 3-22
pending transactions table, 3-30
recoverer process, 3-35
rollback segments, 3-22
rolling back, 3-32
Initialization parameters
specifying, 7-13
integrity constraints
ORA-02055
constraint violation, 5-3

J

joins, 2-25

K

keys
primary, 5-3
unique, 5-3

L

Language, A-5
LANGUAGE parameter, A-5
large data sets, 8-2
Listener, 7-2
listing database links, 2-19
local coordinator, 3-7
Location Transparency, 7-5
location transparency, 2-20
using procedures, 2-24
LOCK TABLE command
in distributed transactions, 2-27
locks
in distributed transactions, 3-21
LONG columns, 2-27
LONG RAW columns, 2-27

M

messages
error
trapping, 5-4
messaging sustems, 6-4
multiple rows
bufferung, 8-8
multi-threaded (MTS) servers and shared database links, 2-9
multi-threaded server mode, 2-6

N

name resolution
in distributed databases, 1-6
National Language Support (NLS)
clients and servers may diverge, 1-19
Net3 listener, 7-2
Net8 Listener, 6-5
network connections
minimizing, 2-6
networks
distributed databases use of', 1-2
security, 4-1
NLS_DATE_FORMAT parameter, A-6
NLS_DATE_LANGUAGE parameter, A-7
NO_DATA_FOUND
PL/SQL keyword, 5-4
non-queries
passthrough SQL, 8-3
NovellsNetWareManagementSystem', 1-19

O

object names
resolving partial, 2-16
objects
referencing with synonyms, 2-22
OPEN_CURSOR, 8-3
OPEN_LINKS initializtion parameter, 2-19
operating system dependencies, C-1
ORA-00900
SQL error, 5-4
ORA-02015
SQL error, 5-4
ORA-02055
integrity constraint violation, 5-3
ORA-02067
rollback required, 5-3
ORA-06510
PL/SQL error, 5-6
Oracle Security Server, 4-2
operations, 4-2
Oracle Security Server Manager, 4-4, 4-6
OUT Bind Variables, 8-6
OUT bind variables, 8-6

P

parent/child table relationships
maintaining, 5-3
PARSE, 8-3
partial global object name, 2-16
Pass-through SQL, 8-2
pass-through SQL
avoiding SQL interpretation, 8-2
overview, 8-2
restrictions, 8-2
passthrough SQL
non queries, 8-3
queries, 8-3
pass-through SQL statements
executing, 8-3
pass-through SQL statements with bind variables, 8-4
pending transaction tables, 3-30
PL/SQL
error
ORA-06510, 5-6
user-defined exceptions, 5-4
PL/SQL development environment, 8-2
PL/SQL external procedures, 6-4
PRAGMA_EXCEPTION_INIT
assigning exception names, 5-4
preface
Send Us Your Comments, iii
prepare phase, 3-3
recognizing read-only nodes, 3-18
prepare/commit phases
abort response, 3-3
effects of failure, 3-21
failures during, 3-20
forcing to fail, 3-34
locked resources, 3-21
pending transaction table, 3-30
prepared response, 3-3
read-only response, 3-3
testing recovery, 3-34
primary
key, 5-3
privileges
closing a database link, 5-2
committing in-doubt transactions, 3-32
managing with procedures, 2-25
managing with synonyms, 2-23
managing with views, 2-22
rolling back in-doubt transactions, 3-32
Procedural service, 6-3
PROCEDURE ALLOW_ALL, 4-7
PROCEDURE ALLOW_SERVER (server IN VARCHAR2), 4-7
procedure calls
remote, 1-11
PROCEDURE DENY_ALL, 4-7
PROCEDURE DENY_SERVER (server IN VARCHAR2), 4-7
procedures
location transparency using, 2-24
remote
error handling, 5-4
process architecture for distributed external procedures, 6-6
public database link
connected user, 2-11
fixed user, 2-10
public fixed user database link, 2-10
public key cryptology, 4-2

Q

Queries
pass-through SQL, 8-7
queries
distributed, 1-10
application development issues, 5-3
distributed or remote, 1-10
during prepare phase, 3-3
location transparency and, 1-14
passthrough SQL, 8-3
post-processing, 5-3
remote, 5-3
remote execution, 5-3
transparency, 2-25
queuing system, 6-4

R

RAISE_APPLICATION_ERROR procedure
remote procedures, 5-4
read-only transactions
distributed, 3-18
recover in-doubt transaction dialog, 3-31
recoverer process (RECO)
disabling, 3-35
distributed transaction recovery, 3-35
DISTRIBUTED_TRANSACTIONS parameter, 3-19
enabling, 3-35
pending transaction table, 3-35
recovery
testing distributed transactions, 3-34
referential integrity
distributed database systems
application development, 5-3
using triggers to enforce, 5-3
remote data
querying, 2-25
updating, 2-25
remote procedure calls, 6-4
remote procedure calls (RPCs), 1-11
remote procedures
error handling
application development, 5-4
remote queries, 5-3
execution, 5-3
post-processing, 5-3
remote transactions, 1-11
restriction
distributed transactions, 2-27
rollback
forcing, 3-31
ROLLBACK command
FORCE option, 3-32
forcing, 3-22
rollback segments
in-doubt distributed transactions, 3-22
rollbacks
ORA-02067 error, 5-3
rows
buffering multiple, 8-8
fetching, 8-8
RPC, 1-11
RPCs, 6-4

S

savepoints
in-doubt transactions, 3-32
schema objects
distributed database naming conventions for, 1-6
global names, 1-6
security
database trust, 4-7
distributed database systems, 4-1
for remote objects, 2-22
using synonyms, 2-23
SELECT ... FOR UPDATE, 2-25
Send Us Your Comments
boilerplate, iii
SERVER clause, 2-9
Server Manager, 1-18
servers
role in two-phase commit, 3-6
Service names, 7-4
sessions
setting advice for transactions, 3-23
Setting up access to Foreign Systems, 7-7
shared database links, 2-6
configurations, 2-8
creating, 2-8
to dedicated servers, 2-8
to multi-threaded (MTS) servers, 2-9
SHARED keyword, 2-8
shared SQL for remote and distributed statements, 2-27
Simple Network Management Protocol (SNMP) support
database management, 1-18
single-process systems
enabling distributed recovery, 3-36
site autonomy, 1-15
SQL capabilities
data dictionary tables, 7-11
SQL dialect, 6-3
SQL errors
ORA-00900, 5-4
ORA-02015, 5-4
SQL service, 6-3
capabilities, 6-3
data dictionary views, 7-8
SQL statement
reducing parsing, 8-4
SQL statements
distributed databases and, 1-10
mapping to non-Oracle datastores, 8-2
multiple, 8-4
stored procedures
distributed query creation, 5-3
managing privileges, 2-25
remote object security, 2-25
subqueries, 2-25
in remote updates, 1-10
SunSoftsSunNetManager', 1-19
synonyms
CREATE command, 2-22
definition and creation, 2-22
examples, 2-23
location transparency using, 2-22
managing privileges, 2-23
name resolution, 2-17
remote object security, 2-23
System Change Number (SCN)
in-doubt transactions, 3-32
system change numbers (SCN)
coordination in a distributed database system, 3-18

T

tables
parent/child relationships
maintaining across nodes, 5-3
third generation language (3GL) routines, 6-4
transaction management
overview, 3-2
transactions
closing database links, 5-2
distributed
read-only, 3-18
restrictions, 2-27
two-phase commit and, 1-12
in-doubt, 3-3
after a system failure, 3-20
pending transactions table, 3-30
recoverer process (RECO) and, 3-35
manual overriding in-doubt, 3-22
read-only
distributed, 3-18
transactions folder
forcing a commit
Enterprise Manager, 3-31
forcing a rollback
Enterprise Manager, 3-31
transparency, 2-20
location
using procedures, 2-24
query, 2-25
update, 2-25
triggers
distributed query creation, 5-3
enforcing referential integrity, 5-3
maintaining parent/child table relationships across nodes, 5-3
troubleshooting
distributed transactions, 3-20
trust between databases, 4-7
trusted databases
administering, 4-7
TRUSTED_SERVER
data dictionary view, 4-7, D-1
two-phase commit
commit phase, 3-4, 3-16
described, 1-12
example of, 3-11
prepare phase, 3-3
recognizing read-only nodes, 3-18

U

unique key, 5-3
updates
location transparency and, 1-14
transparency, 2-25
USER
data dictionary view, 2-19
user-defined exceptions
PL/SQL, 5-4

V

Variables
BIND, 8-4
variables
IN bind, 8-5
IN OUT bind, 8-7
views
location transparency using, 2-20
managing privileges with, 2-22
name resolution, 2-17
remote object security, 2-22
vriables
OUT bind, 8-6

X

X.509 certificate standard, 4-4


Prev
Oracle
Copyright © 1997 Oracle Corporation.

All Rights Reserved.

Library

Product

Contents