I must thank my fellow DBA Franky Weber Faust for his publication in his blog.
We know NetCA  Oracle command line for configuring the Oracle listener. NetCA stands for (Network Configuration Assistant). NetCA is used as a configuration assistant launched by the OUI at install time. It is more suitable for a batch mode for silent installations.

I will show how to create the Listener with NETCA in text mode using a response file. Before creating the database I like to create the Listener because if we are going to configure the Enterprise Manager the Listener must be previously created and running.

Listener creation process using NETCA via response file

Adjust the environment variables:

[oracle@oracle-srv netca]$ . oraenv
ORACLE_SID = [cdb] ? cdb2
ORACLE_HOME = [/home/oracle] ? /u01/app/oracle/product/
The Oracle base remains unchanged with value /u01/app/oracle

Run NETCA by passing the response file. The response file default that comes with the installation is enough to upload a Listener, if necessary you can adjust it as you want.

[oracle@oracle-srv netca]$ netca -silent -responsefile /u01/app/oracle/product/
Parsing command line arguments:
Parameter "silent" = true
Parameter "responsefile" = /u01/app/oracle/product/
Done parsing command line arguments.
Oracle Net Services Configuration:
Profile configuration complete.
Oracle Net Listener Startup:
Running Listener Control:
/u01/app/oracle/product/ start LISTENER
Listener Control complete.
Listener started successfully.
Listener configuration complete.
Oracle Net Services configuration successful. The exit code is 0

Verify that the Listener is running:

[oracle@oracle-srv ~]$ lsnrctl status LISTENER

LSNRCTL for Linux: Version - Production on 10-JUN-2017 20:48:02

Copyright (c) 1991, 2016, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oracle-srv.localdomain)(PORT=1521)))
Version TNSLSNR for Linux: Version - Production
Start Date 10-JUN-2017 19:48:06
Uptime 0 days 0 hr. 59 min. 56 sec
Trace Level off
Security ON: Local OS Authentication
Listener Parameter File /u01/app/oracle/product/
Listener Log File /u01/app/oracle/diag/tnslsnr/oracle-srv/listener/alert/log.xml
Listening Endpoints Summary...
The listener supports no services
The command completed successfully

About The Author


Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.