Oracle8 Distributed Database Systems
Release 8.0
A58247-01

Product

Contents

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

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

datatypes

Date

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

ORA-00900

ORA-02015

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

passthrough SQL

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 errors

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

Library

Product

Contents