Configuring Listener Exercise

Edit listener.ora: add COIN instance

Objective: Add the COIN instance to the list of services in your listener.ora configuration. In this exercise, you will paste the updated SID_LIST entry (or the updated block) into the text area for scoring.

Exercise scoring

You will receive 10 points for this exercise. This exercise is auto-scored. When you have completed the steps below, click Submit to receive full credit.

Instructions

Locate the listener.ora file on your system (commonly under $ORACLE_HOME/network/admin).
Find the SID_LIST section that contains existing SID_DESC entries.
Copy an existing database-related SID_DESC entry.
Paste it as a new entry and update the values to represent the COIN instance.
Paste your updated entry (or the updated SID_LIST block) into the text area below.
Click Submit.

Hints

Adding a SID^[1] to the SID_LIST is best done by copying and pasting an existing entry and then modifying the duplicate to point to your new database instance. You should already have an entry for a starter database in the SID_LIST; copy from that entry to avoid parenthesis and formatting mistakes.

Submitting your exercise

When you are done, click Submit to send your solution to the exercise result page for scoring.

[1](SID) Oracle system identifier: An Oracle system identifier (SID) is a unique name for an Oracle database instance on a specific host. The SID identifies the instance locally on the Oracle server and is commonly used in legacy listener configurations. The SID prefix is often derived from the first characters of the database name and typically uses only letters and digits.