Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: MTS

Re: MTS

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Tue, 16 Jul 2002 17:25:24 +1000
Message-ID: <PMPY8.35936$Hj3.108648@newsfeeds.bigpond.com>


Hi Alan,

Find comments imbedded.

"Alan" <athiery_at_ais-nantes.fr> wrote in message news:3d33b9a0$0$10538$626a54ce_at_news.free.fr...
> On an Oracle 8.1.7 Windows NT 4, I dont succed to
> access on an instance via MTS
>
> I have
>
> * in the init.ora :
>
> mts_dispatchers = "(protocol=TCP)(tick=15)(pool=true)(DISPATCHERS=2)"
> LOCAL_LISTENER = "(ADDRESS = (PROTOCOL=TCP)(HOST=pcat)(PORT=1521))"

The LOCAL_LISTENER parameter looks OK but note as you're using the default 1521 port, it's actually unnecessary. Oracle will register itself with the listener on this port by default. Try taking it out.

Check the SERVICES_NAMES parameter. Make sure it's set to ALAIN.

>
>
> * in the view v$dispacher i obtain
>
> NAME NETWORK PADDR STATUS ACCEPT MESSAGES BYTES BREAKS OWNED CREATED IDLE
> BUSY LISTENER CONF_INDX
> D000 (ADDRESS=(PROTOCOL=tcp)(HOST=pcat)(PORT=1515)) 2B7D9DC4 WAIT YES 0 0
0
> 0 0 202867 0 0 0
> D001 (ADDRESS=(PROTOCOL=tcp)(HOST=pcat)(PORT=1517)) 2B7DA0EC WAIT YES 0 0
0
> 0 0 202838 0 0 0

What does services on the listener say (lsnrctl services). Have the dispatcher processes registered themselves with the listener. Are you sure the listener has been started and configured correctly.

>
> * i force connection via MTS in the tnsnames.ora
>
>
> ALAIN =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = pcat)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SID = alain)
> (SRVR = SHARED)
> )
> )
>

Change (SID = alain) to (SERVICE_NAME = alain). Also make sure there are no funnies in the sqlnet.ora (eg. NAMES.DIRECTORY_PATH=(TNSNAMES), NAMES.DEFAULT_DOMAIN = world, etc.)

> But when i try to access via sqlplus i obtain an ORA-12519 error
>
> Why ???

Hopefully because of one of the above suggestions.

Good Luck

Richard
>
> ALAN
>
>
>
>
>
>
>
Received on Tue Jul 16 2002 - 02:25:24 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US