Re: Multiple service names for a single instance?

oraclems_at_hotmail.com (Murali) wrote in message news:<22e6597b.0202281853.7e1ac09e_at_posting.google.com>...
> 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/

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

  .
  .
  .
  .

Have you EVER tried this?
I did. Guess what? It doesn't work.
Please don't try to make a fool out of me when you don't know what you are talking about.

Regards

Sybrand Bakker
Senior Oracle DBA Received on Fri Mar 01 2002 - 02:23:39 CST