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