Oracle8i

Overview

Designed expressly for the beginner,Oracle8i Networking 101 teaches the critical topics necessary to run Oracle8i on a network.

Learn the essentials of using Oracle8i on a network.

Get step-by-step details on implementing Net8 - the Oracle8i mode of networking.

Oracle8i Networking 101 explains how interactions over a network take place,describes the hardware and software required,and how all the components ...

See more details below
Paperback
$37.35
BN.com price
(Save 15%)$43.95 List Price
Other sellers (Paperback)
  • All (20) from $1.99   
  • New (6) from $6.88   
  • Used (14) from $1.99   
Sending request ...

Overview

Designed expressly for the beginner,Oracle8i Networking 101 teaches the critical topics necessary to run Oracle8i on a network.

Learn the essentials of using Oracle8i on a network.

Get step-by-step details on implementing Net8 - the Oracle8i mode of networking.

Oracle8i Networking 101 explains how interactions over a network take place,describes the hardware and software required,and how all the components interface to produce successful communications between computers and databases. Step-by-step procedures illustrated by screen shots demonstrate precisely how to configure on Oracle8i network. Details on Internet protocols and network encrytion are also included.

  • Determine the hardware and software components required for an Oracle network

  • Configure Oracle clients and servers to communicate using Net8

  • Configure Oracle Names servers

  • Make us of configuration tools,including Net8 Assitant,Net8 Configuration Assistant,and the Connection Manager

  • Support large networks with multi-threading and client load balancing

  • Use Oracle WebDB,internet Application Server (iAS),and Internet Directory server

  • Handle security and troublehsooting

Written by an Oracle DBA and authorized by Oracle Corporation,this hands-on resource shows you everything you need to know to plan and set up an Oracle8i networking environment.

Read More Show Less

Product Details

  • ISBN-13: 9780072125177
  • Publisher: McGraw-Hill Companies, The
  • Publication date: 8/25/2000
  • Series: Oracle Press Series
  • Pages: 580
  • Product dimensions: 7.50 (w) x 9.25 (h) x 1.19 (d)

Read an Excerpt

Chapter 1: Overview of Networking

A systems administrator I once worked with was fond of saying, "To understand the future, you must examine the past" because our current technology often reflects and encompasses the advances of the past. This book is both an introduction and a guide to interacting with Oracle in a networked environment. However, I believe that to work effectively with the product set, you must know a little about how network components are assembled and, at the very least, understand some of the basic terminology involved. I spent many years hearing others using terms such as "token-ring" and "Ethernet" or "T1 line," without understanding exactly what they were talking about. (I would, of course, never admit that to them!) Therefore, this first chapter is devoted to some of the history of networking, elementary terminology, and network configurations. I'll also describe some of the hardware involved and the protocols used. Although this book is very Oracle networking centered, this chapter will not cover much Oracle-specific information.

If you already feel comfortable about your knowledge level of basic networking, you can move on to Chapter 2. Of course, you will be missing a review of networking basics, but you will have saved a bit of reading time.

A Brief History of Network Communications

In the mid-1860s, the following scene might have taken place. A sheriff's deputy comes running into the railroad station and hurries to the desk of the Western Union telegraph operator. "Quick," he shouts to the operator, "send a message to the sheriff of Bogus City. Tell him that Butch Blunder and his gang are headed towards his town. He needs to beprepared!" With due haste, the operator sends the message in Morse code. The method used to transmit the message consisting of letters and numbers is a series of timed on-and-off pulses of electricity. Each letter or number has a unique set of short and/or long pulses. The line over which the message is sent is a single wire. The mechanism used to send and receive the message is relatively rugged-to stand up to the rough-and-ready frontier life. Although very simplistic by today's standards, the telegraph provided eastern businesses with a way to communicate with the rugged West. Let's see where communications have gone since the time that early telegram might have been sent. On February 14, 1876, Alexander Graham Bell patented the telephone-two hours before Elisha Gray, of Western Union, filed his patent. The timing on that patent filing is significant because, after a court battle, Bell was awarded not only the rights and patents to the telephone but the network of telephones that Western Union had established, including all enhancements that had been made to Bell's original designs. One hundred years later, Bell's company (later known as AT&T) was the largest company in the world.

