Network Admin   «Prev  Next»

Lesson 8

Oracle Network Services Summary

This module introduced you to the features of Oracle Network Services.
You should now be able to:
  1. Identify features of the Oracle Net listener
  2. Describe Oracle enhancements for scalability
  3. Identify the characteristics for partitioned tables
  4. Describe Oracle enhancements and features that improve connectivity
  5. Describe Oracle enhancements that improve manageability of network/database tasks
  6. Describe Oracle enhancements that improve and simplify security
As you have seen, Oracle connectivity has constantly evolved from its earliest version. Oracle is now concentrating on adding new features that increase the functionality of its existing framework.

Oracle Network Services beginning with Oracle 9i

Oracle Network Services, beginning with Oracle 9i, appear to have introduced several features aimed at enhancing network security, scalability, and manageability. These features might include:
  1. Advanced Security: Oracle 9i potentially introduced more robust security features, such as stronger encryption algorithms and support for SSL/TLS. This could have been designed to ensure secure data transmission across networks.
  2. Scalability and Performance Improvements: There might have been significant enhancements in scalability, possibly including features like connection pooling and shared server configurations. These would be intended to handle a large number of client connections more efficiently.
  3. Load Balancing and Failover Capabilities: Oracle 9i may have improved its support for load balancing and failover, which would be crucial for high availability and reliability. This could involve distributing client requests across multiple servers and providing automatic failover in case of server failure.
  4. Enhanced Configuration and Management Tools: The introduction of better management tools could have been a focus, possibly simplifying the configuration and management of network components. This would include user-friendly interfaces and command-line tools.
  5. Integration with Directory Services: There might have been integration with directory services like LDAP, which would allow centralized management of network resources and user authentication.
  6. Support for Multiple Network Protocols: Oracle 9i potentially expanded its support for various network protocols, ensuring compatibility and flexibility in different network environments.
  7. Monitoring and Diagnostics Enhancements: Enhanced monitoring and diagnostic tools could have been included to provide detailed insights into network performance and to quickly identify and resolve network-related issues.
It's important to note that these features are based on the general evolution of Oracle Network Services with the release of Oracle 9i, and specific implementations and capabilities might vary.

Oracle Networking Concepts

The following paragraph discusses "Oracle Network Services" functions with the tools that are used to implement those functions. Primary Communication Foundations for an Oracle database are:
  1. Oracle's Family of Networking Features:
1) Oracle Net, 2)Oracle Net Listener, 3) Connection Manager, 4) Configuration Tools
The Network Configuration Files consist of:
  1. sqlnet.ora: a) Main Oracle Net configuration file, b) On both Client and Server
  2. listener.ora: a) Configuration for the Net Listener, b) On Server only
  3. tnsnames.ora:
    1. Contains the Connect Name to descriptor mappings,
    2. Used by the TNSNames Naming adapter,
    3. On both the client and server.
  4. ldap.ora: a) Contains LDAP configuration information, b) Used the LDAP Naming adapter, c) On both the Client and Server

Security RADIUS
Connectivity Multiplexing
Manageability Shared repository
Partitioning Row movement

Network services enables services and their applications to reside on different computers and communicate as peer applications.
The main function of Net is to establish network sessions and transfer data between a client machine and a server or between two servers. Net is located on each machine in the network and once a network session is established, Net acts as a data courier for the client and the server.

Client Server
Basic Client-to-Server Connection

Database Connection Features

The connection between the client and the database server is a key component of the overall architecture. The database connection is responsible for supporting all communications between an application and the data it uses. Oracle includes a number of features that establish and tune your database connections. We have divided the discussion into two categories:
  1. database networking and
  2. Oracle Application Server.

Database Networking

Database users connect to the database by establishing a network connection. You can also link database servers via network connections. Oracle provides a number of features to establish connections between users and the database and/or between database servers, as described in the following subsections.


In this module, you were introduced to the following glossary terms:
  1. Advanced Queuing: A pre-defined package enabling you to store messages into queues for deferred retrieval and processing by the Oracle server.
  2. Cache fusion: A diskless data transfer method for Oracle Parallel Server (OPS) that moves information from the cache of one database instance to the cache of another database instance.
  3. Multiplexing: Combining several individual transmissions and sending them across a single connection to and from a database.
  4. Partitioned table: A table containing data in multiple physical tables. This divides large amounts of data into smaller segments.
  5. RADIUS: Acronym for Remote Authentication Dial-In User Service, a client-server security protocol that is used primarily with the Internet.
  6. Snapshot: A replica of a table or part of a table that resides on another database instance. Snapshots can be read-only or updateable.
  7. Transparent application failover (TAF) : A feature in Net to seamlessly move a user’s session from one instance to another when the original instance fails.

The next module covers the changes in Net installation and configuration.

Ad Oracle Integration Cloud Service