Network Admin   «Prev  Next»

Lesson 1

Installing Oracle Network Services on Oracle Database 11g: An Analytical Guide

  1. Preliminary Considerations:
    Oracle Network Services, an integral component of Oracle Database 11g, facilitates client-server communication and streamlines remote database access. Before you initiate the installation, ensure that:
    1. You've performed a complete system backup.
    2. The system meets the Oracle Network Services prerequisites.
    3. Oracle Database 11g is already installed and functional.
  2. Accessing Oracle Universal Installer (OUI):
    Oracle Universal Installer is the primary tool for the installation of all Oracle components.
    - Launch the OUI from the Oracle home directory: 
      cd $ORACLE_HOME
  ./runInstaller
  3. Navigating the Oracle Universal Installer (OUI):
    • 3.1. Choose the 'Install/Deinstall Products' option.
    • 3.2. The 'Welcome' window will appear. Click 'Next'.
    • 3.3. Ensure the Oracle Home you're working on is selected. If you have multiple Oracle installations, this step is crucial.
    • 3.4. Choose the 'Oracle Net Services' component from the available list.
  4. Installation:
    • 4.1. Select Installation Type: Choose 'Advanced' for a comprehensive installation with full configurability. This is recommended for production environments.
    • 4.2. Product-Specific Prerequisite Checks: The OUI will analyze your system to ensure compatibility. Address any issues the OUI flags before proceeding.
    • 4.3. Specify Installation Actions:
      - You will be presented with a checklist. Ensure you select:
      1. Oracle Program Files: Installs the necessary binaries.
      2. Oracle Net Listener: Enables the database to listen for client connections.
      3. Oracle Net Configuration: Enables network configuration after the installation.
    • 4.4. Configuration Assistants:
      1. Following the component installation, the configuration assistants will launch. Use these to:
      2. Define the listener name (typically "LISTENER").
      3. Specify listening protocol addresses. For most installations, the TCP protocol with the default port (1521) suffices.
      4. Test the listener's functionality.
      5. Save the network configuration.
    • 4.5. Installation Review: The OUI will provide an overview of your selections. Scrutinize this summary. If satisfied, click 'Install'.
    • 4.6. Completion: Post successful installation, the OUI will generate a summary and a log file location. Analyze the log for any anomalies or warnings.
  5. Post-Installation Actions:
    Ensure the smooth functioning of Oracle Network Services by:
    - Starting and stopping the Oracle listener to confirm its operational integrity: 
      lsnrctl start
  lsnrctl stop
    - Checking the status of the Oracle listener: 
      lsnrctl status
  6. Conclusion:
    The installation of Oracle Network Services on Oracle Database 11g, though methodical, is structured to ensure seamless network communication and optimized client-server interactions. By adhering to this analytical guide, DBAs can assure a confident deployment, fostering database reliability and network efficiency.
This module discusses Oracle Net installation and configuration for Oracle databases 11g and higher.
This module does not cover the basic concepts of Net; you should already be familiar with the introductory Net content from the Network administration course. By the end of this module, you will be able to:
  1. Describe changes to initialization parameters needed to support the new features
  2. Add a network node in Net Assistant
  3. Modify the tnsnames.ora file
  4. Describe how to start a Net listener service with Oracle Enterprise Manager
  5. Start a listener with line commands
  6. Describe the uses of the Net Configuration Assistant
In the next lesson, we observe initialization parameters that involve new Net features.

Shared Oracle Databases

With Oracle databases shared across geographical areas, it is very important for the Oracle professional to recognize the importance of network communications on the performance of their databases. As you may know, Oracle provides for distributed communications between databases by using its (TNS) Transparent Network Substrate. The TNS is a distributed protocol that allows for transparent database communications between remote systems. The TNS acts as an insulator between Oracle's
  1. logical request for data and
  2. the physical communications
between the distributed servers. Because of this insulation between the Oracle logical data request and the internal workings of the network, much of the network performance tuning is in the hands of the network administrator. In other words, the Oracle administrator has very little direct control over the network configuration settings that can affect the overall performance of their database .

Oracle Database Administration