Since 1999     References  |  Search more  | Oracle Syntax  | Free Online Oracle Problem Solver

    .Home      .Subscribe     .Login      .Start Learning      .Certification      .Cancel      .Password Reminder      .Password Change     .Sign out


. Online Accounting        .Copyright & User Agreement   |
    .Vision      .Biography     .Acknowledgement

.Contact Us      .Comments/Suggestions       .Email2aFriend    |


Online Oracle Training for beginners and advanced - The most comprehensive Oracle tutorial

The authors do not guarantee or take any responsibility for the accuracy, or completeness of the information.

DBAs - Fundamentals II


Lesson 01 | Lesson 02 | Lesson 03 | Lesson 04 | Lesson 05 | Lesson 06 | Lesson 07 | Lesson 08 | Lesson 09 | Lesson 10 | Lesson 11 | Lesson 12 | Lesson 13 | Lesson 14 | Lesson 15 | Lesson 16 | Lesson 17 | Lesson 18 | Lesson 19 | Lesson 20 | Lesson 21 | Lesson 22 | Lesson 23 | Lesson 24 | Lesson 25 | Lesson 26 | Lesson 27 | Lesson 28 | Lesson 29 |


Lesson 23

“The only normal people are the ones you don't know very well.” Joe Ancis


Read first then play the video:

   DBA-VIDEO -Configuring a LISTENER using the Net Manager Tool


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.


“I have never met a man so ignorant that I couldn't learn something from him.” Galileo Galilei (1564 - 1642)



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?