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/184.108.40.206 $ORACLE_HOME/bin/netca
Once the GUI starts, respond as follows:
- Listener configuration
- Listener Configuration, Listener
- Add (this should be the only option available if there is no listener present already)
- Listener Configuration, Listener Name
- Listener name: LISTENER (you can leave the default ‘LISTENER’ name or chose your own here)
- Listener Configuration, Select Protocols
- TCP selected
- Listener Configuration, TCP/IP Protocol
- Specify port number (1521 being the default)
- Listener Configuration, More Listeners?
- No to configuring another listener
The listener status can be verified by issuing the lsnrctl command like below:
lsnrcrl stat LISTENER LSNRCTL for Linux: Version 220.127.116.11.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 18.104.22.168.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/22.214.171.124/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: