Create Listener.ora File

Oracle Listener Operation - Exercise

Create a listener.ora file

Objective: Create a listener.ora file.

Exercise scoring

This exercise is worth a total of 10 points. To receive full credit, you will need to create a correct listener.ora file for the server described below.

Instructions

In this exercise, you will use a sample template to create a listener.ora file for the following server:

Hostname=FRED
Listener port=1523 
ORACLE_HOME=/u01/oracle/product/8.0.5 
Databases are HUEY, DEWIE, and LOUIE 
Here is the sample template:

# Filename: Listener.ora
# 
LISTENER =
  (ADDRESS_LIST =
        (ADDRESS= (PROTOCOL= IPC)(KEY= tom))
        (ADDRESS= (PROTOCOL= IPC)(KEY= jerry))
        (ADDRESS= (PROTOCOL= TCP)(Host= dilbert)(Port= 1521))
  )
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME= dilbert.)
      (ORACLE_HOME= /ora7/home/dba/oracle/product/7.3.4)
      (SID_NAME = tom)
    )
    (SID_DESC =
      (GLOBAL_DBNAME= dilbert.)
      (ORACLE_HOME= /ora7/home/dba/oracle/product/7.3.4)
      (SID_NAME = jerry)
    )
  )
STARTUP_WAIT_TIME_LISTENER = 0
TRACE_LEVEL_LISTENER = OFF

Source code

For your convenience, the template above is available in the compressed download file available on the Resources page.

Submitting the exercise

Type or paste your answer into the text box below, then click the Submit Button to submit your answer and view a results page.