Now, let's move our earlier scene forward in time to the late 1800s. Instead of a telegram, the deputy would just pick up a telephone headset consisting of a transmitter (the mouthpiece) and a receiver (the earpiece). He would call a central telephone operator who would then use a switchboard to transfer his call to the sheriff of Bogus City. In 1889, Almon Brown, a Kansas City undertaker, invented the Strowger switch and the telephone dial. These inventions enabled a person to dial a telephone number directly instead of having to go through an operator.

The third version of our story, taking place after the turn of the century, might have the deputy sending a written teletype warning to the sheriff of Bogus City. The original telegraph had some major drawbacks. Only one conversation at a time could cross the line. The wire used was handmade and very brittle. Installing the line was very time consuming, costly, and dangerous. The obvious solution was to develop a multiplex telegraph that would enable several operators to send and receive messages at the same time. The other goal was to create a telegraph system that did not require as much human intervention. A French inventor, Emile Baudot, made many of the necessary breakthroughs. His printing telegraph was the first to use a typewriter keyboard and enabled eight machines to share a single wire. Instead of Morse code, Baudot's machine used a five-level code that sent five pulses down the wire for each character. The machines did the encoding and decoding.

The reoccurring theme in these scenarios is, of course, our society's need to communicate information rapidly from one location to another. There's another, more important point to the three scenarios though. Have you figured it out yet? If you said, "They are all examples of networking," you'd be correct. We tend to think of electronic networks in relation to computers and cable companies that transmit radio and television broadcasts, but, as you can see from this brief history, electronic networks have been around since the mid-1800s.

At first glance, the telephone seems far removed from the computer. In reality, there is a strong interdependency between the two forms of equipment. Over the years, the telephone companies have come to rely on the computer to provide call processing, traffic routing, order tracking, and so on, while computer technology has come to rely on the telephone network to enable worldwide computer interconnection and communication.

For the most part, both the computer and the telephone rely on digital communications-those "on" and "off" pulses that Morse code relied on. However, the telephone still retains analog lines both to your home or office and to the telephone companies' switching equipment. The need to send digital signals over analog lines was the driving force in AT&T's successful invention of the telephone modem. AT&T employees also created the transistor at Bell Labs in 1948. Looking back at our earliest example of networking, the telegraph, you see an example of point-to-point communications...

Read More Show Less

Table of Contents

