Configure Multiple Listeners in the same Oracle Home

At times we may need to configure multiple listeners under same OH.

To do this, navigate to $OH/network/admin

vi listener.ora

Add these entries:

PRIM =


(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = dba.asteroid.com)(PORT = 1521))

)

)


DR01 =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = dba.asteroid.com)(PORT = 1523))

)

)

SID_LIST_PRIM =(SID_LIST =(SID_DESC = (GLOBAL_DBNAME = PRIM) (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1) (SID_NAME = PRIM)))



SID_LIST_DR01 =(SID_LIST =(SID_DESC = (GLOBAL_DBNAME = DR01) (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1) (SID_NAME = DR01)))

 
 
In my case, i have two listeners: PRIM, DR01 runnng on two different ports: 1521, 1523
 
[oracle@dba admin]$ lsnrctl status PRIM




LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 27-JUL-2011 10:36:26



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



Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=dba.asteroid.com)(PORT=1521)))

STATUS of the LISTENER

------------------------

Alias PRIM

Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production

Start Date 27-JUL-2011 10:33:20

Uptime 0 days 0 hr. 3 min. 6 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora

Listener Log File /u01/app/oracle/diag/tnslsnr/dba/prim/alert/log.xml

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dba.asteroid.com)(PORT=1521)))

Services Summary...

Service "DR01" has 1 instance(s).

Instance "DR01", status BLOCKED, has 1 handler(s) for this service...

Service "PRIM" has 1 instance(s).

Instance "PRIM", status UNKNOWN, has 1 handler(s) for this service...

Service "prim.asteroid.com" has 1 instance(s).

Instance "prim", status READY, has 1 handler(s) for this service...

Service "primXDB.asteroid.com" has 1 instance(s).

Instance "prim", status READY, has 1 handler(s) for this service...

The command completed successfully

 
Cheers!