Re: MTS not workin ??

On 19 Aug 2003 07:05:41 -0700, Ibrahim DOGAN <ibrahim.dogan_at_lowes.com> wrote:

> quarkman <quarkman_at_myrealbox.com> wrote in message
> news:<oprt4djwoozkogxn_at_haydn>...
> ...
>>
>> All you should have is:
>>
>> mts_dispatchers=(PROTOCOL=TCP)(DISPATCHERS=3)
>> mts_servers=5
>>
>> You don't need a 'listener' parameter in the setting for dispatchers,
>> because quite evidently, your listener runs tcp/ip on port 1521, and
>> those are the defaults, and therefore the dispatchers will register
>> themselves with that in any case. You only need all that other guff if
>> your listener is not running tcp/ip, not on port 1521, or isn't called
>> "listener".
>>
>> With that tidied up (and don't forget to bounce your instance), you need
>> to make sure that the listener has recived registration details from the
>> dispatchers:
>>
>> lsnrctl services
>>
> Ora version is 8.1.7
> now i have only mts_servers and mts_dispatchers parameters as you
> specified...
> i shutdown and restarted the instance..
> stopped and started the listener..
> when i do 'lsnrctl services', i get the following:
> PLSExtProc has 1 service handler(s)
> DEDICATED SERVER established:0 refused:0
> LOCAL SERVER
> PRACTICE has 1 service handler(s)
> DEDICATED SERVER established:0 refused:0
> LOCAL SERVER
> RCAT has 1 service handler(s)
> DEDICATED SERVER established:0 refused:0
> LOCAL SERVER
> mrdbdev has 1 service handler(s)
> DEDICATED SERVER established:0 refused:0
> LOCAL SERVER
>
> The instance i'm trying to configure as shared server is PRACTICE..
> but lsnrctl still says it's DEDICATED... no idea what's going wrong
> here...
>
> here is the listener.ora if it hepls:
>
> LISTENER =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = irm2)(PORT = 1521))
> )
>
> SID_LIST_LISTENER =
> (SID_LIST =
> (SID_DESC =
> (SID_NAME = PLSExtProc)
> (ORACLE_HOME = /home/oracle)
> (PROGRAM = extproc)
> )
> (SID_DESC =
> (GLOBAL_DBNAME = mrdbdev)
> (ORACLE_HOME = /home/oracle)
> (SID_NAME = mrdbdev)
> )
> (SID_DESC =
> (GLOBAL_DBNAME = PRACTICE
> (ORACLE_HOME = /home/oracle)
> (SID_NAME = PRACTICE)
> )
> (SID_DESC =
> (GLOBAL_DBNAME = RCAT
> (ORACLE_HOME = /home/oracle)
> (SID_NAME = RCAT)
> )
>
>
> )
> STARTUP_WAIT_TIME_LISTENER = 0
> CONNECT_TIMEOUT_LISTENER = 10
> TRACE_LEVEL_LISTENER = OFF
>
> thanks for taking your time..
>

I can't help further without knowing your version. Is this 8.0 or 8.1.x? It makes a difference.

Assuming your init.ora is configured correctly (and you'll need quotes around the mts_dispatchers entry... sorry, I was giving you a flavour for how things should be, not spelling it out exactly, syntactically, correct), then it is clear you don't have automatic registration of dispatchers with the listener working. And if that's not working, you fall at the first hurdle. In 8i, it should work. In 8.0 it won't, because they hadn't invented it yet.

Also, as I mentioned in my earlier post, you can't have SID_NAME=xxxx in the listener.ora if you want this to work. It has got to be SERVICE_NAME=xxxx.

You need to work through the entire reply, not just the first paragraph of it.

Regards
HJR Received on Tue Aug 19 2003 - 14:46:04 CDT