Create Oracle database listener Using Netca and manually

This article presents creating a simple Oracle Listener service. DBA's can create Listener manually however Oracle Net Configuration Assistant provide us simple way.

First Method Manually Create the listener

Manually create the listener.ora file and start the listener from command line.

LISTENER_TEST =

  (DESCRIPTION_LIST =

    (DESCRIPTION =

      (ADDRESS = (PROTOCOL = TCP)(HOST =orcl.localdomain )(PORT = 1522))

      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1522))

    )

  )

ADR_BASE_LISTENER_ORACLEDB1 = /u01/app/oracle

[oracle@orcl admin]$ lsnrctl stop LISTENER_TEST

[oracle@orcl admin]$ lsnrctl status LISTENER_TEST

 Second method Start the Oracle Net Configuration Assistant (NETCA)

Choose Listener configuration And Click Next

 Here Add (to add new listener) Reconfigure(exist listener), delete(exist) Rename(exist).
Choose Add And click next

So, Give new listener Name  For example Listener_test

The important thing you must Select TCP here. Click next

The exist port is 1521 however user for different listener different port for example 1522 

 Asking for another listener to configure Choose No and click Next

Choose new listener to be started and click next

Almost its done! Click next

Click Finish

After all you we'll see the script of new listener.

AS You see there are two listener script my first and second listener.
Have a nice job! :)