Creating Oracle Database Listener using Net Configuration Assistant.

Today we will see how to create Oracle Database Listener.

We will create listener as shown below.

Set the database environment.

export ORACLE_HOME=<Location of oracle home>
export TNS_ADMIN=$ORACLE_HOME/network/admin

Go to $ORACLE_HOME/bin directory

cd $ORACLE_HOME/bin

./netca

Select Listener Cofiguration option.

  

Select Add option.

 

Enter Listener Name as LISTENER_<SID>

Ex. LISTENER_MWDB

 Click on Next.

 Enter Port number which is not in use.

 Select No option.

 Click on Next.

Now check the listener status by executing below command.

[oracle@ebs ~]$ lsnrctl status LISTENER_MWDB

LSNRCTL for Linux: Version 10.2.0.4.0 - Production on 31-MAY-2013 21:01:51

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ebs.oracle.com)(PORT=152 2)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER_MWDB
Version                   TNSLSNR for Linux: Version 10.2.0.4.0 - Production
Start Date                31-MAY-2013 21:01:03
Uptime                    0 days 0 hr. 0 min. 47 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/mwdb/10.2.0/network/admin/listener.ora
Listener Log File         /u01/app/oracle/mwdb/10.2.0/network/log/listener_mwdb. log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ebs.oracle.com)(PORT=1522)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully