Creating an Oracle Listener using NETCA

Creating an Oracle Listener using NETCA

Firstly login in ORACLE

IN Linux platform write NETCA

[oracle@testing Desktop]$ netca

Click on Next





Again Next



Give the name of listener and click on next
`


Select protocols you want and click next



Give port number you want to use for oracle. By default it will use 1521




If you want to configure another listener then select yes else No



Click on next



Click on Finish as process is completed.

The listener status can be verified by issuing the lsnrctl command like below:

lsnrcrl status 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