DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: MTS configure

  1. #1
    Join Date
    Jan 2001
    Posts
    230
    Hi:

    Oracle : 8.1.6
    O.S. : Windows NT

    I have configured the MTS.
    Now, If I don't have domain name with service name in
    SEVICE_NAME parameter in tnsnames.ora then it uses the dedicated service.

    Following will use MTS..
    DBNAME.DOMAIN_NAME =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = hostname)(PORT = 1521))
    )
    (CONNECT_DATA =
    # Here is Change..
    (SERVICE_NAME = SERVICE.DOMAIN_NAME)
    )
    )

    Following will use dedicated
    DBNAME.DOMAIN_NAME =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = hostname)(PORT = 1521))
    )
    (CONNECT_DATA =
    # Here is Change..
    (SERVICE_NAME = SERVICE)
    )
    )

    That means in order to use MTS, I have to modify the tnsnames.ora.
    Is there any way that I can use MTS without changing the tnsnames.ora?

    Thanks.

  2. #2
    Join Date
    Jan 2001
    Posts
    230
    Hi:

    Any suggestion?

    Thanks.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width