Listener Creation using NETCA

Introduction:
NETCA (Network Configuration Assistant) is an Oracle utility used to configure network components for Oracle databases. It simplifies the setup and management of network configurations, including creating and managing listener.ora, tnsnames.ora, and other related files. This guide will walk you through the listener configuration process using NETCA utility.

Prerequisites:
1. Oracle Database Software should be installed.
2. Oracle Database Environments should be set.

Run NETCA from OS prompt:

[oracle@target ~]$ netca

Then a GUI wizard will open:

Select Listener Configuration and Click Next

Select Add and Click Next

Provide listener name "LISTENER" and Click Next

Select Protocol and Click Next

Provide Port and Click Next

Select No and Click Next

Click Next

Click Finish

Now start the Listener:

[oracle@target ~]$ lsnrctl start LISTENER
LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 22-JAN-2025 12:09:54
Copyright (c) 1991, 2024, Oracle. All rights reserved.
Starting /u01/app/oracle/product/19.0.0/dbhome_1/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 19.0.0.0.0 - Production
System parameter file is /u01/app/oracle/product/19.0.0/dbhome_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/diag/tnslsnr/target/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=target.localdomain)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=target.localdomain)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date                22-JAN-2025 12:09:54
Uptime                    0 days 0 hr. 0 min. 2 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/19.0.0/dbhome_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/target/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=target.localdomain)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
The listener supports no services
The command completed successfully

Thanks for visiting!!