Re: Multiple listener services on win2k

"Ana C. Dent" <anacedent_at_hotmail.com> wrote in message news:9jada.8578$FH2.204_at_fed1read02...
> Krzysztof Kryczka wrote:
> > Reasons are:
> > 1. Separation of access to instances. I dont want to allow users from
> > different networks to have access to all instances.
> > 2. Windows Plug and Pray behavior - if there is no link of interface
Win2K
> > makes interface down and after that listener which have address on that
> > interface doesnt start untill you remove address from address_list
> > 3. Management - if i want to cut out part of users it will be easier for
me
> > to stop specific listener followed by kill session rather than modify
> > address_list in listener.ora, restart listener and kill sessions and
rewrite
> > all changes back
> >
> > K.K.
> >
> > Użytkownik "Ana C. Dent" <anacedent_at_hotmail.com> napisał w wiadomości
> > news:rm9da.8554$FH2.7101_at_fed1read02...
> >
> >>Krzysztof Kryczka wrote:
> >>
> >>>Platform: Windows 2000 Serv
> >>>Oracle: 8.1.7.1.4
> >>>
> >>>I have machine with 4 NICs and 3 instances on it. I'm looking for
> >>>possibility to setup at least 3 different listener services on 3
> >
> > differend
> >
> >>>interfaces, each one with differend sid_list. Could someone send me a
> >
> > hint
> >
> >>>how to create 3 differend listener services/processes, each one with
> >>>different listener.ora file. Also links for windows specific NET8
> >>>documentation are welcomed.
> >>>Thanks for all sugestions
> >>>
> >>>K.K.
> >>>
> >>>
> >>>
> >>
> >>WHY are you doing this?
> >>What problem are you trying to solve?
> >>What metrics will be used measure the success or failure of your
efforts.
> >>
> >>Keep in mind that the Oracle listener only function is to INITIATE a
> >>connection between a client and a database instance. Once the client
> >>get connected to the DB, the listener is no longer involved with this
> >>client.
> >>
> >
> >
> >
>
> #1 Which clients can get to which instances
> can also be controled by either using PROTOCOL.ORA
> or by TNSNAMES.ORA file.
>
> #2 made NO sense to be but it kind of sounded as
> though you use IP#s in the listener.ora file.
>
>
> #3 sounds to me like Damagement has unsound business
> practices, 'cuz I for one want folks to use the DB
> so the company will maximize profit. If you need to
> "lock out" users on a regular basis, I suggest that
> you try to find employment with a better managed
> resources.
>
> I don't know how to specify which listener.ora file to use
> other than by setting TNS_ADMIN enovironmental variable.
> Below is how to control two listeners from a single
> listener.ora file
>
>
> LISTENER =
> (ADDRESS_LIST =
> (ADDRESS =
> (PROTOCOL = TCP)
> (HOST = prod)
> (PORT = 1521)
> )
> )
>
> SID_LIST_LISTENER =
> (SID_LIST =
> (SID_DESC =
> (SID_NAME = MWH)
> (ORACLE_HOME=/u01/app/oracle/product/7.3.4)
> (ENVS='EPC_DISABLED=TRUE')
> )
> )
>
>
> PROD_DED =
> (ADDRESS_LIST =
> (ADDRESS =
> (PROTOCOL = TCP)
> (HOST = prod )
> (PORT = 1529)
> )
> )
>
> SID_LIST_PROD_DED =
> (SID_LIST =
> (SID_DESC =
> (SID_NAME = MWH)
> (ORACLE_HOME=/u01/app/oracle/product/7.3.4)
> (ENVS='EPC_DISABLED=TRUE')
> )
> (SID_DESC =
> (ORACLE_HOME= /u01/app/oracle/product/8.1.7)
> (SID_NAME = WRK)
> )
> )
>

I think you would have to put the listeners on different ports. The listener only connects users to the database. Once it does that it no longer is involved in that connection.
Jim Received on Sun Mar 16 2003 - 20:38:04 CST