List of Figures

1-1 Basic Client-to-Server Connection

1-2 Client-to-Server Connection through Oracle Names

1-3 Client to Server Connections through Oracle Connection Manager

2-1 OSI Communications Stack

2-2 Typical Communications Stack in an Oracle environment

2-3 Typical Client vs. IIOP Client Communication Stacks

2-4 Client/Server Communications Stack in an IIOP Environment

2-5 Typical Client vs. JDBC Client Communication Stacks

2-6 Client/Server Communications Stack in a JDBC Environment

2-7 Redirected Connection to a Dispatcher

2-8 Redirected Connection To a Prespawned Dedicated Server Process

2-9 Bequeathed Connection To a Dedicated Server Process

2-10 Listener In a Typical Net8 Connection

2-11 Oracle Names

2-12 Single Domain Naming Model

2-13 Hierarchical Naming Model

2-14 Default Domains

2-15 Delegated Administrative Regions

2-16 Connection Concentration through Oracle Connection Manager

2-17 Multi-Protocol Support Through Oracle Connection Manager

2-18 Connection Pooling

5-1 Oracle8i Client to Oracle8i Database

5-2 Oracle8i Client release 8.0/Oracle7 Client to Oracle8i Database

5-3 Oracle8i Client to Oracle8i Release 8.0/Oracle7 Database

6-1 Net Service Name Usage in TNSNAMES.ORA

6-2 Multiple Listener Addresses

7-1 TNSNAMES.ORA File with and without Oracle Connection Manager

7-2 CMAN Parameter Configured to Use Multi-Protocol Support

8-1 Successful Trace Route

8-2 Trace Route with Error

9-1 Oracle Multi-Threaded Sever Architecture

10-1 Net8 OPEN

11-1 Network Products and Error Stack Component

11-2 Typical Error Stack

11-3 Typical Audit Trail Information for Successful Reload Request

11-4 Typical Audit Trail Information for Successful Connection Request

11-5 CMAN_PID.LOG

11-6 CMADM_PID.LOG

11-7 Packet Information

11-8 Trace File Error Output

11-9 Typical Trace Assistant Conversion

11-10 Summary Data Packets Sent in a Bequeathed Connection

11-11 Detailed Data Packets Sent in a Bequeathed Connection

11-12 Summary Data Packets Sent in a Redirected Connection

11-13 Data Packet

11-14 Two Task Common Summary Information

11-15 Two Task Common Summary Information

11-16 Detailed SQL information on top of summary Two-Task

11-17 Typical Trace File Statistics

11-18 Trace File Example

C-1 General Syntax of TNSNAMES.ORA

C-2 Multiple Descriptions in TNSNAMES.ORA

C-3 Multiple Address Lists in TNSNAMES.ORA

C-4 Client Load Balancing for Release 8.1 and Prior to Release 8.1

C-5 Multiple Oracle Connection Manager Addresses TNSNAMES.ORA

C-6 Client Load Balancing in TNSNAMES.ORA

---