Re: Multiple service names for a single instance?

Hi

I'm quite sure that I at least one time saw a config with two "tcp" ADDRESS clauses in the ADDRESS_LIST, not sure if it works though :-P

Regards
Fredrik

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:m5ms7uo0265lvh0nu1167kcgvql4422r82_at_4ax.com...
> On Thu, 28 Feb 2002 14:41:54 +0200, "Janne Keskitalo"
> <Janne.Keskitalo_at_oulu.fi> wrote:
>
> >
> >Is it possible to configure listener.ora so that clients can connect
to a
> >single database instance with two different service_name parameters
and port
> >numbers? One of our customers has hard coded connection parameters in
their
> >servlets and we are planning to move the schema to a new 9i database
which
> >has different db-name and port number than the original. We can't
rename the
> >new instance, because it is in production and contains other mission
> >critical applications. My second option is to create another new
instance
> >which has the same name and port number as the original instance, but
I
> >would really like to use the existing one.
>
>
> It is not possible. Once you allocate a port number to the tcp
> protocol you can't use any other port. A lousy solution to address
> this problem would be running two different listeners (you'll need to
> define them in 1 listener.ora, but please use the net8 configuration
> assistant)
>
> Regards
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address
Received on Thu Feb 28 2002 - 17:49:13 CST