Re: MTS not workin ??

From: Ibrahim DOGAN <ibrahim.dogan_at_lowes.com>
Date: 20 Aug 2003 07:54:39 -0700
Message-ID: <33634314.0308200654.1ff2efe0@posting.google.com>

quarkman <quarkman_at_myrealbox.com> wrote in message news:<oprt53ve00zkogxn_at_haydn>... ..
> I assume that you are suggesting that, despite following the advice to just
> have two lines in the init.ora for dispatchers and shared server, the thing
> is still not working?
>
> What about all the other advice I put in the first reply?
>
> lsnrctl services needs to be done, and the output posted here. And your
> tnsnames.ora needs to refer to a SERVICE and not a SID. So post that whilst
> you're at it.
>
> And, most importantly, tell us what your Oracle version is. Otherwise this
> little bit of help can go no further.
>
> Regards
> HJR
Thanks all of you guys for your input, but i still got a big DEDICATED server..
there should be a tiny little thing somewhere that messes up whole thing otherwise everything is by book..

first, of course i use quotes around mts_dispatchers, otherwise Oracle wouldn't start up..

here is where i'm at now :

Oracle & OS Version

SQL>
SQL> SELECT version FROM v$instance;

VERSION

8.1.7.0.0

SQL> ! uname -a
AIX irm2 3 4 000AC71D4C00

LISTENER

irm2:/home/oracle/network/admin-> lsnrctl services

LSNRCTL for IBM/AIX RISC System/6000:
Version 8.1.7.0.0 - Production on 20-AUG-2003 10:45:33

Connecting to (ADDRESS=(PROTOCOL=TCP)(HOST=irm2)(PORT=1521)) Services Summary...
PRACTICE has 1 service handler(s) DEDICATED SERVER established:1 refused:0 LOCAL SERVER
The command completed successfully

I removed the SID_LIST_LISTENER section from listener.ora because i just found out that this section was required for static service assignment in pre-8.1.7. So i guess i don't need it..

TNSNAMES.ORA of client

I have always used "SERVICE_NAME" in tnsnames.ora on my client box. Here is the section of my instance from tnsnames.ora:

PRACTICE.LOWES.COM =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = irm2)(PORT = 1521))     )
    (CONNECT_DATA =
      (SERVICE_NAME = PRACTICE)
    )
  )

MTS PARAMETERS

They're same as in my latest post..
I set only 2 of them as quarkman suggested: NAME VALUE

~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
mts_dispatchers	     (PROTOCOL=TCP)(DISPATCHERS=3)
mts_servers	     5
mts_max_servers	     20
mts_max_dispatchers  5
mts_sessions	     33
mts_circuits	     38
mts_service	     PRACTICE
mts_listener_address [NULL]
mts_multiple_listeners	FALSE

do you think there might be an init.ora param or another thing that prevents listener from configuring a shared server??

Thanks again..
i.d. Received on Wed Aug 20 2003 - 09:54:39 CDT