Acknowledgments xv
Getting Started xix
Part I Getting Down to Basics
1 Overview of Networking 3
A Brief History of Network Communications 4
The Telephone Network 6
The Computer Network 7
Basic Network Configurations and Features 16
The Different Types of Networks 16
Network Topology 22
Network Data Packaging 25
A Look at Open Systems Interconnection 28
Standards at Work 29
The SNA and TCP/IP Reference Models 36
2 Oracle Network Components 41
A Little Bit of Oracle History 42
Enter SQL*Net 44
Basic Architecture 45
Hardware Requirements 45
Component Layers 47
Oracle Protocols 48
Communications Stacks Used by Oracle 51
Dedicated Server Processes 56
Multi-Threaded Server Processes 59
Bequeath Connections 62
Database Links 63
Basic Database Link Architecture 63
Creating a Database Link 65
About Shared Database Links 73
3 Oracle Net8 Components 75
Net8 Components and Parameters 76
Making a Connection 77
Listener.ora 78
The Listener Control Utility (Isnrctl) 89
Tnsnames.ora 95
Sqlnet.ora 101
Understanding SNMP 102
A Look Under the Hood 103
Oracle Enterprise Manager and the Intelligent Agent 104
A Look at OEM 104
4 Oracle Names Server 107
Networking in General 109
Different Architectures 109
Where Networking Fits In 110
About the Oracle Names Server 113
Getting Connection Information 113
Multiple Oracle Names Servers 115
Storing Oracle Names Data 118
More About Global Database Links 118
Oracle Naming Models 124
Configuring an Oracle Names Server 129
Starting an Oracle Names Server 137
About Discovery 139
New Features for Net8 Oracle Names Server 140
The Oracle Names Control (namesctl) Utility 141
Namesctl Commands 143
5 Oracle Internet Directory 151
A Different Kind of Directory 152
Enter, the Database Directory 153
About LDAP Directory Servers 155
LDAP Models 157
Oracle Internet Directory Overview 163
Entries, Attributes, and Object Classes (Oh, My!) 164
Net8 and Oracle Internet Directory 171
About the Components 172
Installing the Oracle Internet Directory 175
Oracle Internet Directory Tools 176
Command Line Tools 177
OID Manager Tool 181
6 Planning Your Network 185
Creating a Network Plan 186
Issues and Considerations 187
Management Questions 187
Network Questions 193
Server Questions 197
Connection Questions 200
Backup and Recovery Questions 203
Part II Using the Configuration Tools
7 Using Net8 Assistant--Local Options 209
Net8 Assistant Basics 211
Using Net8 Assistant 211
Basic Screen Features 213
Pull-Down Menu Options 213
Net8 Assistant Navigator Area 219
Local Configuration Options 222
Profile Configurations 222
Service Naming Configuration 241
Listeners Configuration 247
8 Using Net8 Assistant--Oracle Names Server Options 259
Creating and Configuring Oracle Names Servers 260
Creating a New Oracle Names Server 261
Manage Server Options 262
Manage Data Options 269
Configure Server Options 276
9 Using Net8 Configuration Assistant Options 285
Net8 Configuration Assistant Overview 286
Listener Configuration 288
Naming Methods Configuration 296
Net Service Name Configuration 297
Directory Service Access Configuration 306
10 Connection Manager 311
Oracle Connection Manager Overview 312
Oracle Connection Manager Processes 313
Oracle Connection Manager Connection Concentration 313
Net8 Access Control 314
Multiprotocol Support 316
Configuring the Oracle Connection Manager 317
Cman.ora 317
Configuring Oracle Connection Manager Connection Concentration 322
Configuring Oracle Connection Manager Multiprotocol Support 324
Configuring Oracle Connection Manager Access Control 325
Oracle Connection Manager Control Utility 325
11 Supporting Large Networks 333
Enable Multi-Threaded Server 335
Why Use Multi-Threaded Servers? 336
Enabling Multi-Threaded Server Processes 340
Determining the Right Number of Dispatchers to Specify 344
Resolving Contention Issues Caused by MTS 346
Enabling Connection Pooling, Connection Concentration, and/or Client Load Balancing 362
Prespawn Dedicated Servers 363
Overview of Prespawned Dedicated Server Processes 363
Configuring Prespawned Dedicated Server Processes 364
Part III Oracle Networking and the Internet
12 About the WebDB Listener 369
About WebDB 370
A Look at WebDB Features and Listener 371
Installing the WebDB Listener 371
Before You Begin Installation 372
WebDB Listener Installation Steps 374
After Installation Actions 381
Starting and Stopping the WebDB Listener 384
Running Multiple Virtual Hosts 387
How to Access Static Files 388
Examining the Configuration Parameters 389
Troubleshooting WebDB Listener Problems 395
13 The Oracle Advanced Security Option 397
Overview of the Oracle Advanced Security Products 398
Oh, the Language That They Use 400
A Look at Oracle Advanced Security Features 404
Examining the Oracle Advanced Security Architecture 410
Part IV Troubleshooting
14 Diagnosing Net8 Problems 421
Reported Technical Support Calls 422
General Troubleshooting Guidelines 423
Rules You Can Follow 424
Isolating the Problem 426
Understanding Logs, Trace Files, and Error Messages 432
Getting the Listener to Work 433
Debugging in the Real World--Step by Step 434
Guidelines for Debugging the Most Common Errors 441
Understanding Net8 Log and Trace Files 461
Examining Log Files 461
Examining Trace Files 465
A Sqlnet.ora Parameters 473
B Names.ora Parameters 489
Glossary 497
Index 523
Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)

    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)