Network Admin   «Prev  Next»

Lesson 1

Using Oracle Net for Server Side Administration

Connecting to the database is the primary job of Oracle Net Services. There have been some exciting new improvements in Oracle Net Services that complement improvements in the Oracle database server software. This module explores these new features and shows you when and why to use them.

Oracle Database 23c introduces several advancements in Oracle Net Services

Oracle Database 23c introduces several advancements in Oracle Net Services, enhancing connectivity, security, and performance. Key developments include:
  1. Oracle Connection Manager Enhancements:
    • Direct Path Application Support: Oracle Connection Manager in Traffic Director Mode (CMAN-TDM) now supports direct path applications, enabling more client applications to leverage CMAN-TDM's connection multiplexing capabilities.
    • Usage Statistics: A new V$TDM_STATS view provides usage statistics for CMAN-TDM per Pluggable Database (PDB) Proxy Resident Connection Pools (PRCP), offering insights into active client connections, server connection statuses, and peak usage metrics.
    • IP Rate Limiting: CMAN now offers the ability to limit the number of new connections from a specific IP address within a defined timeframe, protecting databases against potential denial-of-service (DoS) attacks by detecting and rejecting excessive connection attempts.
  2. Database Resident Connection Pooling (DRCP) Improvements:
    • Implicit Connection Pooling: DRCP now automatically assigns servers to applications at runtime, even if the application doesn't explicitly close the connection. This enhancement leads to better scalability and efficient database resource utilization for applications lacking explicit connection pooling.
    • Multiple Named Pools: The introduction of multiple pools allows finer control over DRCP usage, preventing scenarios where certain applications dominate a single pool, thus ensuring equitable resource distribution. citeturn0search1
  3. Enhanced Security Features:
    • Extended Password Length: Oracle Database and client drivers now support passwords up to 1024 bytes, aligning with industry trends for stronger authentication and enhancing security measures.
    • Kerberos Authentication Enhancements: Support for MIT Kerberos library version 1.20.1 brings improvements such as multiple principal support, cross-domain functionality, and Windows Credential Guard integration, bolstering secure authentication mechanisms.
  4. Oracle Data Provider for .NET (ODP.NET) Updates:
    • Asynchronous Programming: ODP.NET now supports the .NET Task Asynchronous Programming (TAP) model, allowing for more responsive data access operations and simplified development of asynchronous applications.
    • OpenTelemetry Integration: Integration with OpenTelemetry provides standardized observability, enabling better monitoring, tracking, and analysis of ODP.NET operations within cloud computing and distributed systems.
These enhancements in Oracle Database 23c's networking capabilities are designed to provide more secure, efficient, and scalable connectivity solutions for modern applications.

Networking Tools

Oracle Net Services provides user interface tools and command-line utilities that enable you to easily configure, manage, and monitor the network.
  1. Oracle Net Configuration Assistant enables you to configure listeners and naming methods.
  2. Oracle Enterprise Manager combines configuration functionality across multiple file systems, along with listener administrative control to provide an integrated environment for configuring and managing Oracle Net Services.
  3. Oracle Net Manager provides configuration functionality for an Oracle home on a local client or server host.
    With Oracle Enterprise Manager (Enterprise Manager), you can fine-tune the listener and naming method configuration created with Oracle Net Configuration Assistant. In addition, Enterprise Manager and Oracle Net Manager offer built-in wizards and utilities that enable to you to
    1. test connectivity,
    2. migrate data from one naming method to another, and
    3. create additional network components.
  4. Command-line control utilities enable you to configure, administer, and monitor network components, including listeners and Oracle Connection Managers.

Module Objectives

By the end of the module, you will be able to:
  1. Configure and run the Connection Manager
  2. Configure Oracle Net Services for multiplexing
  3. Identify scenarios where connection pooling is beneficial
  4. Configure a network for load balancing
  5. Identify situations where automatic instance registration can be an advantage
  6. Define the RADIUS adapter and its purpose
  7. Describe what needs to be configured to use RADIUS adapter
The next lesson looks at configuring and running the Connection Manager.

SEMrush Software TargetSEMrush Software Banner