Re: Configuring SQL*Net for MTS

Lynda Sohl (lyndas_at_email.mot.com) wrote:
: I hope someone can help me here. I am trying to configure SQL*Net V2 (the
: tnslsnr) to use the Multithreaded server. I want remote users to connect
: through TCP/IP and local users to connect through IPC. I have the SQL*Net
: connections going but I can not seem to get Oracle to make use of the
: dispatchers. This happens no matter how I try to connect through SQL*Net.
 

: This is my listener.ora:

[seems to be OK]

: This is my tnsnames.ora:

[seems to be OK]

: These are the MTS init.ora parameters I am using:
 

: mts_dispatchers = "ipc, 1"

• add : mts_dispatchers="tcp,1"
  : mts_max_dispatchers = 10
  : mts_service = v7test
  : mts_servers = 1
  
• should be 2
  : mts_max_servers = 10
  : mts_listener_address = "(ADDRESS=(PROTOCOL=ipc) (KEY=v7test))"
  ** add : mts_listener_address="(ADDRESS=(PROTOCOL=tcp)(HOST=<host>)(PORT=1521))"

Sandor Nieuwenhuijs
Oracle Netherlands

• These opinions (if any) are just mine. I do not represent Oracle ---
• Corporation in this Posting ---