Re: SQL*net on Oracle 8: How to spawn "wild card port" connection

Are you wanting to change the port or add another listener on another port? You can have more than one listener for a particular SID or one listener can service more than one SID. What usage do you have to make you want to have more than one listener for a single SID?

You will never see another port being used if you only have the default listener running (port 1521).

Johnson Wu wrote in message <34BADD4F.52676617_at_cisco.com>...
>Greetings,
>
>I just got Oracle 8 running in the lab with an MS access client
>running performing queries to a linked table on the Oracle server
>but I somehow could never get the client to spawn the 2nd connection,
>ie. all queries seem to use a live connection to port 1521 and that's
>it.
>The queries seem to works but they only use 1521 and not what I usually
>see
>at customer sites doing the multi thread thing.
>
>I wonder if I can get any help at all configuring my server ( or client
>)
>to do multi thread so I can get the client to try talking to the server
>using a second wildcard port connection instead of the original one to
>tcp port 1521.
>
>Any help appreciated.
>
>-JOhnson Wu
>jlw_at_cisco.com
>
>
Received on Sat Jan 17 1998 - 00:00:00 CET