Re: Multiple service names for a single instance?

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:
>

> It is not possible.

It is possible.

> Once you allocate a port number to the tcp
> protocol you can't use any other port.
  

Not true. You can have the same listener listening on two different ports for the same protocol (in this case, TCP).

> 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)

You dont need a second listener to do what he wants. In the init.ora, define the SERVICE_NAMES parameter to be the two values that you want. For example,

DB_NAME=test
DB_DOMAIN=something.com
SERVICE_NAMES=test.something.com, testme.something.com

In the listener.ora, tell the listener to listen on two ports for TCP connections.

LISTENER =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = test_server)(PORT = 1521))     (ADDRESS = (PROTOCOL = TCP)(HOST = test_server)(PORT = 1526))   )

  .
  .
  .
  .

You dont need the sid_list since the instance will register automatically with the listener. Listener status should show both service names as having service handlers.

Now in your tnsnames.ora, put the following entries

FIRST_PORT =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = test_server)(PORT = 1521))     )
    (CONNECT_DATA =
      (SERVICE_NAME = test.something.com)     )
  )

SECOND_PORT =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = test_server)(PORT = 1526))     )
    (CONNECT_DATA =
      (SERVICE_NAME = test_me.something.com)     )
  )

You should be able to connect to the TEST instance using any of these entries. Furthermore, the port numbers in the above tnsnames.ora entries are interchangable. For the original poster, each of the two entries will be in two different tnsnames.ora files with people connnecting to the same instance, but only using different service names and over different ports.

Murali
http://www.dbaquest.com/ Received on Thu Feb 28 2002 - 20:53:56 CST