The Configuring the Oracle Network Environment module, provides you with the instructions and devices to develop your hands-on skills in the following topics.

  • Managing Oracle Listeners
  • Configuring the Client Side Network
  • Configuring Communications Between Databases

Exercise 1 - Managing Oracle Listeners

When Oracle is initially installed, it creates a listener called LISTENER. Listeners are processes which are used to listen and manage incoming database connections.

In this exercise, you will:

  • Establish a connection to the database
  • Understand how to create a listener
  • Understand how to manage listener with ISNRCTL
  • Understand how to stop, start and reload the listener
  • Understand how to show the status of the listener
  • Understand how to list the services for the listener

Exercise 2 - Configure the Client Side Network

The most widely used and well known method for resolving net service names is the LOCAL NAMING method. Since this method uses the tnsnames.ora file, it is familiar with tnsnames.ora method.

The ORACLE EASY CONNECT Method is a connection resolution technique. It adds parameters that allow for a port and service name specification. By default, the ORACLE EASY CONNECT names resolution Method is configured when Oracle Net is installed. It eliminates the need for service name lookup in the tnsnames.ora files for TCP/IP environments; in fact no naming or directory system is required if this method is used.

In this exercise you will:

  • Understand the Oracle Easy Connect Method
  • Understand the Local Naming Method
  • Understand the Contents and Structure of a tnsnames.ora file
  • Configure the Oracle Shared Server
  • Request a dedicated connection in a shared server environment.

Exercise 3 - Configure Communication Between Databases

DHCP has started using the Oracle supplied package DBMSCONNECTIONPOOL. To start the pool, execute the START_POOL procedure after logging into the database using SYSDBA connection.

A private database link is created using CREATE DATABASE LINK statement, and the public database link is created using CREATE PUBLIC DATABASE LINK statement. The rest of the syntax for both statements is exactly the same.

In this exercise you will:

  • Understand how to configure DRCP
  • Understand how to create database links

Comprehensive Learning

See the full benefits of our immersive learning experience with interactive courses and guided career paths.