Creating an Oracle Listener using NETCA

In this example, I’m creating a simple Oracle Listener service called ‘LISTENER’ using the default port of 1521.

Start the Oracle Net Configuration Assistant (NETCA)

Open an X-Windows session to the server as the ‘oracle’ user.

Set your ORACLE_HOME environment variable appropriately, then start the assistant by running the following:

export ORACLE_HOME=/u01/app/oracle/product/11.2.0.3
$ORACLE_HOME/bin/netca

Once the GUI starts, respond as follows:

  • Welcome
    • Listener configuration
    • Next

  • Listener Configuration, Listener
    • Add (this should be the only option available if there is no listener present already)
    • Next

  • Listener Configuration, Listener Name
    • Listener name: LISTENER (you can leave the default ‘LISTENER’ name or chose your own here)
    • Next

  • Listener Configuration, Select Protocols
    • TCP selected
    • Next

  • Listener Configuration, TCP/IP Protocol
    • Specify port number (1521 being the default)
    • Next

  • Listener Configuration, More Listeners?
    • No to configuring another listener
    • Next
    • Next
    • Finish

  

The listener status can be verified by issuing the lsnrctl command like below:

lsnrcrl stat LISTENER

LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 19-MAR-2013 21:59:43
Copyright (c) 1991, 2011, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.3.0 - Production
Start Date                19-MAR-2013 21:58:41
Uptime                    0 days 0 hr. 1 min. 2 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/11.2.0.3/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/linux03/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=linux03.vbox)(PORT=1521)))
Services Summary...
Service "db11g" has 1 instance(s).
  Instance "db11g", status READY, has 1 handler(s) for this service...
Service "db11gXDB" has 1 instance(s).
  Instance "db11g", status READY, has 1 handler(s) for this service...
The command completed successfully

…and the listener configuration will have been written to the following file:

$ORACLE_HOME/network/admin/listener.ora

3 thoughts on “Creating an Oracle Listener using NETCA

Leave a comment

Your email address will not be published.