Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: 2 databases 2 listeners 1 oracle_home
In article <388DEC06.3A5C19FA_at_us.ibm.com>,
Doug Cowles <dcowles_at_us.ibm.com> wrote:
> If I have 2 different sids on one oracle home, how can I configure 2
> different listeners,
> one for each, each listening on a different port?
>
> Thanks,
> - Dc.
>
>
Add more entries in listener.ora substituting listener with a new name,
say listener2. For eg:
if current file has:
LISTENER=( ADDRESS_LIST=
(ADDRESS= (PROTOCOL=tcp) (HOST=host1) (PORT=1521)))
sid_list_listener=( SID_LIST=
(SID_DESC=
(SID_NAME=ABC)
(ORACLE_HOME=/u01/home/oracle/product/8.0.5)
))
add the following to it: (note the change in port number)
listener2=(address_list=
(address=(protocol=tcp) (host=host1) (port=1525))) sid_list_listener2=(sid_list=
(sid_desc (sid_name=XYZ) (ORACLE_HOME=/u01/home/oracle/product/8.0.5)))
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Tue Jan 25 2000 - 16:27:10 CST
![]() |
![]() |