Re: second instance

It's not listening for instances, it's listening for clients. A client places a call on the port that says, in effect, 'hey, listener, hook me up to sid wxyz." The listener then does whatever it does to make the connection, then steps out of the picture. Think of it like an early telephone operater. Everyone dials zero, (the "port" number), the operator ("listener") picks up the phone, the customer ("client") says, "Maude, this is Eunice, please put me through to Mabel" and Maude makes the connection between Eunice and Mabel.

On 17 Oct 2001 01:15:57 -0700, faheemrao_at_yahoo.com (FaheemRao) wrote:

>How can a listener can listen for two instances on a single port ?
>if you are not using other protocols(other than tcp/ip) for second instance.
>
>Faheem Rao
>
>
>Ed_Stevens_at_nospam.noway.nohow (Ed Stevens) wrote in message news:<3bcc8ca9.28030065_at_ausnews.austin.ibm.com>...
>> One listener and one port is all that is required.
>>
>> On 10 Oct 2001 17:46:07 -0700, faheemrao_at_yahoo.com (FaheemRao) wrote:
>>
>> >Hi Guys I have an question regarding 2 Instance , that dont we need
>> >two listner for two instacnes ,and if so, we need to ports for 2
>> >listner to listen at.?
>> >
>> >"Terry Dykstra" <dontreply_tdykstra_at_cfol.ab.ca> wrote in message news:<0nZw7.3392$xU4.610419_at_news1.telusplanet.net>...
>> >> You use oradim80.exe to create new instances. First make a initXXXX.ora
>> >> file with the proper settings. Then use oradim80 -new -sid XXXX ..... It
>> >> has a number of other parameters you need. Use oradim80 /? and it will
>> >> list the options.
>> >>
>> >> --
>> >> Terry Dykstra
>> >> Canadian Forest Oil Ltd.
>> >> "Andreas Lommel" <anlommel_at_gmx.de> wrote in message
>> >> news:3bc3f853.3037247_at_news.btx.dtag.de...
>> >> > Hi there. I have oracle 8.0.5 on NT. I must create a second instance.
>> >> > On the system there is a instance.
>> >> > What must be done to create this new instance ?
>> >> >

--
Ed Stevens
(Opinions expressed do not necessarily represent those of my employer.)