|
Oracle Network
This section
covers the most important notes that a DBA
should know about the Oracle Network. It
covers configuring different type of methods
a client can access to a database.
Oracle
networking is a method for a DBA to manage
connectivity between database application
clients and the server. Oracle uses the
SQL*NET tool (Oracle Networking Utility)
such as NET8 to perform connectivity,
security, performance, configuration, and
administration of its network.
Configuring the Oracle Network
To configure
the Oracle network, a DBA can use the Oracle
Networking Utility such as the NET8
Assistant or the NET8 Easy Config tools.
A client (user
process) can access to a database either by
dedicated server or shared sever. Connecting
user processes to shared servers in the
multithreaded server (MTS) configuration is
designed to reduce network traffic. Notice
that the MTS architecture consists of a
SQL*NET listener, which hears user requests
from across the network and passes all
requests to the dispatcher. The dispatcher
access to a shared server and the shared
server reads user�s request from the
database (DATAFILES) on behalf of user
process. A dispatcher can receive
information from a client or the Connection
Manager server. A communication between a
dispatcher and a shared server will be
performed through the Common Request Queue
and the Response Queue in the System Global
Area. See the Shared Server Architecture
figure. Note that in the dedicated server, a
server doesn�t share its work with any other
clients.
Shared Server
Architecture figure
Use the Oracle
Connection Manager utility to configure the
network that can act as a firewall for
checking authorization and as a
multi-protocol interchange translates from
one network protocol to another. You can use
the Connection Pooling feature to reduce the
burden on the Oracle Network. It allows the
server to define a maximum number of
connection sockets. If one connection socket
is inactive, it will disable it temporarily
in order to process the new one. See the
Connection Manager figure.
Using
Connection Manager with the Multi-threaded
Server
Connection
Manager Figure
Use the Oracle
Internet Directory (OID) to provide a
single, centralized repository for all user
data. It creates and manages user
identities, roles, authorization and
authentication credentials, and profiles
within a single repository.
Use the Oracle
Names utility to centrally define the
service addresses, inter-database links, net
service names (aliases), and client
configuration profiles by using Oracle
Enterprise Manager utility (OEM).
Use the Single
Sign-On feature to let a user access
multiple accounts and applications with a
single password by using the Oracle Advanced
Security.
Use the Secure
Sockets Layer (SSL) feature to secure
network connections over the internet. SSL
is an industry standard protocol.
Use the Oracle
Wallet Manager feature to authenticate a
user to multiple services, such as database
and application servers. The contents of the
wallet are encrypted with a key based on a
user-specified password. It is part of
Oracle�s SSL implementation.
Questions:
Q: What is
Oracle Networking?
Q: What tool
does Oracle use to establish client/server
connectivity?
Q: What tool
does a DBA use to configure an Oracle
Network?
Q: What is a
dedicated server?
Q: What is a
shared server?
Q: What is
multithreaded sever (MTS)?
Q: Describe a
dispatcher jobs in the Oracle database?
Q: Describe
the Common Request Queue in the SGA?
Q: What does
the Oracle Connection Manager utility?
Q: What does
the Oracle Internet Directory (OID) provide
for Oracle users?
Q: What is the
Oracle Names (ONAME) Utility?
Q: Describe
the Single Sign-On feature in the Oracle
environment?
Q: Describe
the Oracle Wallet Manager feature in the
Oracle environment? |
