“The only normal
people are the ones you don't know very well.” Joe Ancis
first then play the video:
a LISTENER using the Net Manager Tool
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
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
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.
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.
Connection Manager with the Multi-threaded Server
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
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.
“I have never met a
man so ignorant that I couldn't learn something from him.”
Galileo Galilei (1564 - 1642)
Q: What is Oracle
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
Q: What is a shared server?
Q: What is multithreaded
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
Q: Describe the Single
Sign-On feature in the Oracle environment?
Q: Describe the Oracle
Wallet Manager feature in the Oracle environment?