Re: Multiple service names for a single instance?

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 - 10:22:20 CST