Network Admin   «Prev  Next»

Lesson 8

Oracle Net Features Conclusion

This module introduced you to the features of Oracle Network Services.
You should now be able to:
  1. Identify new features of the Net listener
  2. Describe Oracle enhancements for scalability
  3. Identify the new features for partitioned tables
  4. Describe Oracle enhancements and new 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 Integration Cloud Service


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.

Oracle Networking Concepts

The following paragraph discusses Network Services functions with the tools that are used to implement the functions.

Oracle Networking Concepts

Primary Communication Foundation for Oracle DB
  1. Oracle's Family of Networking Features:
1) Oracle Net, 2)Oracle Net Listener, 3) Connection Manager, 4) Configuration Tools

Net Configuration Files

  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 Connect Name to Descriptor mappings,
    2. Used by the TNSNames Naming adapter,
    3. On both Client and Server
  4. ldap.ora, a) Contains LDAP configuration information, b) Used the LDAP Naming adapter, c) On both Client and Server

Security RADIUS
Connectivity Multiplexing
Manageability Shared repository
Partitioning Row movement

Net 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.