Viewing Listener Configuration

The listener runs on your database server computer and handles incoming client requests. With Oracle Enterprise Manager Database Control (Database Control), you can view the status of the listener, which is set to start automatically whenever your server computer is restarted. You can also view the listener status at the command line.

To view information about the listener with Database Control:

• On the Database Home page, click the Listener link under General.

  The Listener page appears, displaying the following information about the listener:

  • Current status

  • Availability over the last 24 hours

  • Alias

  • Version

  • Oracle home

  • Net address

  • Configuration file (listener.ora) location

  • Start time

  • Host

  For more information about a page at any time, click Help on that page.

To view information about the listener at the command line:

1. Open a command window.

2. (Linux and UNIX systems only) Set the required environment variables by running the script oraenv (for the Bourne, Korn, or Bash shells) or coraenv (for the C shell).

   These scripts are typically located in the /usr/local/bin directory. They may prompt you for the desired value of the ORACLE_SID environment variable. If so, supply the system ID (SID) that you chose when you installed Oracle Database. The default SID that the installer typically suggests is orcl.

3. (Linux and UNIX systems only) Either ensure that the Oracle_home/bin directory is in your PATH environment variable, or change the directory to Oracle_home/bin.

4. Enter the following command:

   lsnrctl status