oracle apps dba blog

Hi All,
In this post we will see how to configure multiple listeners in the same oracle home in the same servers.
In certain circumstances we need to configure multiple listeners in the same oracle home since we will be running
multiple databases in the same Oracle homes. so the entry in the listener.ora has to be as follows. i have given the
entries for DEV and TEST

LSNRDEV =(DESCRIPTION_LIST =(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = oracleserver)(PORT = 2200)) )))

LSNRTEST =(DESCRIPTION_LIST =(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = oracleserver)(PORT = 1522)) )))

SID_LIST_LSNRDEV =(SID_LIST =(SID_DESC = (GLOBAL_DBNAME = DEV) (ORACLE_HOME = /u01/oracle) (SID_NAME = DEV)))

SID_LIST_LSNRTEST =(SID_LIST =(SID_DESC = (GLOBAL_DBNAME = TEST) (ORACLE_HOME = /u01/oracle) (SID_NAME = TEST)))

how to start these listeners???

use the following commands

$lsnrctl start lsnrdev
which starts the listener for dev

$lsnrctl start lsnrtest

which starts the listener for test.

so now we have configured two listeners in two differnt ports for the same ORACLE_HOME.

meet you all in my next post.

–Vivek R.