Re: 2 databases 2 listeners 1 oracle_home

Frank,

I've read your thread on the news server about Oracle. your reply ..."After a connection request is made, the actual communication will be on another port alltogether anyway......"

May be the answer I'm looking for.......

I know that TCP port 1521 is the IP (tcp) port that the initial connection to the database is made via Oracle's SQL*NET IP.

What I need to do (set) is to make Oracle ONLY WORK on port 1521 and not reassign another IP port to each connection.....

Q.) Can I do this?
Q.) How?

In short my Internet firewall can be set to allow "inbound" TCP requests to my Oracle server (10.0.1.48) on port 1521. When Oracle reassings the connection port to say......1566 the firewall prevents the session from starting up....

Thanks,

Pete Buckley

On Wed, 26 Jan 2000 15:20:43 -0800, Frank van Bortel <f.van.bortel_at_vnl.nl> wrote:

>madhul_at_my-deja.com wrote:
>
>> 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.
>
>Why would you have two listeners on two ports? They can both listen on the
>same port. After a connection request is made, the actual communication
>will
>be on another port alltogether anyway.
>
>--
>Met vriendelijke groet/kind regards,
>
>Frank van Bortel
>Technical consultant Oracle
>
>
Received on Wed Jan 26 2000 - 11:36:08 CST