Re: Multiple listener services on win2k

From: Ana C. Dent <anacedent_at_hotmail.com>
Date: Sun, 16 Mar 2003 18:21:59 -0800
Message-ID: <9jada.8578$FH2.204@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)
	 )

   ) Received on Sun Mar 16 2003 - 20:21:59 CST